cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle to EDB migration using XDB

SOLVED
Highlighted
Level 3 Adventurer

Oracle to EDB migration using XDB

Hi Guys,

I have installed EDB Replication Server(version 6.20 using the interactive installer method on RHEL 7.5 machine.But facing issues while configuring the publication server(Oracle).Since its a linux machine with no GUI access,I am trying to configure it through runRepConsle.sh file.I have tried with java -jar as well.It shows below error.

 

[root@ip-172-31-2-48 ~]# su - enterprisedb
Last login: Tue Feb 12 04:41:08 EST 2019 on pts/0
-bash-4.2$ cd /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin
-bash-4.2$ java -jar edb-repconsole.jar -version
Exception in thread "main" java.awt.HeadlessException:
No X11 DISPLAY variable was set, but this program performed an operation which requires it.
at java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:204)
at java.awt.Window.<init>(Window.java:536)
at java.awt.Frame.<init>(Frame.java:420)
at java.awt.Frame.<init>(Frame.java:385)
at javax.swing.JFrame.<init>(JFrame.java:189)
at com.edb.replication.frontend.ui.Main.<init>(Main.java:199)
at com.edb.replication.frontend.ui.Main.main(Main.java:4703)
-bash-4.2$

 

I have tried exporting display,installed xming but still not able to figure out clear solution.Kindly suggest.

 

Thanks and Regards,

Manisha

Kindly suggest.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

Hi @manisha 

 
Control database has all the information related to publications, subscriptions etc which is created while installing XDB. 
Thus, installation of XDB should be completed without any errors, as this would avoid further issues.
Also, you need to take care that the control database is not tampered,else then starting and using XDB may become problematic.
 
Considering your scenario :
Your XDB installation is done on server 172-31-2-48, thus the services will also be on this server.
pubsvr.prop and subsvr.prop have details for connecting your publication and subscription servers.  Whereas the entries in your prop files is with IP 172.31.10.187 which means it is searching the services on 172.31.10.187 server, thus failing.
Add the IP of the server 172-31-2-48 in your prop files, and that would solve your problem. 
 
Hope this helps.

View solution in original post

Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

Hi @manisha,

 

As communicated by earlier, the Oracle JDBC driver needs to be placed at : XDB_HOME/lib/jdbc.

 

However, from the output shared by you, its placed at /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib.

 

Could you please place this jar under directory /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib/jdbc and try again.

 

NOTE: You may also copy the ojdbc7.jar file to the jre/lib/ext subdirectory of the location where you installed your Java runtime environment.

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir

 

View solution in original post

18 REPLIES 18
Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi Manisha,

 

The error you are facing 'No X11 DISPLAY variable was set, but this program performed an operation which requires it.' is not specific to the XDB installation error, whereas this is the common error when you are trying to execute installer on server which does not support UI mode.

 

Check with below steps if it could resolve :

1. Try to execute the command with sudo

2. Check what the value of the DISPLAY environment variable is:

echo $DISPLAY

3. If the value returned is blank or not the correct hostname, correct the DISPLAY value by exporting the DISPLAY environment variable. The syntax for this command is:

export DISPLAY=<hostname_to_display_X11_graphics_to>:0.0

 

Also, you can get the number of solutions regarding this error outside to try hands on this error

  

Highlighted
Silver Adventurer

Re: Oracle to EDB migration using XDB

Hi Manisha..

 

                  your doing through putty right..

1.you need to install Xming software(Free)

2.After installed click the putty icon.

3.go to the +SSH---->X11--->enable X11 forwarding(tick that option)

4.then going to session type address like same as before followed.

5.see if you facing agin these error.

                     export DISPLAY=oraprod-local-sin.com:0.0;     ----type and enter your os promt..

 

FYI

                 And which document you followd..can you please share the Document of XDB Replication's.

 

Thanks&Regards

Diny.

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

 Hi,

I have tried the available solutions of exporting the DISPLAY variable.It still gves me the same issue.

 

[root@ip-172-31-2-48 ~]# su - enterprisedb
Last login: Tue Feb 12 07:22:02 EST 2019 on pts/1
-bash-4.2$ echo $DISPLAY

