How To Start Instance with a Minimal Initialization Parameter File?
Submitted by: AdministratorThe 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
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
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Write Date and Time Interval Literals in Oracle? |
☺ | What Happens to Indexes If You Drop a Table? |
☺ | What Is Input Buffer in SQL*Plus? |
☺ | What Happens If You Lost a Data File? |
☺ | How To Recover a Dropped Table in Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |