xdb No suitable driver found for jdbc:oracle:thin ERROR

[asotolongo]

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

[SwagataBanik]

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 

[asotolongo]

HI Swagata,thanks for your answer, 

i readed the documentation refered 

https://www.enterprisedb.com/docs/en/6.0/repguide/EDB_Postgres_Replication_Server_Users_Guide.1.24.h...

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

[asotolongo · Accepted solution]

i copy others jdbc

ojdbc6.jar

ojdbc7.jar

ojdbc5.jar

ojdbc14.jar

and work

thanks

[justicehlaps]

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

[SwagataBanik]

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

[justicehlaps]

Dear Swagata,

thanks for the response,

see my  java configs on the subscriber below.

[SwagataBanik]

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.

[justicehlaps]

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

[SwagataBanik]

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.