Page History

...

• OCI Connection to Oracle 21c
• OCI Connection to Oracle 19c
• OCI Connection to Oracle 18c and 12c Release 2
• OCI Connection to Oracle 12c and Oracle 12c Release 1
• OCI Connection to Oracle 11g
• OCI Connection to Oracle 10g
• OCI Connection to Oracle 9i
• OCI Connection to Oracle 8i
• Troubleshooting OCI connections

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.

...