Oracle instance Idle

[Former Member]

Hello to all experts,

I have just upgraded my oracle database 9i to 10g and also upgraded the patch set to 10.2.0.2.0 suceesfully but when iam trying to connect to databse @sqlplus it showing me the msg that connected to idle instance and I have to manually start the database . After sometime its giving me another msg that Oracle instance terminated : disconnection forced.

please throw some light on it.

[Former Member]

thanks

[Former Member]

Thanks for the help, here are the errors.

ORA-00202: controlfile: 'D:\oracle\PRD\origlogA
cntrl\cntrlPRD.dbf'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Media Recovery failed with error 264

Errors in file d:\oracle\prd\saptrace\usertrace\prd_ora_3044.trc:

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Sat Jul 05 00:40:54 2008

Errors in file d:\oracle\prd\saptrace\background\prd_pmon_2844.trc:

ORA-00704: bootstrap process failure

Errors in file d:\oracle\prd\saptrace\background\prd_mman_1076.trc:

ORA-00704: bootstrap process failure

Errors in file d:\oracle\prd\saptrace\background\prd_lgwr_2688.trc:

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Errors in file d:\oracle\prd\saptrace\background\prd_pmon_3864.trc:

[andreas_herzog]

are you sure about the two backslashes before cntrl?

> ORA-00202: controlfile: 'D:\oracle\PRD\origlogA
cntrl\cntrlPRD.dbf'

=>
cntrl\cntrlPRD.dbf'

the file cntrlPRD.dbf exists? what does the PFILE say about the location of the control files?

GreetZ, AH

[Former Member]

Yes, there ar two // before control

[Former Member]

Yes,the control file and the path for that file on system is

D:\oracle\PRD\saparch\cntrl

[Former Member]

Sorry, I am not an databse guy can u please suggest me where to look for Parameter file in my dir structure.

[Former Member]

There are two CNTRL<SID>.DBF files in my directory structure one is in

D:\oracle\PRD\origlogA\cntrl

and the other one is in

D:\oracle\PRD\saparch\cntrl

is that common.

[Former Member]

Sorry, I am not an databse guy can u please suggest me where to look for Parameter file in my dir structure.

The parameter file is in $ORACLE_HOME\dbs (X:\oracle\SID\102_64\dbs), the name is most probably spfileSID.ora. If there is no spfile, then look out for a initSID.ora at the same place.

The parameter name is control_files.

Regards

Michael

[Former Member]

control_files=D:\oracle\PRD\origlogA
cntrl\cntrlPRD.dbf, D:\oracle\PRD\saparch\cntrl\cntrlPRD.dbf, D:\oracle\PRD\sapdata1\cntrl\cntrlPRD.dbf

Does *
* after cntrl is wrong, should i edit this parameter

[former_member204746]

yes, edit this parameter, take out the double backslashes

then, restart Oracle.

[Former Member]

Hi

Can you please look into the alertlog, it is in /oracle/SID/saptrace/background/alert_SID.log. If you cannot resolve it yourself, please post the errors here.

Best regards

Michael