Wednesday, June 15, 2011

TWO_TASK In oracle

   1. Find Values from system you are connecting to...
             echo $ORACLE_SID,  echo $FNDNAM,   echo $GWYUID
             from the system you will be joining to.
         2. Set Environment Variables
             TWO_TASK=[net_alias]; export TWO_TASK
             FNDNAM=value from $FNDNAM; export FNDNAM
             GWYUID=value from $GWYUID; export GWYUID
Using two task we can connect remote database with using connection string (@xxx).
which value we will set for two task default database will try to connect same database,
no matter weather that instance is in same node or different node .


No comments:

Post a Comment