topic Re: Oracle 12c | Unable to connect to Oracle-Oracle environment in Administration and Deployment

Oracle 12c | Unable to connect to Oracle-Oracle environment

MariaD — Tue, 10 Sep 2019 19:52:31 GMT

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?

Re: Oracle 12c | Unable to connect to Oracle-Oracle environment

SASKiwi — Tue, 10 Sep 2019 21:16:38 GMT

I suggest you try a test query in Oracle's SQLPLUS tool on your SAS server. If it works then there is something on the SAS side that is not configured correctly. If it doesn't work, then it is an Oracle client configuration problem and nothing to do with SAS. Make sure you have the correct database connections defined in your TNSNAMES.ORA file.

Re: Oracle 12c | Unable to connect to Oracle-Oracle environment

ankitd — Wed, 11 Sep 2019 12:43:10 GMT

My initial understanding is that you need to define the ODBCINI and ODBCINST path as well apart from that ensure that you LD_LIBRARY_PATH has everything covered.

The best validation is to verify whether the isql test works fine, in case that fails then you need to understand whether there is some firewall issue, if the isql test works fine then you are confined to just the SAS configuration.

Worth trying the above two before we can look at other possibilities.

Regards,

Ankit

Re: Oracle 12c | Unable to connect to Oracle-Oracle environment

MariaD — Wed, 11 Sep 2019 12:56:25 GMT

Thanks to all. We reviewed the environment variables definition and we find an extra "/" that cause the problem.

Regards,