Collections:
Start with a Minimum Initialization Parameter File in Oracle
How To Start Instance with a Minimal Initialization Parameter File in Oracle?
✍: FYIcenter.com
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
⇒ Run CREATE DATABASE Statement in Oracle
⇐ Start a Specific Oracle Instance in Oracle
2018-05-08, 3709🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...