ORACLE_SID in client machine

i am just a new ba..., plz forgive me this stupid question.

version 9.2.0.1
machines Solaris 2.8

database is installed in db1 machine, and oracle client is installed in ap1.

in ap1:
i set ORACLE_SID=DBNAME, and tnsnames.ora has this entry.

sqlplus /nolog
sql> connect usr1/usr1;
ERROR:
ORA-12545: Connect failed because target host or object does not exist

but it is OK
sql> connect usr1/usr1_at_DBNAME
connected

my question is "the @DBNAME is necessary or not?".
-- if the answer is no, then what i need to setup in order to make it work

   without enter "@DBNAME".

• if the answer is yes, then ORACLE_SID deosn't mean that much in here.

Thanks in advance. Received on Fri Jun 18 2004 - 14:07:45 CDT