Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database running but crs_stat showing its OFFLINE

AnjumShehzadSep 16 2008 — edited Sep 26 2008
Yesterday, when I checked database and all RAC components status with crs_stat -t command, I saw database as offline although database and both of its instances are up and already running.

oracle@hisdbs01[orcl1]:/u01/app/oracle/db/network/admin$ crs_stat -t
HA Resource Target State
----------- ------ -----
ora.hisdbs01.ASM1.asm ONLINE ONLINE on hisdbs01
ora.hisdbs01.LISTENER_HISDBS01.lsnr ONLINE ONLINE on hisdbs01
ora.hisdbs01.gsd ONLINE ONLINE on hisdbs01
ora.hisdbs01.ons ONLINE ONLINE on hisdbs01
ora.hisdbs01.vip ONLINE ONLINE on hisdbs01
ora.hisdbs02.ASM2.asm ONLINE ONLINE on hisdbs02
ora.hisdbs02.LISTENER_HISDBS02.lsnr ONLINE ONLINE on hisdbs02
ora.hisdbs02.gsd ONLINE ONLINE on hisdbs02
ora.hisdbs02.ons ONLINE ONLINE on hisdbs02
ora.hisdbs02.vip ONLINE ONLINE on hisdbs02
ora.orcl.db OFFLINE OFFLINE
ora.orcl.orcl1.inst OFFLINE OFFLINE
ora.orcl.orcl2.inst OFFLINE OFFLINE

Then I had to use srvctl start commands to see ora.orcl.db, ora.orcl.orcl1.inst & ora.orcl.orcl2.inst ONLINE.

I want to know how it is possible that Oracle instances are running (checked from ps & EM) but crs_stat thinks they are offline.

I checked alert logs of crs, ocssd.logs but could not find anything significant.

Br,
Anjum
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2008
Added on Sep 16 2008
7 comments
2,387 views