Hi,
We are having serious issues for our Prod Db 9.2.0.8.0 patch set 13 hosted on windows 2003 sp2 .
Total Memory-15 GB SGA-8GB
Batches to this server are failing with error ORA-12547: TNS:lost contact.
This started to happen alot after i applied april security patch 2008 on out Prod-stdby DB.
raised a SR with Oracle too they asked for sqlnet traces after analyzing that they first blammed the network(which it is not as I hace confirmed that network is working absolutely fine)and than limitaions of 32 bit architecture unable to handle that huge SGA(8 Gb in our case).
I can the same error for sqlplus making a connection from the Prod server too(local connections also fails with this error.
As a workaround I rolled back the patch ,with this now our listner has become unstable it keeps on shutting down with error The OracleOraHome92TNSListener
service terminated unexpectedly. It has done this 1 time(s) and Faulting application TNSLSNR.EXE, version 0.0.0.0, faulting module oranl9.dll, version 9.2.0.8, fault address 0x0001cc90. in the EVENETVWR OF WINDOWS.
There is no firewall betweeb the client and server and also we are having issues on connections made from DB server itself(local connections).
During opatch apply and rollback there were no errors.
PLEASE HELP.
LOGs attached:listner.ora,sqlne
t.ora,list
ner.log,sq
lnet.log(s
erver),ale
rt.log,cli
ent trace(IT HAS 12547 ERROR IN IT) and others.
logs abstract
**************************
**********
**********
**********
**********
**********
**********
**********
*******
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Jun 10 11:10:00 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
LISTNER LOG:
TNS-12502: TNS:listener received no CONNECT_DATA from client
13-JUN-2008 01:34:48 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
13-JUN-2008 01:34:49 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
13-JUN-2008 01:34:49 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
Client TRACE(FULL LOG ATTACHED):
4952) [000001 04-JUN-2008 08:41:39:378] nsbal: normal exit
(4952) [000001 04-JUN-2008 08:41:39:378] nsprecv: reading from transport...
(4952) [000001 04-JUN-2008 08:41:39:378] nttrd: entry
(4952) [000001 04-JUN-2008 08:41:39:487] ntt2err: entry
(4952) [000001 04-JUN-2008 08:41:39:487] ntt2err: soc 33888 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
(4952) [000001 04-JUN-2008 08:41:39:487] ntt2err: exit
(4952) [000001 04-JUN-2008 08:41:39:487] nttrd: exit
(4952) [000001 04-JUN-2008 08:41:39:487] nsprecv: transport read error
(4952) [000001 04-JUN-2008 08:41:39:487] nsprecv: error exit
(4952) [000001 04-JUN-2008 08:41:39:487] nserror: entry
(4952) [000001 04-JUN-2008 08:41:39:487] nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:487] nscon: error exit
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:487] nsdo: nsctxrnk=0
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:487] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:487] nsdo: error exit
(4952) [000001 04-JUN-2008 08:41:39:487] nscall: unexpected response
(4952) [000001 04-JUN-2008 08:41:39:487] nsclose: entry
(4952) [000001 04-JUN-2008 08:41:39:487] nstimarmed: entry
(4952) [000001 04-JUN-2008 08:41:39:487] nstimarmed: no timer allocated
(4952) [000001 04-JUN-2008 08:41:39:487] nstimarmed: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsdo: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x440, cflgs=0x2
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsdo: rank=64, nsctxrnk=0
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsdo: nsctx: state=1, flg=0x4201, mvd=0
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbaddfl: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbaddfl: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbaddfl: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbaddfl: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsdo: nsctxrnk=0
(4952) [000001 04-JUN-2008 08:41:39:503] nsdo: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsclose: closing transport
(4952) [000001 04-JUN-2008 08:41:39:503] nttdisc: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nttdisc: Closed socket 33888
(4952) [000001 04-JUN-2008 08:41:39:503] nttdisc: exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbittrm_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbittrm_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsclose: global context check-out (from slot 0) complete
(4952) [000001 04-JUN-2008 08:41:39:503] nsnadisc: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nadisc: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nacomtm: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nacompd: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nacompd: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nacompd: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nacompd: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nacomtm: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nas_dis: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nas_dis: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nau_dis: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nau_fad: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nau_dis: exit
(4952) [000001 04-JUN-2008 08:41:39:503] naeetrm: entry
(4952) [000001 04-JUN-2008 08:41:39:503] naeetrm: exit
(4952) [000001 04-JUN-2008 08:41:39:503] naectrm: entry
(4952) [000001 04-JUN-2008 08:41:39:503] naectrm: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nagbltrm: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nau_gtm: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nau_gtm: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nagbltrm: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nadisc: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsnadisc: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbittrm_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbittrm_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: acquired the bit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitts_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbaddfl: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbaddfl: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsbfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: 2348 bytes at 0x3fe5520
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: entry
(4952) [000001 04-JUN-2008 08:41:39:503] snsbitcl_ts: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: 492 bytes at 0x3fb6a40
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsclose: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nscall: connecting...
(4952) [000001 04-JUN-2008 08:41:39:503] nsclose: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsclose: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nladget: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nladget: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: 203 bytes at 0x377b2f0
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: 164 bytes at 0x37448c8
(4952) [000001 04-JUN-2008 08:41:39:503] nsmfr: normal exit
(4952) [000001 04-JUN-2008 08:41:39:503] nladtrm: entry
(4952) [000001 04-JUN-2008 08:41:39:503] nladtrm: exit
(4952) [000001 04-JUN-2008 08:41:39:503] nscall: error exit
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: error from nscall
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: nr err code: 0
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: ns main err code: 12547
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: ns (2) err code: 12560
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: nt main err code: 517
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: nt (2) err code: 54
(4952) [000001 04-JUN-2008 08:41:39:503] nioqper: nt OS err code: 0
(4952) [000001 04-JUN-2008 08:41:39:503] niomapnserror: entry
(4952) [000001 04-JUN-2008 08:41:39:503] niqme: entry
(4952) [000001 04-JUN-2008 08:41:39:503] niqme: reporting NS-12547 error as ORA-12547
(4952) [000001 04-JUN-2008 08:41:39:503] niqme: exit
(4952) [000001 04-JUN-2008 08:41:39:503] niomapnserror: returning error 12547
(4952) [000001 04-JUN-2008 08:41:39:503] niomapnserror: exit
(4952) [000001 04-JUN-2008 08:41:39:503] niotns: Couldn't connect, returning 12547
**************************
**********
**********
**********
**********
**********
**********
**********
*********
LET ME KNOW IF YOU NEED ANYTHING ELSE?
Start Free Trial