RE: Timezone file
- From: Mayen.Shah@xxxxxxxxxx
- To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
- Date: Tue, 26 Oct 2010 09:50:56 -0400
Tom,
I did look at DBA_DIRECTORIES and I have only two entries DATA_PUMP_DIR
and ORACLE_OCM_CONFIG_DIR. Nothing for related to timezone file.
Thanks
Mayen
From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
To: Mayen Shah/ITS/Lazard@Lazard NYC, "Oracle-L@xxxxxxxxxxxxx"
<Oracle-L@xxxxxxxxxxxxx>
Date: 10/26/2010 09:30 AM
Subject: RE: Timezone file
Mayen,
Look at the DBA_DIRECTORIES view within the prod database. I have an
entry for the timezone directory which implies that Oracle uses it
internally. This is probably where you are getting this from/
Hope this helps.
Tom
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mayen.Shah@xxxxxxxxxx
Sent: Tuesday, October 26, 2010 9:19 AM
To: Oracle-L@xxxxxxxxxxxxx
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
Other related posts:
