ISSUE WHILE DOING THE DATABASE UPGRADE :

DOC>#######################################################################

DOC>#######################################################################

DOC>   The following error is generated if (1) the old release uses a time

DOC>   zone file version newer than the one shipped with the new oracle

DOC>   release and (2) the new oracle home has not been patched yet:

DOC>

DOC>      SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME')

DOC>                       *

DOC>      ERROR at line 1:

DOC>      ORA-01722: invalid number

DOC>

DOC>     o Action:

DOC>       Shutdown database ("alter system checkpoint" and then "shutdown abort").

DOC>       Patch new ORACLE_HOME to the same time zone file version as used

DOC>       in the old ORACLE_HOME.

DOC>

DOC>#######################################################################

DOC>#######################################################################

DOC>#

SELECT TO_NUMBER('MUST_PATCH_TIMEZONE_FILE_VERSION_ON_NEW_ORACLE_HOME')

                 *

ERROR at line 1:

ORA-01722: invalid number

Solution:

1. We have crosschecked whether RDBMS DST patch is applied to the 11.2.0.4 home or not, and found it is fine. 

2. As per the given error (1) to make sure we have 11.2.0.3 RDBMS DST patch on 11.2.0.4 home, we have applied it manually (=not using opatch). 

We followed the below process.

•             2  *17.dat files and the readme_17.txt from the $ORACLE_HOME/oracore/zoneinfo of 11.2.0.3 home to 11.2.0.4 $ORACLE_HOME/oracore/zoneinfo directory,

•             2 *17.dat files $ORACLE_HOME/oracore/zoneinfo/big of 11.2.0.3 home to 11.2.0.4 $ORACLE_HOME/oracore/zoneinfo/big directory,

•             2 *17.dat files $ORACLE_HOME/oracore/zoneinfo/little of 11.2.0.3 home to 11.2.0.4 $ORACLE_HOME/oracore/zoneinfo/little directory, as it is simply adding new files, not replacing used ones.