SQL Statement or script failed.

[Former Member]

Dear All,

While uploading the IDES 5.0 version of SAP in system, I am getting the below mentioned error. Can any one help to solve the problem.

I have already verified the Oracle updation, I am not finding any problem in it.

Error:

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message:

ORA-01092: Oracle instance terminated. Disconnection forced.

Can any one tell me what all I need to check to overcome the above problem.

It is quite urgent. Maximum points will be awarded for the solution.

Regards,

Dilip

[Former Member]

Hello Dilip,

Please follow the following steps -

su - ora<SID>

sqlplus "/ as sysdba"

sql> startup nomount;

sql> alter database mount ;

if database is not mounting properly, try to mount database by using other copy of control file. Change the control file path in pfile or spfile.Retry mounting the database again also examine the alert log for more details.

then try to open database in normal mode

sql> alter database open

if it fails then open the database in reset.

sql> alter database open resetlogs;

Regards,

Pratap

[markus_doehr2]

The database crashed - please post the last lines of alert<SID>.log in the saptrace/background directory.

Are you using 10.2.0.2 with the latest patches?

Markus