cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01092: ORACLE instance terminated. Disconnection forced

Former Member
0 Kudos

Dear all,

At "Install DBA Tools" step in EHP4 installation I encounter the following error:

"An error occurred while processing option Enhancement Package 4 for SAP ERP 6.0 > SAP Application Server ABAP > Oracle > Central System > Central System( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-01092: ORACLE instance terminated. Disconnection forced Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options .). You can now:

Choose Retry to repeat the current step.

Choose View Log to get more information about the error.

Stop the option and continue with it later."

Having looked at other threads at SDN I found "[Installation of Enhancement Pack 4 with ECC6.0 Errors out. |/thread/1568434 [original link is broken];" as a resolved one but didn't understand exactly how it was resolved.

Can someone please suggest something.

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Can you post the last few lines of alert log ? Also let us know the DB version and its patch level. Confirm whether the DB went down abnormally.

Regards,

Varadharajan M

Former Member
0 Kudos

Following is the alert log:

Thread 1 opened at log sequence 19
  Current log# 3 seq# 19 mem# 0: C:\ORACLE\IDS\ORIGLOGA\LOG_G13M1.DBF
  Current log# 3 seq# 19 mem# 1: F:\ORACLE\IDS\MIRRLOGA\LOG_G13M2.DBF
Successful open of redo thread 1
Sun Aug 22 20:56:15 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Aug 22 20:56:15 2010
SMON: enabling cache recovery
Sun Aug 22 20:56:16 2010
Errors in file e:\oracle\ids\saptrace\usertrace\ids_ora_1416.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Sun Aug 22 20:56:16 2010
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sun Aug 22 20:56:16 2010
Errors in file e:\oracle\ids\saptrace\background\ids_mman_752.trc:
ORA-00704: bootstrap process failure

DB in use is oracle 10.2.0 with patch 10.2.0.4.

Regards.

Mohammad

Former Member
0 Kudos

It looks like the oracle db expects the upgrade mode for some reason.

Did you perform a db upgrade before starting the EHPI?

You can try the following in order to perform a db upgrade manually, but be careful:

sqlplus / as sysdba
shutdown immediate

(db must be completly down)

startup upgrade;

Go to the directory @$ORACLE_HOME/rdbms/admin (path symbols will vary a bit as you are using Windows)

Execute the scripts catupgrd.sql and utlrp.sql manually.

Afterwards shutdown the db and restart it normally. If it worked you can retry the EHPI step as the db should now run.

Also check the logs that the db does not throw any more errors.

Former Member
0 Kudos

Thanks Sven,

Issue resolved following the procedures:

1. Started oracle instance with STARTUP UPGRADE command at sql prompt

2. Applied suggested scripts i.e. catalog.sql, catupgrd.sql and after executing both scripts;

3. Compile using suggested script utlrp.sql

4. Shutdown immediate and startup

This resolved issue and now EHP4 installation is proceeding on smoothly. Thanks for assistance.

Regards.

Former Member
0 Kudos

Thanks Sven, our issue was also resolved as per the instructions given by you.

Edited by: Sushant G on Apr 14, 2011 3:06 PM

Answers (2)

Answers (2)

carsten_esser
Explorer
0 Kudos

That did it in my case, too. Thanks Sven for the solution. And thank you for your propper summary, Mohammad.

Former Member
0 Kudos

Hi,

please check the EHPI and Oracle install logs as well as the Oracle alert log and see if you can find more details for the error you encountered. From what you posted until now it would just be guess work to say what exactly is wrong.