Upgrading to 11.2.0.2 - dbua problem

[audunlea_hansen]

Hi!

I'm upgrading one of my 11.2.0.1 64-bit bases to 11.2.0.2 (Linux RHEL5)

When I start dbua.sap.sh this installation fails to retrieve db information due to:

"The Upgrade Assistant failes in bringing up the database XXX. Oracle Home /oracle/XXX/11202 obtained from file /etc/oratab was used to connect to the database. Either the database is not running from Oracle Home /oracle/XXX/11202 or the correct Initialization Parameter file (pfile) was not found" Then it asks me to locate the pfile.

There are some errors in this message:

The database are up and running in ORACLE_HOME: /oracle/XXX/112_64.

11202 are not in /etc/oratab

Parameters are set:

oraxxx> set |grep 112

ADD=/oracle/XXX/11202/lib

LD_LIBRARY_PATH=/usr/sap/XXX/SYS/exe/run:/oracle/XXX/11202/lib

ORACLE_HOME=/oracle/XXX/11202

ORACLE_HOME_SRC=/oracle/XXX/112_64

ORACLE_HOME_TGT=/oracle/XXX/11202

ORA_NLS33=/oracle/XXX/112_64/ocommon/nls/admin/data

PATH=/oracle/XXX/11202/bin:/site/home/oraxxx:/usr/sap/XXX/SYS/exe/run:/local/bin:/local/gnu/bin:/usr/bin:/local/sbin:/usr/X11R6/bin:/bin:/usr/games:.

dbua.sap.sh -q runs with no errors.

I've upgraded 3 PI-systems and one EP system without this error.

Have tried to reinstall 11.2.0.2 SW insc SBP form 201104.

Have crosschecked again with Note 1524205 - no missing steps.

Any suggestions?

Regards

Audun

[Former Member · Accepted solution]

Hi you need to check the log directories from the dbua and make sure they are cleared out. Specifically the Welcome_<SID>.txt file which is located in the ORACLE_BASE/cfgtoollogs/dbua/logs/ directory, if this file exists already the dbua thinks it is a rerun and will act differently when it is executed. These Oracle 'wizards', seem to create files in places that they want to 're-read' so be aware of this as well. Hope this helps resolve your issue.

[audunlea_hansen · Accepted solution]

Thanks Stefanie

I didn't see Your update before I tried a lot of stuff, but move $ORACLE_BASE/cfgtoollogs/dbua/logs/* files and restart the upgrade solved the problem!

Regards

Audun

[audunlea_hansen]

Have tried to upgrade 2 other db's like that one I've got trouble to upgrade. Both upgraded fine.

I'll try the problem-db again this weekend. Since those two others went fine, it's most likely an env-setting problem somewere on that host.

Are there any debug option to the sap-script?

Regards

Audun

[volker_borowski2]

Hi,

according to note 830578: ORA_NLS33 should not be used any more,

and I mind to rememeber, that the upgrade note states the very same.

The LIBPATH should have $ORACLE_HOME/lib at the beginning.

Your listener is down at that point?

Did you check that 112_64 is still pointing to your old SW location.

May be the 10202 install already switched the symlink?

Volker

Hum: /usr/games in the orasid PATH looks strange

[audunlea_hansen]

Hi!

So fare no good....

I've tried to upgrade my db again. Checked and followed Note 1524205 and checked parameters in 830578.

Retyped /etc/oratab

/oracle/HRD/112_64 are the real 112_64 home.

Why dbua not are using the right ORACLE_HOME for connecting to the database are a mystery:

From the run og dbua.sap.sh:

Upgrading from 11.2: no need to run script set_compatible.sql again.

==============================

Custom scripts selected to use

==============================

/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/post_upgrade_tasks.sql

/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/set_remote_os_authent.sql

/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/sapuprof_profile.sql

/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/post_upgrade_checks.sql

================

Upgrade Settings

================

Query mode : N

.

DBUA silent mode : N

TSTZ upgrade method : DBUA

Using custom scripts : Y

DIAGNOSTIC_DEST : /oracle/HRD/saptrace

AUDIT_FILE_DEST : /oracle/HRD/saptrace/audit

Configure Enterprise Manager: -emConfiguration NONE

.

DBUA environment :

DBUA command : /oracle/HRD/11202/bin/dbua

DBUA command line options : -sid HRD -oracleBase /oracle -oracleHome /oracle/HRD/112_64 -recompile_invalid_objects true -emConfiguration NONE -upgradeTimezone -postUpgradeScripts /oracle/HRD/11202/sap/ora_upgrade/post_upgrade/post_upgrade_tasks.sql,/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/set_remote_os_authent.sql,/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/sapuprof_profile.sql,/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/post_upgrade_checks.sql

DBUA command line : /oracle/HRD/11202/bin/dbua -sid HRD -oracleBase /oracle -oracleHome /oracle/HRD/112_64 -recompile_invalid_objects true -emConfiguration NONE -upgradeTimezone -postUpgradeScripts /oracle/HRD/11202/sap/ora_upgrade/post_upgrade/post_upgrade_tasks.sql,/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/set_remote_os_authent.sql,/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/sapuprof_profile.sql,/oracle/HRD/11202/sap/ora_upgrade/post_upgrade/post_upgrade_checks.sql

.

Date/time :

===================

Upgrade Environment

===================

Database to upgrade : HRD

ORACLE_BASE : /oracle

ORACLE_HOME (Source): /oracle/HRD/112_64 (Release / 11.2)

ORACLE_HOME (Target): /oracle/HRD/11202 (Release 11.2.0.2)

DBUA log directory : /oracle/cfgtoollogs/dbua/HRD/upgrade2

Log file : /oracle/HRD/11202/sap/ora_upgrade/post_upgrade/dbua.sap_11202.log

Take a look at http://folk.uio.no/audunle/HRD_snapshot.png

to see screen snapshot from dbua.

I've searched for oratab file elsewhere on the server. /etc/oratab are the only one.

Does someone have a good idea?

Regards

Audun

DBA

[former_member184473]

Hello Audun,

The following note could be also useful:

[1431797 Oracle 11.2.0: Troubleshooting the Database Upgrade|http://service.sap.com/sap/support/notes/1431797]

Regards,

Eduardo Rezende

[Former Member]

Hi Audun,

Did you checked " Note 1431793 - Oracle 11.2.0: Upgrade Scripts"?

Best regards,

Orkun Gedik

Senior SAP Netweaver and Development Consultant

SAP Technical Architect