On Friday 09 June 2006 22:32, you wrote:
> Hi,
>
>  By default, during startup, Oracle uses the
> $ORACLE_HOME/dbs/spfileSID.ora If it does not find it, it uses the initfile
> $ORACLE_HOME/dbs/initSID.ora
>
>  What I use to do:
>  I copy my spfile in another folder, let say
> $ORACLE_BASE/admin/SID/pfile/. Then I create an initfile
> $ORACLE_HOME/dbs/initSID.ora containing:
> spfile='$ORACLE_BASE/admin/SID/pfile/spfileSID.ora'
> #ifile='$ORACLE_BASE/admin/SID/pfile/initSID.ora'

Yes, we have discovered this mechanism too.

We have now one spfile on shared storage that is used by both instances.

And we put a one line pfile in $ORACLE_HOME/dbs/ that points to the common
spfile.


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting