cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Gold Adventurer

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

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

error.jpg

 

 

 

I'm missing something?

any idea

regards

1 ACCEPTED SOLUTION

Accepted Solutions
Gold Adventurer

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

i copy others jdbc

ojdbc6.jar

ojdbc7.jar

ojdbc5.jar

ojdbc14.jar

 

and work

 

thanks

View solution in original post

15 REPLIES 15
Level 3 Adventurer

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

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 

Gold Adventurer

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

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

pantalla1_lrt.png

 

ls -lrt /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib/jdbc

 

pantalla2_lrt.png

 

With SQL server function fine!!!

 

i use CENTOS 7

Regards

 

Gold Adventurer

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

i copy others jdbc

ojdbc6.jar

ojdbc7.jar

ojdbc5.jar

ojdbc14.jar

 

and work

 

thanks

View solution in original post

Adventurer

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

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

Level 3 Adventurer

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

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

 

Adventurer

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

Dear Swagata,

thanks for the response,

see my  java configs on the subscriber below.

ojdbc_config.PNG

Tags (1)
Highlighted
Level 3 Adventurer

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

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.

Adventurer

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

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

ojdbc_config_publisher.PNG

Level 3 Adventurer

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

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.