Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
827
|
Aqua Data Studio comes bundled with Oracle 18c JDBC drivers. These drivers are compatible with Oracle 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.
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.
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 |
Help > About > JDBC Drivers tab indicating 10g Drivers |
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.
Failing to do this may cause ADS to crash.
The best way to ensure compatibility is to copy the Oracle JDBC drivers from your Oracle Client installation directory into ADS's drivers directory. The set of files that need to copied vary by Oracle version. Please follow the appropriate link based upon the version of Oracle you have installed.
macOS Users: OCI Connections are not supported on macOS. There is no need to change or update the drivers on macOS.
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.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
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.
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> |
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.
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> |
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.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
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.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
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.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
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.
Renaming the files is not sufficient. You must either delete these files or move them to a directory outside of [ADS_HOME]
You must change the .zip file extensions of classes12.zip and nls_charset12.zip to .jar for use in Aqua Data Studio
Be sure to follow the above steps first to ensure that you have the proper drivers installed for ADS to make an OCI connection. In most situations, following the above steps will result in successful OCI connection.
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:
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017