SASACCESS Oracle problem

kreg — Tue, 31 Jul 2012 16:15:48 GMT

Hi, I am having a strange problem attempting to connect to Oracle using SAS 9.1 - connecting to an Oracle 11gR2 system - SAS 9.1 includes a hotfix that enables compatibility with Oracle 10g - we have this same setup working on many systems but for some reason on this particular system it is not working:

Note the error message: ORALIB Ôö

I am wondering if this is an Oracle exception coming back that is not getting displayed properly? I can connect to the database using sqlplus so the problem is not on the database side.

Re: SASACCESS Oracle problem

kreg — Wed, 01 Aug 2012 18:04:02 GMT

Hello, posting back the solution. I contacted SAS support and was pointed to this note:

http://support.sas.com/kb/14/862.html

In my case, the problem was that the people who installed Oracle installed 64 bit database software (other parts of the application require 64 bit oracle) version 11.2.0.1 and then also added 32-bit libraries necessary for SAS (as of Oracle 11gR2 the lib32 directory is no longer shipped with the 64 bit software) but with a version of 11.1.0.7. This version discrepancy is the cause of the problem I asked about.

Just in case anyone finds this with the same problem I thought I'd post up the solution in my case.

Thanks!

topic Re: SASACCESS Oracle problem in Administration and Deployment

SASACCESS Oracle problem

Re: SASACCESS Oracle problem