Basic Oracle Concepts and Programming Question: Download Questions PDF
How To Start Instance with a Minimal Initialization Parameter File?
Answer:
The sample initialization parameter file provided by Oracle seems to be not working. But we can try to start the new instance with a minimal initialization parameter file (PFile). First you can create another PFile, $ORACLE_HOME/database/initggl_ini_min.ora, as shown below:
db_name=ggl
control_files=("oraclexeoradatagglcontrol.dbf")
undo_management=AUTO
Then start the ggl instance again:
SQL> CONNECT / AS SYSDBA
Connected.
SQL> STARTUP NOMOUNT
PFILE=$ORACLE_HOME/database/initggl_ini_min.ora
ORACLE instance started.
<pre>Total System Global Area 113246208 bytes
Fixed Size 1286028 bytes
Variable Size 58720372 bytes
Database Buffers 50331648 bytes
Redo Buffers 2908160 bytes</pre>
db_name=ggl
control_files=("oraclexeoradatagglcontrol.dbf")
undo_management=AUTO
Then start the ggl instance again:
SQL> CONNECT / AS SYSDBA
Connected.
SQL> STARTUP NOMOUNT
PFILE=$ORACLE_HOME/database/initggl_ini_min.ora
ORACLE instance started.
<pre>Total System Global Area 113246208 bytes
Fixed Size 1286028 bytes
Variable Size 58720372 bytes
Database Buffers 50331648 bytes
Redo Buffers 2908160 bytes</pre>
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Start a Specific Oracle Instance? | How To Run CREATE DATABASE Statement? |