DATA Step, Macro, Functions and more

Error assigning Oracle Libname

Reply
Frequent Contributor
Posts: 83

Error assigning Oracle Libname

Hi

i`m getting the following error while assigning oracle tables in unix

2? libname REP Oracle SCHEMA=CREP path=CUP_PRODEXT user=SAS1READ password='sasad#123';

ERROR: Could not load /apps/sas/SASFoundation/9.2/sasexe/sasora (32 images
loaded)
ERROR: ld.so.1: sas: fatal: libclntsh.so.10.1: open failed: No such file or
directory
ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: Image
SASORA found but not loadable.
ERROR: Error in the LIBNAME statement.


Could somebody help me out
Super Contributor
Posts: 394

Re: Error assigning Oracle Libname

This looks like the kind of problem that's best handled by Technical Support.
Super User
Posts: 3,261

Re: Error assigning Oracle Libname

I came up with a list of 16 SAS notes when I searched SAS Support for your error. I suggest you check these out yourself as they are operating system and SAS version specific. One possibility since you are on Unix is that file permissions may not be set correctly for SAS and/or Oracle files.
Super User
Posts: 10,046

Re: Error assigning Oracle Libname

Do you have license for sas/access to oracle.
If you have setup it correctly.then need to setup Oracle in your sas computer and config it.


Ksharp
Ask a Question
Discussion stats
  • 3 replies
  • 750 views
  • 0 likes
  • 4 in conversation