Re: meaning of TWO_TASK setting

OK, now here's a question.

Is it possible to get a bequeath adapter connection yet still specify the DB (eg. sqlplus foo/bar_at_DB)

What does the connect string look like in TNSNAMES.ORA for such a connection, if it IS possible?

On Mon, 20 Dec 1999 11:00:24 -0500, Doug Cowles <dcowles_at_nospambigfoot.com> wrote:

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

===

Yurasis Dragon
yurasis_dragonNOSPAM_at_yahoo.com
(remove NOSPAM to reply) Received on Tue Dec 21 1999 - 18:21:01 CST