11.2.0.1 To 12.1.0.1.0 Upgrade (Timezone wrong info in Post Script)
Hi Support,
I Upgraded my Oracle Database from 11.2.0.1 To 12.1.0.1.0 using the below steps
1) Upgrade 11.2.0.1. to 11.2.0.3 using dbua with Timezone upgrade option
2) Upgrade 11.2.0.3 To 12.1.0.1.0 using dbua with Timezone upgrade option
Post 12c Upgrade , when I run the script postupgrade_fixups.sql , it reports that i have to upgrade the Timezone
but the query return the newer version Timezone (18).
Please clarify
---------------------
Timezone Query:
---------------------
21:55:17 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
21:55:21 2 FROM DATABASE_PROPERTIES
21:55:21 3 WHERE PROPERTY_NAME LIKE 'DST_%'
21:55:21 4 ORDER BY PROPERTY_NAME;
PROPERTY_NAME VALUE
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------
DST_PRIMARY_TT_VERSION 18
DST_SECONDARY_TT_VERSION 0
DST_UPGRADE_STATE NONE