Data Replication 2
Results 1 to 2 of 2

Thread: Issues while using Oracle as a source

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

    Issues while using Oracle as a source

    I am facing a few issues while using oracle as a source:

    1. I get an error for oaxml12.dll:

    :26:03 [SERVER ]E: Failed to load the library 'oraxml12.dll' [720126] (system.c:448)



    00005044: 2017-02-08T12:26:03 [SERVER ]I: Failed to load OraXML library, XMLType will not be supported (oracle_endpoint.c:194)


    00005044: 2017-02-08T12:26:03 [INFRASTRUCTURE ]T: Alloc repo D:\data\tasks\Oracle to Hadoop dev/Oracle to Hadoop dev.repo (repository.c:5923)


    00005044: 2017-02-08T12:26:03 [INFRASTRUCTURE ]T: Free repository D:\data\tasks\Oracle to Hadoop dev/Oracle to Hadoop dev.repo (repository.c:397)


    00005044: 2017-02-08T12:26:03 [INFRASTRUCTURE ]T: Syntax object for 'Oracle' provider was not found in the repository (dbprops.c:415)


    00005044: 2017-02-08T12:26:03 [INFRASTRUCTURE ]T: The 'Oracle' provider syntax was not found in the repository. (dbprops.c:1007)


    00005044: 2017-02-08T12:26:03 [INFRASTRUCTURE ]T: The default 'Oracle' provider syntax will be used instead. (dbprops.c:1013)


    00005044: 2017-02-08T12:26:03 [METADATA_MANAGE ]I: Going to connect to Oracle server (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dwcmsdev x.stage.shutterfly.com)(PORT=3115))(CONNECT_DATA=( SERVICE_NAME=KAFKATST))) with username replicate_user (oracle_endpoint_imp.c:922)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Going to prepare the statement 'select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET'' (oracle_endpoint_conn.c:582)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Going to prepare the statement 'select value from v$nls_parameters where parameter = 'NLS_NCHAR_CHARACTERSET'' (oracle_endpoint_conn.c:592)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Going to prepare the statement 'select 1 from dba_tablespaces where ENCRYPTED = ' '' (oracle_endpoint_conn.c:894)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Column compress_for may be used (oracle_endpoint_conn.c:903)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Going to prepare the statement 'select 1 from all_tables where owner = ' ' and compress_for = ' '' (oracle_endpoint_conn.c:801)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Column compress_for may be used (oracle_endpoint_conn.c:810)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Going to prepare the statement 'select 1 from all_views where owner='SYS' and view_name='ALL_ENCRYPTED_COLUMNS'' (oracle_endpoint_conn.c:926)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Table all_encrypted_columns may be used (oracle_endpoint_conn.c:935)


    00005044: 2017-02-08T12:26:05 [METADATA_MANAGE ]T: Going to prepare the statement 'select 1 from sys.enc$' (oracle_endpoint_conn.c:939)


    2. I am also getting an error for ALTER TABLE privileges, I want to know why the user should have ALTER TABLE privileges in Oracle.
    3. Supplemental logging error: All the privileges are given at a database level, should it be given at user level too?

    Thanks,
    Aditi

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    1. for "Failed to load the library 'oraxml12.dll'" I have seen that error before and if you are not using xml data types then it should be no problem.


    2. For permission, please reference user guide on Oracle requirement.

Posting Permissions

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