Failed Upgrade: ''Dbua Thinks This Is ...'' ORA-01507 [ID 339887.1]

Failed Upgrade: ''Dbua Thinks This Is A Rerun Operation'' ORA-01507 [ID 339887.1]
		修改时间 16-JUN-2011 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Cause
Solution

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Oracle Server - Standard Edition - Version: 10.2.0.1 to 11.2.0.2 [Release: 10.2 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 16-JUN-2011

Symptoms

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
. If you believe this is
not a Rerun operation, remove the below file and invoke
DBUA again.
/cfgtoollogs/dbua/logs/Welcome_.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/ of database being upgraded,
there are multiple upgrade directories (i.e. upgrade, upgrade0, ...., upgradeN)
b. $ cd $ORACLE_HOME/cfgtoollogs/dbua/
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.

相关内容 产品 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Standard Edition 关键字 DBUA 错误 ORA-1507

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17252115/viewspace-735887/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17252115/viewspace-735887/