-bash-4.2$ export DISPLAY=10.20.14.34:0.0
-bash-4.2$ cd /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin
-bash-4.2$ java -jar edb-repconsole.jar -version
Exception in thread "main" java.awt.AWTError: Can't connect to X11 window server using '10.20.14.34:0.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.access$200(X11GraphicsEnvironment.java:65)
at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:115)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:74)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:103)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82)
at com.edb.commons.i18n.I18NUtils.getAvailableChineseFonts(Unknown Source)
at com.edb.commons.i18n.I18NUtils.getPrefferedChineseFont(Unknown Source)
at com.edb.replication.frontend.ui.Main.loadFontSetting(Main.java:139)
at com.edb.replication.frontend.ui.Main.main(Main.java:4688)

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi,

 

I have tried even this.I am still not able to solve the issue.

 

[root@ip-172-31-2-48 ~]# su - enterprisedb
Last login: Tue Feb 12 07:22:02 EST 2019 on pts/1
-bash-4.2$ echo $DISPLAY

-bash-4.2$ export DISPLAY=10.20.14.34:0.0
-bash-4.2$ cd /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin
-bash-4.2$ java -jar edb-repconsole.jar -version
Exception in thread "main" java.awt.AWTError: Can't connect to X11 window server using '10.20.14.34:0.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.access$200(X11GraphicsEnvironment.java:65)
at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:115)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:74)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:103)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82)
at com.edb.commons.i18n.I18NUtils.getAvailableChineseFonts(Unknown Source)
at com.edb.commons.i18n.I18NUtils.getPrefferedChineseFont(Unknown Source)
at com.edb.replication.frontend.ui.Main.loadFontSetting(Main.java:139)
at com.edb.replication.frontend.ui.Main.main(Main.java:4688)

 

Below are the links referred:

https://get.enterprisedb.com/docs/EDB_Postgres_Replication_Server_Users_Guide_v6.2.pdf

https://blog.dbi-services.com/replicating-from-oracle-to-postgresql-with-edb-replication-server-1-a-...

https://www.enterprisedb.com/docs/en/6.1/repguide/EDB_Postgres_Replication_Server_Users_Guide.1.12.h...

 

I have tried installation using rpm as well as interactive installer.Both shows me the same error.Kindly suggest.

 

Thanks and Regards,

Manisha

 

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi Team,

 

I started to use th edb-repcli.jar file on my linux box.Now its not asking for any DISPLAY variable.But its still not able to connect to oracle source.Kindly suggest.I have allowed the ports required as well.

 

[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# java -jar /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin/edb-repcli.jar -paramfile addpubsvr
Adding publication database...
Error: Unable to connect to publication service.
Reason:Connection refused to host: 172.31.10.187; nested exception is:
java.net.ConnectException: Connection refused (Connection refused)
Error: Publication service is not available.
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# more addpubsvr
-addpubdb -repsvrfile pubsvr.prop -dbtype oracle -dbhost 172.31.10.187 -dbport 1521 -dbuser pubuser -dbpassword uQ5vWL7WGWte6DtjiBjD4w== -oraconnectiontype sid -databa
se ORCL
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# more pubsvr.prop
user=pubuser
password=uQ5vWL7WGWte6DtjiBjD4w==
port=9051
host=172.31.10.187
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]#

 

Kindly suggest.

 

Thanks and Regards,

Manisha

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi Manisha,

 

Good to hear that you came out of previous error. Regarding the error you are facing now, xDB server is unable to connect to publication database/publication server. Can you help us to identify your xDB setup

 

1. Have you configured the xDB server, Publication server and Subscription server on a single host

2. publication database on one host and subscription database on another host, is it?

3. From the logs shared, we can see that you are using the same host (172.31.10.187) as publication database and publication server, is it?

 

Please confirm us on above points.

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

HI Ranjan,

Below are responses for the queries:

1. Have you configured the xDB server, Publication server and Subscription server on a single host

---Yes

2. publication database on one host and subscription database on another host, is it?

---Yes

Oracle and EDB Postgres servers are different.XDB is configured on the EDB Postgres server.

3. From the logs shared, we can see that you are using the same host (172.31.10.187) as publication database and publication server, is it?

---I am not sure of this.Are the publication database and server to be different or same??

 

It will be good to have any links or docs for xdb replication configuration using edb-rep-cli.jar.Please provide if any as I am not able to find any relevant docs for the same.Kindly help.

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi Manisha, 

 

You can go through the link EDB Postgres™ Replication Server 6.2 for more details.

 

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi Ranjan,

 

I was following the same link as suggested.

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

