cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle upgrade 10.2g to 11g

former_member183984
Participant
0 Kudos

Hi

I have an ides system installed on Oracle 10.2g.

Is it possible to upgrade to 11gR2 without using SAP's packages.

I have installables on Oracle 11gR2.

I have tried it for test purpose, installed the 11g and now while running the DBUA, I get the error that ORA-01507 database not mounted.

Please guide

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

This message was moderated.

Reagan
Advisor
Advisor
0 Kudos

If you have installed the Oracle 11G database software as advised in the upgrade guide then you will be able to upgrade the database from 10G to 11G. SAP is only providing the installation package provided by Oracle. Regarding the error you should check the alert log and other upgrade logs to understand more about the issue.

-Reagan

former_member204080
Active Contributor
0 Kudos

Hi ,

Please check below oracle doc

Failed Upgrade: ''Dbua Thinks This Is A Rerun Operation'' ORA-01507 (Doc ID 339887.1)


Pasting data from doc  as reference


After selection of the database/SID that is to be upgraded, the Database Upgrade Assistant (DBUA) will show a pop-up window that states:

Getting Database Information.  Please Wait...

Then another pop-up is displayed that states:

DBUA thinks this is a Rerun operation and is trying to
connect to the database with the oracle home
<full path of $ORACLE_HOME>.  If you believe this is
not a Rerun operation, remove the below file and invoke
DBUA again.
<full path to $ORACLE_HOME>/cfgtoollogs/dbua/logs/Welcome_<$ORACLE_SID>.txt


Removing the named file in the above error message does not resolve the error.

CAUSE

This problem can be the result of several different causes:

1. A previous upgrade failure forced the database to be shutdown and so the database is not mounted or open.

2. The database is mounted but not in the needed 'startup upgrade' mode.

3. Subsequent runs of DBUA after a failed upgrade attempt created directories that the DBUA finds and prevent it from going further.

SOLUTION

1.  In the case that the first sentence states "null":

a. Shutdown immediate the database
b. Startup upgrade
c. Re-run DBUA

2. In the case that the first sentence states "ORA-01507 - database is not mounted"

a. Verify whether it is mounted/open or if it is idle.
b. Startup upgrade
c. Re-run DBUA

3. If the database is already up and in 'startup upgrade' mode then the cause of the error could be the presence of the upgrade directories:

a. In the $ORACLE_ HOME/cfgtoollogs/dbua/<$ORACLE_SID> of database being upgraded,
there are multiple upgrade directories (i.e. upgrade, upgrade0, ...., upgradeN)
b. $ cd $ORACLE_HOME/cfgtoollogs/dbua/<$ORACLE_SID>
c. $ rm -rf upgrade*
d. Re-run the DBUA

NOTE: If the "startup upgrade" command fails, this will need to be investigated separately.
Listing the potential causes for this failure is beyond the scope of this note.


Regards,

Murali