Oracle 11g ODAC 11.1.0.6.21 on Windows 2008 Standard server gives TNS error
822763Dec 9 2010 — edited Jan 25 2011Hi,
I have Oracle 11g ODAC 11.1.0.6.21 installed on my Application server that has 32 bit Windows 2008 Standard. The Oracle database 10g is installed on another 2008 server. On database server I can connect using SQLPlus. But on application server I cannot connect using ODAC SQLPlus. I have given correct service name in tnsnames.ora file.
Error is ORA-12154 TNS: Listener cannot resolve service name
What's wrong? Is 11.1.0.6.21 not meant for Windows 2008? I did not get any errors while installing.
This 11.1.0.6.21 works perfectly for me on XP machine.
I have browsed this forum but not getting clear steps to peform.
Can someone guide me what is needed?
Thanks
Shrini