Online Documentation for Data Comparer for Oracle
Step 1 - Setting connection properties
At this step you should specify necessary settings to establish connection to Oracle databases.
Specify your Oracle Home storage for this connection.
Note: If no database is registered in Oracle Client (DB list is empty in this case) you need to add registration info manually.
Select the type of connection to be established: Normal (by default), SYSDBA, SYSOPER.
Specify the type of authentication to be used for the connection: Windows or Server authentication.
If Server has been selected as the authentication type, you should also provide authorization settings: Login and Password.
The default superuser name is 'SYS' (for Oracle 9.0 and higher) and the default password is 'change_on_install'.
After that it is necessary to select the database for data comparison: use the Database drop-down list to select the database you need (the drop-down list contains databases currently specified in the TNS file).
Please note that you need to have sufficient privileges to be able to write to the destination database on Oracle server.
To setup the connection via SSH tunnel proceed to the Tunneling tab and input the following values in the corresponding fields:
- SSH host name is the name of the host where SSH server is running
- SSH port indicates the port where SSH server is activated
- SSH user name stands for the user on the machine where SSH server is running (Note: it is a Linux/Windows user, not a user of Oracle server)
- SSH password is the Linux/Windows user password
For details see SSH tunneling options.
Repeat the steps above for the target Oracle connection or just check the Both databases on the same server option for comparing data from databases located on the same server.