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)