Replication from Oracle to Oracle
I'm about replicating between two Oracle 7.0 databases. What other Sybase
tools do I need apart from Replication agent for Oracle?
Femi Olumofin wrote:
> I'm about replicating between two Oracle 7.0 databases. What other Sybase
> tools do I need apart from Replication agent for Oracle?
You'll also need the Replication Server product (duh, Mark?!?!).
Besides Rep Server, you need ASE (Adaptive Server Enterprise), DCO (Direct
Connect for Oracle), and CIS (Component Integration ...Oracle-to-Oracle DDL Replication
I've completed Oracle-to-Oracle DDL Replication successfully
by using Replication Agent 12.6.
It's really amazing to see data flow from Oracle to Oracle.
...Replication from Oracle to Oracle using Mobilink
we have a customer with an Laboratory Information System (LIMS) using ORCALE
as Database. Now a second
Lims implementation on another site is planed and we have to use Ora again.
( Please don't think we are Ora Fans, all other own build applications use
So we thout instead of buying expencive replication of Ora we could use
Mobilink for two way replication.
Has any one experiences in this ?
MobiLink only support Oracles as a consolidated database, not as a remote.
The Sybase option to replicated between two Ora...oracle -> Replicating ->oracle
Can anybody of you please help me find any documents or any help to find
out for requirements and installation/design for using Sybase replication
between one oracle data server to another oracle dataserver.
Any help is appreciated.
Thanks in advance,
<Subbu> wrote in message
> Hi Gurus,
> Can anybody of you please help me find any documents or any help to
> out for requirements and installation/design for using Sybase
> between one oracle data ser...PB 5.03 app works against NT Oracle Server but not UNix Oracle Server
As the subject suggests I am able to connect the NT Oracle Server
and the application works. If I try to connect to the UNIX Oracle
erver.( Both are at 7.3.3 release of Oracle. )
I get the following dialog error:
Database transaction information not available.
Call SetTrans or SetTransObject function.
Does any one have any idea what may be wrong..
The only thing I can think of is the PB CAtalogs.....
Thanks in advance.....
I would think you are not connected. Run the application with a trace by
setting SQLCA.dbms = trace O73 or use the debugger to check ...Replication sql-anywhere-> Oracle without replication server?
Replication sql-anywhere-> Oracle without replication server?
Anyone got some experience to share?
Replication Server is the only way to do this.
Please post only to the news group.
Jonas Bonde wrote in message ...
>Replication sql-anywhere-> Oracle without replication server?
>Anyone got some experience to share?
...We're trying to get Oracle::DBD installed on a web server, where Oracle is installed on another server
/*DBD README file says send questions to firstname.lastname@example.org and CC them =
to me at Tim.Bunce@pobox.com. */
We're trying to get Oracle::DBD installed on a web server, where Oracle is =
installed on another server. I read Wintermute's comment in the =
README.clients file, but hope there are some standardized instructions on =
this by now. Any one have the instructions for this one? My attempst =
to build the DBD stuff came up with following error:
...Oracle <-> Oracle replication limits
I 'm looking for informations about Replication between 2 oracle databases.
Regarding volumes, is there a limit ? how to improve this limit ?
How often does this amount of data can be replicate ? I think that we need
to find the good compromise between volumes and replication frequency... Is
there any guideline or tips and tricks from REAL EXPERIENCES ?
Thanks very much
I'm just a programmer at Sybase so I have no real experience. However, I can
say that the question you ask is very open to interpretation, should be
qualified by any numb...install DBD::Oracle on oracle application server
Content-Type: text/plain; charset=iso-8859-1
I am trying to install DBD::Oracle on a box that has oracle application ser=
ver.=A0 The sqlplus works fine, but i got error=20
Unable to locate an oracle.mk, proc.mk or other suitable *.mk
=A0=A0=A0=A0=A0=A0=A0 file in your Oracle installation.=A0 (I looked in
b/oracle.mk /usr/local/app/oracle/pr...Problem in replicating CLOB column from Oracle
I am trying to replicate a table having a CLOB column from
Oracle to Oracle. The problem ofcourse is that its not
No errors but nothing happens.
I have used the pdb_setrepcol command on the repagent and i
can see that data is moving into the blob shadow table. The
rs_writetext seems to be executed as well. But the blob
column does not get replicated, all other columns seem to
I am using DCO v 12.5 for oracle and from earlier posts my
understanding is that there is no need to override any
function strings to make this happen.
Please tell...PB 10.5.1 Build 6021 , Oracle 10g server , Oracle 8i client. Making an RPC call to a Oracle Function and the last character is getting truncated
Making an RPC call to a Oracle Function and the last
character is getting truncated.
Similar Support Case : CR Number: 386424
Case Number: 11158124
I tried Disableunicode = 1 and not working .Is there any
other workaround for oracle 8i client.
That case was for Oracle 9i server and 8i client. There was
a second workaround which was to use the Oracle 9i client.
Not sure if that would work for you since you're on Oracle
> Making an RPC call to a Oracle Function and the last
> character is getting truncated.
> Simi...replication between MSSql server and Oracle
can repserver be usde to replication betwen MSSql server and Oracle and if
whant other products would I need besides the repserver
My understanding is that logically, as opposed to how this may or may not be
packaged for sale, you need:
1. Replication Server (which includes a Rep Server specific license of ASE
for the RSSD etc - this need for ASE may change in a near future release
based on other threads here).
2. EnterpriseConnect for Oracle
3. EnterpriseConnect for MSSQL
The Enterprise Connect products enable rep server (and any other OpenClient
applications to...oracle RAC and Oracle 11gR2 installation with oracle ASM
how to perform oracle RAC 11gR2 and Oracle Database 11gR2 installation
with oracle ASM on open SUSE 11.1 x86_64??
what short of package to find for oracle ASM and OCFS??
You need to download the rac and asmlib stuff from oracle.
You then need to present san storage to each node.
You will then need to stamp each asm lun with
/etc/init.d/oracleasm createdisk NAME /dev/sandevice.
------------------------------------------------------------------------...Linux DBD::Oracle to SUN Oracle 8i Server???
Hello all...What I am trying to do is connect to a Oracle 8i database on a SUN
server from my Linux workstation. Anyone know how or what is needed to do this?
My linux worksatiuon is RedHat 7.2 w/ stock perl install 5.6.0
I tried in the past to build DBDLOracle but I get errors. Not sure what they
are off the top of my head. I am going to try some more today but would like to
get some input...
Bill McClintock - EDMS App/Web Development
MCIWorldcom - Colorado Springs (GOG)