Oracle TWO_TASK setting and default database logon
Posted on 2001-07-31
We are attempting to configure our application with a dedicated Oracle 8.0 database server on a separate Solaris 2.7 host.
We've set the TWO_TASK environment variable to the separate alias name configured in the tnsnames.ora file, and it works fine. All connections are diverted to the dedicated database server.
The problem is that the default username and password logon are disabled as soon as TWO_TASK is set. Hence, all the supporting shell scripts which use default logon in the form "sqlplus /", or "sqlplus -s /" now fail. Default logon has been used extensively in our application environment, so this is a major hurdle.
Any suggestions or tips that don't require major rework of the shell scripts would be most welcome.