Home » Server Options » Streams & AQ » Oracle streams + heterogeneous service agent
Oracle streams + heterogeneous service agent [message #120188] Wed, 18 May 2005 06:06 Go to next message
lauraiannone
Messages: 2
Registered: May 2005
Junior Member
I have tried to use Oracle Streams with Oracle Generic Connectivity for replicating data from an Oracle10g database to a Mysql 4.1.9 database.

The apply process is aborted with this error message:
ORA-12801: error signaled in parallel query server P003
ORA-28584: heterogeneous apply internal error
ORA-28584: heterogeneous apply internal error
ORA-02063: preceding line from RCC1

Is not possible the use of these two mechanisms together?
Re: Oracle streams + heterogeneous service agent [message #155197 is a reply to message #120188] Thu, 12 January 2006 15:42 Go to previous messageGo to next message
hgemin
Messages: 1
Registered: January 2006
Junior Member
Hi,

Have you successfully implemented this replication?
How is the performance and reliability?

Thanks,
Heloisa.
Re: Oracle streams + heterogeneous service agent [message #155199 is a reply to message #155197] Thu, 12 January 2006 16:11 Go to previous message
lauraiannone
Messages: 2
Registered: May 2005
Junior Member
No Sad

I received the following response from Oracle:

According to the 10g Streams Concepts and Administration Manual
Overview of Heterogeneous Information Sharing

Streams needs to have an Oracle Transparent Gateway for the
Oracle to Non-Oracle Heterogeneous Data Sharing

For Heterogeneous Apply we support:
SQLServer
SYBASE
DB2
IBM DRDA

All of these have Transparent Gateway available.

But MySQL does not use Transparent Gateway.
It uses HSODBC and 3rd party ODBC Driver.

bye,
Laura
Previous Topic: Oracle Stream's Performance
Next Topic: AQ Propagation not happening over remote DBLINK
Goto Forum:
  


Current Time: Thu Sep 18 20:54:30 CDT 2014

Total time taken to generate the page: 0.09195 seconds