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 jdbcracle: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