Still unable to add or configure the publication or subscription database.Need some clear understanding on the concepts and configuration steps using the cli.Please suggest.

 

[root@ip-172-31-2-48 bin]# ./runRepConsole.sh
Exception in thread "main" java.awt.HeadlessException:
No X11 DISPLAY variable was set, but this program performed an operation which requires it.
at java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:204)
at java.awt.Window.<init>(Window.java:536)
at java.awt.Frame.<init>(Frame.java:420)
at java.awt.Frame.<init>(Frame.java:385)
at javax.swing.JFrame.<init>(JFrame.java:189)
at com.edb.replication.frontend.ui.Main.<init>(Main.java:199)
at com.edb.replication.frontend.ui.Main.main(Main.java:4703)
[root@ip-172-31-2-48 bin]# cd ..
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# java -jar /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin/edb-repcli.jar -printpublist -repsvrfile pubsvr.prop
Printing publications ...
Error: Unable to connect to publication service.
Reason:Connection refused to host: 172.31.10.187; nested exception is:
java.net.ConnectException: Connection refused (Connection refused)
Error: Publication service is not available.
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]#

Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

Hi @manisha,

 

From the error message shared by you, it looks like the publication service in not up and running.

 

1) Please make sure the services for publication and subscription are up and running on RHEL 7 and CentOS 7, services can be start using below commands :

systemctl start edb-xdbpubserver

systemctl start edb-xdbsubserver

2) Connections to both Oracle and EPAS database from the server where these services are running should be working.

 

Please do the above checks and then proceed with adding the publications and subscription.

 

Regards,

Sudhir

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi Slonkar,

 

As suggested,I checked the connectivity as well the status of xdbpubserver and xdbsubserver.But unable to figure out the issue.This analysis has created some confusions.Would be good if I get the clarity on my below queries.

 

  • xdb publication service is not running on the source i.e oracle server.Still it is looking for that service when adding the publicaton database.Is it mandatory to have it running on source server??

[root@ip-172-31-2-48 ~]# cd /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# java -jar /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin/edb-repcli.jar -printpublist -repsvrfile pubsvr.prop
Printing publications ...
Error: Unable to connect to publication service.
Reason:Connection refused to host: 172.31.10.187; nested exception is:
java.net.ConnectException: Connection refused (Connection refused)
Error: Publication service is not available.

 

  • The error log says the driver not available at source host.Even after adding the driver in /etc/alternatives/jre/lib/ext/ of source host,it shows the same log.Any suggestions on this?

Error occured during server initialization:
The connection with the Controller database could not be established.
Reason:No suitable driver found for jdbc:oracle:thin:@172.31.10.187:1521:ORCL

Initializing publication server at port 9051 ...
Publication server started.
[root@ip-172-31-2-48 xdbpubserver]# pwd
/var/log/edb/xdbpubserver

 

  • To start the subscription service ,is it mandatory to have publication service running?

Error occured during server initialization:
The connection with the Controller database could not be established.
Reason:No suitable driver found for jdbc:oracle:thin:@172.31.10.187:1521:ORCL

[root@ip-172-31-2-48 xdbsubserver]# pwd
/var/log/edb/xdbsubserver

 

Appreciate the support till now.

Kindly help me in understanding the behavior of xdb as well as the steps on configuring it.

 

Thanks and Regards,

Manisha

 

Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

Hi @manisha 

 
Control database has all the information related to publications, subscriptions etc which is created while installing XDB. 
Thus, installation of XDB should be completed without any errors, as this would avoid further issues.
Also, you need to take care that the control database is not tampered,else then starting and using XDB may become problematic.
 
Considering your scenario :
Your XDB installation is done on server 172-31-2-48, thus the services will also be on this server.
pubsvr.prop and subsvr.prop have details for connecting your publication and subscription servers.  Whereas the entries in your prop files is with IP 172.31.10.187 which means it is searching the services on 172.31.10.187 server, thus failing.
Add the IP of the server 172-31-2-48 in your prop files, and that would solve your problem. 
 
Hope this helps.

View solution in original post

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Thanks Chailtars.

 

So the driver has to be in the source server??If so,I have already placed ojdbc7.jar in source and the host of xdb.

 

[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# java -jar /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin/edb-repcli.jar -paramfile addpubsvr
Adding publication database...
Error:No suitable driver found for jdbc:oracle:thin:@172.31.10.187:1521:ORCL
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# java -jar /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/bin/edb-repcli.jar -printpublist -repsvrfile pubsvr.prop
Printing publications ...
Error: No publications found.
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]#

 

