- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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".
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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