ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

ethanasiJul 10 2009 — edited Aug 10 2010

Hi,
I have installed Ora9iR2 server and ODAC 11.1.0.6.20 with Oracle Developer Tools for Visual Studio at the same machine(Win2003 Server).
Now, when I am trying to connect to Oracle database in my aspx app, I get the following error:

Exception Details: Oracle.DataAccess.Client.OracleException: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I have searched the forum for similar cases, and checked the following:
1. Copied everything from /network/admin of 9i installation to /network/admin of 11g installation.
2. Deleted /oracle/ora92 from path
3. Edited and then commented NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT ) in sqlnet.ora

Still I get the same error.

Any help is highly appreciated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2010

Added on Jul 10 2009

#odp-net

8 comments

5,856 views