Page History

Versions Compared

Key

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

...

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

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

Using the Oracle 10g Drivers in Aqua Data Studio to connect to Oracle 8i and 9i
Before Deleting the Oracle 18c drivers	After 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

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

...

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 19c

...

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.
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]
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.
Copy ojdbc8.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
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.

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.

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

Location of Oracle 18c or 12c Release 2 Client JDBC Drivers

C:\ora\app\admin\product\12.2.0\dbhome\jdbc\lib>dir

02/23/2017  05:19 PM    <DIR>          .
02/23/2017  05:19 PM    <DIR>          ..
02/23/2017  10:09 PM         1,996,390 ojdbc5.jar
02/23/2017  10:09 PM         2,429,986 ojdbc5dms.jar
02/23/2017  10:09 PM         3,102,538 ojdbc5dms_g.jar
02/23/2017  10:09 PM         3,081,969 ojdbc5_g.jar
??/??/????  ??:?? ??         ?,???,??? ojdbc8.jar    <- copy this
02/23/2017  10:09 PM         2,656,012 ojdbc6dms.jar
02/23/2017  10:09 PM         3,423,966 ojdbc6dms_g.jar
02/23/2017  10:09 PM         3,402,257 ojdbc6_g.jar
02/23/2017  10:09 PM            20,355 simplefan.jar
               9 File(s)     22,224,811 bytes
               2 Dir(s)  127,050,838,016 bytes free

C:\ora\app\admin\product\12.2.0\dbhome\jdbc\lib>

C:\ora\app\admin\product\12.2.0\dbhome\jlib>dir

01/02/2017  05:54 PM    <DIR>          .
01/02/2017  05:54 PM    <DIR>          ..
12/28/2016  08:08 AM            55,434 ocrs12.jar
01/02/2017  07:25 PM         2,313,802 ojdbc5dms.jar
01/02/2017  07:25 PM         1,062,368 orai18n-collation.jar
01/02/2017  07:25 PM            11,057 orai18n-internal.jar
01/02/2017  07:25 PM         1,469,241 orai18n-lcsd.jar
01/02/2017  07:25 PM            82,953 orai18n-mapping.jar
01/02/2017  07:25 PM             9,799 orai18n-net-ee.jar
01/02/2017  07:25 PM            45,528 orai18n-net.jar
01/02/2017  07:25 PM            85,878 orai18n-servlet.jar
01/02/2017  07:25 PM            86,409 orai18n-tools.jar
01/02/2017  07:25 PM         1,403,740 orai18n-translation.jar
01/02/2017  07:25 PM           405,501 orai18n-utility.jar
??/??/????  ??:?? ??         ?,???,??? orai18n.jar    <- copy this
              13 File(s)      8,686,914 bytes
               2 Dir(s)  127,050,846,208 bytes free

C:\ora\app\admin\product\12.2.0\dbhome\jlib>

What to modify in [ADS_HOME]/lib/drivers folder

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>dir


02/18/2017  08:58 AM    <DIR>          .
02/18/2017  08:58 AM    <DIR>          ..
02/18/2017  11:13 AM            35,701 cassandra-clientutil.jar
02/18/2017  11:13 AM            64,465 cassandra-jdbc.jar
...
02/18/2017  11:13 AM           445,188 ncluster.jar
02/18/2017  11:13 AM         4,036,257 ojdbc8.jar    <- delete before paste
02/18/2017  11:13 AM         1,661,088 orai18n.jar   <- delete before paste
02/18/2017  11:13 AM           346,944 paraccel-jdbc.jar
02/18/2017  11:13 AM           561,969 postgresql.jar
02/18/2017  11:13 AM         3,516,830 sqlite-jdbc.jar
02/18/2017  11:13 AM           286,773 util400.jar
02/18/2017  11:13 AM           262,740 xdb6.jar   
02/18/2017  11:13 AM           839,982 xmlparserv2.jar
              28 File(s)     29,365,764 bytes
               2 Dir(s)  88,341,790,720 bytes free

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>dir


02/18/2017  08:58 AM    <DIR>          .
02/18/2017  08:58 AM    <DIR>          ..
02/18/2017  11:13 AM            35,701 cassandra-clientutil.jar
02/18/2017  11:13 AM            64,465 cassandra-jdbc.jar
...
02/18/2017  11:13 AM           445,188 ncluster.jar
??/??/????  ??:?? ??         ?,???,??? ojdbc8.jar    <- paste
??/??/????  ??:?? ??         ?,???,??? orai18n.jar   <- paste 
02/18/2017  11:13 AM           346,944 paraccel-jdbc.jar
02/18/2017  11:13 AM           561,969 postgresql.jar
02/18/2017  11:13 AM         3,516,830 sqlite-jdbc.jar
02/18/2017  11:13 AM           286,773 util400.jar
02/18/2017  11:13 AM           262,740 xdb6.jar   
02/18/2017  11:13 AM           839,982 xmlparserv2.jar
              28 File(s)     28,761,869 bytes
               2 Dir(s)  88,341,186,825 bytes free

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>

