Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Create an Initialization Parameter File?
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.
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 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Establish Administrator Authentication to the Server? | How To Connect the Oracle Server as SYSDBA? |