Re: question about the listener.log file

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)