NOTE: The autoexec file, /home/sas/SASConfig/Lev1/SASApp/WorkspaceServer/autoexec.sas, was executed at server initialization.
1 LIBNAME ORAREF ORACLE PATH=XEPDB1 SCHEMA=sasora USER=sas PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
ERROR: The ORACLE engine cannot be found.
ERROR: Error in the LIBNAME statement.
As your results shows, your company does not have SAS/ACCESS Interface to Oracle licensed! Therefore you can not use the ORACLE engine in your Libname statement(s).
You have SAS/ACCESS Interface to ODBC, which means you could connect to an Oracle Database via Oracle's or other Vendor ODBC Driver, as long as your SAS system Administrator sets-it-up/configure-it on the Linux/Unix Workspace Server
Note: The system requirements document I mentioned in my first response, has a section for SAS/ACCESS Interface to ODBC
Hope this helps
Submit the following code and see if you see the SAS/Access to Oracle engine listed
PROC SETINIT; RUN;
If your license includes SAS/Access for Oracle you should see a line like the following in the log, with a license expiration date:
---SAS/ACCESS Interface to Oracle 06FEB2024
If you don't see the product listed, then it is not licensed and will need to your administrator or account team.
Carl Sommer
Hi @haibh
To access Oracle database tables from within SAS software, you require two components!
1. Oracle Client Software -----> Provides the required C libraries to enable third party software such as SAS to communicate with Oracle Database. This must be installed in order to enable communication with Oracle.
2. Licensed and installed/configured SAS/ACCESS Interface to Oracle -----> Establishes communication and translation between SAS & Oracle. This must be configured in order to enable connection to Oracle database.
For details, Your SAS System Administrator must checkout "System Requirements for SAS® 9.4 Foundation for Linux for x64"
Contrary to what @carl_sommer had mentioned about SAS Proc Setinit. Having the SAS/ACCESS product licensed is a must, but that does not guarantee it was installed!!
You'll need to run Proc Product_status; run;
"PROC PRODUCT_STATUS returns a list of the SAS Foundation products that are installed on your system, along with the version numbers of those products. It provides a quick method to determine whether a SAS product is available for your use. The results from PROC PRODUCT_STATUS are returned to the SAS log."
Hope this helps
As your results shows, your company does not have SAS/ACCESS Interface to Oracle licensed! Therefore you can not use the ORACLE engine in your Libname statement(s).
You have SAS/ACCESS Interface to ODBC, which means you could connect to an Oracle Database via Oracle's or other Vendor ODBC Driver, as long as your SAS system Administrator sets-it-up/configure-it on the Linux/Unix Workspace Server
Note: The system requirements document I mentioned in my first response, has a section for SAS/ACCESS Interface to ODBC
Hope this helps
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.