topic Re: SAS Access to Oracle using wallets in Administration and Deployment

SAS Access to Oracle using wallets

MariaD — Thu, 20 Feb 2020 13:52:43 GMT

Hi Folks,

We are setting our first Oracle connection using wallets. We have SAS 9.4 M6 installed on Linux and we have Oracle 12c client installed too.

We copy the wallet folder (includes sqlnet.ora, tnsname.ora, etc files inside) on a new directory. This folder has 400 permission for "sas" user. We also add on out TNS_ADMIN environment variable, inside sasenv_local file the wallet directory and restarted the SAS services.

But when we tried to connect the following error appears:

LIBNAME TEST ORACLE PATH=path_defined_wallet_tns USER=user PASSWORD=XXXXXXXXXXXXXXXXX;

ERROR: ORACLE connection error: ORA-28759: failure to open file.
ERROR: Error in the LIBNAME statement.

Any suggestions?

Regards,

Re: SAS Access to Oracle using wallets

SASKiwi — Thu, 20 Feb 2020 19:17:24 GMT

Remotely logon to your SAS server and try to open tnsnames.ora manually using the same userid you are testing your Oracle connection with. If it fails it is a simple OS file permission issue.

Re: SAS Access to Oracle using wallets

MariaD — Thu, 20 Feb 2020 19:43:44 GMT

Hi @SASKiwi ,

Thanks! I logon on our SAS server and I open the tnsnames.ora without any problem. The error is the same:

ERROR: ORACLE connection error: ORA-28759: failure to open file.

I checked and the tnsnames.ora permissions, on wallet folder, are the same of the tnsnames.ora used for regular Oracle connections.

Any other idea?

Re: SAS Access to Oracle using wallets

SASKiwi — Thu, 20 Feb 2020 19:51:22 GMT

I googled the Oracle error and came up with links like this: https://community.oracle.com/thread/2317808?start=0&tstart=0

I suggest you also google this and work through the suggestions to see if they help. This is an Oracle only problem.

Re: SAS Access to Oracle using wallets

MariaD — Thu, 20 Feb 2020 19:58:43 GMT

Thanks @SASKiwi . So, in SAS Server the only actions are:

- copy wallet folder;

- include wallet folder in TNS_ADMIN environment variable

And the connect the same way as regular Oracle connections. That's correct?

Re: SAS Access to Oracle using wallets

SASKiwi — Thu, 20 Feb 2020 20:24:22 GMT

@MariaD - Sounds reasonable. Your Oracle Administrator should be able to advise you on this.

Re: SAS Access to Oracle using wallets

jwatson — Mon, 24 Feb 2020 21:43:42 GMT

At our site (Windows, not Linux), we don't use USER= or PASSWORD=:

LIBNAME TEST ORACLE PATH=path_defined_wallet_tns /*schema=user*/;

This might help with the Error in LIBNAME statement.

We ran into an issue when updating the file because the permissions changed. We had to ensure that "Authenticated Users" were allowed "Read" and "Read/Execute" to the file.

Re: SAS Access to Oracle using wallets

MariaD — Wed, 26 Feb 2020 14:51:46 GMT

Hi @jwatson ,

I try commented user and password options but the same error occurs. I copied the wallet folder to our SAS server. The wallet folder is set with 500 permission for "sas" user. The sqlnet.ora file, inside wallet folder, has the correct directory for the wallet. I also included the wallet path to TNS_ADMIN environment variable, inside sasenv_local file and I restarted the sas services too.

Do you know if I missing something?

Regards,

Re: SAS Access to Oracle using wallets

MariaD — Wed, 26 Feb 2020 15:43:37 GMT

@jwatson and @SASKiwi , thanks! I found the cause of the error. I added the wallet location on sqlnet.ora file on Oracle installation folder and now I can connect.

Thanks!