Friends,

I am getting ora-12154 error when connecting from client mechine(Windows 2000 professional) to DB server(Windows XP mechine).

I am trying to connect like this from client machine

C:> sqlplus u2/u2@tomat

Then error is comming

======================
I can able to connect from Server like this
C:> sqlplus u2/u2@tomat
=========================

My listener configuration

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = d-166)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = MAT)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = mat)
)
)


My Service name conf in tnsnames.ora in client side

TOMAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-166)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MAT)
)
)

What will be the problem? Plz help me

regards
Mathew