Re: New behavior in 11g?

'LOGOFF BY CLEANUP' occurs when a session hasn't explicitly closed the connection & Oracle has to clean the session up itself.

Sounds like your new server is behind a firewall that drops connections after 2 hours, causing the above. Talk to your network admins and ask what network hardware is between the app and database server.

Thanks,

Phil

On Thu, Nov 28, 2013 at 7:19 PM, Maureen English <maureen.english_at_alaska.edu
> wrote:

> We have an application that has been using a 10g database for years. We
> just
> created a new 11.2.0.4 RAC database on a new RHEL5 Linux server.
>
> The audit trail, however, shows the last
> entry for that user as doing a 'LOGOFF BY CLEANUP'. I'm 95% sure that
> there had
> been no communication between the application and the database for this
> user for
> the 2 hours before it disappeared...I was monitoring netstat output and
> the audit trail.
>
> I'm also sure that this is related to either some kind of timeout on the
> new database
> server, or some kind of timeout in the database. IDLE_TIME for the
> profile is set to
> UNLIMITED, so it's not that. No alert log info and no trace file info to
> show anything
> is wrong.
>
> It really looks like something is killing the Oracle process, but I don't
> know where
> else to look. Is there some kind of system parameter that may have been
> set that
> kills processes that are essentially inactive?
>
> - Maureen
>
>

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