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, 3597🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...