This section describes how you create a new remote Oracle server. Before you begin ensure that you:
-
Install the Oracle Database Client software on the remote host.
-
Install the appropriate JDBC drivers. The JDBC driver is required to access the remote instance of Oracle. This must be done even if Oracle is not installed on the remote host. For Windows you can use the Connect CDC Installation wizard to install the appropriate JDBC drivers. Refer to the Connect CDC Installation Guide. For Linux and Unix, you must manually download the JDBC drivers.
-
On the Servers Properties dialog, select Oracle from the dropdown list in the DBMS type section.
-
Check the checkbox, Remote Machine Name or IP. Specify the remote machine name or IP address of the remote server.
-
Enter information for each field on the Server Properties dialog. Refer to Server properties dialog for Oracle for field information.