Oracle Upgrade Catupgrd.sql failed: with SELECT TO_NUMBER('MUST_BE_11_2_0_3') FROM v$instance


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



Again you can verify the service properties by opening the services.msc. Please see the screen shot below.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google