Re: Oracle Transparent Gateway on Solaris
Date: Fri, 27 Jan 2023 18:44:55 +0100
Message-ID: <CAJ=80GXLd3BJ2z1ZfDScg2NP-5pccwRVFgh6ShD4mTpae_6YZQ_at_mail.gmail.com>
Hi
THe gateway does not need to be on the solaris machine. You can put it on the RHEL 8 machine if there is a odbc driver for linux. See manual 1) that even suggests this.
Best regards/Venlig hilsen
Peter Gram
Sæbyholmsvej 18 DK-2500 Valby
Mobile: (+45) 5374 7107
Email: peter.m.gram_at_gmail.com
On Fri, 27 Jan 2023 at 18:34, Zahir Mohideen <zahir.dba_at_gmail.com> wrote:
> Hi
>
> I had Oracle 12c Enterprise on Windows 64 and MariaDB 10.2 on Ubuntu .
> I have been using ODBC transparent gateway to send the data from Oracle to
> MariaDB.
>
> I am in the process of transitioning to Oracle Enterprise 19c on Solaris
> and MariaDB 10.4 on RHEL8 .It looks like , there are no native mariadb odbc
> drivers for Solaris.
>
> What is your recommendation on connecting Maria DB ( RHEL) to Oracle 19 (
> Solaris ) ?
> With the current licensing model , only the ODBC Transparent Gateway
> covered with regular licensing?
>
> This data transfer happens once a day ( via dbms_scheduler).
> At the maximum , we will have 2000 records transferred between these
> DBMSes.
>
> What is the best approach ?
> Any known issues with Oracle Solaris TG ?
>
> Thanks very much.
> Zahir Mohideen
> http://mfzahirdba.blogspot.com/
>
>
> *Nothing so GREAT was achieved without enthusiasm*
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 27 2023 - 18:44:55 CET