how to turn on the tracing?

Posted on 2009-08-06 filed under: Oracle (RSS) 19 views

When I use the lsnrctl status query db port status, it was found that:

[Oracle @ test admin] $ lsnrctl status testdb

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 01:27:27

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION = (SID_NAME = testdb) (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROCTEST)))
STATUS of the LISTENER
------------------------
Alias testdb
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 05-AUG-2009 05:49:53
Uptime 0 days 19 hr. 37 min. 33 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File / u01/app/oracle/oracle/product/10.2.0/db_3/network/admin/listener.ora
Listener Log File / u01/app/oracle/oracle/product/10.2.0/db_3/network/log/testdb.log
Listening Endpoints Summary ...
(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = EXTPROCTEST)) (SID_NAME = testdb))
(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 127.0.0.1) (PORT = 1666)) (SID_NAME = testdb))
The listener supports no services
The command completed successfully

[Oracle @ test admin] $ tail -15 sqlnet.log
Fatal NI connect error 12514, connecting to:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1666)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testdb) (CID = (PROGRAM = sqlplus @ test) (HOST = test) (USER = oracle))))

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
TCP / IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 05-AUG-2009 05:07:10
Tracing not turned on .-------> how to turn on this tracing ?-----------------
Tns error struct: |
ns main err code: 12564 |
TNS-12564: TNS: connection refused |
ns secondary err code: 0 |
nt main err code: 0 |
nt secondary err code: 0 |
nt OS err code: 0

|

-------> Way: vi sqlnet.ora, add the following red part of the configuration:

[oracle @ test admin] $ cat sqlnet.ora # sqlnet.ora Network Configuration File: / u01/app/oracle/oracle/product/10.2.0/db_3/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH = (TNSNAMES, hostname)
trace_level_client = 16
trace_timestamp_client = true
trace_unique_client = on

trace_level_client This parameter Indicates the level at which the client program is to be traced.
# Available Values:
# 0 or OFF - No Trace output
# 4 or USER - User trace information
# 10 or ADMIN - Administration trace information
# 16 or SUPPORT - Worldwide Customer Support trace information

###########################
# trace_unique_client = ON
###########################
#
# Possible values: (ON, OFF)
# Default: OFF
#
# Purpose: Used to make each client trace file have a unique name to
# Prevent each trace file from being overwritten by successive
# Runs of the client program

See you again sqlnet.log:

[oracle @ test admin] $ tail -15 sqlnet.log
Fatal NI connect error 12505, connecting to:
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1666)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = testdb) (CID = (PROGRAM = sqlplus @ test) (HOST = test) (USER = oracle))))

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
TCP / IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 06-AUG-2009 02:45:00
Tracing to file: / u01/app/oracle/oracle/product/10.2.0/db_3/network/admin/cli_1861.trc
Tns error struct:
ns main err code: 12564
TNS-12564: TNS: connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Perhaps the analysis of trace log will provide you some clues.

It is worth noting that even when you are a DB, it will produce a trace log file, so, when you will find and solve the problem, you can turn off the tracing log, or will have a lot of log file.