Re: Oracle RAC, and reboots

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 03 Dec 2007 05:15:13 GMT
Message-ID: <6127l3lfqcfrgapupbt8iohjre5b59cfl9@4ax.com>

On Fri, 30 Nov 2007 19:39:37 GMT, NetComrade <netcomradeNSPAM_at_bookexchange.net> wrote:

>On Thu, 29 Nov 2007 10:01:42 -0800 (PST), madhusreeram_at_gmail.com
>wrote:
>
>>May be the db is disabled from auto start.
>>Try this:
>> srvctl enable database -d <db>
>>
>>you could run : crs_stat -p to determine the current settings.
>
>Thanks for the command.. all the autostarts are set to 1, or 'always',
>or 'restore'.. Is there are a crs log somehwere that I could look at?
>Something similar to VCS
>/var/log/VRTSvcs/log/engine_A.log
>or
>hastatus command

$CRS_HOME/crsd/crsd.log is apprently the log

crs_stat -t -v is the equivalent of hastatus -sum command I guess

db is enabled
$srvctl enable database -d BMRAC
PRKP-1016 : Database BMRAC already enabled.

db is obviously registered, but is not coming online crs_stat -t -v
Name Type R/RA F/FT Target State Host

---

ora....C1.inst application 0/5 0/0 ONLINE ONLINE lsbcmdbp01
ora....C2.inst application 0/5 0/0 ONLINE OFFLINE ora.BMRAC.db application 0/0 0/1 ONLINE ONLINE lsbcmdbp01
ora....M1A.asm application 0/5 0/0 ONLINE ONLINE lsbcmdbp01
ora....01.lsnr application 0/5 0/0 ONLINE ONLINE lsbcmdbp01
ora....01.lsnr application 0/5 0/0 ONLINE ONLINE lsbcmdbp01
ora....p01.gsd application 0/5 0/0 ONLINE ONLINE lsbcmdbp01
ora....p01.ons application 0/3 0/0 ONLINE ONLINE lsbcmdbp01
ora....p01.vip application 0/0 0/0 ONLINE ONLINE lsbcmdbp01
ora....M1B.asm application 0/5 0/0 ONLINE ONLINE lsbcmdbp02
ora....02.lsnr application 0/5 0/0 ONLINE ONLINE lsbcmdbp02
ora....02.lsnr application 0/5 0/0 ONLINE ONLINE lsbcmdbp02
ora....p02.gsd application 0/5 0/0 ONLINE ONLINE lsbcmdbp02
ora....p02.ons application 0/3 0/0 ONLINE ONLINE lsbcmdbp02
ora....p02.vip application 0/0 0/0 ONLINE ONLINE lsbcmdbp02

I've looked in the logs, and it doesn't look like crs is attempting to start the db

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Sun Dec 02 2007 - 23:15:13 CST