Oracle Database Discussions

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!

EZCONNECT problem

user610465Jan 14 2009 — edited Jan 15 2009

Hello,

I am facing an strange problem. I'm trying to use easy connect. No matters how I try to take advantage from this future I get always:

[oracle@dhcppc1sqlplus rgaspardba@dbs275-v:1574/DEST_S.WORLD

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jan 14 18:57:16 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

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

Indeed there is no SERVICE_NAME provided. I have sniffed the communication using tcpdump and the service_name in my case: DEST_S.WORLD is lost.
I am running on redhat 4 using 10.2.0.4 databases.

Using the normal tnsnames is working fine.

The listener on the server side is properly defined.
Thought it should be not needed (http://www.oracle.com/technology/products/oraclenet/files/OracleNetServices_NetEasyConnect.pdf)
I have added: NAMES.DIRECTORY_PATH=(ezconnect, tnsnames) on the sqlnet.ora at the client.

Any idea?
THanks for your time,
Ruben

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 12 2009

Added on Jan 14 2009

#general-database-discussions

5 comments

844 views