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: Joe D <jkdriscoll_at_qg.com>
Date: Fri, 4 Nov 2005 11:45:26 -0600
Message-ID: <dkg6nn$1plv$1@sxnews1.qg.com>


Thank you

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1129829911.931968_at_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 Fri Nov 04 2005 - 11:45:26 CST

Original text of this message

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