DBUA upgrade assistant error

[Former Member]

Experts,

I am trying to upgrade an oracle DB 10.2.0.2 to 11.2, on AIX platfrom after completing the pre_uprgrade activity, while

trying to run the "DBUA" for post_upgrade activity, getting an error as the "DB is down/not open" but ironically

the DB is up and running and in open status.

/etc/oratab sitll has the old "oracle_home".

/oracle/cfgtoollogs/dbua/logs- doesnot contatin "Welcome_SID.txt" either.

while running the command ./dbua.sap.sh, the DBUA is gathering the database information after

some time its returning a "Null" value. and unable to proceed.

where as while running the command ./dbua.sap.sh -silent the belwo error in log directory

"The Upgrade Assistant failed in executing any query on the database SID. Oracle

Home /oracle/SID/102_64 obtained from file /etc/oratab was used to connect to th

e database. Either the database is not running from Oracle Home /oracle/SID/102_

64 or its not in OPEN status. Correct the error and run the Upgrade Assistant ag

ain."

Thanks in advance.

Ahamed

[Former Member]

Hi Ahamed,

Can you please paste the contents of oratab file.

Regards,

Ershad Ahmed.

[Former Member]

Hi Ershad,

Please find the oratab entries, I am trying to update the SV1 database (from 10.2.0.4 to 11.2), where as

the SE1 db is already updated successfully, without this error.

SB1:/oracle/SB1/102_64:N

SV1:/oracle/SV1/102_64:N

SE1:/oracle/SE1/112_64:N

thanks

Ahamed

[Former Member]

Hi Ahamed,

Can you please comment SB1 and SE1 and try to upgrade SV1 database.

Your oratab file should like this.

#SB1:/oracle/SB1/102_64:N

SV1:/oracle/SV1/102_64:N

#SE1:/oracle/SE1/112_64:N

Regards,

Ershad Ahmed.

[Former Member]

Hi Ershad,

I have tried the settings in "oratab" but no luck.

I really dont understand, why the DBUA GUI is unable to recognize the status of DB, even though

as the DB is in "Open" state.

Thanks

Ahamed

[Former Member]

Hi Ahmed,

Please recheck if your Environment variables are set correctly.

ORACLE_SID,ORACLE_HOME and SAPDATA_HOME.

Regards,

[Former Member]

Hi Baig,

Its currently pointing to my "old orace_home" which is 10.2.0.4 and before executing

"./dbua.sap.sh" I have set the source and TGT respectively.

Thanks

Ahamed

[Former Member]

Hi Ahmaed,

Ensure that you have write permissions on /etc/oratab.

Did you start dbua.sh with user orasid ?

Regards,

Ershad Ahmed.

[Former Member]

Hi Ershad,

the directory (/etc/oratab) has the write permission to the user "ora<sid>".

My oratab

SID:/oracle/SID/102_64:N (old oracle home)

thanks

Ahamed

[Former Member]

Hi,

Please check SAP provided standard upgrade guide, Guide clearly confirmed following.

"If the source database runs Oracle 10.2.0.2, you need to first update the source database to at least patch set 10.2.0.4 or 10.2.0.5. You can then perform the upgrade from 10.2.0.4 or 10.2.0.5 to 11.2.0.2, as described in this guide."

Thanks,

Kapil

[Former Member]

Hi Kapil,

We are already in the Oracle patch 10.2.0.4.0, sorry for the miscommunication.

We have more than one DB running on that particular instance/server

Thanks

Regards

[Former Member]

Hi Ahamed,

From the Oracle Upgrade guide..I assume you would have stopped SAP and Listener

1.

Stop the SAP application server by entering the following command as user <sapsid>adm:stopsap r3

2.

Stop the Oracle listener by entering the following command as user ora<dbsid>:lsnrctl stop

Next thing to check is the Environment variables.

Enter these commands to upgrade from 10.2.0.x to 11.2.0.3:

setenv ORACLE_HOME_SRC /oracle/<DBSID>/102_64

setenv ORACLE_HOME_TGT /oracle/<DBSID>/11203

If you have not set the above env variables please do so.

Run dbua.sap.sh

You did mention that Database is up and running, please cross check with the following command.

select status from v$instance;

It should come back with OPEN

Is this the only SAP system running on that box or do you have any other systems. /etc/oratab should contain an entry and it should be of old version.

If all the above things does not work. Restart ur Database and try again.

If not shutdown the DB and run dbua.sap.sh

dbua.sap.sh should automatically start the DB.

Regards,

Ershad Ahmed.

[Former Member]

Hi Ershad/Baig,

Thanks for your valuable inputs.

1. The SAP & listener both are stopped.

The ORACLE_HOME_SRC & ORACLE_HOME_TGT has been already set and I have old oracle home entry

"oratab" file

I have tried once again (dbua.sap.sh) after completely stopping the DB and results are similar, DBUA throwing

an error as "Null" and exiting. I cant proceed further with DBUA.

"Error: Starting Database Upgrade Assistant in interactive mode ...

. Database Upgrade Assistant finished with return code -1"

Ershad: The DB was in "OPEN" STATUS when I tried before, but still its throwing as an error.

Regards

Ahamed

[Former Member]

Hi Ahamed,

You Should Shutdown your database and stop all ORACLE / SAP Services and then start DBUA from the script.

Regards,