RE: connection pools and listener log
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 19 Apr 2011 11:12:59 -0700 (PDT)
Message-ID: <532721.22292.qm_at_web80601.mail.mud.yahoo.com>
> What I don't get is why the listeners aren't recording some sort
> of redirect command in their logs.
Date: Tue, 19 Apr 2011 11:12:59 -0700 (PDT)
Message-ID: <532721.22292.qm_at_web80601.mail.mud.yahoo.com>
> What I don't get is why the listeners aren't recording some sort
> of redirect command in their logs.
Dave,
If the connection is redirected from another node, the listener log will have INSTANCE_NAME=... in the line (see Note:263599.1). You can grep -v those lines and see if the database logons tally up to the listener entries.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 19 2011 - 13:12:59 CDT