topic Re: SAS/Access error and ORacle in Administration and Deployment

SAS/Access error and ORacle

BrianSims — Wed, 15 Jun 2022 18:51:34 GMT

I just upgraded from SASm5 to SAS m7 and now users are getting this erorr when connecting to the oracle database

Does anyone have any trouble shooting steps?

Re: SAS/Access error and ORacle

gwootton — Wed, 15 Jun 2022 19:01:34 GMT

Was this an upgrade in place? It sounds like it's not finding the oracle client libraries. Are the Oracle variables in sasenv_local in your SASHome?

Setting UNIX Environment Variables for SAS/ACCESS
https://go.documentation.sas.com/doc/th/bicdc/9.4/bidsag/p1w3v98qca3sfzn1rzty2tngrfyq.htm

Re: SAS/Access error and ORacle

BrianSims — Wed, 15 Jun 2022 19:05:01 GMT

it was an upgrade in place. I'm not sure where the oracle variables are stored. Thank you for the documentation

Re: SAS/Access error and ORacle

gwootton — Wed, 15 Jun 2022 19:48:23 GMT

The sasenv_local file is found in <SASHome>/SASFoundation/9.4/bin, typically this is where variables would be defined to indicate where the Oracle client is installed as described in the documentation I had linked before. This file, like the _usermods files elsewhere, are not overwritten during things like updates. If these variables were not defined in one of those files it's possible the upgrade overwrote them.

More information on connecting to Oracle can be found here:

Establishing Connectivity to an Oracle Database
https://go.documentation.sas.com/doc/en/bicdc/9.4/bidsag/n017taop8cx07in1r3awuwxlyb9m.htm

Re: SAS/Access error and ORacle

jklaverstijn — Mon, 27 Jun 2022 13:11:59 GMT

In order to be of any help we would at least have to know details about your operating environment. Especially for getting dbms's to work there's a big difference between eg. Windows and Linux. But I would start ticking off the possible causes one by one mentioned in your log. And always check Oracle access by using its own client software like sql*plus.

Regards,

- Jan.