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

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...