Oracle spfile parameter file

Pfile is used for Oracle8i and can also be used in oracle9i. It exists in text form and can be modified in vi editor. For oracle9i and later versions, oracle can use the server parameter file (spfile, system parameter file) to replace the traditional init. ora parameter file.

Spfile is a binary file created by oracle at the operating system level to store database parameters.

When the startup command without the pfile clause is used, oracle reads the initialization parameters from the server parameter file (spfile) in the default location specified by the platform. oracle searches for spfile or the init. the order of ora is: in the default location specified by the platform, oracle first looks for the file named spfile $ oracle_sid.ora. If not, it looks for the spfile. find the init $ oracle_sid.ora file.

Under $ oracle_base \ admin \ db_name \ spfile, you may see an init. ora.192003215317] Name of the file, which is the initialization parameter file, just keeping up with the timestamp. for oracle920, spfile is started by default, but this spfile is not created out of thin air, but created based on this file. You can remove this long suffix, that is, the standard pfile file.

You can create a pfile Based on spfile, edit and modify it, and then create a spfile by pfile to modify the spfile:

Method for creating pfile from spfile:

1. log on to sqlplus with sysdba permission

2. Run: create pfile = 'd: \ a. ora 'from spfile;

In this case, the default spfile is used to export editable text files. Or create pfile = 'd: \ a. ora 'from spfile = 'd: \ spfileXE. ora', and specify the specific path of the spfile file.

You can also create the spfile file: create spfile from pfile = 'd: \ a. ora 'based on the pfile file ';