Re: Listener is stopping !

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Mon, 27 Nov 2006 11:01:53 -0500
Message-id: <1164643313l.3205l.1l@medo.noip.com>

On 11/27/2006 10:28:16 AM, walid alkaakati wrote:
> Hi Ghassan.
>
> The listener is the same version of db (db version 9.2.0.4.0 ), and i have two oracle homes one for db and the other for forms.
> Can i ask something ? how i trace network problems.
> Regards.

Network problems are, generally speaking, very difficult to figure out. Recommended procedure is to blame everything on the network administrator and let him prove his innocence. If he can't - it's a network problem. Network administrators are presumed guilty until proven innocent.

Tracing listener is easy:

$ lsnrctl trace admin

LSNRCTL for Linux: Version 10.2.0.2.0 - Production on 27-NOV-2006 10:54:37

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=10G))) Opened trace file: /oracle/product/10g/network/trace/listener.trc The command completed successfully
$

Be careful, those trace files can grow very quickly and storage space, except on /dev/null, is not infinite.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 27 2006 - 10:01:53 CST