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, 4821🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...