Re: SQL*PLUS connect string problem...

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Mon, 14 Sep 1998 09:26:38 -0600
Message-ID: <35fd3511.0@news.cadvision.com>

If you are on server B, all you need is to set the ORACLE_SID. Then you can run sqlplus locally on that machine without having to enter the tnsnames alias.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

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 Mon Sep 14 1998 - 10:26:38 CDT