OraFAQ Forum: Server Administration » Upgrading from 10.2.0.1 to 10.2.0.4

Home » RDBMS Server » Server Administration » Upgrading from 10.2.0.1 to 10.2.0.4 (Oracle 10g RHEL 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upgrading from 10.2.0.1 to 10.2.0.4 [message #504408]

Mon, 25 April 2011 00:08

snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad

Member

I am upgrading my server from 10.2.0.1 to 10.2.0.4.
in DST check the timezone values returned is 2 and not 4.
I have checked using utltzpv4.sql and the jobs returned are as below.
Owner table_name Column_Name.
SYS SCHEDULER$_JOB LAST_ENABLED_TIME
SYS SCHEDULER$_JOB START_DATE
SYS SCHEDULER$_WINDOW LAST_START_DATE

Can any one please guide what to do....I dont have any userdata using TSTZ or TSLTZ.

Report message to a moderator

Re: Upgrading from 10.2.0.1 to 10.2.0.4 [message #504411 is a reply to message #504408]

Mon, 25 April 2011 01:04

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is a Metalink note about this point and related ones saying what to do in different cases.
Search for DST and you will find it.

Regards
Michel

Report message to a moderator

Re: Upgrading from 10.2.0.1 to 10.2.0.4 [message #504416 is a reply to message #504411]

Mon, 25 April 2011 01:17

snehalgandhi
Messages: 43
Registered: February 2011
Location: Ahmedabad

Member

Dear Michel,
I have the document of metalink.
I have gone through the same.
It says to ignore the DST related section in update if database does not have any TSTZ and TSLTZ data and the jobs returned in the query are scheduler_Jobs.
Means i just need to ignore the DST section and proceed with the patch update. Will it really update the database in proper way ??

Report message to a moderator

Re: Upgrading from 10.2.0.1 to 10.2.0.4 [message #504418 is a reply to message #504416]

Mon, 25 April 2011 01:43

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I made the DST upgrade about 5 years ago, as far as I remember if you follow what is said in the document you will have no problem.

Regards
Michel

Report message to a moderator

Previous Topic:	Database shutdown is required or not
Next Topic:	cofiguring IP address instead of HOSTNAME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 20:12:52 CST 2025