Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Start Instance with a Minimal Initialization Parameter File?

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.

Total System Global Area 113246208 bytes

Fixed Size 1286028 bytes

Variable Size 58720372 bytes

Database Buffers 50331648 bytes

Redo Buffers 2908160 bytes

 167 views

More Questions for you: