Re: New behavior in 11g?

From: David Ramírez Reyes <dramirezr_at_gmail.com>
Date: Fri, 29 Nov 2013 08:23:33 -0600
Message-ID: <CAJt=wvUTpGCeFku9CYkdnbyDn0pfjgCMRPw_y57v=yJ0DSN4bQ_at_mail.gmail.com>

Interesting problem, am having the same (with less impact) on our db migrated to 11g (we were on 8i, -don't ask why-).

Please let me know if you find something on that side.

Regards

David Ramírez Reyes
Profesión: Padre de Familia

On 28 November 2013 16:37, Maureen English <maureen.english_at_alaska.edu>wrote:

> Phillip,
>
> Yes, there definitely is a firewall between the app server and the
> database server. I thought it was
> the same firewall as is between the app server and the old database
> server, but that may not be
> true. Or, the rules may not be the same...or....
>
> I didn't think of this as possibly being a firewall issue, but now that
> you mention it, we also use
> IP tables on the new database server. Even though we did the same on the
> old database server,
> this one could easily be set up differently.
>
> Thanks! Now I have another direction I can go for troubleshooting this
> problem.
>
> - Maureen
>
>
> On Thu, Nov 28, 2013 at 10:32 AM, Phillip Jones <phil_at_phillip.im> wrote:
>
>> Hi,
>>
>> '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

Received on Fri Nov 29 2013 - 15:23:33 CET