Data Replication 2
Results 1 to 5 of 5

Thread: New Replicate - setup connection point and error - Client HTTP request failed

  1. #1
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    221
    Rep Power
    3

    New Replicate - setup connection point and error - Client HTTP request failed

    I am setting up a new Replicate server and try the connection point for SQL database / Oracle database but fail

    SYS-E-HTTPMSG, Client HTTP request failed: API library cannot be loaded.

    I have installed the 64-bit SQL client and the 64-bit Oracle Client.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    221
    Rep Power
    3
    The issue could be that you installed the SQL or Oracle client after Replicate.

    if so, you would need to Restart the Replicate Services, for Replicate to recognize the clients are installed.

  3. #3
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    109
    Rep Power
    10
    As Steve indicates, be sure to re-start the Attunity Replicate service after installing new DB clients.

    May we assume you assumed on a Windows Server?

    Which endpoint is failing? Both ... must be the restart.

    Oracle? You may have to add the (insta?) client location to the system PATH.
    You may also want to add an environment variable for TNS_ADMIN.
    Not required, but handy.
    Also download/install SQLplus... get that to work first, Replicate next.


    If it still fails, using the 'TEST' button on the Manage Endpoints, then be sure to open up the log and study it.
    Post relevant log fragments ( version, "]E:" lines and a few around it ) to this topic.

    hth,
    Hein

  4. #4
    gavinajayar is offline Junior Member
    Join Date
    Feb 2017
    Posts
    1
    Rep Power
    0

    SYS-E-HTTPMSG, Client HTTP request failed

    Hi,

    Good day.. I would really appreciate if someone can help me on this error, i cant connect to oracle database. Im using this connection string lenovo-pc:1521/orcl.168.1.9. I'm searching in internet for this kind of error and found one in this forum, but the thread isn't resolved yet.


    • SYS-E-HTTPMSG, Client HTTP request failed: Stream component initialization function has failed for component 'Oracle', type 'Oracle'. [121914] API library cannot be loaded.


    I have installed oracle and cannot connect to, i have restarted the attunity replicate server and gui. I was able to connect to oracle using sqldeveloper and pl/sql developer, but not in attunity.

    Oracle version:

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE 11.2.0.1.0 Production
    TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production


    tnsnames.ora details

    # tnsnames.ora Network Configuration File: C:\app1\Jay-ar\product\11.2.0\dbhome_1\network\admin\tnsnames. ora
    # Generated by Oracle configuration tools.


    LISTENER_ORCL =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))




    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )


    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl.168.1.9)
    )
    )

  5. #5
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    109
    Rep Power
    10
    >> but the thread isn't resolved yet.
    It probably was, but happy folks rarely come back to indicate success.
    This is a really basic setup error. This stuff works. Period.

    I'm pleased to see you did your homework and checked with other tools.
    I prefer the simple SQLplus as it is close to what Replicate uses.

    >> API library cannot be loaded.

    That typically means that the Oracle Client Library Bin directory is NOT in the path.
    There was no indication in your reply indicating that was verified

    Replicate needs to be able to find OCI.DLL
    Be sure the bin directory for it is in the path and restart the Replicate Service to pick it up, then test.


    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
  •