A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
The Oracle `OCI Client` for Mac OS X is available, but must be downloaded directly from Oracle.
Please note that the entire OCI Client installation is not necessary for ODBC connectivity.
OpenLink bundles the only necessary library, libclntsh.dylib, from the Oracle OCI Client, into our installation of the
The Oracle Lite driver does require the user to specify the Oracle Home Directory (also known as ORACLE_HOME, or
OpenLink's general recommendation is to execute the following commands in a Terminal session -
mkdir -p /Library/ODBC/Oracle/network/admin touch /Library/ODBC/Oracle/network/admin/tnsnames.ora chmod -R 775 /Library/ODBC/Oracle
Users may also choose to add the entire OCI Client to their machine, if they prefer to receive full-text errors rather than just the `TNS-12345` style errors, which are delivered by this single library.
The necessary installer may be downloaded from Oracle, via the following link (note - this will require one to register with Oracle's
OCI 8 Client for Mac OS X (approx 6 MB) http://download.oracle.com/otn/utilities_drivers/jdbc/8171/
MacOSX_8171.cpio
These components may be installed anywhere on the boot volume.
Oracle has a recommended location, or one may use their own preferred location.
The directory which is thereafter known as ORACLE_HOME should be specified in all Oracle Lite DSNs, and the TNS Names file referenced by the
Installation instructions are shown on the download page for the OCI Client.
They currently indicate the wrong cpio filename; this has been corrected in the instructions which follow.
OpenLink recommends first creating a directory, /Library/ODBC/Oracle/, and placing the MacOSX?_8171.cpio file therein. Then execute these commands to shift to the bash shell, and unpack the cpio file -
bash cpio -idvmc < MacOSX_8171.cpio
The user will observe output similar to that below, and the listed zip files will now be found in /Library/ODBC/Oracle/ (or whatever location was chosen above) -
bash-2.05a$ cpio -idvmc < MacOSX_8171.cpio ./MacOSX_8.1.7.1_OCI_Demo.zip ./Oracle_8.1.7.1_Client.zip ./Release_Notes.zip 1176 blocks bash-2.05a$
The following instructions are adapted from the contents of the Release_Notes.zip.
Installation Instructions
The following procedures provide the instructions to install the Oracle8i Client software. The examples shown assume that the directory used is /Library/ODBC/Oracle and commands are entered in the bash shell.
% cp Oracle_8.1.7.1_Client.zip /Library/ODBC/Oracle
% cd /Library/ODBC/Oracle % unzip Oracle_8.1.7.1_Client.zip
% export ORACLE_HOME=/Library/ODBC/Oracle/
% export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME/lib
% export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
% export TNS_ADMIN=$ORACLE_HOME/network/admin