Start with a Minimum Initialization Parameter File in Oracle

Q

How To Start Instance with a Minimal Initialization Parameter File in Oracle?

✍: FYIcenter.com

A

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/initFYI_ini_min.ora, as shown below:

db_name=FYI
control_files=("\oraclexe\oradata\FYI\control.dbf")
undo_management=AUTO

Then start the FYI instance again:

SQL> CONNECT / AS SYSDBA
Connected.

SQL> STARTUP NOMOUNT
   PFILE=$ORACLE_HOME/database/initFYI_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

 

Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2016-10-16, 206👍, 0💬