Re: meaning of TWO_TASK setting

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