topic Re: Error assigning Oracle Libname in SAS Programming

Error assigning Oracle Libname

tommy81 — Fri, 01 Apr 2011 09:16:39 GMT

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

Re: Error assigning Oracle Libname

Tim_SAS — Fri, 01 Apr 2011 12:33:09 GMT

This looks like the kind of problem that's best handled by Technical Support.

Re: Error assigning Oracle Libname

SASKiwi — Tue, 05 Apr 2011 01:34:39 GMT

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.

Re: Error assigning Oracle Libname

Ksharp — Wed, 06 Apr 2011 09:59:32 GMT

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