Re: How to move init.ora or SPFILE

From: bh <bh_at_blah.net>
Date: Tue, 26 Oct 2004 15:28:51 GMT
Message-ID: <T2ufd.7599$df2.593@edtnps89>

Mark D Powell wrote:

> JohannesBavendiek_at_gmx.de (Johannes Bavendiek) wrote in message news:<df6af3e.0410260132.5684a213_at_posting.google.com>...
>

>>Hello,
>>
>>we are running Oracle 9.2 on a Win2003 Cluster.
>>I want to move the init.ora and/or the SPFILE to another location
>>(especially from the local disk to a cluster-disk).
>>How can I do that?
>>
>>thanks in advance
>>Johannes

>
>
> Johannes, by default Oracle looks for the init.ora and spfile in the
> $ORACLE_HOME/dbs (UNIX) directory so if you really need to move these
> and do not want to have to use the pfile or spfile parameters on the
> startup command then you will need to re-install Oracle onto the
> cluster disk.
>
> If you are going to run the database on clustered disk then you
> probably want the binary on clustered disk anyway.
>
> HTH -- Mark D Powell --

Yes, Oracle looks in %ORACLE_HOME%\database by default. But that's only the default. I support many MSCS Oracle FailSafe systems and keep the spfile on the clustered drive, so we don't have to worry about whether each node has the most recent copy.

To move an init.ora file on a Windows system, you use the oradim utility. There is a registry key which sets the location of the pfile for the Oracle service. Check
oradim -help
but the syntax is more or less

oradim -edit -sid <SID> -pfile=<new location of pfile>

Using an spfile in a non-default location is a bit trickier on Windows. The suggested workaround is a one line pfile. It contains the ini_file parameter pointing at the location of the spfile. You then use oradim to modify its pfile setting to read this one line file, which points to the real location of the spfile.

Brian Holgate Received on Tue Oct 26 2004 - 10:28:51 CDT