I try to use XDB replication tool to replicate ORACLE to postgres EDB, and i copy the JDBC driver ojdbc5.jar to JAVA_HOME(/usr/lib/jvm/jre/lib/ext) and to XDB_HOME(/opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib/jdbc)
when i try to connect i get this ERROR:
Database connection information test failed. No suitable driver found for jdbc:oracle:thin:@//myIP:1521/myname
I'm missing something?
Hope you are doing good..
Could you please share the output of ls -ltr command , from your JAVA_HOME (/usr/lib/jvm/jre/lib/ext) and XDB_HOME (/opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib/jdbc) location.
Is your publication and subscription server running on same server ?
You can refer to the below link for more information regarding this.
HI Swagata,thanks for your answer,
i readed the documentation refered
is your publication and subscription server running on same server ?- YES
ls -ltr /usr/lib/jvm/jre/lib/ext
ls -lrt /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib/jdbc
With SQL server function fine!!!
i use CENTOS 7
I am getting the same error and have no ideas
I am using xDB server 6.2.5,
jre :OpenJDK 1.7.0
oracle 126.96.36.199 EE
Could you please share the output of ls -ltrh of XDB_HOME/lib/jdbc directory and JAVA_HOME (/usr/lib/jvm/jre/lib/ext) .
Please refer the below link for more information regarding access to Oracle database.
thanks for the response,
see my java configs on the subscriber below.
Could you please confirm if the publication and subscription server are installed on the same host?
If subscription server is running on a different host than the publication server then you need to copy the ojdbcX.jar file to
XDB_HOME/lib/jdbc and jre/lib/ext location on the subscription server host as well.
Also, restart the publication and subscription service. Let us know how it helps.
Thank you for the feedback.
I did that already and i had no joy.My publisher is running on a different host
find the settings on my publisher as per screenshot below
Could you please try once using ojdbc8.jar file in both subscription and publiation server. And, restart the publication and subscription service.
Let us know if it works.