Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

DST Updates When Upgrading To 11.2.0.1

edited Aug 5, 2014 3:30AM in Database Install/Upgrade/Opatch (MOSC) 1 commentAnswered ✓

Hi all,

I upgraded from 11.1.0.6 to 11.2.0.1. Then following Doc ID 815679.1 :

* For 11.1.0.6 and 11.1.0.7, there is no need to apply any patchest before upgrading to 11.2.0.1
Upgrade to 11.2.0.1. You can skip any DST related upgrade instructions.
The 11.2.0.1 RDBMS DST version after the upgrade to 11.2.0.1 will be the same DST version as used in 11.1.0.6/11.1.0.7.

After the upgrade to 11.2.0.1 you can:

* (recommended) update the 11.2.0.1 database(s) to DSTv11 (standard DST version of 11.2.0.1) by:

  • or using the scripts in note 1585343.1 Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database .

And I ran scripts in 1585343.1.

Now we are with :

SQL> SELECT version FROM v$timezone_file;

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