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? |
| ☺ | How Run SQL*Plus Commands That Are Stored in a Local File? |
| ☺ | What Happens to Indexes If You Drop a Table? |
| ☺ | How To Run SQL*Plus Commands in SQL Developer? |
| ☺ | How To Use Values from Other Tables in UPDATE Statements using 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. |
