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
Â
2018-05-08, 1965👍, 0💬
Popular Posts:
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...