08-18-2015 04:16 AM
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?
08-19-2015 08:41 AM
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):
The second one addresses the error ORA-12154:
08-19-2015 09:58 AM
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.