Oracle Database Interview Question:

How To Create an Initialization Parameter File?

Submitted by: Administrator

This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters.

The easiest way to create an initialization parameter file to copy from the sample file provided by Oracle. You can do this in a command window as shown below:

>cd $ORACLE_HOME

>copy .configscriptsinit.ora .databaseinitggl_ini.ora

>edit .databaseinitggl_ini.ora
(replace XE by ggl)

In this example, only the SID is changed from XE to ggl. All other parameters are maintained as is.
Submitted by: Administrator