Problem Note 60895: Under Linux, an Oracle connection using the Oracle 12CR2 client fails with "..ERROR: Image SASORA found but not loadable
 |  |  |  |  |
Under Linux, an Oracle connection with SAS/ACCESS® Interface to Oracle might fail when using the Oracle Database 12C Release 2 Client (12.2.0.1.0) and SAS® 9.4 TS1M4. In this scenario, you encounter an error similar to the following:
ERROR: Could not load /sasapp/SASFoundation/9.4/sasexe/sasora (37 images loaded)
ERROR: /sasapp/SASFoundation/9.4/sasexe/sasora: undefined symbol: irc__print
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.
ERROR: /sasapp/SASFoundation/9.4/sasexe/sasora: undefined symbol: irc__print
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.
To circumvent this error, complete the following steps:
- On the UNIX machine where SAS is running, go to !SASHome/SASFoundation/9.4/sasexe.
- Rename the sasora file (if sasora exists) to sasora.bak using the command below:
mv sasora sasora.bak - Link sasora to orlax11 with the command below:
ln -s orlax11 sasora - Create a symbolic link, libclntsh.so.11.1, to the Oracle client libclntsh.so.12.1 file using the following command:
cd ${ORACLE_HOME}/lib ln -s libclntsh.so.12.1 libclntsh.so.11.1 - Retry the Oracle connection from SAS.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | Linux for x64 | 9.41 | 9.41 | 9.4 TS1M4 | 9.4 TS1M5 |
A fix for this issue for SAS/ACCESS Interface to Oracle 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B4F.html#60895
Under Linux, an Oracle connection using the Oracle Database 12c Release 2 Client (12.2.0.1.0)fails with "..ERROR: Image SASORA found but not loadable.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-11-21 12:08:50 |
| Date Created: | 2017-08-09 11:00:17 |