Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: question about the listener.log file

Re: question about the listener.log file

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Oct 2005 10:38:38 -0700
Message-ID: <1129829911.931968@yasure>


Joe D wrote:
> Morning all,
>
> After being away from Oracle for many years, I'm once again managing an
> Oracle instance. So, while I'm still trying to dust off some old memory
> cells in my brain, I have this question.
>
> Is following type of entry in the listener.log file an indication of a
> Oracle connection being disconnected?:
>
> 17-OCT-2005 11:21:36 * service_update * <OracleSID> * 0
>
> The reason for my question is that I was asked to see if I could trace or
> track down why clients where being disconnected from Oracle.
>
> Thanks for your time,
>
> Joe D

Put the following into sqlnet.ora

# Debugging Parameters

trace_level_client= 16
trace_file_client=client
trace_directory_client=/home/oracle
trace_unique_client=true

(of course change the trace directory to the one you want).

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 20 2005 - 12:38:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US