Re: how to use OCI program access remote oracle db?

They are not related.

you are looking for either

SQLPLUS user/password_at_NAME or

export TWO_TASK=NAME (does this still work ? it used to)

if you are on a client machine ORACLE_SID is not relevant.

Check out the Net 8 administrator's guide on tahiti.oracle.com

check out the help for SQL*PLUS

"Xie Haifeng" <xiehaifeng_at_hotmail.com> wrote in message news:b8leif$asaci$1_at_ID-179281.news.dfncis.de...
> Thank you all!
> I have installed oracle client on the 2nd machine. and have configed a
> Service Naming with netasst. Then modify the dblink parameter of
> OCIServerAttach function to the name I configed. Then everything is OK.
> But when I have installed oracle client on the 2nd machine, I have to
use
> such command to logon to remote server:
> sqlplus /nolog
> connect user/passwd @Name(which I configed).
> but
> sqlplus user/passwd
> can not logon even I set ORACLE_SID to the name I just configed. Why? Does
> there are some different between them?
> Thanks!
>
> xie.
>
>
Received on Tue Apr 29 2003 - 04:23:59 CDT