topic Re: SAS-Oracle connection error after upgrading to 9.4M4 from M2 in Administration and Deployment

SAS-Oracle connection error after upgrading to 9.4M4 from M2

Sven111 — Wed, 22 Mar 2017 16:25:26 GMT

We just finished upgrading from 9.4M2 to 9.4M4 (Linux environment), but now our connection to Oracle isn't working right. When we try to setup an Oracle LIBNAME we get the following error:

UNABLE TO CONNECT TO ORACLE-ORACLE ENVIRONMENT IS EITHER NOT SET OR SET INCORRECTLY!

I've done some searching for this error message, but have come up dry. SAS appears to be working in general if we're not connecting to Oracle. It seems like it might be saying it's missing some environmental variables somewhere, but my user environment didn't change at all. Does SAS have it's own environmental variables that may have been overwritten in the upgrade maybe?

Any ideas?

Re: SAS-Oracle connection error after upgrading to 9.4M4 from M2

SASKiwi — Wed, 22 Mar 2017 19:11:44 GMT

Can you remote into the SAS Server and try a test query in the Oracle client (SQLPlus I think). If it works then the Oracle side of things should be OK. It not then there is a problem with the Oracle set up.

Re: SAS-Oracle connection error after upgrading to 9.4M4 from M2

maheshtalla — Wed, 22 Mar 2017 19:17:49 GMT

Also can you please verify environment variables set in sasenv_local file in the path SASROOT/bin.

Re: SAS-Oracle connection error after upgrading to 9.4M4 from M2

Sven111 — Wed, 22 Mar 2017 20:06:05 GMT

Oracle appears to be working ok, I think @maheshtalla is on the right track with the environmental vars. I've gone through the SAS ACCESS install/config guide but didn't see anything about modifying the environmental vars, I also went through all of the sasenv files and didn't see anything looking like it's referencing Oracle. And sasenv_local appears to be stock, everything is commented out instructions.

Re: SAS-Oracle connection error after upgrading to 9.4M4 from M2

maheshtalla — Wed, 22 Mar 2017 20:34:03 GMT

If its empty, so you should make entries to export them which looks similar to below example and then it should resolve the issue.

export oracel_home= refer to path where oracle client is installed in your server like /etc/oracle

LD_LIBRARY_PATH= $ORACLE_HOME/lib:$LD_LIBRARY_PATH

export LD_LIBRARY_PATH

Re: SAS-Oracle connection error after upgrading to 9.4M4 from M2

Sven111 — Wed, 22 Mar 2017 21:31:02 GMT

We found an entry for ORACLE_HOME in the backup we made prior to upgrade in the sasenv_local file. We readded it to the file and it looks like it's working again. Thanks!