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….!!!!