TWO_TASK environment variable
- From: mailbin@xxxxxxxxxxx (Tom R)
- Date: Wed, 11 Apr 2007 11:06:51 -0600
reading man DBD::Oracle gives an in depth explanation on how the TWO_TASK
environment variable can be used. however, when i tried to use it in place
of .tnsnames.ora nothing worked. i believe that sql*plus does not use
TWO_TASK.
-----
[~] cat .tnsnames.ora
infra=(description=(address=(protocol=tcp)(host=infradb.fs.usda.gov)
(port=1521))(connect_data=(sid=iwebdb)))
[~] sqlplus 'fs_public/fs_public@infra'
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 10:36:04 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 -
64bit Production
With the Partitioning, OLAP and Data Mining options
[~] printenv | grep TWO
TWO_TASK=T:infradb.fs.usda.gov:iwebdb
[~] sqlplus 'fs_public/fs_public'
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 10:35:35 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
-----
in addition, it appears sql*plus doesn't even allow one to specify the
connection parameters on the command line.
-----
[~] sqlplus 'fs_public/fs_public@host=infradb.fs.usda.gov/sid=iwebdb'
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 10:35:43 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
-----
unless i'm missing something here, it seems sql*plus must use
the .tnsnames.ora file.
tom
--
turn off the computer and go outside. i hear the special 3d effects are
stunning. --anonymous
.
- Follow-Ups:
- RE: TWO_TASK environment variable
- From: Ron Reidy
- RE: TWO_TASK environment variable
- Prev by Date: Re: help with my perl script
- Next by Date: RE: :Oracle function
- Previous by thread: Re: help with my perl script
- Next by thread: RE: TWO_TASK environment variable
- Index(es):
Relevant Pages
|
|
