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