Tnsping80 cause microsoft critical error

Posted on 2005-04-07
Last Modified: 2012-06-27
hi all!

Oracle client worked fine on my laptop. But one day I recieved MS critical error while running oracle forms.
I tried just start tnsping80 [my_SID] - and recieved same error

Then I reinstalled oracle on my PC a lot of times.
Check it on viruses and trojans - it was clean
I have WinXP SP2 with all updates

Then a tried diagnostic this error via tnsping.trace_level=admin in sqlnet.ora

New trace stream is "c:\temp\tnsping.trc"
New trace level is 6
nnftboot: entry
nnftboot: exit
nnfoboot: entry
nnfoboot: exit
nnfoboot: entry
nnfoboot: exit
nnfhboot: entry
nnfhboot: exit
nncpmlf_make_local_addrfile: local names file is C:\orant\NET80\ADMIN\tnsnames.ora
nncpmsf_make_sys_addrfile: system names file is C:\orant\NET80\admin\tnsnames.ora
nncpcin_maybe_init: first request sent to name server will have ID 0
nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
nncpcin_maybe_init: max request retries per name server is 1
nngsini_init_streams: initializing stream subsystem, cache size is 10
nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
nncpcin_maybe_init: default name server domain is world
nnfun2a: entry
nnftqnm: entry
nnfcagmd: entry
nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
nnfcagmd: exit
nncpldf_load_addrfile: initial load of names file C:\orant\NET80\ADMIN\tnsnames.ora
nncpldf_load_addrfile: success
nnftqnm: Using tnsnames.ora address (DESCRIPTION = (SDU=1461) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = (PROTOCOL = TCP) (Host = (Port = 1521))) (CONNECT_DATA = (SID = m300))) for name
nnfcraa: entry
nnftans: entry
nnfcran: entry
nnfcran: 64 rrs requested, 1 remaining, 1 total
nnfcran: exit
nnfotrv1: entry
nnfotrv1: translated "" to (DESCRIPTION = (SDU=1461) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = (PROTOCOL = TCP) (Host = (Port = 1521))) (CONNECT_DATA = (SID = m300)))
nscall: connecting...
nttbnd2addr: entry
nttbnd2addr: port resolved to 1521
nttbnd2addr: using host IP address:
nttbnd2addr: exit
nsmal: 400 bytes at 0xd19818
nsmal: 1664 bytes at 0xd5c0f0
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvllt: entry
ntvllt: No PROTOCOL.ORA file is found
ntvllt: exit
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 1832.
nttcni: exit
nttcon: exit
nsopen: transport is open
nsnainit: call
nsnainit: NA not wanted - disabling and returning
nsoptions: lcl[0]=0x0, lcl[1]=0x10, gbl[0]=0x0, gbl[1]=0x0, cha=0x0
nsoptions: lcl[0]=0xefff, lcl[1]=0x10, gbl[0]=0xb83f, gbl[1]=0x0
nsopen: global context check-in (to slot 0) complete
nsopen: lcl[0]=0xefff, lcl[1]=0x10, gbl[0]=0xb83f, gbl[1]=0x0, tdu=32767, sdu=2048
nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=7, flg=0x4201, mvd=0
nsmal: 44 bytes at 0xd1a8c0
nsmal: 44 bytes at 0xd1a9d8
nlidg8: entry
nlidg8: exit
nsdo: nsctxrnk=0
nsdo: cid=0, opcode=67, *bl=29, *what=8, uflgs=0x0, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=14, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2047
nscon: doing connect handshake...
nscon: sending NSPTCN packet
nspsend: plen=87, type=1
nttwr: entry
nttwr: socket 1832 had bytes written=87
nttwr: exit
nspsend: 87 bytes to transport
nsdo: nsctxrnk=0
nsdo: cid=0, opcode=68, *bl=256, *what=9, uflgs=0x2000, cflgs=0x3
nsdo: rank=64, nsctxrnk=0
nsdo: nsctx: state=2, flg=0x4205, mvd=0
nsdo: gtn=0, gtc=0, ptn=10, ptc=2047
nscon: recving a packet
nsmal: 44 bytes at 0xd1b728
nsprecv: reading from transport...
nttrd: entry

----- THIS is the end of file on error

don't know what to do. Any suggestions exept reinstall Windows?
Question by:sergey_qw
    LVL 25

    Expert Comment

    Do you have a protocol.ora file in your $TNS_ADMIN directory?  If not....

    Try creating one manually.

    For example, open NOTEPAD and type the entries according to your needs for
    example  >>>

      tcp.validnode_checking = yes
      tcp.invited_nodes = (
      tcp.excluded_nodes = (
      tcp.nodelay =no

    tcp.excluded_nodes :  Lists addresses of machines not allowed to connect.
    tcp.invited_nodes :  Lists addresses of machines allowed to connect. This
    parameter will take precedence over the tcp.excluded_nodes parameter if both
    are present.
    tcp.validnode_checking :  Indicates whether address checking should be
    enabled. Values YES / NO (default NO).
    tcp.nodelay : Specifies no delay in buffer flushing within the TCP/IP stack.
    Values YES / NO (default NO).

    Save the contents and then start the listener..

    Author Comment

    same error,
    applications worked fine within 6 years without protocol.ora :))
    LVL 47

    Expert Comment

    Have you created TNS_ADMIN in the registry?

    Author Comment

    yes. same error
    LVL 25

    Accepted Solution

    OK, if it worked without protocol.ora at all...I can't imagine it needs to be there then.  Can you bump up your trace level to SUPPORT (from ADMIN)?

    You could also add TNSPING tracing to your SQLNET.ORA file:

            TNSPING.TRACE_LEVEL = 16
            TNSPING.TRACE_DIRECTORY = {directory}

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now