on 08-22-2010 1:52 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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.
That did it in my case, too. Thanks Sven for the solution. And thank you for your propper summary, Mohammad.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.