Usage Note 30476: System, installation, and configuration requirements for SAS/ACCESS® Interface to Oracle in UNIX operating environments
This note provides a summary of system and installation requirements for SAS/ACCESS Interface to Oracle under UNIX.
Verify That the Software Is Licensed
First, you should verify that you have licensed the software. To do that, invoke the SAS® System and submit the following SETINIT procedure in the SAS Program Editor:
proc setinit noalias;
If you check the SAS log, you should see SAS/ACCESS Interface to Oracle listed. If it is not listed, then the software is not licensed. If the software is listed, you need to verify that it is installed.
To verify that the SAS/ACCESS Interface to Oracle product is installed, the sasora file must reside in the !SASROOT/sasexe directory. (!SASROOT is the directory where SAS is installed). Submit the following commands to verify that sasora resides in the directory:
unix_prompt> cd !SASROOT/sasexe
unix_prompt> ls -la sasora
If the sasora file does not exist, then the software is not installed.
Verify System Requirements
The following SAS®®9 applications are required in order to use SAS/ACCESS Interface to Oracle under UNIX:
Base® SAS software
SAS/ACCESS Interface to Oracle
Oracle SQL*Net Client
You can install SAS/ACCESS Interface to Oracle software on either a full Oracle RDBMS server node or on an Oracle client node.
The minimum required Oracle 8 release is Oracle, Release 220.127.116.11.x (64-bit libraries).
The minimum required Oracle 9 release is Oracle, Release 9i (64-bit libraries).
The Oracle release can vary depending on the the UNIX platform and the SAS software release. You need to verify that you meet the system requirements by selecting the appropriate operating system from SAS 9.1.3 Operating System-Specific Documentation and viewing the system requirements documentation for SAS/ACCESS Interface to Oracle.
Be sure that you have all of the appropriate environment variables set corrrectly.
Note: It is recommended that the environment variables should be set in the sasenv_local file that is located in the !SASROOT/bin directory. For releases earlier than SAS 9.1.3 Service Pack 4, the recommendation is to set environment variables in the sasenv file.
You also need to verify that your Oracle environment is configured correctly outside of SAS. To do that, test a connection using the Oracle SQL*PLUS utility on the SAS server, as follows:
unix_prompt> sqlplus user-name/password@database-name
sql> select count(*) from table-name
In this example, user-name, password, database-name, and table-name are valid Oracle values.
If you CANNOT connect to the Oracle database using SQL*PLUS, contact your Oracle database administrator for assistance.
Once you are able to connect to the Oracle database using SQL*PLUS and you have configured SAS correctly, you are now ready to access Oracle from within SAS. You can use the following LIBNAME statement engine with SAS/ACCESS Interface to Oracle to test your connection:
libname libref oracle user=user-name password=password database=database-name;
/* Use the same connection values that you used with SQL*PLUS.*/
select count(*) from libref.table_name;
Operating System and Release Information
SAS/ACCESS Interface to Oracle
64-bit Enabled AIX
64-bit Enabled HP-UX
64-bit Enabled Solaris
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be