Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

11.2.0.1 To 12.1.0.1.0 Upgrade (Timezone wrong info in Post Script)

edited Mar 14, 2014 12:00PM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center