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?
any idea
regards
i copy others jdbc
ojdbc6.jar
ojdbc7.jar
ojdbc5.jar
ojdbc14.jar
and work
thanks
Hi asotolongo,
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.
https://www.enterprisedb.com/docs/en/6.0/repguide/EDB_Postgres_Replication_Server_Users_Guide.1.24.h...
Thanks ,
Swagata
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
Regards
i copy others jdbc
ojdbc6.jar
ojdbc7.jar
ojdbc5.jar
ojdbc14.jar
and work
thanks
I am getting the same error and have no ideas
I am using xDB server 6.2.5,
OS:redhat 7.4,
jre :OpenJDK 1.7.0
ojdbc7.jar
oracle 12.1.0.2 EE
Please help
Hi justicehlaps,
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.
https://www.enterprisedb.com/docs/en/6.2/repguide/EDB_Postgres_Replication_Server_Users_Guide.1.24.h...
Thanks,
Swagata
Dear Swagata,
thanks for the response,
see my java configs on the subscriber below.
Hi justicehlaps,
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.
Hi Swagata,
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
Hi justicehlaps,
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.