Initialization Parameter Files

- Initialization Parameter Files

 

When you start the instance, an initialization parameter file is read.

There are two types of parameter files:

 

•Server parameter file

  - It is a binary file that can be written to and read by the database server

     and must not be edited manually.

  - It resides in the server that the Oracle database is executing on,

    and is persistent across shutdown and startup.

  - This is often referred to as a server parameter file (SPFILE).

  - The default name of this file, which is automatically sought at startup, is spfile<SID>.ora.

 

•Text initialization parameter file

 - This type of initialization parameter file can be read by the database server,

      but it is not written to by the server.

  - The initialization parameter settings must be set and changed manually by using a text editor

     so that they are persistent across shutdown and startup.

  - The default name of this file, which is automatically sought at startup

     if an SPFILE is not found, is init<SID>.ora.

  - Default location is $ORACLE_HOME/dbs.

  

 

-Oracle DBA 10g workshop l-