ORA-12154: TNS:could not resolve service name

[chrislee8]

SQL> connect Scott/tiger@oscar
ERROR:
ORA-12154: TNS:could not resolve service name

oscar is the database name
Scott/tiger is the default login

can anyone tell me what the error message mean?

thanks

[ocpwannabe]

sondz like your tnsnames.ora is not setup correctly. shud look something like:
XXX_TCP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = III)
(PORT = 1521)
)
)
(CONNECT_DATA = (SID = XXX) )
)