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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
