Pages

Tuesday, January 25, 2011

Using and Disabling the Automatic Diagnostic Repository (ADR) with Oracle Net for 11g

Trace Files Viewing Method 
C:\Users\inam>adrci
ADRCI: Release 11.2.0.1.0 - Production on Tue Jan 25 13:56:20 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
No ADR base is set

adrci> show base -product client
ADR base is "C:\Users\inam\Oracle\oradiag_inam"
adrci>
adrci> set base C:\Users\inam\Oracle\oradiag_inam
adrci> show tracefile
     diag\clients\user_inam\host_959400119_76\trace\sqlnet.log
adrci> show alert

Choose the alert log from the following homes to view:

1: diag\clients\user_inam\host_959400119_76
2: diag\diagtool\user_inam\host_959400119_76
Q: to quit

Please select option: 1
Output the results to file: c:\users\inam\appdata\local\temp\3\alert_1452_3416_h
ost_959400119_76_1.ado

Please select option: q
adrci>
Reverting Back to Old-Style Tracing and Logging: Set DIAG_ADR_ENABLED=off in the following locations, after doing so, set a trace_level accordingly:

revert to client/server tracing/logging: set parameter DIAG_ADR_ENABLED=off in the client or server sqlnet.ora files

revert to listener tracing/logging: set parameter DIAG_ADR_ENABLED_listenerName=off in the listener.ora file
revert to cman tracing/logging:
Linux and Windows: add (DIAG_ADR_ENABLED=off) inside the parameter_list

Samlpe sqlnet.ora
# sqlnet.ora Network Configuration File: C:\app\inam\product\11.2.0\client_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

DIAG_ADR_ENABLED=OFF

TNSPING.TRACE_LEVEL= SUPPORT
TNSPING.TRACE_DIRECTORY=C:\TEMP\tnsping

TRACE_LEVEL_CLIENT= SUPPORT
TRACE_DIRECTORY_CLIENT = C:\TEMP\trace
TRACE_FILE_CLIENT= client153_.trc
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON

No comments:

Post a Comment