Re: Timezone file
Date: Wed, 27 Oct 2010 07:33:13 -0400
Message-ID: <OF0056DBBB.4A3A5ACD-ON852577C9.003F544C-852577C9.003F776E_at_lazard.com>
Hi Jack,
I did thought about that. No sybase rep agent was not cloned, just fresh configuration.
Thanks
Mayen
From: "Jack van Zanen" <jack_at_vanzanen.com> To: Mayen Shah/ITS/Lazard_at_Lazard NYC Date: 10/26/2010 06:41 PM
Subject: Re: Timezone file Sent by: jack.van.zanen_at_gmail.com
Hi
just some things you may have checked/considered already
Does the sybase rep server create some config tables in the database? been
a while can't remember
Did the pdb_timezone file have anything in there pointing to production?
or was it empty?
Was the sybase rep server config also cloned from production at the same
time as the database?
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
On Wed, Oct 27, 2010 at 12:18 AM, <Mayen.Shah_at_lazard.com> wrote: 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 27 2010 - 06:33:13 CDT