topic Re: SAS connect to Oracle database in SAS Procedures

SAS connect to Oracle database

arunsunny — Mon, 29 Jun 2020 11:18:27 GMT

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

Re: SAS connect to Oracle database

AnandVyas — Mon, 29 Jun 2020 11:36:51 GMT

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

Re: SAS connect to Oracle database

arunsunny — Mon, 29 Jun 2020 11:41:00 GMT

Thanks @AnandVyas 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.

Re: SAS connect to Oracle database

AnandVyas — Mon, 29 Jun 2020 12:19:10 GMT

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".

Re: SAS connect to Oracle database

AhmedAl_Attar — Mon, 29 Jun 2020 15:05:47 GMT

@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