topic Re: Oracle connection error in SAS Enterprise Guide

Oracle connection error

shruthinayakvad — Fri, 29 May 2020 16:31:35 GMT

22   proc sql;
23   connect to oracle(user=shruthi password=XXXX path='SAS');
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the oracle DBMS is not currently supported, or is not installed at your site.
24   select * from connection to oracle(select * from plans_2008 unionall select * from plans_2009);
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the oracle DBMS is not currently supported, or is not installed at your site.
25   disconnect from oracle;
ERROR: Connection to the oracle DBMS does not exist.
26   quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.08 seconds
      cpu time            0.01 seconds

Why is my application unable to connect to oracle?

Re: Oracle connection error

ChrisHemedinger — Fri, 29 May 2020 16:41:09 GMT

It appears you don't have SAS/ACCESS to Oracle installed in your environment. Run proc product_status; run; to verify.

You might be able to connect using ODBC (if you have SAS/ACCESS to ODBC).

Re: Oracle connection error

shruthinayakvad — Fri, 29 May 2020 17:58:16 GMT

31 proc product_status;
32 run;

For Base SAS Software ...
Custom version information: 9.4_M2
Image version information: 9.04.01M2P072314
For SAS/STAT ...
Custom version information: 13.2
For SAS/GRAPH ...
Custom version information: 9.4_M2
For SAS/ETS ...
Custom version information: 13.2
For SAS/OR ...
Custom version information: 13.2
For SAS/IML ...
Custom version information: 13.2
For High Performance Suite ...
Custom version information: 2.2_M1
For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.4_M2
NOTE: PROCEDURE PRODUCT_STATUS used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds

I did run the statement mentioned.The above appears in log.
??

Re: Oracle connection error

ballardw — Fri, 29 May 2020 21:17:41 GMT

The connection method you attempted would have required the output to show something like

For SAS/ACCESS to Oracle

The result means that was not loaded.

You can run Proc Setinit; run; to show what is licensed. It may be that you have a license but the module wasn't installed for you. Which could be an easy partial reinstall. If Oracle (or the ODBC) doesn't appear in the license then license changes will be needed and then an updated install.

Without ODBC or the Oracle you will be stuck until one is installed.