Data Replication 2
Results 1 to 2 of 2

Thread: Replicate Express Oracle Connection fails while Toad can connect

  1. #1
    ozgen is offline Junior Member
    Join Date
    Aug 2016
    Posts
    1
    Rep Power
    0

    Replicate Express Oracle Connection fails while Toad can connect

    Hi,

    We have a connection issue with Replicate Express. The computer can connect to an Oracle instance via Toad but with the same information Replicate Express cannot connect.

    I have attached a screenshot of the connection error.

    Could you please help us with this issue?

    Best Regards

    Name:  OracleProblem.jpg
Views: 295
Size:  37.8 KB

  2. #2
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    163
    Rep Power
    12
    The good new is that you get a 'clear' ORA- error mesage, so the Oracle client is nicely activated.

    I see a second (source) connection on the screenshot. Does that work?

    Is "EXPRESS" the Service Name or SID?
    Try192.168.115.44/xe
    Try just myserver:myport/myservice
    Check for names/services on the server itself with LSNTCRL STATUS

    Is this a Windows replicate server?
    You can also setup a TNSNAMES.ORA entry and just specify a SID
    For that you need to to have a TNS_ADMIN setup as a (system) environment variable indicating there TNSNAMES.ORA is located.
    If you use an Instaclient install, then I suggest to just use that directory.
    Restart the Replicate service if TNS_ADMIN was not there.

    Just google for ORACLE CONNECTION STRING and try some suggested variants.

    Let us know?

    Good luck,
    Hein.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •