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@(protected)> 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 (See ORA-12547.ora-code.com) : TNS lost contact > > > > > >
<div>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:</div>
<div> </div> <div>trace file contents:</div> <div>************************************************************************** **</div> <div>nscon: sending NSPTRF packet<br>ntnwr: failed to write 115 bytes<br >ntn2err: error: handle=428, op=6, nt[0]=524, nt[1]=997<br>ntnrd: failed to read 2064 bytes<br>ntn2err: error: handle=428, op=5, nt[0]=507, nt[1]=109 <br>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<br>nstimarmed: no timer allocated<br>nsclose : closing transport<br>nsclose: global context check-out (from slot 6) complete <br>nsopen: opening transport...<br>nttcnp: getting sockname<br>nttcnr: waiting to accept a connection.<br>nttcnr: getting sockname<br>nttcnr: connected on ipaddr <a href="http://192.9.200.16">192.9.200.16</a><br>nttvlser: valid node check on incoming node <a href="http://192.9.200.16">192.9.200.16</a><br>nttvlser: Accepted Entry: <a href="http://192.9.200.16">192.9.200.16</a><br>nttcon: set TCP_NODELAY on 428 <br>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 <br>nsopen: transport is open<br>nsnainit: inf->nsinfflg[0]: 0xd inf-> ;nsinfflg[1]: 0xd<br>nsopen: global context check-in (to slot 6) complete<br >nsanswer: deferring connect attempt; at stage 5<br>ntt2err: soc 428 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0 <br>nscon: doing connect handshake...<br>nscon: got NSPTCN packet<br>nsevdansw: exit<br>nttgetport: port resolved to 1109<br>nttbnd2addr: looking up IP addr for host: <a href="http://ns1.oneapps.com">ns1.oneapps.com</a><br> nscall: connecting...<br>nttgetport: port resolved to 1109<br>nttbnd2addr: looking up IP addr for host: <a href="http://ns1.oneapps.com">ns1.oneapps.com< /a><br>nsopen: opening transport...<br>nttcni: trying to connect to socket 444. <br>nttcni: connected on ipaddr <a href="http://0.0.0.0">0.0.0.0</a><br>nttcon: set TCP_NODELAY on 444<br>nsopen: transport is open<br>nsopen: global context check-in (to slot 7) complete<br>nscall: deferring connect attempt; at stage 4 <br>nscon: doing connect handshake...<br>nscon: sending NSPTCN packet<br >ntt2err: soc 444 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2 ]=0<br>nsevdcall: exit<br>nscon: got NSPTAC packet<br>nscon: doing connect handshake... <br>nscon: nsctxinf[0]=0x61, [1]=0x0<br>nstimarmed: no timer allocated<br >nsclose: closing transport<br>nsclose: global context check-out (from slot 7) complete<br>nscall: connecting...<br>nttgetport: port resolved to 1336 <br>nttbnd2addr: looking up IP addr for host: <a href="http://ns1.oneapps.com" >ns1.oneapps.com</a><br>nsopen: opening transport...<br>nttcni: trying to connect to socket 464.<br>nttcni: connected on ipaddr <a href="http://0.0.0.0"> 0.0.0.0</a><br>nttcon: set TCP_NODELAY on 464<br>nsopen: transport is open<br >nsopen: global context check-in (to slot 7) complete<br>nscall: deferring connect attempt; at stage 8<br>nsevdcall: exit<br>nsbequeath: NSE=0<br> nstimarmed: no timer allocated<br>nsclose: closing transport<br>nsclose: global context check-out (from slot 6) complete<br>nsevdansw: exit<br>nsglhe: Deallocating cxd 0xed0370.<br>nsopen: opening transport...<br>nttcnp: getting sockname <br>nttcnr: waiting to accept a connection.<br>nttcnr: getting sockname<br >nttcnr: connected on ipaddr <a href="http://192.9.200.16">192.9.200.16</a><br >nttvlser: valid node check on incoming node <a href="http://192.9.200.169"> 192.9.200.169</a><br>nttvlser: Accepted Entry: <a href="http://192.9.200.169" >192.9.200.169</a><br>nttcon: set TCP_NODELAY on 428<br>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 <br>nsopen: transport is open<br>nsnainit: inf->nsinfflg[0]: 0xd inf-> ;nsinfflg[1]: 0xd<br>nsopen: global context check-in (to slot 6) complete<br >nsanswer: deferring connect attempt; at stage 5<br>ntt2err: soc 428 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0 <br>nscon: doing connect handshake...<br>nscon: got NSPTCN packet<br>nsevdansw: exit<br>nttgetport: port resolved to 1109<br>nttbnd2addr: looking up IP addr for host: <a href="http://ns1.oneapps.com">ns1.oneapps.com</a><br> nsbequeath: NSE=0<br>nstimarmed: no timer allocated<br>nsclose: closing transport<br>nsclose: global context check-out (from slot 6) complete<br >nsevdansw: exit<br>nsglhe: Deallocating cxd 0xed0370.<br>nsopen: opening transport... <br>nttcnp: getting sockname<br>nttcnr: waiting to accept a connection.<br >nttcnr: getting sockname<br>nttcnr: connected on ipaddr <a href="http://192.9 .200.16">192.9.200.16</a><br>nttvlser: valid node check on incoming node <a href="http://192.9.200.169">192.9.200.169</a><br>nttvlser: Accepted Entry: <a href="http://192.9.200.169">192.9.200.169</a><br>nttcon: set TCP_NODELAY on 428<br>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 <br>nsopen: transport is open<br>nsnainit: inf->nsinfflg[0]: 0xd inf-> ;nsinfflg[1]: 0xd<br>nsopen: global context check-in (to slot 6) complete<br >nsanswer: deferring connect attempt; at stage 5<br>nscon: doing connect handshake... <br>nscon: got NSPTCN packet<br>nsevdansw: exit<br>nttgetport: port resolved to 1109<br>nttbnd2addr: looking up IP addr for host: <a href="http://ns1.oneapps .com">ns1.oneapps.com</a><br>nsbequeath: NSE=0<br>nstimarmed: no timer allocated <br>nsclose: closing transport<br>nsclose: global context check-out (from slot 6) complete<br>nsevdansw: exit<br>nsglhe: Deallocating cxd 0xed0370.<br>nsopen: opening transport...<br>nttcnp: getting sockname<br>nttcnr: waiting to accept a connection. <br>nttcnr: getting sockname<br>nttcnr: connected on ipaddr <a href="http://192 .9.200.16">192.9.200.16</a><br>nttvlser: valid node check on incoming node <a href="http://192.9.200.16">192.9.200.16</a><br>nttvlser: Accepted Entry: <a href="http://192.9.200.16">192.9.200.16</a><br>nttcon: set TCP_NODELAY on 428<br>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<br>nsopen: transport is open<br>nsnainit: inf-> ;nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd <br>nsopen: global context check-in (to slot 6) complete<br>nsanswer: deferring connect attempt; at stage 5<br>nscon: doing connect handshake...<br>nscon: got NSPTCN packet<br>nsevdansw: exit<br>nttgetport: port resolved to 1109 <br>nttbnd2addr: looking up IP addr for host: <a href="http://ns1.oneapps.com" >ns1.oneapps.com</a><br>nsbequeath: NSE=0<br>nstimarmed: no timer allocated<br >nsclose: closing transport<br>nsclose: global context check-out (from slot 6) complete <br>nsevdansw: exit<br>nsglhe: Deallocating cxd 0xed0370.<br>nsopen: opening transport...<br>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<br>nsopen: transport is open <br>nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd<br>nsopen: global context check-in (to slot 6) complete<br>nsanswer: deferring connect attempt; at stage 5<br>ntnrd: failed to read 8208 bytes<br>ntn2err: error: handle=224, op=5, nt[0]=524, nt[1]=997 <br>nscon: doing connect handshake...<br>nscon: got NSPTCN packet<br>nsevdansw: exit<br>nscon: sending NSPTRF packet<br>ntnwr: failed to write 115 bytes<br >ntn2err: error: handle=224, op=6, nt[0]=524, nt[1]=997<br>ntnrd: failed to read 2064 bytes <br>ntn2err: error: handle=224, op=5, nt[0]=507, nt[1]=109<br>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<br>nstimarmed: no timer allocated<br>nsclose: closing transport <br>nsclose: global context check-out (from slot 6) complete<br>nsopen: opening transport...<br>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<br>nsopen: transport is open <br>nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd<br>nsopen: global context check-in (to slot 6) complete<br>nsanswer: deferring connect attempt; at stage 5<br>ntnrd: failed to read 8208 bytes<br>ntn2err: error: handle=464, op=5, nt[0]=524, nt[1]=997 <br>nscon: doing connect handshake...<br>nscon: got NSPTCN packet<br>nsevdansw: exit<br>*********************************************************************** *****************</div> <div> </div> <div>any clue??????????????????????????????<br><br> </div> <div><span class="gmail_quote">On 11/9/05, <b class="gmail_sendername">Stephane Faroult</b> <<a href="mailto:sfaroult@(protected)">sfaroult@(protected)</a >> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">Enable logging and check what you get. It may be something not obviously<br>related to Oracle (permissions, etc.). <br><br>SF<br><br>On Wed, 2005-11-09 at 17:50 +0530, Onkar N Tiwary wrote:<br> > Hi guys,<br>><br>> Since today morning I am facing one problem :<br> ><br>> ORA-12547 (See ORA-12547.ora-code.com) : TNS lost contact<br>><br><br><br><br> </blockquote></div><br><br clear="all"><br>-- <br>Thanks & Regards,<br>T. Onkar Nath<br>OneAPPS Enterprise Technology Pvt. Ltd.<br> <a href="mailto:to_onkar@(protected)">to_onkar@(protected)</a><br > <a href="mailto:onkarnath.tiwary@(protected) "> onkarnath.tiwary@(protected)</a><br>
