Strange behavior in Oracle restart

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Fri, 5 Aug 2011 05:28:32 -0700
Message-ID: <CAHDOOG4us2myjygyyBeUnqdK=UKsjdjOE=K2CTFieVkATKwSkw_at_mail.gmail.com>

Hi
Can some one explain why the diag dest parameter has a different value when asm is getting started through srvctl/crscl vs sqlplus. Details below

GI version 11.2.0.2

Diagnostic dest value is not set in init.ora.

Case (a): Start the Oracle restart config using crsctl start has; crsctl start resource -all . In this case asm comes up and diagnostic dest is set to $GRID_HOME/log
Case (b): Start the oracle restart config in this orderv

crsctl stop resource ora.xxxxx_DG.dg
crsctl stop resource ora.asm
crsctl stop has
crsctl start has
sleep 60
crsctl start resource ora.cssd
sqlplus '/ as sysasm' -- *starting asm manually and not through crs.* Here the value of diagnostic dest is set $ORACLE_BASE.

Question is why is set differently.
When I do
oracle:> srvctl getenv asm
asm:
ORACLE_HOME=/u02/app/oracle/product/11.2.0/grid/ Like I mentioned, the diag dest is not set in init.ora and in both cases (a) and (b) the same init.ora is used as seen in the alert log in both locations.

I know both case (a) and case(b) are non-standard ways of bringing up the cluster but in this case (that's a different story) but I am more interested in knowing how different values are getting picked up for diag_dest in these cases and how the defaults are choosen. I remember reading that diag_dest will default to $ORACLE_BASE when not set and I can explain the value I see in case (b). I cant explain how the value is getting derived in case (a) th ough.

Thank you
Kumar

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 05 2011 - 07:28:32 CDT