Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

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: