Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: 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
2007-04-23, 4690👍, 0💬
Popular Posts:
How can you check to see whether a symbol is defined? You can use the #ifdef and #ifndef preprocesso...
How To Escape Special Characters in SQL statements? - MySQL FAQs - Introduction to SQL Basics There ...
An application needs to load a library before it starts to run, how to code? One option is to use a ...
What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...
Regarding C Coding Given: Line in file Contents 30 int * someIDs, theFirst, *r; 110 someIDs =GetSome...