Is there any problem if we move the SPFILE to different location???
what if we only say STARTUP, will Oracle know where to look for SPFILE, is there any drawback to move the SFILE????
thanks
Printable View
Is there any problem if we move the SPFILE to different location???
what if we only say STARTUP, will Oracle know where to look for SPFILE, is there any drawback to move the SFILE????
thanks
metalink.oracle.com
Doc ID : Note:166601.1
Subject: How to migrate from a pfile to a spfile
migrating from a pfile to an spfile isnt the question. It was how to move the location of an spfile
Doc ID: Note:166601.1Quote:
migrating from a pfile to an spfile isnt the question. It was how to move the location of an spfile
You can also specify the SPFILE in a PFILE. This is the only way to start the instance with an SPFILE in a non default location. The entry in the PFILE would look like: SPFILE = /database/startup/spfileora1.ora
I haven't tried it. But think you can do this as follows.
This would require a couple of shutdown and startup on the instance.Code:1. Create a new initSID.ora file using the current spfile.
2. Start your instance using the initSID.ora file
3. Create the new spfile on the new location
4. Now rename the old spfile on the default location to spfileSID.old
Edit the spfile location in the initSID.ora file to point to the
new SPFILE
5. Try starting the instance without specifying the any parameters.
I think the system would fetch the spfile from the new location
and start the instance.
Sam