Re: Strange behavior in Oracle restart

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Fri, 5 Aug 2011 05:44:02 -0700
Message-ID: <CAHDOOG6jJEAHo_9OcW2nChyr1Rs=hdWJNa5WJKa-BRBSxBhycw_at_mail.gmail.com>

I found the answer.
When starting asm through srvctl/crs, oracle_base is not set and default $ORACLE_HOME is chosen as the location of diag_dest Whens tarting explicitly using sqlplus after setting the env, oracle_base is obtained and t hat value is set.

Thank you
Kumar

On Fri, Aug 5, 2011 at 5:28 AM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:

> 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:44:02 CDT