Guang, It might just be the difference between the lowercase `incyte.com` on your sqlnet.ora and the uppercase `INCYTE.COM` on your tnsnames.ora. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of QuijadaReina, Julio C Sent: Wednesday, February 18, 2004 3:36 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: 9i client tnsping error Guang, Try using full tnsname NPD.INCYTE.COM when tnsping'ing.=3D20 Does that work for you? Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Guang Mei Sent: Wednesday, February 18, 2004 2:18 PM To: Oracle-L-freelists Subject: 9i client tnsping error Hi: I have just installed oracle client 9.2.0.1.0 on one unix box (called curly), and I am trying to connect to an oracle 8173 server (on another unix box, called rex). During the installastion, the net service part had test successful and it installed sqlnet.ora and tnsnames.ora automatically. The files are those: curly$ cat sqlnet.ora # SQLNET.ORA Network Configuration File: /oracle/product/9.2.0.1.0/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DEFAULT_DOMAIN =3D3D incyte.com NAMES.DIRECTORY_PATH=3D3D (TNSNAMES, ONAMES, HOSTNAME) curly$ cat tnsnames.ora # TNSNAMES.ORA Network Configuration File: /oracle/product/9.2.0.1.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools. NPD.INCYTE.COM =3D3D (DESCRIPTION =3D3D (ADDRESS_LIST =3D3D (ADDRESS =3D3D (PROTOCOL =3D3D TCP)(HOST =3D3D rex)(PORT =3D3D = 1521)) ) (CONNECT_DATA =3D3D (SERVICE_NAME =3D3D NPD) ) ) ping is working ok, but tnsping is not working: curly$ tnsping NPD TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 18-FEB-2004 14:09:02 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: /oracle/product/9.2.0.1.0/network/admin/sqlnet.ora TNS-03505: Failed to resolve name -- If I do sqlplus user/password@NPD, I will get: SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 18 14:11:18 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12154: TNS:could not resolve service name -- looking at sqlnet.log: curly$ more sqlnet.log *********************************************************************** Fatal NI connect error 12545, connecting to: (DESCRIPTION=3D3D(ADDRESS=3D3D(PROTOCOL=3D3Dbeq)(PROGRAM=3D3D/oracle/prod= uct/9.2 .=3D 0.1.0/b in/o racle)(ARGV0=3D3Doracle)(AR GS=3D3D'(DESCRIPTION=3D3D(LOCAL=3D3DYES)(ADDRESS=3D3D(PROTOCOL=3D3Dbeq)))= ')(DETACH =3D3D=3D NO))(CONN ECT_ DATA=3D3D(CID=3D3D(PROGRAM=3D3D)(HOS T=3D3Dcurly)(USER=3D3Doracle)))) VERSION INFORMATION: TNS for Solaris: Version 9.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for Solaris: Version 9.2.0.1.0 - Production Time: 18-FEB-2004 14:11:19 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12545 TNS-12545: Connect failed because target host or object does not exist ns secondary err code: 12560 nt main err code: 515 TNS-00515: Connect failed because target host or object does not exist nt secondary err code: 2 nt OS err code: 0 I have done client installation before and never had this kind of situation. ANy idea what could be the problem? TIA. Guang ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------