Why do you put your connect info in single quotes? Here is my stuff.
First, sqlnet.ora: $ cat sqlnet.ora DISABLE_OOB = ON NAMES.DEFAULT_DOMAIN = xx.com #TRACE_LEVEL_CLIENT = on #trace_level_client=16 #trace_file_client=client #trace_directory_client=/tmp #trace_level_client=admin #trace_file_client=ron SQLNET.EXPIRE_TIME = 0 #NAMES.DIRECTORY_PATH= (TNSNAMES) NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, ezconnect) AUTOMATIC_IPC = OFF Next, output from tnsping: $ tnsping yy TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 11-APR-2007 12:47:05 Copyright (c) 1997, 2006, Oracle. All rights reserved. Used parameter files: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora Used LDAP adapter to resolve the alias Attempting to contact (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aaa.xxxyyy.com)( PORT=999)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=yy.xx.com)(INST ANCE_NAME=yy)(GLOBAL_NAME=yy.xx.com))) OK (0 msec) Last, my connection (using EZ Connect) to the DB via SQL*Plus: $ sqlplus uid/[EMAIL PROTECTED]:9999/yy.xx.com SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 12:45:22 2007 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production SQL> I think your problem is that you are not spcifying a service name in your connection (your tnsnames.ora file does not show this - only a sid). In my connection, I am using the GLOBAL_NAME as shown from my tnsping. When I used the "sid" type of argument (INSTANCE_NAME in my tnsping output), sqlplus gave me the TNS-12154 error. So, I think you should use the GLOBAL_NAME as defined by the init parameters db_name and domain_name. rr -----Original Message----- From: tom r [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 12:37 PM To: Reidy, Ron; dbi-users@perl.org Subject: Re: TWO_TASK environment variable hi ron, thanks for the response. using sqlnet.ora just doesn't work for me. i agree with you about hidden files -- i don't like them. that's why i'd like to find a better way. here's what happens using sqlnet.ora: ----- [~] cat sqlnet.ora NAMES.DIRECTORY_PATH=(ezconnect, tnsnames) [~] sqlplus 'fs_public/[EMAIL PROTECTED]/iwebdb' SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 12:30:48 2007 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Enter user-name: ERROR: ORA-12162: TNS:net service name is incorrectly specified Enter user-name: ERROR: ORA-12162: TNS:net service name is incorrectly specified SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus [~] cat tnsnames.ora infra=(description=(address=(protocol=tcp)(host=infradb.fs.usda.gov) (port=1521))(connect_data=(sid=iwebdb))) [~] sqlplus 'fs_public/[EMAIL PROTECTED]' SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 11 12:31:13 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-12162: TNS:net service name is incorrectly specified Enter user-name: ERROR: ORA-12162: TNS:net service name is incorrectly specified SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus ----- but if i create a .tnsnames.ora file, i can use sqlplus 'fs_public/[EMAIL PROTECTED]' and it works just fine. did i make a mistake somewhere? thanks, tom -- a celebrity is a person who works hard all his life to become well known, then wears dark glasses to avoid being recognized. --fred allen 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.
