System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

Get updated TimeZones compliant with Oracle EM

Frank de Vries
Respected Contributor

Get updated TimeZones compliant with Oracle EM

Hi,
I have an Oracle server running on hpux 11.11
Since the DST change (daylight saving last march), we have a problem with dbconsole which does not support our current TZ setting:

TZ=MET-1MEST
or
TZ=GMT-1DST

It appears that there is a new list of supported timezones values that our hpux 11.11 os does not (yet) know.

Where/how to get these new timezones implemented into our os ?

Europe/Amsterdam
Europe/Paris
Europe/Brussels

export TZ=Europe/Paris
would be nice /°°:))
Look before you leap
6 REPLIES
Steven E. Protter
Exalted Contributor

Re: Get updated TimeZones compliant with Oracle EM

Shalom Frank,

HP usually releases TZ updates as patches in the patch database.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
James R. Ferguson
Acclaimed Contributor

Re: Get updated TimeZones compliant with Oracle EM

Hi Frank:

As new timezones are made officially available in HP-UX a patch is released in the form of a new '/usr/lib/tztab'. You can find the latest in the ITRC Patch Database by using the keyword 'tztab' in a search.

The most recent ones have been posted in February 2009.

You are always at liberty to make you own changes to '/usr/lib/tztab' following the rules defined in the 'tztab(4)' manpages.

Be aware, though, that if you modify '/usr/lib/tztab' the subsequent application of an official patch will be incomplete. That is, the newly delivered patch will be left in '/usr/newconfig/usr/lib/tztab' rather than installed there and copied to replace '/usr/lib/tztab'.

Regards!

...JRF...
Dennis Handly
Acclaimed Contributor

Re: Get updated TimeZones compliant with Oracle EM

>TZ=GMT-1DST

It is illegal to use GMT in a timezone unless it is "TZ=GMT0". Otherwise you will see GMT and assume that it is the same as UTC. Also randomly assigned timezones will have US start and stop times.

>Where/how to get these new timezones implemented into our OS?
Europe/Amsterdam
Europe/Paris
Europe/Brussels

Perhaps Java has timezones like this but tztab(4) has the format: XXXnnnDDD
OldSchool
Honored Contributor

Re: Get updated TimeZones compliant with Oracle EM

Europe/Amsterdam
Europe/Paris
Europe/Brussels


appear to be Linux timezone names
Matti_Kurkela
Honored Contributor

Re: Get updated TimeZones compliant with Oracle EM

OldSchool:
Linux, or Solaris, or MacOSX, or any other unix-like OS that uses zoneinfo-style time zone database (aka the Olson database).

http://en.wikipedia.org/wiki/Zoneinfo

HP-UX still uses the older-style /usr/lib/tztab. It is a simple text file, so it's easy to view it to see what's available, and edit it if necessary. The format is documented in the man pages.

For HP-UX, the correct setting for France should be "TZ=MET-1METDST". HP-UX tends to use six-letter DST timezone identifiers in Europe, because the four-letter ones would be ambiguous.

MK
MK
OldSchool
Honored Contributor

Re: Get updated TimeZones compliant with Oracle EM

MK - I was aware of that, but OP had them (that format) on his wish list.

As for why "Oracle doesn't recognize...." the timezone setting he's using, I've no idea, as I'm not sure what he means by that.