Oracle Database Interview Question:

How To Start Instance with a Minimal Initialization Parameter File?

Submitted by: Administrator

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>
Submitted by: Administrator