Hi Guys recently we had issue while starting the DB of our Hyperion application. Just wanted to share this with you guys which will help you.
Background:
Since 2 weeks while stopping DB it was taking more than 40 mins. This time it took more than 40 min. While checking the pending oracle process only one it was showing so I killed that one.
$ ps -ef | grep -i hyq
orasid 3342396 1 0 Sep 16 – 0:15 /oracle/SID/112_64/bin/tnslsnr LISTENER -inherit
orasid 36372574 51970254 1 06:14:07 – 0:07 oracleSID (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
$ kill -9 51970254
Problem:
Now while starting the DB instance.
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 25 07:23:45 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected.
SQL> startup
ORA-01012: not logged on
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01012: not logged on
So whenever we forcefully shut down the DB this issue may occurs
“SYSRESV” shows a shared memory segment for a non-existing instance
Solution:
At OS level remove the orphaned shared memory segment using this utility
$ sysresv
IPC Resources for ORACLE_SID “SID” :
Shared Memory:
ID KEY
1048579 0xffffffff
4 0xffffffff
5 0x6767020c
Oracle Instance not alive for sid “SID”
$ ipcrm -m 1048579
$ ipcrm -m 4
$ ipcrm -m 5
Now tried to start DB
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 25 07:29:17 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 7482626048 bytes
Fixed Size 2236048 bytes
Variable Size 3271557488 bytes
Database Buffers 4194304000 bytes
Redo Buffers 14528512 bytes
Database mounted.
Database opened.
SQL> exit
Now good to see that instance getting stop & start immediately without any delay.
Hope this article helped to you. I am expecting your suggestions/feedback.
It will help to motivate me to write more articles….!!!!
Thanks & Regards,
Samadhan
https://samadhandba.wordpress.com/
“Key for success, always fight even knowing your defeat is certain….!!!!
Great thanks….i just followed these steps and DB came up fine
Thanks for posting this! We ran into an issue with our storage subsystem on AIX where our 12.1 db crashed hard and we received the ORA-1012 errors trying to connect through sqlplus – low and behold the shared memory segment was still dangling out in the OS. Cleared it out and db started fine. Great job 🙂
excellent! it helped me on oracle 12c 🙂 thank you!
This helped me thanks
Thanks, it worked well…
Thanks for the help.
Hi Samadhan, Thank you very much for your article. i have the same problem today and search webs but could not find the solution. i follow your instructions in this article and easily startup my database. — Best. Yu