Use the "TWO_TASK" environment variable (while logged into sever B). This
overrides the ORACLE_SID & it should correspond to your target database
alias as named in tnsnames.ora file.
Once your TWO_TASK variable is set,
sqlplus username/password
will try to connect to the database specified by the TWO_TASK envronment
variable.
Jimmy wrote in message <35FD0BC9.30B3_at_comp.polyu.edu.hk>...
>Hello all,
>
> Oracle server (7.3) is in UNIX server A. I want to use SQL*Plus in
>another UNIX server B to connect to Oracle server (in UNIX server A). SO
>I type "sqlplus username/passwd_at_A". (using SQL*NET V2.0)
> However, I want in server B, just typing "sqlplus username/passwd". Is
>it possible? And any env. variable in UNIX that need to be set? Both
>UNIX server is Solaris 2.5.(like LOCAL in PC client)
>
>Thanks,
>Jimmy
Received on Tue Sep 15 1998 - 08:42:40 CDT
