HP-UX 10.2.0.1 升級到 10.2.0.3 時報 ORA-20000: Upgrade re-run not supported from version

ysjxjf發表於2008-03-17
SELECT version_script AS file_name FROM DUAL
*
ERROR at line 1:
ORA-20000: Upgrade re-run not supported from version
ORA-06512: at "SYS.VERSION_SCRIPT", line 45


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
透過 update registry$ set prv_version='' where cid='CATPROC' 更新到你要升級到的 version
再次執行, 不會報錯
[@more@]

Bug No.

5071433

Filed

01-MAR-2006

Updated

02-MAR-2006

Product

Oracle Universal Installer

Product Version

10.2.0.2

Platform

Red Hat Advanced Server

Platform Version

3

Database Version

10.2.0.2

Affects Platforms

Generic

Severity

Severe Loss of Service

Status

Closed, Not a Bug

Base Bug

N/A

Fixed in Product Version

No Data


Problem statement:

CATUPGRD.SQL IN 10.2.0.2 FAILS WITH ORA-20000


 

*** 03/01/06 09:24 am ***

.

=========================

PROBLEM:

1. Clear description of the problem encountered:

.

- Upgrading from 10.2.0.1 to 10.2.0.2

.

- The catupgrd.sql script for 10.2.0.2 fails with :

.

...

SELECT version_script AS file_name FROM DUAL

*

ERROR at line 1:

ORA-20000: Upgrade re-run not supported from version

ORA-06512: at "SYS.VERSION_SCRIPT", line 45

...

.

.

=========================

DIAGNOSTIC ANALYSIS:

.

- catupgrd.sql creates a pl/sql function called version_script which fails

with the above errors.

.

- The error is raised in one place in this function:

.

EXECUTE IMMEDIATE 'SELECT prv_version

FROM registry$ where cid=''CATPROC'''

INTO p_prv_version;

IF substr(p_prv_version,1,5) = '8.1.7' THEN

RETURN '0801070';

ELSIF substr(p_prv_version,1,5) = '9.0.1' THEN

RETURN '0900010';

ELSIF substr(p_prv_version,1,5) = '9.2.0' THEN

RETURN '0902000';

ELSIF substr(p_prv_version,1,6) = '10.1.0' THEN

RETURN '1001000';

ELSIF substr(p_prv_version,1,6) = '10.2.0' THEN

RETURN '1002000';

ELSE

RAISE_APPLICATION_ERROR(-20000,

'Upgrade re-run not supported from version ' || p_prv_version );

END IF;

.

- The value of prv_version in registry$ is null therefore we fail.

- I checked several 10.2.0.1 databases, prv_version was always null.

.

.

.

=========================

WORKAROUND:

.

- None.

.

=========================

RELATED BUGS:

.

=========================

REPRODUCIBILITY:

.

- Each time the script is run.

.

.

.

=========================

TESTCASE:

========================

STACK TRACE:

.

=========================

SUPPORTING INFORMATION:

*** 03/01/06 11:52 am *** (CHG: Asg->NEW OWNER)

*** 03/01/06 11:52 am ***

*** 03/01/06 11:53 am ***

*** 03/02/06 07:30 am *** (CHG: Sta->92)

*** 03/02/06 07:30 am ***

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66634/viewspace-1001061/,如需轉載,請註明出處,否則將追究法律責任。

相關文章