Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: listener intermittently down
crs_stat -t shows all are fine.
but when I check with ps -ef | grep lsn
sometimes listener -inherit comes 2 or 3 lines
and back again to 1 line output.
is this due to vip problem? or something else?
from the log, i could not find it...
turn on tracing...hm... it so hard due to listener down intermittently, even it can be down after 3 days.
btw, it seem that when listener down , the cpu utilization is on high percentage of user processes.
regards
ujang
On Nov 11, 2007 2:25 AM, Alex Gorbachev <ag_at_oracloid.com> wrote:
> What does "crs_stat -t" show?
>
> You should check logs
> $ORACLE_HOME/log/<node>/racg/<listener_resource_name>.log (not in
> ORA_CRS_HOME).
> If details there are not enough - you can enable debugging
> (_USR_ORA_DEBUG in racgvip or USR_ORA_DEBUG on resource attributes).
>
> Also, check that you VIP doesn't fail and not moved to another node.
> You can also enable listener trace if it dies to try to capture more details.
>
>
> On Nov 8, 2007 6:55 AM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> > all,
> >
> > 2 nodes linux rhel4.4 IA 64
> > node 1 has 4 processors
> > node 2 has 8 processors
> >
> > oracle RAC 10.2.0.3
> >
> > have the problem that intermittently listener down.
> > could not found some valuable info from crsd.log / cssd.log or even on
> > lsn.log or vip.log under client crs log.
> >
> > my application comes from IIS6 with ODAC (oracle data access
> > connection???) with connection pooling disable.
> >
> > have been set on listerner.ora
> > SUBSCRIBE_FOR_NODE_DOWN_EVENT_LSNR_HQRAC1=OFF
> > INBOUND_CONNECT_TIMEOUT_LSNR_HQRAC1 = 120
> >
> > on sqlnet.ora
> > SQLNET.INBOUND_CONNECT_TIMEOUT = 120
> >
> > but same problem still raised.
> >
> > please help....and thyanks for the share
> >
> > --
> > regards
> > ujang
> > jakarta - indonesia
> > http://ujang-id.blogspot.com
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
>
> --
> Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
> http://www.pythian.com/blogs/author/alex http://www.oracloid.com
> BAAG party - www.BattleAgainstAnyGuess.com
>
-- regards ujang jakarta - indonesia http://ujang-id.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Sat Nov 10 2007 - 21:38:33 CST
![]() |
![]() |