ora-12154 please help me

[mathewcos]

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

[davey23uk]

you need to configure the tnsnames.ora file on your client machine, or make sire you are using the right tnsnames.ora file.

That error means the client doesnt know what you want to connect to

[DaPi]

make sire you are using the right tnsnames.ora file.

Yes, this can happen if you've multiple oracle homes.

[DaPi]

Does your client-side sqlnet.ora have a line like:
names.default_domain=mydomain.com


If so three solutions:
1) delete that line from sqlnet.ora (I've yet to hear of a case where this is needed)
2) modify tnsnames.ora to start:
tomat.mydomain.com = ( . . . . . )
3) connect with u2/u2@tomat. (note the dot!)
(I prefer the first option).