Oracle listener problem on AIX:

From: MIchael J. <mjNOmjSPAM_at_procon.dk.invalid>
Date: Thu, 09 Dec 1999 03:26:45 -0800
Message-ID: <0c2df4d6.d6d70a83@usw-ex0110-073.remarq.com>

Running AIX ver. 4.3.2., Oracle 7.3.4.4, Listener version 2.3.4.0.0, we experience a problem with the listener, which hangs, during runtime. All of a sudden, no connections can be established and users already connected can't use their application. On a ps -ef the Listener figures as running, and appaerently it is not spinning. The listener can't be stopped by using lsnrctl stop, but only with the kill command. After this, the listener can be restarted in a few cases, but mostly we have to reboot the entire system. When this occurs, the error messages we get when issuing lsnrctl start is:

Starting /oracle73/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production
System parameter file
is /oracle73/network/admin/listener.ora Log messages written to /oracle73/network/log/listener.log Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=imp)) Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10) (ADDRESS=(PROTOCOL=TCP)
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use

The following has been seen when trying to get a status from the listener:

LSNRCTL for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production on 20-OCT-0

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=imp)) TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=cwts7a) (Port=1521))

TNS-12203: TNS:unable to connect to destination TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error TNS-00505: Operation timed out
IBM/AIX RISC System/6000 Error: 78: Connection timed out Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=cwts7a) (Port=1526))

Listener.ora file:

LISTENER =
(ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL=IPC)


          (KEY= imp)


        )
        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 172.16.31.1)


          (Port = 1521)


        )
        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 172.16.31.1)


          (Port = 1526)


        )

)

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
# TRACE_LEVEL_LISTENER = 16

TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = imp)
      (ORACLE_HOME = /oracle73)
      (ENVS='EPC_DISABLED=TRUE')
      (connect_timeout_listener=100)

)
)

Can anyone help on this one?? Is it an Oracle problem, AIX problem or could it even be
the network ??
We have installed AIX PTF U463849, though it didn't solve the problem.

Thanks in advance.

Michael Janning
Manager, Service & Support
Pro:Con Scandinavia A/S, Denmark

Tel. 	(+45) 43 63 22 66
Fax 	(+45) 43 28 88 00
Email:	mj_at_procon.dk

Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

Received on Thu Dec 09 1999 - 05:26:45 CST