SQL tutorial | Interview questions | Oracle
Would you like to react to this message? Create an account in a few clicks or log in to continue.
SQL tutorial | Interview questions | Oracle

Database administration, oracle Interview questions, SQL Interview questions, DBMS Interview questions,SQL tutorial


How To Start Instance with a Minimal Initialization Parameter File?

SQL tutorial | Interview questions | Oracle :: Interview questions :: Database interview questions

Go down

How To Start Instance with a Minimal Initialization Parameter File? Empty How To Start Instance with a Minimal Initialization Parameter File?

Post by Micheal Tue Jan 19, 2010 7:37 pm

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

Micheal
Admin

Posts : 243
Join date : 2010-01-10

http://sql-tutorial.co.cc

Back to top Go down

Back to top

- Similar topics

SQL tutorial | Interview questions | Oracle :: Interview questions :: Database interview questions

 
Permissions in this forum:
You cannot reply to topics in this forum