Hi Folks,
We have installed Oracle Client 12c on our Linux server. Using SAS Deployment Manager we configure SAS Access to Oracle to 12c. We also added the following environment variables on sasenv_local under../SASFoundation/9.4/bin:
export LD_LIBRARY_PATH=/oracle/product/12.2.0/client_1/lib:$LD_LIBRARY_PATH
export PATH=/oracle/product/12.2.0/client_1/bin:$PATH
export TNS_ADMIN=/oracle/product/12.2.0/client_1/network/admin:$TNS_ADMIN
export ORACLE_HOME=/oracle/product/12.2.0/client_1:$ORACLE_HOME
Before test the new library, we restarted our services but when we tried to create a oracle libname we had the following error:
26 LIBNAME ORALIB ORACLE PATH=AAAA SCHEMA=MY_SCHEMA USER=user
26 ! PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
ERROR: Unable to connect to Oracle-Oracle environment is either not set or set incorrectly!
ERROR: Error in the LIBNAME statement.
Any idea what is missing?