Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006


[Help]can 'T find init file for database "xxx" This is how? Distressed Ch'ing

AS4U2 system, Oracle version 9.2.04 to 9.2.06 appreciation, not just packed Kai, dbstart suggested : can 't find init file for database, our colleagues, how to solve the problem that way?

Direct :
Sqlplus "/ as sysdba"
Startup
Look normal.

Sqlplus "/as sysdba"
Create pfile from spfile;

I tried two upstairs, or not, I changed dbstart script, and everything, some stickers, which also got from the Internet.

- The dbstart script, 1976
- Add the following line :
SPFILE=${ORACLE_HOME}/dbs/spfile${ORACLE_SID}.ora
After this line :
PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

- Change :
$PFILE If [-f]; then
To :
If [-f] $SPFILE $PFILE -o-f;

-->
This is obviously from a spfile adding that the judgment pfile space can be initiated, how could not directly startup! ! !

But I tried sqlplus "/ as sysdba"
Startup
Dbstart after it is reported or not init file, I was just learning vegetable and another to ask sqlplus "/ as sysdba" Why?
O9 installed in composites now, I still learn, too dishes really sorry! 8)



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com