Oracle Database - How To Start Instance with a Minimal Initialization Parameter File
Interview Question Database For Software Developers
|
|
| How To Start Instance with a Minimal Initialization Parameter File | | How To Start Instance with a Minimal Initialization Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually | | By: 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
| | ID: 512 | Rank: 1078 | Votes: 0 | Views: 32 | Submitted: 20070423 |
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view