ORACLE parameter file introduction, oracle parameter Introduction

ORACLE parameter file introduction, oracle parameter Introduction

After the ORACLE database is started, you can use the select * from v $ parameter statement to view all the parameters used by the oracle database.

 

Oracle parameter files are divided into spfile binary files and pfile text files. Currently, the database generally uses the spfile binary file as the parameter file for oracle startup. Differences between spfile and pfile:

 

1. spfile is a binary file (which can be viewed using string spfileorcl. ora). It cannot be modified using a text editor, but can only be dynamically modified using commands in sqlplus. If pfile is a text file, you can directly use the text editor to modify it. It takes effect after the database is restarted.

2. spfile must be stored on the server, generally under the $ ORACLE_HOME/dbs directory. For pfile, it can be stored on the client, and the database can be started through the pfile on the client.

3. spfile and pfile can be dynamically converted to SQL commands (whether or not the database instance is started or not)

 

Use pfile to create spfile create pfile = '/u01/app/oracle/dbs/spfileorcl. ora 'from pfile = '/u01/app/oracle/dbs/initorcl. ora '(or use create spfile from pfile)

 

4. If the start database does not specify the parameter file (if the sid is orcl), search for the parameter file spfileorcl. ora> initorcl. ora in the $ ORACLE_HOME/dbs directory.

 

5. You can specify a parameter file to start the database (only the pfile file can be used, not the spfile file)

Startup pfile = '/u01/app/oracle/dbs/init. ora' (use the pfile file)

 

 

 

6. For parameters not specified in the parameter file, the default values of relevant parameters are used.

For oracle parameter files

Spfile is a binary file and cannot be edited. If you want to edit the text. You need to generate a PFILE that can be edited.
Statement: create pfile from spfile;
The pfile and spfile are generated in the same directory (WINDOWS: $ ORACLE_HOME/DATABASE ).
UNIX: $ ORACLE_HOME/DBS)
If you need to use the pfile parameter file to start data, you need to rename the SPFILE file or specify the PFILE file at startup.
If the pfile parameter file does not contain the db_cerate_file_dest parameter. You can add this parameter in the format at the end. I will not talk about the specific parameter settings and functions.

Oracle parameter file

The initialization file initORCL. ora and initORCL. ora record the path of the control file. So the content is correct.
You can
Create pfile = 'e: \ oracle \ aaa. ora 'from spfile;
View the e: \ oracle \ aaa. ora file.
Here the record is your parameter and can be modified
Then generate the spfile file through the pfile file.
Create spfile from pfile = 'e: \ oracle \ aaa. ora ';
Start the database.
Pfile is text and can be modified, but the modification takes effect only after the database is restarted.
Spfile is binary and cannot be modified manually. You can modify parameters online without restarting the database.