Kindly suggest.

 

Thanks and Regards,

Manisha

Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

According to the error it is still searching on host "172.31.10.187".

Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi,  

The IP 172.31.10.187" is the source oracle server IP.This ip was added while adding the publication database in the addpubsvr  file as it is the db host.So does this Ip has to point to server which has publication service running??

 

[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# more pubsvr.prop
#user=pubuser
#password=uQ5vWL7WGWte6DtjiBjD4w==
user=admin
password=VbjDPk5zwu/naXI2fpEbBQ\=\=
port=9051
host=172.31.2.48
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# more addpubsvr
-addpubdb -repsvrfile pubsvr.prop -dbtype oracle -dbhost 172.31.10.187 -dbport 1521 -dbuser pubuser -dbpassword uQ5vWL7WGWte6DtjiBjD4w== -oraconnectiontype sid -databa
se ORCL

Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

An Oracle JDBC driver jar file such as, ojdbc5.jar, must be accessible to the Java virtual machine (JVM) on the host running the publication server and the subscription server.

 

If the publication server and subscription server are running on separate hosts, the Oracle JDBC driver must be accessible to the JVM on each host. Oracle JDBC driver version ojdbc5 or later must be used.

 

Step 1: Download the Oracle JDBC driver, for example, ojdbc5.jar, from the Oracle download site to the host that will be running the publication server.

 

Step 2: Copy file ojdbc5.jar to the directory XDB_HOME/lib/jdbc.

 

Step 3: If the subscription server is running on a different host than the publication server, repeat steps 1 and 2 for the subscription server host.

Highlighted
Level 3 Adventurer

Re: Oracle to EDB migration using XDB

Hi chaitalirs,

The drivers are already placed.The publication and subscription servers are on single host.But source dataase is on different server.

[root@ip-172-31-2-48 ~]# cd /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# ll
total 7920
-rw-r--r--. 1 root root 175 Feb 13 07:05 addpubsvr
drwxrwxr-x. 2 root root 4096 Feb 13 11:06 bin
-rw-r--r--. 1 root root 0 Feb 13 06:39 -database
-rw-r--r--. 1 root root 0 Feb 13 06:39 -dbtype
-rw-r--r--. 1 root root 0 Feb 13 06:39 -dbuser
-rwxr-xr-x. 1 root root 15 Feb 13 03:23 edb_pwd_file
-rw-r--r--. 1 root root 51 Feb 13 03:25 enc_edb_pwd_file
-rw-r--r--. 1 root root 25 Feb 13 06:44 enc_orcl_pwd_file
drwxrwxr-x. 3 root root 103 Feb 14 02:00 etc
drwxrwxr-x. 4 root root 43 Feb 12 03:19 installer
drwxrwxr-x. 5 root root 4096 Feb 13 00:25 lib
-rw-r--r--. 1 root root 0 Feb 13 06:39 -oraconnectiontype
-rwxr-xr-x. 1 root root 11 Feb 13 06:43 orcl_pwd_file
-rwxr-xr-x. 1 root root 123 Feb 14 03:50 pubsvr.prop
drwxrwxr-x. 4 root root 29 Feb 12 03:19 scripts
-rwxr-xr-x. 1 root root 122 Feb 13 03:45 subsvr.prop
-rwx------. 1 root root 7962824 Feb 12 03:20 uninstall-xdbreplicationserver
-rw-------. 1 root root 21202 Feb 12 03:20 uninstall-xdbreplicationserver.dat
drwx------. 2 enterprisedb root 6 Feb 12 03:19 xdata
-r--r--r--. 1 root root 64025 Feb 5 09:13 xdb_3rd_party_licenses.txt
-r--r--r--. 1 root root 15216 Feb 5 09:13 xdb_license.txt
[root@ip-172-31-2-48 EnterpriseDB-xDBReplicationServer]# cd lib/
[root@ip-172-31-2-48 lib]# ll
total 15156
-rw-r--r--. 1 root root 55932 Feb 5 09:11 activation.jar
-rw-r--r--. 1 root root 252828 Feb 5 09:11 antlr-runtime-4.1.jar
-rw-r--r--. 1 root root 1599570 Feb 5 09:11 axis.jar
-rw-r--r--. 1 root root 610028 Feb 5 09:11 cayenne-exp-3.1.jar
-rw-r--r--. 1 root root 335600 Feb 5 09:11 cglib-nodep-3.2.0.jar
-rw-r--r--. 1 root root 25637 Feb 5 09:11 commons-beanutils-bean-collections.jar
-rw-r--r--. 1 root root 168760 Feb 5 09:11 commons-beanutils-core.jar
-rw-r--r--. 1 root root 188671 Feb 5 09:11 commons-beanutils.jar
-rw-r--r--. 1 root root 41123 Feb 5 09:11 commons-cli-1.2.jar
-rw-r--r--. 1 root root 259600 Feb 5 09:11 commons-codec-1.7.jar
-rw-r--r--. 1 root root 559366 Feb 5 09:11 commons-collections-3.1.jar
-rw-r--r--. 1 root root 160519 Feb 5 09:11 commons-dbcp-1.4.jar
-rw-r--r--. 1 root root 315805 Feb 5 09:11 commons-lang3-3.1.jar
-rw-r--r--. 1 root root 26202 Feb 5 09:11 commons-logging-api.jar
-rw-r--r--. 1 root root 38015 Feb 5 09:11 commons-logging.jar
-rw-r--r--. 1 root root 111119 Feb 5 09:11 commons-pool-1.6.jar
-rw-r--r--. 1 root root 415578 Feb 5 09:11 commons-vfs2-2.0.jar
-rw-r--r--. 1 root root 313898 Feb 5 09:11 dom4j-1.6.1.jar
-rw-r--r--. 1 root root 222325 Feb 5 09:11 edb-commons.jar
-rw-r--r--. 1 root root 2308517 Feb 5 09:11 guava-19.0.jar
-rw-r--r--. 1 root root 31191 Feb 5 09:11 jaxrpc.jar
drwxrwxr-x. 2 root root 81 Feb 12 03:19 jdbc
-rw-r--r--. 1 root root 33832 Feb 5 09:11 jgoodies-common-1.7.0.jar
-rw-r--r--. 1 root root 402425 Feb 5 09:11 jgoodies-looks-2.5.3.jar
-rw-r--r--. 1 root root 326923 Feb 5 09:11 lang-6.6.4.jar
-rw-r--r--. 1 root root 352668 Feb 5 09:11 log4j-1.2.8.jar
-rw-r--r--. 1 root root 416533 Feb 5 09:11 mapdb-1.0.8.jar
-rw-r--r--. 1 root root 3698857 Feb 13 00:24 ojdbc7.jar
-rw-r--r--. 1 root root 825943 Feb 13 00:25 postgresql-42.2.5.jar
-rw-r--r--. 1 root root 466598 Feb 5 09:11 quartz-all-1.8.6.jar
drwxrwxr-x. 2 root root 37 Feb 12 03:19 repl-mtk
-rw-r--r--. 1 root root 18979 Feb 5 09:11 saaj.jar
-rw-r--r--. 1 root root 29257 Feb 5 09:11 slf4j-api-1.7.7.jar
-rw-r--r--. 1 root root 7901 Feb 5 09:11 slf4j-jdk14-1.7.7.jar
-rw-r--r--. 1 root root 157810 Feb 5 09:11 swing-layout-1.0.1.jar
drwxrwxr-x. 2 root root 4096 Feb 12 03:19 xdb
-rw-r--r--. 1 root root 120906 Feb 5 09:11 xpp3-1.1.3_8.jar
-rw-r--r--. 1 root root 538830 Feb 5 09:11 xstream-1.4.8.jar
[root@ip-172-31-2-48 lib]# pwd
/opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib
[root@ip-172-31-2-48 lib]#

Highlighted
EDB Team Member

Re: Oracle to EDB migration using XDB

Hi @manisha,

 

As communicated by earlier, the Oracle JDBC driver needs to be placed at : XDB_HOME/lib/jdbc.

 

However, from the output shared by you, its placed at /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib.

 

Could you please place this jar under directory /opt/PostgreSQL/EnterpriseDB-xDBReplicationServer/lib/jdbc and try again.

 

NOTE: You may also copy the ojdbc7.jar file to the jre/lib/ext subdirectory of the location where you installed your Java runtime environment.

 

Please get back to us in case of any issues/queries.

 

Regards,

Sudhir

 

View solution in original post