update timezone file version from 2 to 4

General suggestions and comments about the forums.

Moderator: Tim...

update timezone file version from 2 to 4

Postby Raaj A » Mon Nov 19, 2012 8:11 am

Hi Tim,

My production db is on windows 2003(32 bit) oracle 10g(10.2.0.1.0) which i want to upgrade to 11g(11.1.0.6). I am a licence user of oracle. Before doing upgrade i need to update timezone file version from 2 to 4. I installed oracle 11g software and created home directory.i run utlu111i.sql to update timezone version but nothing happened.

Please let me know is there any patch to update timezone file version for windows 2003(32 bit). I searched on oracle support site but did not get.


please help.


Thanks
Raaj A
Member
 
Posts: 49
Joined: Wed Mar 07, 2012 7:08 am

Re: update timezone file version from 2 to 4

Postby Tim... » Mon Nov 19, 2012 10:27 am

Hi.

I don't know what you mean by update timezone file. :)

The script you talked about running is a pre-upgrade validation script. it will not actually alter any settings.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: update timezone file version from 2 to 4

Postby Raaj A » Tue Nov 20, 2012 3:58 am

Hi Tim,

On my windows db server when i fire below command it returns following output.

SQL> select * from v$timezone_file;

FILENAME VERSION
------------ ----------
timezlrg.dat 2

My doubt is when i am doing upgrade from oracle 10g(10.2.0.1.0) to 11g(11.1.0.6) using DBUA, i am getting warning message " WARNING: –> Database is using an old timezone file version" i need to update timezone file version from 2 to 4. Is there any patch which will update this timezone file version ?


Thanks
Raaj
Raaj A
Member
 
Posts: 49
Joined: Wed Mar 07, 2012 7:08 am

Re: update timezone file version from 2 to 4

Postby Tim... » Tue Nov 20, 2012 9:16 am

Hi.

There is an explanation of this here:

http://lifedba.wordpress.com/2009/12/29 ... -11-1-0-7/

It includes links to MOS notes.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: update timezone file version from 2 to 4

Postby Raaj A » Tue Nov 20, 2012 11:27 am

Thanks Tim...

Got the solution.
Raaj A
Member
 
Posts: 49
Joined: Wed Mar 07, 2012 7:08 am

Re: update timezone file version from 2 to 4

Postby Tim... » Tue Nov 20, 2012 11:43 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: update timezone file version from 2 to 4

Postby Naveed123 » Tue Sep 10, 2013 10:46 am

let me know is there any patch to update timezone file version for windows 2003(32 bit). :shock:






Leather Jacket Leather Jackets
Leather Jacket Leather Jacket
actualtests actualtests scwcd study guide test
actualtests actualtests JN0-101 study guide test
actualtests actualtests 350-030 study guide test
actualtests actualtests microsoft certification study guide test
actualtests actualtests 640-864 study guide test
Last edited by Naveed123 on Sat Sep 21, 2013 6:39 am, edited 1 time in total.
Naveed123
Member
 
Posts: 1
Joined: Tue Sep 10, 2013 10:43 am

Re: update timezone file version from 2 to 4

Postby Tim... » Tue Sep 10, 2013 11:49 am

Hi.

Q. What would I do to find this out?
A. I would search on support.oracle.com and probably Google for a solution.

I suggest you try the same... :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Suggestions and Comments

Who is online

Users browsing this forum: No registered users and 2 guests

cron