on 01-16-2012 11:35 AM
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
Hi Ahamed,
Can you please paste the contents of oratab file.
Regards,
Ershad Ahmed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ahmaed,
Ensure that you have write permissions on /etc/oratab.
Did you start dbua.sh with user orasid ?
Regards,
Ershad Ahmed.
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 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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Ahamed,
You Should Shutdown your database and stop all ORACLE / SAP Services and then start DBUA from the script.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.