HP-UX 10.2.0.1 升級到 10.2.0.3 時報 ORA-20000: Upgrade re-run not supported from version
*
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RHEL4.4下oracle10.2.0.1升級到10.2.0.3Oracle
- 轉windows2003 oracle版本升級 10.2.0.1到10.2.0.3WindowsOracle
- Upgrade Oracle Database from 10.2.0.1 to 11.2.0.4OracleDatabase
- Oracle database 升級(文件)to 10.2.0.4 from 10.2.0.1OracleDatabase
- 靜默升級oracle(文件)to 10.2.0.4 from 10.2.0.1Oracle
- oracle 10 rac 升級 10.2.0.1升級到10.2.0.5Oracle
- Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- Oracle 10g upgrade from 10.2.0.1 to 10.2.0.4Oracle 10g
- 10.2.0.3 升級到 10.2.0.4 database upgrade 報ORA-03113錯誤解決方法Database
- (轉)Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- 【操作】升級資料庫軟體到10.2.0.3資料庫
- 10.2.0.1安裝並升級到10.2.0.5
- oracle rac 10.2.0.1 升級到 oracle 10.2.0.4Oracle
- ORACLE10G 10.2.0.1升級到10.2.0.5Oracle
- Oracle 10.2.0.1 升級到 10.2.0.4--轉載Oracle
- windows 下oracle從10.2.0.1升級到10.2.0.4WindowsOracle
- 解決The given version [xx] is not supported, only version 1 to 10 is supported in this buildUI
- RHEL AS4下升級oracle10g到10.2.0.3Oracle
- oracle 10.2.0.1 rac 升級到10.2.0.4 rac時,dbua升級的元件列表Oracle元件
- 升級 upgrade ORACLE DBOracle
- 升級Oracle10.2.0.1Oracle
- 從10.2.0.1升級到10.2.0.5操作實驗(下)
- oracle 之 安裝10.2.0.1 且 升級到 10.2.0.4Oracle
- 從10.2.0.1升級到10.2.0.5操作實驗(上)
- 用dbua實現oracle 9.2.0.8到10.2.0.1的升級Oracle
- Oracle10g RAC : 10.2.0.1 升級到 10.2.0.4Oracle
- Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)Oracle 10g
- linux下oracle RAC10.2.0.1升級到10.2.0.4LinuxOracle
- windows 2003,oracle 10.2.0.1升級到10.2.0.4WindowsOracle
- [Upgrade] Oracle 10.2.0.1 --> 10.2.0.5 patchset Upgrade.Oracle
- linux平臺下oracle從10.2.0.1升級到10.2.0.4LinuxOracle
- let definitions are not supported by current javascript versionJavaScript
- Project facet Java version 1.8 is not supportedProjectJava
- pg_upgrade大版本升級
- 【UPGRADE】升級到Oracle18c基本步驟參考(留存)Oracle
- zt_oracle9204upgrade升級到oracle9206Oracle
- oracle在linux平臺從10.2.0.1升級到10.2.0.4方法OracleLinux
- Oracle RAC ASM 例項 從10.2.0.1 升級到 10.2.0.4 說明OracleASM