Relationship between Oracle parameter files and server-related parameter files

The following articles mainly introduce Oracle parameter files and server-related parameter files. We all know that in Oracle, server parameter files are created through the parameter files of the relevant Oracle database, the following describes the main content of the article.

Because the spfile. ora file is a binary file, it is possible that Oracle cannot recognize it after spfile. ora is manually modified, and it cannot be started. The solution is as follows:

1. Find the pfile of the corresponding instance: There is an init under the 10.0.2 \ admin \ Instance name \ pfile \ folder. ora. xxxxxxxxxxx file, which is a pfile with a timestamp. Remove the timestamp and convert it to init. ora file.

2. log on to the database through oralce SQL * PLUS

SQL> conn username/password as sysdba-the login user must have sysdba or sysoper Permissions

SQL> startup pfile = '10. 0.2 \ admin \ Instance name \ pfile \ init. ora ';

Start the database with the specified text Oracle parameter file.

Create server parameter files using text parameter files

SQL> create spfile = 'oracle _ HOME/database/spfileSID. ora 'from pfile = '10. 0.2 \ admin \ instance \ pfile \ init. ora ';

3. Copy the generated file spfileSID. ora to the Oracle_HOME/database directory to overwrite the original file (if the initSID. ora file exists, rename it ).

4. Start Oracle.

 
 

  
  
SQL>startup； 
 
 

For example:

 
 

  
  
C:\Documents and Settings\Administrator>sqlplus /nolog  
  
  
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 10 11:21:42 2008  
  
  
Copyright (c) 1982, 2005, Oracle. All rights reserved.  
  
  
SQL> connect / as sysdba  
  
  
Connected to an idle instance.  
  
  
SQL> startup pfile='E:\Oraclexe\app\Oracle\product\
10.2.0\server\config\scripts\init.ora';  
  
  
Oracle instance started.  
  
  
Total System Global Area 285212672 bytes  
  
  
Fixed Size 1287016 bytes  
  
  
Variable Size 92277912 bytes  
  
  
Database Buffers 188743680 bytes  
  
  
Redo Buffers 2904064 bytes  
  
  
Database mounted.  
  
  
Database opened.  
  
  
SQL> create spfile='E:\Oraclexe\app\Oracle\product\
10.2.0\server\dbs\SPFILEXE1.ORA'from pfile=
'E:\Oraclexe\app\Oracle\product\10.2.0\server\config\scripts\init.ora';  
  
  
File created.  
  
  
SQL>STARTUP;   
 
 

The above content is the description of the Oracle parameter file and the server parameter file, hoping to help you in this regard.