RE: Significance of TWO_TASK

Thanks a lot Guy for the explanation

-----Original Message-----
Sent: Tuesday, August 21, 2001 6:11 AM
To: Multiple recipients of list ORACLE-L

TWO_TASK is like ORACLE_SID, but it directs Oracle clients to resolve via TNS rather than looking for that SID directly via BEQ.

So, if my SID is TEST on the local machine, and I do:

$ export ORACLE_SID=TEST
$ sqlplus system/manager

I will connect to the instance with a SID of TEST on the local machine. But if Oracle is running on a remote machine, and I set up TNS name "TEST" (in tnsnames.ora) for it, then try those commands, it will fail, even tho'

$ sqlplus system/manager_at_TEST

will succeed. However, if I then do

$ export TWO_TASK=TEST
$ sqlplus system/manager

It will work as expected - the client will take the TNS name "TEST" to be its default instance, and connect via TNS.

HTH, g

-----Original Message-----
Sent: Tuesday, August 21, 2001 9:50 AM
To: Multiple recipients of list ORACLE-L

Hello All,

Can anyone tell me what is the significance of the env variable TWO_TASK?
when and where it is used etc ?

Thanks in advance
Uma

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Guy Hammond
  INET: guy.hammond_at_avt.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rao, UmaSankara S (CAP)
  INET: UmaSankara.Rao_at_Gecis.GE.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).