Oracle - Start with a Minimum Initialization Parameter File in Oracle

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

2018-05-08, 532👍, 0💬