Connecting to an Oracle database from Altair SLC on Linux


If you have data stored in an Oracle database, you can connect using the Oracle Instant Client. To install the client you need to:

  1. Download the Basic Package Oracle Instant Client for Linux from the Instant Client download page of the Oracle website.
    Make sure you select the correct Linux distribution and architecture to match the Altair SLC installation.
  2. Once the zip file is downloaded, change directory to the /opt folder and extract the contents using the following command:
    unzip download-path/instantclient-basic-version.zip

    • Where download path is the absolute path to the download location, and version is the downloaded version of the Oracle Instant Client.
    • When complete, the Oracle connector archive is unzipped into the /opt folder.
  3. Create a symbolic link called oracle that links to the extracted folder using the following command: 
    ln -s instantclient-basic-version oracle
  4. Add the Oracle libraries to the shared library cache:
    • Change directory (cd) to the /etc folder.
    • View the contents of the ld.so.conf file.
      • If ld.so.conf references a separate folder through an include statement:
        Create a file called wps.conf in the referenced folder, and add the line /opt/oracle to the wps.conf file.
      • If ld.so.conf contains a list of folders:
        Add the line /opt/oracle to the file.
      • Run ldconfig.

Once the client has been downloaded, test the database connectivity with the following SAS language program:

LIBNAME DATASRC ORACLE USER=user-name PASSWORD=password PATH=remote-id;
PROC DATASETS LIBRARY=DATASRC;
RUN;