If you are currently using a text initialization parameter file, then you can migrate to a server parameter file.
To migrate to a server parameter file:
- If the initialization parameter file is located on a client system, then transfer the file (for example, FTP) from the client system to the server system.
- Create a server parameter file in the default location using the
CREATE SPFILE FROM PFILEstatement. See “Creating a Server Parameter File” for instructions.This statement reads the text initialization parameter file to create a server parameter file. The database does not have to be started to issue aCREATE SPFILEstatement. - Start up or restart the instance.The instance finds the new SPFILE in the default location and starts up with it.
Leave a Reply