Hi all. I installed the Oracle Client 12.1 on the MAC OS using the following zip files and instructions:
Version 12.1.0.2 (64-bit) Updated 7/5/2017
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
Download instantclient-basic-macos.x64-12.1.0.2.0.zip
Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
Download instantclient-sqlplus-macos.x64-12.1.0.2.0.zip
Installing Instant Client 12.1 on macOS
1. Download the desired Instant Client ZIP files. All installations require the Basic or Basic Light package.
2. Unzip the packages into a single directory such as "~/instantclient_12_1". For example, to use SQL*Plus:
cd ~
unzip instantclient-basic-macos.x64-12.1.0.2.0.zip
unzip instantclient-sqlplus-macos.x64-12.1.0.2.0.zip
3. Create the appropriate libclntsh.dylib link for the version of Instant Client. For example:
cd ~/instantclient_12_1
ln -s libclntsh.dylib.12.1 libclntsh.dylib
ln -s libocci.dylib.12.1 libocci.dylib
4. Add links to $HOME/lib or /usr/local/lib to enable applications to find the libraries. For example, OCI based applications could do:
mkdir ~/lib ln -s ~/instantclient_12_1/libclntsh.dylib ~/lib/
5. To be able to run SQL*Plus, update PATH. For example:
export PATH=~/instantclient_12_1:$PATH
6. Run SQL*Plus and connect using your database credentials and connection string:
sqlplus hr/welcome@localhost/orcl
However, now when I attempt to run SQLPLUS I get the message that my tnsnames.ora Hostname can't be resolved. I placed my tnsnames.ora file in the "~/instantclient_12_1" folder, but perhaps I have the wrong location? Can anyone help me with this?
sqlplus ssbuechl@fcprod
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
My TNSNAMES.ORA entry is:
FC,FCPROD,fcprod,SPARC20 =
(DESCRIPTION =
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=9.35.32.206)(Port=1521)))
(CONNECT_DATA=(SID=FCPROD))
)