SAS connect to Oracle database

[arunsunny]

I went thru many of the posts about Oracle database connect issues, i could not find a solution to my problem. Hence i am posting it here.

I have SAS Connect to Oracle installed and licensed. Checked using Proc Product Status and Proc Setinit. I also have ODBC setup as "ORD" and its works fine querying data from SQL Developer tool.

When i ran the following libname statement:

LIBNAME ORD ORACLE SERVER=FIORDXP USER="A476622" PASSWORD="xxxxxxxx" DB=ORD_DOREP;
RUN;

I get the following error:

LIBNAME ORD ORACLE SERVER=FIORDXP USER="A476622" PASSWORD=XXXXXXXXXXX DB=ORD_DOREP;
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.
27 RUN;

Kindly help to resolve this problem? I'm not able to find the Path

[Anand_V]

Hi @arunsunny 

I sense something to do with the configuration or version mismatch. Links below to an old KB and similar question answered see if it helps.

Problem Note 46630: The error "Image SASORA found but not loadable" occurs in SAS® 9.3 

Can't connect to Oracle 

[arunsunny]

Thanks @Anand_V for quick reply.

I went thru the article, didnt come of use. I'm using SAS 9.4 and SAS EG 7.1. I got my SAS Connect to Oracle reinstalled but not been able to configure. On the other hand i also have SAS Connect to Netezza which is working perfectly well.

[Anand_V]

You have to do some configuration based on which platform you are connecting to.

Please find the link for UNIX: Configuration Guide--SAS® 9.4 Foundation for UNIX® Environments 

Please find the section "SAS/Access Interface to Oracle".

[AhmedAl_Attar]

@arunsunny 

In order to user SAS/ACCESS Interface to Oracle properly, You'll need to 

1. Have the correct Oracle Client Software installed on your Machine/Server (This will provide all the required Libraries to allow third party software communicate to Oracle)

2. Modify the [Somepath]/SASHome/SASFoundation/9.4/bin/sasevn_local file to contain the following settings

ORACLE_HOME=/apps/oracle/product/12.2.0/client   #Replace this to reflect where the Oracle software is installed 
export ORACLE_HOME​
​LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH ​
export LD_LIBRARY_PATH​
3. Modify the $ORACLE_HOME/network/admin/tnsnames.ora file and populate your Oracle SID information

Restart/Reconnect to your WorkspaceServer and try the Libname statement.

Hope this helps,

Ahmed