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;
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.
Kindly help to resolve this problem? I'm not able to find the Path
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.
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.
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".
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
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,
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.