RE: Timezone file

From: Amaral, Rui <Rui.Amaral_at_tdsecurities.com>
Date: Tue, 26 Oct 2010 13:53:50 -0400
Message-ID: <AD1FD82AC6BFBE4C8913E32286D9C70D080A11FF3C_at_EX7T2-SV05.TDBFG.COM>

Interesting question. I ended up poking around to satisfy my curiosity about this one and the closest I could find :

SQL> select * from sys.x$timezone_file;

ADDR                   INDX    INST_ID FILENAME        VERSION
---------------- ---------- ---------- ------------ ----------
0000002A97E09F7A          0          1 timezlrg.dat          4

OJVM has it's own but the path is nowhere was the $ORACLE_HOME path should be.

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mayen.Shah_at_lazard.com Sent: Tuesday, October 26, 2010 1:21 PM
To: Taylor, Chris David
Cc: 'Oracle-L_at_FreeLists.org'
Subject: RE: Timezone file

Chris,

Thank you for pointing that out, but the path is correct except it is path for PRODDB and not DEVDB. There is timezone.dat in correct location of DEVDB which is $ORACLE_HOME/oracore/zoneinfo/timezone.dat, but sybase repagent is looking for the file in $ORACLE_HOME/oracore/zoneinfo of PRODDB. I would like to point out again that DEVDB was cloned from PRODDB, so that is why I am thinking if timezone.dat info is store somewhere inside the database.

Thanks
Mayen

From:        "Taylor, Chris David" <ChrisDavid.Taylor_at_ingrambarge.com>
To:        Mayen Shah/ITS/Lazard_at_Lazard NYC, "'Oracle-L_at_FreeLists.org'" <Oracle-L_at_FreeLists.org>
Date:        10/26/2010 01:13 PM
Subject:        RE: Timezone file


________________________________

No the info does not get stored in the database.

However, this path looks suspect:
/opt/PRODDB/oracle/product/10.2.0.4/oracore/zoneinfo/timezone.dat

Is there anything else between the "10.2.0.4" and the "oracore" in the path? Typically there's like a db_1 or something as part of the path.

If you don't have a timezone.dat file in that location, you should. If it is not there I would think there might be something missing from the install besides this file.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor_at_ingrambarge.com<mailto:chris.taylor_at_ingrambarge.com>

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mayen.Shah_at_lazard.com Sent: Tuesday, October 26, 2010 8:19 AM
To: Oracle-L_at_FreeLists.org
Subject: Timezone file

Hi List Members,

I have rather strange issue.

Using RMAN I created a clone of PRODDB to DEVDB 10.2.0.4 on Solaris 10. No issue here. Trying to set Sybase replication going from oracle DEVDB to one of the sybase servers.

During repagent setup I am getting following error:

Command <pdb_xlog> failed - Could not initialize the primary database because: ORACLE_HOME could not be found to help locate timezone file because Could not find Oracle timezone file </opt/PRODDB/oracle/product/10.2.0.4/oracore/zoneinfo/timezone.dat>.. Please set ORACLE_HOME or update config property pdb_timezone_file.

It seems that sybase agent setup is trying to locate timezone.dat but getting path for timezone.dat file from PRODDB. As a work around I set pdb_timezone_file pointing to DEVDB timezone file and error disappeared.

I am running this on DEVDB and yes I checked ORACLE_HOME, ORACLE_SID etc settings few hundred times and they all are pointing to DEVDB.

It is possible that timezone.dat file name and path may be stored somewhere inside the database, which did not get changed during database cloning, and sybase rep agent is looking at the information?

My question is that is there anywhere inside the database, timezone file name gets stored?

Thanks
Mayen

NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, go to www.td.com/legal for instructions. AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, allez au www.td.com/francais/avis_juridique pour des instructions.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 26 2010 - 12:53:50 CDT