@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
... View more