Re: ORA-12547 : TNS lost contact

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: Wed, 9 Nov 2005 18:25:59 +0530
Message-ID: <a144e5210511090455v2837044mfaad882e4f470b4a@mail.gmail.com>

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>

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_at_roughsea.com> 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_at_yahoo.com
onkarnath.tiwary_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 09 2005 - 06:58:53 CST