Re: Connect hangs sqlplus

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 17 Oct 2019 09:12:02 -0500
Message-ID: <CAJvnOJaRx_gBKmD0gtbJBWXFrtJtXdMk8NkgTf2PxcPZzY7H+Q_at_mail.gmail.com>



I havent seen that problem since 10.1. I thought that was fixed.

On Thu, Oct 17, 2019 at 5:05 AM Howard Latham <howard.latham_at_gmail.com> wrote:

>
> solved it - shared mem segment was still attached to oracle process.
> how to find if you get same problem
>
>
> https://stackoverflow.com/questions/5658568/how-to-list-processes-attached-to-a-shared-memory-segment-in-linux
>
>
> On Wed, 16 Oct 2019 at 00:28, Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> But they do. I have to use "-prelim" when that happens.
>>
>> On 10/15/19 3:25 PM, Tanel Poder wrote:
>> > Yep, recovery area / archive log stuck shouldn't affect SYSDBA
>> > connections as they don't log their audit to in-database tables.
>> >
>> --
>> Mladen Gogala
>> Database Consultant
>> Tel: (347) 321-1217
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 17 2019 - 16:12:02 CEST

Original text of this message