OCI Connection to Oracle 12c and Oracle 12c Release 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.
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]
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.
Copy ojdbc7.jar and orai18n.jar to [ADS_INSTALL]\lib\drivers
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.

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.

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

Location of Oracle 12c Release 1 Client JDBC Drivers

C:\ora\app\admin\product\12.1.0\dbhome\jdbc\lib>dir

02/23/2016  05:19 PM    <DIR>          .
02/23/2016  05:19 PM    <DIR>          ..
02/23/2016  10:09 PM         1,996,390 ojdbc5.jar
02/23/2016  10:09 PM         2,429,986 ojdbc5dms.jar
02/23/2016  10:09 PM         3,102,538 ojdbc5dms_g.jar
02/23/2016  10:09 PM         3,081,969 ojdbc5_g.jar
??/??/????  ??:?? PM         ?,???,??? ojdbc7.jar    <- copy this
02/23/2016  10:09 PM         2,656,012 ojdbc6dms.jar
02/23/2016  10:09 PM         3,423,966 ojdbc6dms_g.jar
02/23/2016  10:09 PM         3,402,257 ojdbc6_g.jar
02/23/2016  10:09 PM            20,355 simplefan.jar
               9 File(s)     22,224,811 bytes
               2 Dir(s)  127,050,838,016 bytes free

C:\ora\app\admin\product\12.1.0\dbhome\jdbc\lib>

C:\ora\app\admin\product\12.1.0\dbhome\jlib>dir

01/16/2016  05:54 PM    <DIR>          .
01/16/2016  05:54 PM    <DIR>          ..
01/16/2016  08:08 AM            55,434 ocrs12.jar
01/16/2016  07:25 PM         2,313,802 ojdbc5dms.jar
01/16/2016  07:25 PM         1,062,368 orai18n-collation.jar
01/16/2016  07:25 PM            11,057 orai18n-internal.jar
01/16/2016  07:25 PM         1,469,241 orai18n-lcsd.jar
01/16/2016  07:25 PM            82,953 orai18n-mapping.jar
01/16/2016  07:25 PM             9,799 orai18n-net-ee.jar
01/16/2016  07:25 PM            45,528 orai18n-net.jar
01/16/2016  07:25 PM            85,878 orai18n-servlet.jar
01/16/2016  07:25 PM            86,409 orai18n-tools.jar
01/16/2016  07:25 PM         1,403,740 orai18n-translation.jar
01/16/2016  07:25 PM           405,501 orai18n-utility.jar
??/??/????  ??:?? ??         ?,???,??? orai18n.jar    <- copy this
              13 File(s)      8,686,914 bytes
               2 Dir(s)  127,050,846,208 bytes free

C:\ora\app\admin\product\12.1.0\dbhome\jlib>

What to modify in [ADS_HOME]/lib/drivers folder

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>dir


02/18/2017  08:58 AM    <DIR>          .
02/18/2017  08:58 AM    <DIR>          ..
02/18/2017  11:13 AM            35,701 cassandra-clientutil.jar
02/18/2017  11:13 AM            64,465 cassandra-jdbc.jar
...
02/18/2017  11:13 AM           445,188 ncluster.jar
02/18/2017  11:13 AM         4,036,257 ojdbc8.jar    <- delete before paste
02/18/2017  11:13 AM         1,661,088 orai18n.jar   <- delete before paste
02/18/2017  11:13 AM           346,944 paraccel-jdbc.jar
02/18/2017  11:13 AM           561,969 postgresql.jar
02/18/2017  11:13 AM         3,516,830 sqlite-jdbc.jar
02/18/2017  11:13 AM           286,773 util400.jar
02/18/2017  11:13 AM           262,740 xdb6.jar   
02/18/2017  11:13 AM           839,982 xmlparserv2.jar
              28 File(s)     29,365,764 bytes
               2 Dir(s)  88,341,790,720 bytes free

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>dir


02/18/2017  08:58 AM    <DIR>          .
02/18/2017  08:58 AM    <DIR>          ..
02/18/2017  11:13 AM            35,701 cassandra-clientutil.jar
02/18/2017  11:13 AM            64,465 cassandra-jdbc.jar
...
02/18/2017  11:13 AM           445,188 ncluster.jar
??/??/????  ??:?? ??         ?,???,??? ojdbc7.jar    <- paste
??/??/????  ??:?? ??         ?,???,??? orai18n.jar   <- paste 
02/18/2017  11:13 AM           346,944 paraccel-jdbc.jar
02/18/2017  11:13 AM           561,969 postgresql.jar
02/18/2017  11:13 AM         3,516,830 sqlite-jdbc.jar
02/18/2017  11:13 AM           286,773 util400.jar
02/18/2017  11:13 AM           262,740 xdb6.jar   
02/18/2017  11:13 AM           839,982 xmlparserv2.jar
              28 File(s)     28,761,869 bytes
               2 Dir(s)  88,341,186,825 bytes free

C:\Program Files\Aqua Data Studio 19.0 - 64bit\lib\drivers>

OCI Connection to Oracle 11g

...

Content

Space Tools

Versions Compared

Old Version 2

New Version 3

Key

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

OCI Connection to Oracle 19c

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

OCI Connection to Oracle 11g