Re: TWO_TASK

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Apr 2003 06:41:14 -0700
Message-ID: <2687bb95.0304100541.39b95cc6@posting.google.com>

"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message news:<lx8la.93$fU4.4946_at_nnrp1.ozemail.com.au>...
> Version 8.1.7. Server installation.
>
> I can't connect as sqlplus system/password but I can connect as
> system/password_at_NET8_SERVICENAME.
> Setting TWO_TASK=NET8_SERVICENAME removes the problem but I don't know why I
> need TWO_TASK in a server installation.
> Anybody help?
>
> Ray

Did you set and export ORACLE_SID as part of the current shell. If you place the Oracle parameters in a shell script you must execute that script as part of the current shell and not an independent shell:

# korn and Bourne example, the dot command executes a command within the
# current shell instead of the default shell of its own . setoracleenviron

setoracleenviron will normally contain something like (Korn) export ORACLE_HOME=/oracle/ora817
export ORACLE_SID=FINL
export TWO_TASK=PROD

In order to use svrmgrl or sqlplus /nolog we then execute the setoracleenviron script followed by an "unset TWO_TASK". We can then get a direct dedicated local connection.

HTH -- Mark D Powell -- Received on Thu Apr 10 2003 - 08:41:14 CDT