Versions Compared

Old Version 7

changes.mady.by.user Nadine Hinojosa

Saved on

compared with

New Version Current

changes.mady.by.user Nadine Hinojosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Aqua Data Studio comes bundled with Oracle 18c 21c JDBC drivers. These drivers are compatible with Oracle 21c, 18c, 12c, 11g and 10g when using the Oracle (non-OCI) connection in Aqua Data Studio. To make an OCI connection or to connect to Oracle 9i or 8i, please follow the appropriate instructions below.

...

Anchor
oracle_jdbc_driver_location
oracle_jdbc_driver_location
Connecting to Oracle 8i and 9i using non-OCI Connection

Aqua Data Studio is bundled with the Oracle 18c JDBC drivers. Oracle has discontinued support for Oracle 8i and 9i in their Oracle 18c drivers.  Aqua Data studio still supports Oracle 8i and 9i, but you need to backdrop the Oracle drivers from 18c to 10g. Below are the instructions to backdrop to Oracle 10g drivers. 

...

Using the Oracle 10g Drivers in Aqua Data Studio to connect to Oracle 8i and 9i
Before Deleting the Oracle 18c driversAfter Deleting the Oracle 18c drivers and pasting the Oracle 10g JDBC drivers

Image Modified

Image Modified

Help > About > JDBC Drivers tab indicating 10g Drivers

Image Modified

Anchor
updating_driver_contents
updating_driver_contents
Making an OCI Connection to Oracle 21c/19c/18c/12c/11g/10g/9i/8i

To make an Oracle OCI Connection, you need to ensure that the Oracle JDBC drivers used by ADS are build compatible with the Oracle version you have installed on your machine.

...

macOS Users: OCI Connections are not supported on macOS. There is no need to change or update the drivers on macOS.

Anchor
#Oracle21
#Oracle21
OCI Connection to Oracle 21c

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc11.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc8.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. orai18n.jar: located in [ORACLE_HOME]\jlib.
  4. Copy ojdbc8.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "12" and the Minor Build Number matches your Oracle Client version.

...

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc8.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. orai18n.jar: located in [ORACLE_HOME]\jlib.
  4. Copy ojdbc8.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "12" and the Minor Build Number matches your Oracle Client version.

...

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc8.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. orai18n.jar: located in [ORACLE_HOME]\jlib.
  4. Copy ojdbc8.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "12" and the Minor Build Number matches your Oracle Client version.

...

OCI Connection to Oracle 12c and Oracle 12c Release 1

  1. Shutdown

    Shutdown Aqua Data Studio

    InfoWarning: If running 32-bit Oracle Client, you must use 32-bit

    Aqua Data Studio

    Info

    Warning: . If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc7.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. orai18n.jar: located in [ORACLE_HOME]\jlib.
  4. Copy ojdbc7.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "12" and the Minor Build Number matches your Oracle Client version.

...

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc6.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. orai18n.jar: located in [ORACLE_HOME]\jlib.
  4. Copy ojdbc6.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "11" and the Minor Build Number matches your Oracle Client version.

...

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc14.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. nls_charset12.jar: located in [ORACLE_HOME]\jdbc\lib.
  4. Copy ojdbc14.jar and nls_charset12.jar from [ORACLE_HOME]\jdbc\lib to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "10" and the Minor Build Number matches your Oracle Client version.

...

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. ojdbc14.jar: located in [ORACLE_HOME]\jdbc\lib.
    2. nls_charset12.jar: located in [ORACLE_HOME]\jdbc\lib.
  4. Copy ojdbc14.jar and nls_charset12.jar from [ORACLE_HOME]\jdbc\lib to [ADS_INSTALL]\lib\drivers
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "9" and the Minor Build Number matches your Oracle Client version.

...

  1. Shutdown Aqua Data Studio

    Info

    Warning: If running 32-bit Oracle Client, you must use 32-bit Aqua Data Studio. If running 64-bit Oracle Client, you must use 64-bit Aqua Data Studio.

  2. Delete ojdbc8.jar and orai18n.jar from [ADS_INSTALL]\lib\drivers.

    Info

    Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]

  3. Locate the Oracle JDBC driver files from your Oracle Client installation.
    1. classes12.zip: located in [ORACLE_HOME]\jdbc\lib.
    2. nls_charset12.zip: located in [ORACLE_HOME]\jdbc\lib.

  4. Copy classes12.zip and nls_charset12.zip from [ORACLE_HOME]\jdbc\lib to [ADS_INSTALL]\lib\drivers and rename their extensions to .jar.

    Info

    You must change the .zip file extensions of classes12.zip and nls_charset12.zip to .jar for use in Aqua Data Studio

  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that for the Oracle Driver, the Major Build Number is "8" and the Minor Build Number is what you are expecting.

...

Be aware that if more than one Oracle client has been installed on the same computer as Aqua Data Studio, you must make sure that only one Oracle Client appears in the windows path. Having multiple versions of the OCI DLLs in the path will prevent Aqua Data Studio from successfully connecting and will generate an error message similar to the following when attempting to make a connection:

Image Modified