I am trying to connect to an On-Prem Oracle 19c DB in Integration Suite.
Cloud Connector connectivity is fine.
I tried the following:
1. JDBC URL provided (Old style Full Address format):
This URL was provided in the JDBC Material, Oracle driver was also installed
pod1234.test-testing.com is a virtual host
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=pod1234.test-testing.com)(PORT=1539))(CONNECT_DATA=(SERVICE_NAME=TEST_ABC3)))
Outcome: fails with error com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: Error while getting Datasource Service: ServiceReference is null
2. Tried EZCONNECT Style since I think Full Address format is not supported:
a) jdbc:oracle:thin:@tcps:pod1234.test-testing.com:1539/TEST_ABC3?oracle.net.ssl_server_cert_dn="CN=pod1234a"
b) jdbc:oracle:thin:@tcps://pod1234.test-testing.com:1539/TEST_ABC3?oracle.net.ssl_server_cert_dn="CN=pod1234a"
Outcome: fails with the same error com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: Error while getting Datasource Service: ServiceReference is null
The following URL worked fine:
3. jdbc:oracle:thin:@pod1234.test-testing.com:1521/TEST_ABC3
but this is using the TCP protocol, and I want to connect using the TCPS protocol.
Please note that the cloud connector configuration is working fine; I don't think there is a problem here.
Additionally, I had also uploaded the certificate required for the TCPS connection SSL handshake in the Monitor > "Integration and APIs" > Keystore.
In the local system using DB Client DataGrip, I was able to connect using all the above URLs, but in Integration Suite, I am getting the error.
Please suggest what could be the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.