Re: TWO_TASK env var

Larry <104105.3062_at_CompuServe.COM> reports:

>We just migrated to an HP/UX 9000, had to invoke an environmental
>variable called TWO_TASK so that sql*net would be properly used
>by a C program that calls sql*plus. Without this env var the
>process hangs in sqlplus and does not accomplish anything. With
>it properly invoked our background process successfully enters
>and exits sqlplus.

Your problem was probably due to the fact that the environment variable ORACLE_SID was not set or contained an invalid value.

$ unset ORACLE_SID
$ sqlplus

SQL*Plus: Release 3.1.3.5.1 - Production on Fri May 31 14:56:50 1996

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Enter user-name: system
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07300: smscre: translation error while expanding ?/dbs/sgadef_at_.dbf. Additional information: 7200

If you use the TWO_TASK variable then ORACLE_SID is not needed.

$ TWO_TASK=prod; export TWO_TASK
$ sqlplus

SQL*Plus: Release 3.1.3.5.1 - Production on Fri May 31 15:12:55 1996

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Enter user-name: system
Enter password:

Connected to:
Oracle7 Server Release 7.1.4.1.10 - Production Release With the distributed and parallel query options PL/SQL Release 2.1.4.0.0 - Production

Use the "oraenv" shell script to initialize your Oracle environment properly.

From sh, ksh, bash, or posix-sh:
  $ . /usr/local/bin/oraenv

From csh:
  $ source /usr/local/bin/coraenv

--
Bob Poortinga (mailto:bobp_at_tsc.com)