Versions Compared

Old Version 5

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 6

changes.mady.by.user Nadine Hinojosa

Saved on

Key

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

...

  1. Shutdown Aqua Data Studio
  2. Locate nls_charset12.jar, ojdbc14.jar and xdb6.jar within your Oracle installation.

  3. Delete ojdbc8.jar, orai18n.jar and xdb6.jar from [ADS_INSTALL]\lib\drivers

    Info

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

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

  4. Copy the nls_charset12.jar, ojdbc14.jar and xdb6.jar file that you found in step 2 to [ADS_INSTALL]\lib\drivers.
  5. Launch ADS and go to Help -> About Aqua Data Studio -> JDBC Drivers and verify that the Oracle Driver is now at version 10.x.
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 RemovedImage Added

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.

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.

OCI Connection to Oracle 19c

...