Analysis of Oracle parameter files and server parameter files

The following articles describe the actual operations of the Oracle parameter file and the server parameter file. In the Oracle database, we create the server parameter file through the actual Oracle parameter file, the following describes the specific content of the article. I hope you will find some gains.

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> the user with the conn username/password as sysdba logon 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:\Oracle xe\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:\Oracle xe\app\Oracle \product\10.2.0\server\dbs\SPFILEXE1.
ORA'from pfile='E:\Oracle xe\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.