Tuesday, March 29, 2016

startup ORA-01012: not logged on

ORA-01012: not logged on:

sqlplus "/as sysdba"


SQL>
SQL> startup
ORA-01012: not logged on
SQL> exit
Disconnected

[oemora@lnxdbtst > /apps/oemora/oracle/njvcoid/orabin/11.2.0/rdbms/lib]$ sysresv

IPC Resources for ORACLE_SID "OIDREP" :
Shared Memory:
ID              KEY
387350529       0x00000000
387383298       0x00000000
387416067       0xbd6e4ec0
Semaphores:
ID              KEY
No semaphore resources used
Oracle Instance not alive for sid "OIDREP"

[oemora@lnxdbtst > /apps/oemora/oracle/njvcoid/orabin/11.2.0/rdbms/lib]$ ipcrm -m 387350529
ipcrm -m 387383298
ipcrm -m 387416067
sqlplus "/as sysdba"



SQL> startup
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2230072 bytes
Variable Size            1828718792 bytes
Database Buffers          301989888 bytes
Redo Buffers                4947968 bytes
Database mounted.
Database opened.
SQL>