cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle DB TCPS Connection issue - Integration Suite

kmarrrahul
Newcomer
0 Kudos
93
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.

Accepted Solutions (0)

Answers (0)