Hello Expert.
I want to make a JDBC connection from Cloud Integration to Oracle DB.
Successfully connected to Oracle19 locally
I can't connect, Oracle versions 9i and 11g are on different servers
I am using the Driver downloaded from the following URL
https://download.oracle.com/otn-pub/otn_software/jdbc/1911/ojdbc8.jar
The error message is as follows
・9i
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection, cause: java.net.ConnectException: error 111 - Connection refused
・11g
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: ORA-00604: 再帰SQLレベル1でエラーが発生しました。 ORA-01882: タイムゾーンのリージョンが見つかりません , cause: java.sql.SQLException: ORA-00604: 再帰SQLレベル1でエラーが発生しました。 ORA-01882: タイムゾーンのリージョンが見つかりません
What I did
1. Install database on on-prem server
2. Installed CloudConnector on the same server as the database
3.Add settings to Cloud Connector to communicate via TCP/1521.
4.Added JDBC Driver in Cloud Integration monitor
5.Add Oracle connection setting in Cloud Integration monitor
6..Create iflow using connection settings of 5.
7.Test Iflow
Please advise.
regards.