Re: ORA-12547 : TNS lost contact
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: sfaroult@xxxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, Sunil Bhola <oraclebhola@xxxxxxxxx>
- Date: Wed, 9 Nov 2005 18:25:59 +0530
thanx for the response stephane. i had enabled the logging too but the trace
file doesnt seem to contain any error however i am pasting the contents of
the file for the sake of ref. I might be missing somewhere:
trace file contents:
****************************************************************************
nscon: sending NSPTRF packet
ntnwr: failed to write 115 bytes
ntn2err: error: handle=428, op=6, nt[0]=524, nt[1]=997
ntnrd: failed to read 2064 bytes
ntn2err: error: handle=428, op=5, nt[0]=507, nt[1]=109
nserror: nsres: id=6, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=109,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsopen: opening transport...
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttcnr: connected on ipaddr 192.9.200.16 <http://192.9.200.16>
nttvlser: valid node check on incoming node 192.9.200.16<http://192.9.200.16>
nttvlser: Accepted Entry: 192.9.200.16 <http://192.9.200.16>
nttcon: set TCP_NODELAY on 428
nserror: nsres: id=2, op=78, ns=12612, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 6) complete
nsanswer: deferring connect attempt; at stage 5
ntt2err: soc 428 error - operation=5, ntresnt[0]=524, ntresnt[1]=997,
ntresnt[2]=0
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nttgetport: port resolved to 1109
nttbnd2addr: looking up IP addr for host:
ns1.oneapps.com<http://ns1.oneapps.com>
nscall: connecting...
nttgetport: port resolved to 1109
nttbnd2addr: looking up IP addr for host:
ns1.oneapps.com<http://ns1.oneapps.com>
nsopen: opening transport...
nttcni: trying to connect to socket 444.
nttcni: connected on ipaddr 0.0.0.0 <http://0.0.0.0>
nttcon: set TCP_NODELAY on 444
nsopen: transport is open
nsopen: global context check-in (to slot 7) complete
nscall: deferring connect attempt; at stage 4
nscon: doing connect handshake...
nscon: sending NSPTCN packet
ntt2err: soc 444 error - operation=5, ntresnt[0]=524, ntresnt[1]=997,
ntresnt[2]=0
nsevdcall: exit
nscon: got NSPTAC packet
nscon: doing connect handshake...
nscon: nsctxinf[0]=0x61, [1]=0x0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 7) complete
nscall: connecting...
nttgetport: port resolved to 1336
nttbnd2addr: looking up IP addr for host:
ns1.oneapps.com<http://ns1.oneapps.com>
nsopen: opening transport...
nttcni: trying to connect to socket 464.
nttcni: connected on ipaddr 0.0.0.0 <http://0.0.0.0>
nttcon: set TCP_NODELAY on 464
nsopen: transport is open
nsopen: global context check-in (to slot 7) complete
nscall: deferring connect attempt; at stage 8
nsevdcall: exit
nsbequeath: NSE=0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsevdansw: exit
nsglhe: Deallocating cxd 0xed0370.
nsopen: opening transport...
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttcnr: connected on ipaddr 192.9.200.16 <http://192.9.200.16>
nttvlser: valid node check on incoming node 192.9.200.169<http://192.9.200.169>
nttvlser: Accepted Entry: 192.9.200.169 <http://192.9.200.169>
nttcon: set TCP_NODELAY on 428
nserror: nsres: id=2, op=78, ns=12612, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 6) complete
nsanswer: deferring connect attempt; at stage 5
ntt2err: soc 428 error - operation=5, ntresnt[0]=524, ntresnt[1]=997,
ntresnt[2]=0
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nttgetport: port resolved to 1109
nttbnd2addr: looking up IP addr for host:
ns1.oneapps.com<http://ns1.oneapps.com>
nsbequeath: NSE=0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsevdansw: exit
nsglhe: Deallocating cxd 0xed0370.
nsopen: opening transport...
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttcnr: connected on ipaddr 192.9.200.16 <http://192.9.200.16>
nttvlser: valid node check on incoming node 192.9.200.169<http://192.9.200.169>
nttvlser: Accepted Entry: 192.9.200.169 <http://192.9.200.169>
nttcon: set TCP_NODELAY on 428
nserror: nsres: id=2, op=78, ns=12612, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 6) complete
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nttgetport: port resolved to 1109
nttbnd2addr: looking up IP addr for host:
ns1.oneapps.com<http://ns1.oneapps.com>
nsbequeath: NSE=0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsevdansw: exit
nsglhe: Deallocating cxd 0xed0370.
nsopen: opening transport...
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttcnr: connected on ipaddr 192.9.200.16 <http://192.9.200.16>
nttvlser: valid node check on incoming node 192.9.200.16<http://192.9.200.16>
nttvlser: Accepted Entry: 192.9.200.16 <http://192.9.200.16>
nttcon: set TCP_NODELAY on 428
nserror: nsres: id=2, op=78, ns=12612, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 6) complete
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nttgetport: port resolved to 1109
nttbnd2addr: looking up IP addr for host:
ns1.oneapps.com<http://ns1.oneapps.com>
nsbequeath: NSE=0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsevdansw: exit
nsglhe: Deallocating cxd 0xed0370.
nsopen: opening transport...
nserror: nsres: id=0, op=78, ns=12612, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 6) complete
nsanswer: deferring connect attempt; at stage 5
ntnrd: failed to read 8208 bytes
ntn2err: error: handle=224, op=5, nt[0]=524, nt[1]=997
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nscon: sending NSPTRF packet
ntnwr: failed to write 115 bytes
ntn2err: error: handle=224, op=6, nt[0]=524, nt[1]=997
ntnrd: failed to read 2064 bytes
ntn2err: error: handle=224, op=5, nt[0]=507, nt[1]=109
nserror: nsres: id=6, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=109,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 6) complete
nsopen: opening transport...
nserror: nsres: id=0, op=78, ns=12612, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
ora[0]=0, ora[1]=0, ora[2]=0
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 6) complete
nsanswer: deferring connect attempt; at stage 5
ntnrd: failed to read 8208 bytes
ntn2err: error: handle=464, op=5, nt[0]=524, nt[1]=997
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
****************************************************************************************
any clue??????????????????????????????
On 11/9/05, Stephane Faroult <sfaroult@xxxxxxxxxxxx> wrote:
>
> Enable logging and check what you get. It may be something not obviously
> related to Oracle (permissions, etc.).
>
> SF
>
> On Wed, 2005-11-09 at 17:50 +0530, Onkar N Tiwary wrote:
> > Hi guys,
> >
> > Since today morning I am facing one problem :
> >
> > ORA-12547 : TNS lost contact
> >
>
>
>
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Other related posts:
