Skip to Content
0
Former Member
Jan 16, 2012 at 11:35 AM

DBUA upgrade assistant error

1367 Views

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