Intermittent Connections Failure with TNS-12545 & HPUX-227

(Doc ID 272782.1)

Last updated on JULY 29, 2015

Applies to:

Oracle Net Services - Version 8.1.5.0.0 to 10.2.0.3.0 [Release 8.1.5 to 10.2]
HP-UX PA-RISC (32-bit)
HP-UX PA-RISC (64-bit)
HP-UX PA-RISC (32-bit)HP-UX PA-RISC (64-bit)
All Oracle Net connections to database fail or start to fail intermittantly.

Symptoms

TNS-12545, "Connect failed because target host or object does not exist" reported when connecting to database.

Oracle Net level 16 client trace shows following error stack :

[15-MAY-2004 02:51:16:112] nserror: nsres: id=0, op=65, ns=12545, ns2=12560; 
nt[0]=515, nt[1]=227, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[15-MAY-2004 02:51:16:112] nsopen: unable to open transport
[15-MAY-2004 02:51:16:114] nioqper:    ns main err code: 12545
[15-MAY-2004 02:51:16:114] nioqper:    ns (2)  err code: 12560
[15-MAY-2004 02:51:16:114] nioqper:    nt main err code: 515
[15-MAY-2004 02:51:16:114] nioqper:    nt (2)  err code: 227
[15-MAY-2004 02:51:16:115] nioqper:    nt OS   err code: 0
[15-MAY-2004 02:51:16:115] niomapnserror: entry
[15-MAY-2004 02:51:16:115] niqme: entry
[15-MAY-2004 02:51:16:115] niqme: reporting NS-12545 error as ORA-12545
[15-MAY-2004 02:51:16:115] niqme: exit
[15-MAY-2004 02:51:16:115] niomapnserror: returning error 12545
[15-MAY-2004 02:51:16:115] niomapnserror: exit
[15-MAY-2004 02:51:16:115] niotns: Couldn't connect, returning 12545

Lowest error code in stack is nt[1]=227

NT = Network transport
Errno.h file shows 227 is # define EADDRNOTAVAIL 227 /* Can't assign requested address */

Changes

Lack of resources on server machine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms