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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...