Re: meaning of TWO_TASK setting

To maybe oversimplify -
I can do a sqlplus foo/bar and get to a database if my ORACLE_SID is set, but
that gives me a bequeath adapter connection - if my TWO_TASK is set, then I will
use SQLNET? What if both are set?

Vincent Ventrone wrote:

> Doug Cowles wrote:
> >
> > Can someone explain TWO_TASK?
>
> It basically sets the default TNS service name (database alias) for the
> session. If we are talking about a UNIX telnet session, for ex., then
> when I type "sqlplus <foo>/<bar>" I will connect to the database
> specified by the service name that TWO_TASK is bound to -- as if I had
> typed "sqlplus <foo>/<bar>@<two_task setting>".
>
> > On an account I was at, someone was copying $ORACLE_HOME over to
> > different
> > machine to start up a database, and connection to oracle via internal
> > was impossible
> > without TWO_TASK set.
>
> Hmmmm...sounds to me as if this session did not have correct environment
> variables set. If you have no setting for TWO_TASK and do not specify a
> TNS service name then the Oracle tool will connect you to a local
> database (again, assuming UNIX) whose sid equals the setting of
> environment var. ORACLE_SID (you will get a BEQUEATH adapter connection,
> which uses no TNS listener.)
>
> > Then they re-linked oracle, and didn't need it.
> > Can anyone explain this phenomenon?
>
> I suspect they set the environment correctly during the relink operation
> & that's why they no longer needed to use SQLNet for a local connection.
>
> --
> Vincent Ventrone | The MITRE Corp.
> DBA, Dept. R101 | M/S C020
> vav_at_mitre.org | 202 Burlington Rd.
> (781) 271-7048 | Bedford, MA 01730

Received on Mon Dec 20 1999 - 10:00:24 CST