Hi Gurus,
Oracle Version:11.2.0.1
Operating system:linux
After rebooting the database i was unable to start my database on both the nodes. Also find the error below it is showing.
[root@rac1 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASM_DATA1.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ASM_DATA2.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ASM_FRA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR_VOTE.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1
ora.oc4j
1 OFFLINE OFFLINE
ora.qfundrac.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.qfundrac.ractest.svc
1 OFFLINE OFFLINE
ora.qfundrac.ractest1.svc
1 OFFLINE OFFLINE
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
ora.scan2.vip
1 ONLINE ONLINE rac1
ora.scan3.vip
1 ONLINE ONLINE rac1
[root@rac1 bin]# su - oracle
[oracle@rac1 ~]$ srvctl start database -d qfundrac
PRCR-1079 : Failed to start resource ora.qfundrac.db
CRS-2674: Start of 'ora.qfundrac.db' on 'rac2' failed
CRS-2678: 'ora.qfundrac.db' on 'rac2' has experienced an unrecoverable failure
CRS-0267: Human intervention required to resume its availability.
CRS-5807: Agent failed to process the message
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
ORA-04031: unable to allocate 44210968 bytes of shared memory ("shared pool","DBMS_STANDARD","PLDIA^7ce2fac4","PAR.C:parapt:ptb")
CRS-2674: Start of 'ora.qfundrac.ractest.svc' on 'rac1' failed
ORA-04031: unable to allocate 44210968 bytes of shared memory ("shared pool","DBMS_STANDARD","PLDIA^7ce2fac4","PAR.C:parapt:ptb")
CRS-2674: Start of 'ora.qfundrac.ractest1.svc' on 'rac1' failed
ORA-04031: unable to allocate 44210968 bytes of shared memory ("shared pool","DBMS_STANDARD","PLDIA^7ce2fac4","PAR.C:parapt:ptb")
ORA-04031: unable to allocate 44210968 bytes of shared memory ("shared pool","DBMS_STANDARD","PLDIA^7ce2fac4","PAR.C:parapt:ptb")
[oracle@rac1 ~]$
Please help me how to solve it.
Thanks & Regards,
Poorna Prasad.S