Sqlnet listener tracing

Use TRCASST to read the files generated

following should be in sqlnet.ora file (sqlnet trace)

TRACE_UNIQUE_CLIENT = on

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

TRACE_DIRECTORY_CLIENT = /opt/app/oracle/product/10.2.0.5/network/log

TRACE_LEVEL_SERVER = 16

TRACE_FILE_SERVER = sql_trace.trc

TRACE_DIRECTORY_SERVER = /opt/app/oracle/product/10.2.0.5/network/trace/

TRACE_TIMESTAMP_CLIENT = ON


***************************************************************************************************************
following should be in listener.ora file (listener trace)

TRACE_FILE_LISTENER = LISTENERTEST.trc
TRACE_DIRECTORY_LISTENER = /opt/app/crs/11.2.0/11.2.0.3/network/trace/
LOGGING_LISTENER = on
TRACE_LEVEL_LISTENER =SUPPORT
TRACE_LEVEL_LISTENER =ADMIN


/opt/app/oracle/product/11.2.0/11.2.0.4/network/trace


*********************************************************************************

How does this client connect to oracle -- is it using thin jdbc or sqlnet? If this client is using sqlnet, I need to see a client side trace that shows the client connection attempt failing. Client side tracing is turned on by adding the following syntax to the client's sqlnet.ora file: TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = Some fully qualified directory likeC:\TEMP TRACE_FILE_CLIENT = CLIENT DIAG_ADR_ENABLED= OFF Try to connect. The connection will still fail upload the resulting client side trace to the SR.