TNS connectivity problem

[bang_dba]

Hi,
I have problems connecting to the Oracle8i (8.1.0) server from oracle 8 (8.0.2) client.

I am getting the error ORA-12154 TNS could not resolve service name.


My tnsnames.ora on client is as following
--------------------------------

DEV1.SSS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = SERVER-SSS)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = DEV1 )
(GLOBAL_NAME = DEV1.SSS.COM)
)
)


My listener.ora looks like this
--------------------------------

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST=SERVER-SSS)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DEV1.SSS.COM)
(ORACLE_HOME = C:\oraHome8i)
(SID_NAME = dev1)
)
)


Is there anything else that i have to take care of when i am accessing 8i from 8 client.

TNSPING80 Resolves; but the connection from sqlplus throws the error ORA-12154

[DaPi]

What "Host String" are you using for sqlplus?

Do you have NAMES.DEFAULT_DOMAIN set in sqlnet.ora on the client? That will be appended to the "Host String" if it does not contain a '.'

[bang_dba]

Hi dapi,
I have commented the NAMES.DEFAULT_DOMAIN

and i am using the whole connect string.

sql>connect abc/abc@DEV1.SSS.COM

[stecal]

Funny you should ask that.

http://www.dbasupport.com/oracle/ora9i/connecting.shtml