1. DB Best Documentation
  2. Database Compare Suite
  3. Connecting to an Oracle database
Database Compare Suite™

Connecting to an Oracle database

Use the following procedure to connect to your Oracle database.

  1. Click on the New icon in the Project panel at the top left corner of the window.

  2. Select Oracle in the Platform drop-down list at the top of the dialog box

    • If the Oracle OLE DB Driver is not installed on your PC, you will need to install it. For more information, see Installing the Required Database Drivers.

    • After installing the driver, restart the DataBase Compare Suite application and get back to item 1.

  3. Select the Standard option in the Mode drop-down list if you would like to connect to the Oracle database in the standard mode.

    • Specify the Server name in the appropriate field. You can enter it manually or select it from the drop-down list (if it has been used already).

    • Provide the rest of connection information to the Oracle database: Server Port, Oracle SID and Username. You can manually enter these values or select them from drop-down lists.

    • Enter the Password to complete the information about Oracle database connection.

    • Check the Use SSL option to establish a secure connection to the Oracle database.

    • Press the Test button to verify that you can successfully connect to your Oracle database.

  4. Select the TNS mode option in the Mode drop-down list if you would like to connect to the Oracle database in TNS mode.

    • Specify the Connection ID in the appropriate field. You can enter it manually, select it from the drop-down list (if it has been used already) or load it from your local TNSNames.ora file.

    • Enter Username (can be selected from the list of previously used usernames) and Password.

    • Enter the Password to complete the information about Oracle database connection.

    • Press the Test button to verify that you can successfully connect to your Oracle database.

  5. Choose the Connection String option in the Mode drop-down list if you would like to connect to the Oracle database using special connection string.

    • Enter the Connection string manually or select from the drop-down list (if it has been used already).

    • Find the connection string template below. Use it as an example to create a connection string that allows to connect to your Oracle database:

      DATA SOURCE="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle_server)(PORT=1521)))(CONNECT_DATA=(SID=orcl)))";USER ID=oracle_user;PASSWORD=pass;CONNECTION TIMEOUT=300

    • Press the Test button to verify that you can successfully connect to your Oracle database.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].