Manually Upgrade the time zone in Oracle Database 12c

Procedure:


Go the directory path /oracle/<SID>/12201/oracore/zoneinfo, check for the latest time file available .

SQL> shu immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup upgrade;

ORACLE instance started.

Total System Global Area 2885681152 bytes

Fixed Size                  8624840 bytes

Variable Size            1493173560 bytes

Database Buffers         1375731712 bytes

Redo Buffers                8151040 bytes

Database mounted.

Database opened.

SQL> EXEC DBMS_DST.BEGIN_UPGRADE (27);

PL/SQL procedure successfully completed.

SQL> shu immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 2885681152 bytes

Fixed Size                  8624840 bytes

Variable Size            1493173560 bytes

Database Buffers         1375731712 bytes

Redo Buffers                8151040 bytes

Database mounted.

Database opened.

SQL> select version from v$timezone_file;

   VERSION

----------

        27

Suggestion:

Maintain the proper backup of the system before proceeding fore the upgrade.