topic Unable to connect to oracle 11g xe database from SAS in New SAS User

Unable to connect to oracle 11g xe database from SAS

mbakare — Sun, 02 Dec 2018 13:19:52 GMT

Hello everyone,

Please I need your help to connect to oracle database from SAS 9.4. I had successfully installed oracle database 11g XE edition and SAS 9.4 version on a system running on windows 10 Enterprise. I was able to create database through sql-plus or oracle sql developer. I have all required SAS components such as SAS\ACCESS to ORACLE and SAS\ACCESS to ODBC installed.

I had error while trying to connect to database from SAS using

libname myora oracle user='Bakare' password='Agbaman' path='XE';

the error message I got is below:

2 libname myora oracle user='Moshood' passoword='Agbaman' path='XE' ;

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.

Thanks

Re: Unable to connect to oracle 11g xe database from SAS

LinusH — Sun, 02 Dec 2018 14:48:04 GMT

Have you fulfilled the post install configuration, including SQL*NET client and editing the tnsnames.ora file?

I think the error message implies that there is a problem with the installation/configuration (or even license?).

Re: Unable to connect to oracle 11g xe database from SAS

mbakare — Sun, 02 Dec 2018 17:09:13 GMT

I was able to create and connect to database through command line sql-plus and oracle sql developer.Does it mean SQL * NET is still required? How do I edit tnsnames.ora? What do I need to edit?

Re: Unable to connect to oracle 11g xe database from SAS

Tom — Sun, 02 Dec 2018 17:55:28 GMT

@mbakare wrote:
I was able to create and connect to database through command line sql-plus and oracle sql developer.Does it mean SQL * NET is still required? How do I edit tnsnames.ora? What do I need to edit?

Sounds like you have Oracle tools installed properly to use. Make sure that they are actually installed properly for SAS/Access to Oracle to work.

Also make sure that SAS is running on the same machine that you are running those other program from. With interfaces such as SAS Enterprise Guide and SAS/Studio the server that is actually running SAS might not be your local machine.

Re: Unable to connect to oracle 11g xe database from SAS

mbakare — Mon, 03 Dec 2018 04:39:12 GMT

Thanks for the quick response. I run both SAS 9.4 and Oracle database 11g xe edition on a single window 10 64-bit enterprise edition. Do I need to install oracle client for me to connect to Oracle database 11g xe from SAS? My oracle runs perfectly both in sqlplus and oracle sql developer likewise the SAS. The big challenge is to connect database from SAS

Please let me know if oracle database 11g xe edition requires oracle client for me to connect it from SAS.

Thanks