This discussion is archived
2 Replies Latest reply: Mar 20, 2013 1:40 AM by 961076 RSS

Oracle Stream + Heterogeneous Services agent

439985 Newbie
Currently Being Moderated
I have tried to use Oracle Streams with Oracle Generic Connectivity for replicating data from an Oracle10g database to a MySQL 4.1.9 datatabase.

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?
  • 1. Re: Oracle Stream + Heterogeneous Services agent
    961076 Newbie
    Currently Being Moderated
    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.
  • 2. Re: Oracle Stream + Heterogeneous Services agent
    961076 Newbie
    Currently Being Moderated
    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.