【转】Oracle Upgrade Catupgrd.sql failed: with SELECT TO_NUMBER('MUST_BE_11_

monkeybird

Error Description

During the oracle upgrade from Oracle 11.2.0.1 to 11.2.03(windows), the catupgrd.sql failed with following error.

SELECT TO_NUMBER('MUST_BE_11_2_0_3') FROM v$instance

                 *

ERROR at line 1:

ORA-01722: invalid number

Solution description:

Disclaimer: This would be the one of the reason which I faced during the upgrade.

As part of the upgrade you have to drop the Oracle database service (Eg: OracleServiceORCL) for the older/ source version of the database using the following commands.

NET STOP OracleServiceORCL – Stopping the service

ORADIM -DELETE -SID ORCL   - Dropping the service.

ORACLE_HOME=D:\app\product\11.2.0\dbhome_1

D:\>NET STOP OracleServiceORCL

The OracleServiceORCL service is stopping.................

The OracleServiceORCL service was stopped successfully.

D:\>

D:\>NET STOP OracleServiceORCL

The OracleServiceORCL service is stopping........

The OracleServiceORCL service was stopped successfully.

D:\>ORADIM -DELETE -SID ORCL

Instance deleted.

Make sure you have properly deleted the source version service.

Open up the services.msc from the cmd run prompt and verify it is deleted properly.

Before executing the catupgrd.sql you should start the new service for the target version database using the new ORACLE_HOME(11.2.0.3) ORADIM executables.

ORADIM -NEW -SID SID -SYSPWD PASSWORD -STARTMODE AUTO -PFILE %ORACLE_HOME%\DATABASE\INIT<SID>.ORA