From guy.hammond@avt.co.uk Tue, 21 Aug 2001 03:19:17 -0700 From: "Guy Hammond" Date: Tue, 21 Aug 2001 03:19:17 -0700 Subject: RE: Significance of TWO_TASK Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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@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@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).