topic Re: Problem with Windows x64 and Oracle client in SAS Programming

Problem with Windows x64 and Oracle client

Henke — Tue, 18 Aug 2015 08:16:09 GMT

Hi guys,

I have Windows 7 with a 64 bit os, SAS 9.4 and I have downloaded and installd win64_11gR2_client.

I got this error message in the log: ERROR: ORACLE connection error: ORA-12154: TNS: could not resolve the connect identifier specified.

On my x32 computer the tnsnames.ora and sqlnet.ora files is located in C:\Program Files\Common Files\Oracle\NETWORK\ADMIN but in the new installation (x64) I cant find where the files is created or where to put them.

The map structure of the new installation: C:\Program Files\Oracle\product\11.2.0\client_1

I´m pretty new at this and maybe I have missed something obvious.

Do you have any ideas?

Thanks!

Re: Problem with Windows x64 and Oracle client

Darrell_sas — Wed, 19 Aug 2015 12:41:11 GMT

I don't know anything about this, but perhaps these 2 previous posts will help.

The first is using JMP, not SAS and says that the 'bit-ness' must be the same. (I'm not sure if JMP is the same as SAS):

https://communities.sas.com/message/124221

The second one addresses the error ORA-12154:

https://communities.sas.com/message/269354

Re: Problem with Windows x64 and Oracle client

LinusH — Wed, 19 Aug 2015 13:58:27 GMT

This is perhaps not a SAS issue. Can you verify that the cleint works for other applications?

If not, refer to Oracle resources might be a better start.