Re: Issue with Oracle listener

From: <Prashant.Bapat_at_gmail.com>
Date: 1 Apr 2006 00:33:29 -0800
Message-ID: <1143880409.885855.145750@j33g2000cwa.googlegroups.com>

Sybrand Bakker wrote:
> On 31 Mar 2006 18:50:09 -0800, Prashant.Bapat_at_gmail.com wrote:
>
> >Here is my problem;
> >
> >When I try to connect to the DB from an external system (using jdbc
> >thin driver) sometimes i get "network adapter could not establish the
> >connection..." error.
>
> And after you did examine the listener log, and/or lsnrctl status
> or did you just restart the listener?
> In the latter case, nothing to work on.
>
> --
> Sybrand Bakker, Senior Oracle DBA

Hi Sybrand,

Thanks for the reply.

lsnrctl status returns normal output.

[oracle1_at_oss_tsr admin]$ lsnrctl status

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 01-APR-2006 13:52:07

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.136)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.1.7.0.0 -
Production
Start Date                01-APR-2006 13:45:00
Uptime                    0 days 0 hr. 7 min. 7 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/home/oracle1/product/8.1.7/network/admin/listener.ora Listener Log File
/home/oracle1/product/8.1.7/network/log/listener.log Services Summary...

  HNS           has 1 service handler(s)
  HNS           has 2 service handler(s)
  HNS           has 2 service handler(s)
  PLSExtProc            has 1 service handler(s)

The command completed successfully

And i dont see anything unusual in listner.log too.

01-APR-2006 13:49:02 *
(CONNECT_DATA=(SID=HNS)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.140)(PORT=4662)) * establish * HNS * 0

--Prashant Received on Sat Apr 01 2006 - 02:33:29 CST