 | | | Subject: Re: identifying instance from shared spfile in RAC | Subject: Re: identifying instance from shared spfile in RAC 2007-10-04 - By LS Cheng
Back
Hi
What do you mean instance specific spfile is no longer there?
If you go to $ORACLE_HOME/dbs there should a initSID.ora which points to
your spfile
ThanKs
--
LSC
On 10/4/07, hrishy <hrishys@(protected)> wrote:
>
> Hi
>
> In a single instance database when i issue the startup
> command the oracle software will read a
> instance specific init.ora file and bring up a
> instance
>
> what happens when there is shared spfile file with
> entries like this in case of RAC
>
> rac1.instance_number=1
> rac2.instance_number=2
>
> and when i say
>
> srvctl start instance -i rac1 how will oracle know
> which instance is rac1 as the instance specific spfile
> is no longer there only values seem to be there
>
> regards
> Hrishy
>
>
>
> __ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ______
> Want ideas for reducing your carbon footprint? Visit Yahoo! For Good
> http://uk.promotions.yahoo.com/forgood/environment.html
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Hi<br><br>What do you mean instance specific spfile is no longer there?<br><br
>If you go to $ORACLE_HOME/dbs there should a initSID.ora which points to your
spfile<br><br>ThanKs<br><br>--<br>LSC<br><br><div><span class="gmail_quote">
On 10/4/07, <b class="gmail_sendername">hrishy</b> <<a href="mailto:hrishys
@(protected)">hrishys@(protected)</a>> wrote:</span><blockquote class="gmail
_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0
.8ex; padding-left: 1ex;">
Hi<br><br>In a single instance database when i issue the startup<br>command the
oracle software will read a<br>instance specific init.ora file and bring up a
<br>instance<br><br>what happens when there is shared spfile file with
<br>entries like this in case of RAC<br><br>rac1.instance_number=1<br>rac2
.instance_number=2<br><br>and when i say<br><br>srvctl start instance -i rac1
how will oracle know<br>which instance is rac1 as the instance specific spfile
<br>is no longer there only values seem to be there<br><br>regards<br>Hrishy<br
><br><br><br> __ ____ ____ ____ ____ ____ ___
__ ____ ____ ____ ____ _____<br>Want ideas for reducing your carbon footprint?
Visit Yahoo! For Good
<a href="http://uk.promotions.yahoo.com/forgood/environment.html">http://uk
.promotions.yahoo.com/forgood/environment.html</a><br>--<br><a href="http://www
.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l
</a><br><br><br></blockquote></div><br>
|
|
|