Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

RE: 9i client tnsping error

QuijadaReina, Julio C

2004-02-18

Replies:
Guang,

Try using full tnsname NPD.INCYTE.COM when tnsping'ing.=20
Does that work for you?

Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College



-----Original Message-----
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)
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 =3D incyte.com

NAMES.DIRECTORY_PATH=3D (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 =3D
(DESCRIPTION =3D
  (ADDRESS_LIST =3D
   (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D rex)(PORT =3D 1521))
  )
  (CONNECT_DATA =3D
   (SERVICE_NAME =3D 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@(protected):


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=3D(ADDRESS=3D(PROTOCOL=3Dbeq)(PROGRAM=3D/oracle/product/9.2.=
0.1.0/b
in/o
racle)(ARGV0=3Doracle)(AR
GS=3D'(DESCRIPTION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Dbeq)))')(DETACH=3D=
NO))(CONN
ECT_
DATA=3D(CID=3D(PROGRAM=3D)(HOS
T=3Dcurly)(USER=3Doracle))))

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@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------