![oracle 6i form shuts down when button clicked window 7 oracle 6i form shuts down when button clicked window 7](https://image.slidesharecdn.com/oracleformstutorial-121214005358-phpapp01/95/oracle-formstutorial-8-638.jpg)
# J:\app\oraclexe\product\18.0.0\dbhomeXE\dbs\init.ora
![oracle 6i form shuts down when button clicked window 7 oracle 6i form shuts down when button clicked window 7](https://1.bp.blogspot.com/-PTpiK0bth4U/Xp6-anWrCwI/AAAAAAAABBs/CIqkjd2bdO88DPKFT613Qs1KWf3e2lN2gCLcBGAsYHQ/s1600/Download_Oracle_Developer_10g.jpg)
Xe._oracle_base='J:\app\oraclexe\product\18.0.0'#ORACLE_BASE set from environment ORA-32006: SEC_CASE_SENSITIVE_LOGON initialization parameter has been deprecated **create spfile from pfile='c:\temp\init.ora' ** Then you edit file see **\*.memory_target=2048 M** and use that to start **create pfile = 'c:\temp\init.ora' from spfile **
![oracle 6i form shuts down when button clicked window 7 oracle 6i form shuts down when button clicked window 7](https://s2.manualzz.com/store/data/042266969_1-47b2ff7cdb45e8ca2ffc336239aa6266.png)
outputs : Connected to an idle instance. Then once your instance is started, you can create an spfile out of that pfile.Ĭd J:\app\oraclexe\product\18.0.0\dbhomeXE\bin You can *edit* pfile you created to correct errors you have. ORA-27101: shared memory realm does not exist Specified value of MEMORY_TARGET is too small, needs to be at least 2048 MĪLTER SYSTEM SET MEMORY_TARGET='2048 M' SCOPE=spfile Lsnrctl allows you to connect to DB over TCP/IP from the same machine or other machines on the network. Sqlplus or Sqlplus **XEPDB1 and ora7 are synonims (plugable DB name)**Ĭonn / as sysdba is same as conn as SYSDBA (both conn to SYS user)Ĭonn / as sysdba - connects even if **Net Services DB listener lsnrctl** is not running
Oracle 6i form shuts down when button clicked window 7 Pc#
**Sqlplus - **on PC where 18c XE is installed (if listener port is default = 1521)** Sqlplus.exe as or ALTER SESSION SET container = CDB$ROOT Quit or **ALTER SESSION SET container = XEPDB1 ** Sqlplus / as sysdba or sqlplus.exe as - my script, see below # cd J:\app\oraclexe\product\18.0.0\dbhomeXE\bin = \bin