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>
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
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 tracefilediag\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
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