Basic Oracle Concepts and Programming Question:

How To Create an Initialization Parameter File?

Tweet Share WhatsApp

Answer:

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.

Download Oracle Database PDF Read All 430 Oracle Database Questions
Previous QuestionNext Question
How To Establish Administrator Authentication to the Server?How To Connect the Oracle Server as SYSDBA?