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...
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.