RE: TWO_TASK environment variable
- From: Ron.Reidy@xxxxxxxxxxxxxxxxxx (Ron Reidy)
- Date: Wed, 11 Apr 2007 11:52:36 -0600
Well, this is not a Perl/DBI question, really. I personnaly do not use
TWO_TASK as it is an archaic environment variable that has been around
since version 4 of the DB.
If you are interested in using the Easy Connect method, you should read
the Oracle docs:
http://download-east.oracle.com/docs/cd/B19306_01/network.102/b14212/nam
ing.htm#i498306
Pay close attention to the section on setting up NAMES.DIRECTORY_PATH in
your sqlnet.ora file. When set up properly, it works for me, using
version 10.2.0.2 and 10.2.0.3.
<my $0.02>
Also, I would strongly advise against using .*.ora file (hidden files).
In my opinion, this is a really bad habit to get into and could lead to
a lot of confusion and frustration trying to debug SQL*Net issues.
</my $0.02>
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: tom r [mailto:mailbin@xxxxxxxxxxx]
Sent: Wednesday, April 11, 2007 11:07 AM
To: dbi-users@xxxxxxxx
Subject: TWO_TASK environment variable
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
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
.
- Follow-Ups:
- Re: TWO_TASK environment variable
- From: Tom R
- Re: TWO_TASK environment variable
- References:
- TWO_TASK environment variable
- From: Tom R
- TWO_TASK environment variable
- Prev by Date: RE: :Oracle function
- Next by Date: Re: TWO_TASK environment variable
- Previous by thread: TWO_TASK environment variable
- Next by thread: Re: TWO_TASK environment variable
- Index(es):
Relevant Pages
|
