Hello,

I have some oracle database server with tsnames.ora like following:

DBNAMESERVER =

  (DESCRIPTION =

  (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP) (HOST=DBNAMESERVER.host.com) (PORT = 1521))

  )

  (CONNECT_DATA =

  (SERVICE_NAME=dbnameserver.host.com)

  )

  )

On some client machines i get below error when i try use sqlplus to log on datbase like (sqlplus username/passwd@DBNAMESERVER) but on other client machines(in the same configuration) it's work perfectly;)

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

Thanks for any suggestions.

Best regards,

M