This discussion is archived
4 Replies Latest reply: Feb 14, 2013 1:11 AM by BillyVerreynne RSS

TNS protocol Adapter

oradba11 Newbie
Currently Being Moderated
Hi,
I am working on Oracle 11g and AIX server.
Some times we are getting TNS protocol Adapter message to some users and they are not able to connect to database but at the same time
other users are able to work ...when they will again try after some time ...they are able to connect.
We have checked the database ans listener was up that time , this error is not constent like some time they are getting and some time not and not to specific
to some user also ...

Any idea ..where we can check for this issue and how to resolve this...we have checked client side sqlnet.ora but this error is not recorded in these tracce file.

What alll trace files we need to check for this error...
  • 1. Re: TNS protocol Adapter
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    Look at turning on SQL*Net tracing on one client that often runs into this problem. This results in the local OCI driver logging a trace of its calls (via TCP) to the database. The trace can be used to isolate the problem that occurs.
  • 2. Re: TNS protocol Adapter
    oradba11 Newbie
    Currently Being Moderated
    Actually we have few sqlnet trace files , but in these logs , tns protocol error can not be found..these are big logs files ,just posting top of these files.

    Is these files you are talking about ?


    sqlnet_328018.trc
    sqlnet_328018_1.trc

    1) [13-FEB-2013 23:52:18:560] --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
    (1) [13-FEB-2013 23:52:18:560] New trace stream is /proj/dba/sqltrace/sqlnet_328018.trc
    (1) [13-FEB-2013 23:52:18:560] New trace level is 16
    (1) [13-FEB-2013 23:52:18:560] --- TRACE CONFIGURATION INFORMATION ENDS ---
    (1) [13-FEB-2013 23:52:18:560] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
    (1) [13-FEB-2013 23:52:18:560] Attempted load of system pfile source /etc/sqlnet.ora
    (1) [13-FEB-2013 23:52:18:560] Parameter source loaded successfully
    (1) [13-FEB-2013 23:52:18:560]
    (1) [13-FEB-2013 23:52:18:560] Attempted load of local pfile source /proj/home/aa319ctm/.sqlnet.ora
    (1) [13-FEB-2013 23:52:18:560] Parameter source was not loaded
    (1) [13-FEB-2013 23:52:18:560]
    (1) [13-FEB-2013 23:52:18:560] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
    (1) [13-FEB-2013 23:52:18:560] Successful parameter table load
    (1) [13-FEB-2013 23:52:18:560] -> PARAMETER TABLE HAS THE FOLLOWING
  • 3. Re: TNS protocol Adapter
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Actually we have few sqlnet trace files , but in these logs , tns protocol error can not be found..these are big logs files ,just posting top of these files.
    then how you decide its listener issue ?
  • 4. Re: TNS protocol Adapter
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    oradba11 wrote:
    Actually we have few sqlnet trace files , but in these logs , tns protocol error can not be found..these are big logs files ,just posting top of these files.

    Is these files you are talking about ?
    Correct.

    Which is why I suggested finding a specific problematic client - and dealing with its (large) trace file.

    Or wait for the error to hit a client, enabling tracing, and then evaluate the trace.

    The problem needs to be isolated. With sporadic and seemingly random occurring error you are seeing, tracing the OCI calls is one of the more effective methods.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points