Manual DST upgrade version 11 to 14

SQL >  SELECT   PROPERTY_NAME, SUBSTR (property_value, 1, 30) VALUE
 FROM   DATABASE_PROPERTIES
 WHERE   PROPERTY_NAME LIKE 'DST_%'
 ORDER BY   PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------------------------------------------------------------------------------------------------
-----------
DST_PRIMARY_TT_VERSION         11
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

3 rows selected.SQL > alter session set "_with_subquery"=materialize;

Session altered.SQL > exec DBMS_DST.BEGIN_PREPARE(14);

PL/SQL procedure successfully completed.SQL > SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  FROM DATABASE_PROPERTIES
  WHERE PROPERTY_NAME LIKE 'DST_%'
  ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------------------------------------------------------------------------------------------------
-----------
DST_PRIMARY_TT_VERSION         11
DST_SECONDARY_TT_VERSION       14
DST_UPGRADE_STATE              PREPARE

3 rows selected.SQL > TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;

Table truncated.SQL > TRUNCATE TABLE sys.dst$affected_tables;

Table truncated.

SQL> TRUNCATE TABLE sys.dst$error_table;

Table truncated.SQL > set serveroutput onSQL > BEGIN
   DBMS_DST.FIND_AFFECTED_TABLES
    (affected_tables => 'sys.dst$affected_tables',
    log_errors => TRUE,
    log_errors_table => 'sys.dst$error_table');
    END;
    /

PL/SQL procedure successfully completed.SQL > SELECT * FROM sys.dst$affected_tables;

no rows selectedSQL > SELECT * FROM sys.dst$error_table;

no rows selectedSQL > EXEC DBMS_DST.END_PREPARE;
A prepare window has been successfully ended.

PL/SQL procedure successfully completed.SQL > SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
   FROM DATABASE_PROPERTIES
   WHERE PROPERTY_NAME LIKE 'DST_%'
    ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------------------------------------------------------------------------------------------------
-----------
DST_PRIMARY_TT_VERSION         11
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

3 rows selected.SQL > shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade;
ORACLE instance started.

Total System Global Area 3423965184 bytes
Fixed Size                  2260000 bytes
Variable Size            2583692256 bytes
Database Buffers          822083584 bytes
Redo Buffers               15929344 bytes
Database mounted.
Database opened.
SQL> set serveroutput on
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
    FROM DATABASE_PROPERTIES
    WHERE PROPERTY_NAME LIKE 'DST_%'
    ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------------------------------------------------------------------------------------------------
-----------
DST_PRIMARY_TT_VERSION         11
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

3 rows selected.SQL > purge dba_recyclebin;

DBA Recyclebin purged.SQL > TRUNCATE TABLE SYS.DST$TRIGGER_TABLE;

Table truncated.SQL > TRUNCATE TABLE sys.dst$affected_tables;

Table truncated.SQL > TRUNCATE TABLE sys.dst$error_table;

Table truncated.SQL > EXEC DBMS_DST.BEGIN_UPGRADE(14);
An upgrade window has been successfully started.

PL/SQL procedure successfully completed.SQL > SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
    FROM DATABASE_PROPERTIES
    WHERE PROPERTY_NAME LIKE 'DST_%'
     ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------------------------------------------------------------------------------------------------
-----------
DST_PRIMARY_TT_VERSION         14
DST_SECONDARY_TT_VERSION       11
DST_UPGRADE_STATE              UPGRADE

3 rows selected.SQL > SELECT OWNER, TABLE_NAME, UPGRADE_IN_PROGRESS FROM ALL_TSTZ_TABLES where UPGRADE_IN_PROGRESS='YES';

OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYSMAN                         MGMT_PROV_DEFAULT_IMAGE        YES
SYSMAN                         MGMT_PROV_RPM_REP              YES
SYSMAN                         MGMT_PROV_CLUSTER_NODES        YES
SYSMAN                         MGMT_PROV_ASSIGNMENT           YES
SYSMAN                         MGMT_PROV_OPERATION            YES
SYSMAN                         MGMT_PROV_STAGING_DIRS         YES
SYSMAN                         AQ$_MGMT_NOTIFY_QTABLE_S       YES
SYSMAN                         AQ$_MGMT_LOADER_QTABLE_L       YES
SYSMAN                         AQ$_MGMT_LOADER_QTABLE_S       YES
SYSMAN                         AQ$_MGMT_NOTIFY_QTABLE_L       YES
SYSMAN                         MGMT_PROV_BOOTSERVER           YES
SYSMAN                         MGMT_PROV_SUITE_INST_MEMBERS   YES
SYSMAN                         MGMT_PROV_IP_RANGE             YES
SYSMAN                         MGMT_PROV_NET_CONFIG           YES

14 rows selected.SQL > shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.SQL > startup
ORACLE instance started.

Total System Global Area 3423965184 bytes
Fixed Size                  2260000 bytes
Variable Size            2583692256 bytes
Database Buffers          822083584 bytes
Redo Buffers               15929344 bytes
Database mounted.
Database opened.SQL > alter session set "_with_subquery"=materialize;

Session altered.SQL > set serveroutput onSQL > VAR numfail numberSQL > log_errors_table => 'SYS.DST$ERROR_TABLE',
SP2-0734: unknown command beginning "log_errors..." - rest of line ignored.SQL > BEGIN
     DBMS_DST.UPGRADE_DATABASE(:numfail,
    parallel => TRUE,
    log_errors => TRUE,
    log_errors_table => 'SYS.DST$ERROR_TABLE',
    log_triggers_table => 'SYS.DST$TRIGGER_TABLE',
    error_on_overlap_time => FALSE,
    error_on_nonexisting_time => FALSE);
    DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
   END;
   /
Table list: "SYSMAN"."MGMT_PROV_SUITE_INST_MEMBERS"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_STAGING_DIRS"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_RPM_REP"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_OPERATION"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_NET_CONFIG"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_IP_RANGE"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_DEFAULT_IMAGE"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_CLUSTER_NODES"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_BOOTSERVER"
Number of failures: 0
Table list: "SYSMAN"."MGMT_PROV_ASSIGNMENT"
Number of failures: 0
Table list: "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_S"
Number of failures: 0
Table list: "SYSMAN"."AQ$_MGMT_NOTIFY_QTABLE_L"
Number of failures: 0
Table list: "SYSMAN"."AQ$_MGMT_LOADER_QTABLE_S"
Number of failures: 0
Table list: "SYSMAN"."AQ$_MGMT_LOADER_QTABLE_L"
Number of failures: 0
Failures:0

PL/SQL procedure successfully completed.SQL > VAR fail numberSQL > BEGIN
    DBMS_DST.END_UPGRADE(:fail);
    DBMS_OUTPUT.PUT_LINE('Failures:'|| :fail);
    END;
      /
An upgrade window has been successfully ended.
Failures:0

PL/SQL procedure successfully completed.SQL > SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
    FROM DATABASE_PROPERTIES
    WHERE PROPERTY_NAME LIKE 'DST_%'
     ORDER BY PROPERTY_NAME;

PROPERTY_NAME                  VALUE
------------------------------ ----------------------------------------------------------------------------------------------------
-----------
DST_PRIMARY_TT_VERSION         14
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

3 rows selected.SQL > SELECT * FROM v$timezone_file;

FILENAME                VERSION
-------------------- ----------
timezlrg_14.dat      ##########

1 row selected.SQL > set numwidth 20SQL > /

FILENAME                VERSION
-------------------- ----------
timezlrg_14.dat      ##########

1 row selected.SQL > set linesize 30SQL > /

FILENAME
--------------------
   VERSION
----------
timezlrg_14.dat
##########


1 row selected.