Load Ingest Data
Results 1 to 4 of 4

Thread: Issue while loading data from Oracle system

  1. #1
    chetan86 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    19
    Rep Power
    0

    Issue while loading data from Oracle system

    Hello Experts,

    While loading data from Oracle to target system, I am getting below error.
    Another thing is that data is getting loaded correctly for first exact 4,000 rows and then task gets failed.

    Any kind of suggestion would be helpful.

    00008956: 2016-12-08T06:28:46:935795 [TASK_MANAGER]T: Start control thread (replicationtask.c:2334)
    00008956: 2016-12-08T06:28:46:935795 [SERVER]T: Going to load 'oci.dll' library (system.c:432)
    00008956: 2016-12-08T06:28:46:935795 [SERVER]T: Going to load 'oraxml12.dll' library (system.c:432)
    00008956: 2016-12-08T06:28:46:935795 [SERVER]T: Going to load 'oraxml11.dll' library (system.c:432)
    00008956: 2016-12-08T06:28:46:935795 [SERVER]T: Going to load 'oraxml10.dll' library (system.c:432)
    00008956: 2016-12-08T06:28:46:935795 [SERVER]E: Failed to load the library 'oraxml12.dll' [720126] (system.c:448)
    00008956: 2016-12-08T06:28:46:935795 [SERVER]I: Failed to load OraXML library, XMLType will not be supported (oracle_endpoint.c:194)

    Thanks!

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    Hello chetan86,

    We have seen similar error message on older Replicate kit, what Replicate kit are you running?

    The current Replicate kit is 5.1.1xx and can be download from the Customer Zone from the support Portal.

    Thanks,
    Steve

  3. #3
    chetan86 is offline Junior Member
    Join Date
    Nov 2016
    Posts
    19
    Rep Power
    0
    Hi Steve,

    we are using 5.1.1.94 version.

    Thanks,
    Chetan

  4. #4
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    This issue seems to be related to the Oracle client installation. in our documentation, there is a note saying:


    Note: Support for the XMLTYPE data type requires the full Oracle Client.

    For UNIX


    In addition, if not already included in your system, you need to create a symbolic
    link in the $Oracle_Home\lib directory. This link should be called
    libclntsh.so, and should point to a specific version of this file. For example:
    Oracle Version 11 client:


    lrwxrwxrwx 1 oracle oracle 63 Oct 2 14:16 libclntsh.so ->
    /u01/app/oracle/home/lib/libclntsh.so.11.1
    Oracle Version 10 client:


    lrwxrwxrwx 1 oracle oracle 63 Oct 2 14:16 libclntsh.so ->
    /u01/app/oracle/home/lib/libclntsh.so.10.1


    Additionally, the LD_LIBRARY_PATH environment variable should be appended
    with the Oracle lib directory and added to the site_arep_login.sh script.


    =====

    Also, there are limitations using the XML type:


    On Oracle 11, LogMiner Agent does not support the UPDATE statement for
    XMLTYPE and LOB columns.


    Oracle Target: In Batch Optimized Apply mode, loading into the net changes table
    uses Direct Path which does not support XMLType.
    Workaround:


    Use Transactional Apply mode.


    The XMLTYPE data type is only supported in limited
    LOB mode.


    Please verify the full oracle client is installed.


    Thanks,
    Steve

Posting Permissions

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