INSTALLATION DOCUMENTS BY RAVI

Tuesday, July 3, 2018

Database crashed, unable to connect through sqlplus ; ORA-01012: not logged on ; Oracle Instance alive for sid "orcl"

When trying to start the database getting the below error:

ORA-01012: not logged on
Process ID: 0

Session ID: 0 Serial number: 0












To resolve this exit from the database first




Run SYSRESV Utility as below:


















































Remove damaged Semaphores and shared memory as below:








Try to connect the database now














No comments:

Post a Comment

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...