Skip to Content
avatar image
Former Member

Issue Remote Source OracleECC and OracleLogReader

Dear SAP,

I have the following remote source:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: Adapter validation failed. Failed to establish JDBC connection.

The adapter works correctly, we validate with sqlplus that is connected to oracle, install the .jar according to the version of oracle, but I do not understand why it does not work for me.Please Help me.Thank You!

error.png (46.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 12 at 10:31 PM

    Hello,

    I think there is a configuration error here, Oracle TNSNAMES Connection field should contain a connection name from the tnsnames.ora file on the dpagent machine.

    For example, say the file C:\usr\sap\dataprovagent\lib\tnsnames.ora has an entry as below:

    PROD = (description=
                  (source_route=yes)
                  (address=(protocol=tcp)(port=1610)(host=spcstn))
                  (address=(protocol=tcp)(port=1580)(host=spcstn)))
                  (connect_data=(service=sales1))
              )

    In the example, you would enter PROD in the Oracle TNSNAMES Connection field. See the Oracle Log Reader remote source configuration parameters in the Installation and Configuration Guide.

    Regards,
    Jeff K

    Add comment
    10|10000 characters needed characters exceeded