Re: ORACLE_SID in client machine

scw_00_at_yahoo.com (jr) wrote:

>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.

Try:

Set LOCAL=DBNAME
sqlplus /nolog
sql> connect usr1/usr1;

Should work... Received on Fri Jun 18 2004 - 15:13:30 CDT