topic Re: SAS Oracle Configration in Administration and Deployment

SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 07:51:28 GMT

Hello Everyone

Could you please advise what steps are required to setup sas oracle configration on Linux. We alredy installed oracle client 11.2 version on sas9.4.

Oracle installed : /usr/lib/oracle/11.2./client64

TNS File Path : /etc/opt/oracle

I am getting below error from SAS EG: -

ERROR: Unable to connect to Oracle-Oracle environment is either not set or set incorrectly!
ERROR: Error in the LIBNAME statement.

Re: SAS Oracle Configration

Kurt_Bremser — Mon, 27 Mar 2017 10:00:14 GMT

You need to set the Oracle environment variables in ...../Lev1/level_env.sh

Re: SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 10:11:12 GMT

done...Again I am getting the same error:

ERROR: Unable to connect to Oracle-Oracle environment is either not set or set incorrectly!
ERROR: Error in the LIBNAME statement.

Re: SAS Oracle Configration

Timmy2383 — Mon, 27 Mar 2017 10:53:06 GMT

Probably works the same way as what Kurt suggested, but mine is set in the env_local file under !SASROOT/SASFoundation/9.4/bin/

You need to set the LD_LIBRARY_PATH environment variable in this file. See page 59 in this doc:

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

Re: SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 12:49:23 GMT

I have added these variable in both these files but still getting the same error.

I noticed when i execuate below prog its showing Oracle_Home not exit during signon?

data _null_;
 if sysexist('$ORACLE_HOME') then do;
 put "Exists";
 Oracle_Home = sysget('$ORACLE_HOME');
 put Oracle_Home = ;
 end;
 else put "Not exists";
run;

Re: SAS Oracle Configration

Kurt_Bremser — Mon, 27 Mar 2017 13:29:08 GMT

Do not use the dollar sign in a %sysget, sysget or sysexist, just use ORACLE_HOME.

Re: SAS Oracle Configration

Kurt_Bremser — Mon, 27 Mar 2017 13:31:14 GMT

And what do you mean by "during signon"? Is SAS/CONNECT involved in the situation in some way?

Re: SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 18:54:26 GMT

We are not using sas connect. I am getting the error agin .

28 data _null_;
29 if sysexist('LD_LIBRARY_PATH') then do;
30 put "Exists";
31 LD_LIBRARY_PATH = sysget('LD_LIBRARY_PATH');
32 put LD_LIBRARY_PATH = ;
33 end;
34 else put "Not exists";
35 run;

Exists
LD_LIBRARY_PATH=/opt/sas/sashome/Secure/sasexe:/opt/sas/sashome/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver:/
opt/sas/sashome/SASPrivateJavaRuntimeEnvironment/9.4/jre/lib/amd64/server:/opt/sas/s
NOTE: DATA statement used (Total process time):

Is this env resolved coreclty?

oracle error:

ERROR: Could not load /opt/sas/sashome/SASFoundation/9.4/sasexe/sasora (105 images loaded)
ERROR: libclntsh.so.11.1: cannot open shared object file: No such file or directory
24
25 LIBNAME abc ORACLE PATH=prod USER=sas_r PASSWORD=XXXXXXXXXXX;
ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image SASORA found but not loadable..
Please make sure Oracle environment is set correctly.
Look in the install/Config doc for additional info for your platform.
Other possible reasons - incomplete Oracle client install, 32/64-bit mismatch between Oracle client & SAS, incorrect Oracle client
version(Oracle client must match the version picked during post-install process), incompatible sasora for your OS or its
attribs don't permit SAS to load it.
ERROR: Error in the LIBNAME statement.

Re: SAS Oracle Configration

Timmy2383 — Mon, 27 Mar 2017 18:58:28 GMT

Where is your Oracle client installed and do you have SAS/Access to Oracle licensed/installed?

Re: SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 19:10:59 GMT

yes we have licened for oracle client. but know know how we can whether it is installed or not?

oracle client version 11.2 installed on Linux env. on below path :

/usr/lib/oracle/11.2./client64

Oracle database version : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Re: SAS Oracle Configration

Timmy2383 — Mon, 27 Mar 2017 19:16:12 GMT

See if you can use my setup as a template for your own. Here's what the entry for Oracle client in my env_local file looks like:

#ORACLE

export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=/u02/app/oracle/product/11.2.0/client
export ORACLE_VERSION=11.2.0
export PATH=$ORACLE_HOME/bin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

Re: SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 19:21:33 GMT

Thanks for reply.

Still getting the same error.

Re: SAS Oracle Configration

Timmy2383 — Mon, 27 Mar 2017 19:24:21 GMT

1. Can you show what your env_local file looks like?2. Are you starting new SAS sessions for testing after each change?

Re: SAS Oracle Configration

japsas100 — Mon, 27 Mar 2017 19:31:04 GMT

Thanks Timmy2383

Issued has been fixed. Acutually use not have the appropriate access right thats why its throwing error.

When I assigned all the required access through smc then I am able to connect with oracle without any error.

Thanks You soo much for your help.

Re: SAS Oracle Configration

Timmy2383 — Tue, 28 Mar 2017 12:09:16 GMT

Glad you got it resolved!