Re: Connect hangs sqlplus

Yep, recovery area / archive log stuck shouldn't affect SYSDBA connections as they don't log their audit to in-database tables.

When the audit dump destination is full, wouldn't you get an error message instead of hanging?

Howard mentioned in a private reply that the DB isn't even up, can't connect to start it.

So in this case run:

1. *sqlplus "/as sysdba"* (it hangs)
2. use *ps* to find the sqlplus child process PID (there will be an oracle process with BEQ connection type under your sqlplus process as a child for local connections)
3. run *pstack PID* to see where that oracle process is stuck

If there's not even an oracle process started and the sqlplus doesn't have any child processes, then you could run pstack on sqlplus itself to see where it's stuck or use *strace -f sqlplus "/as sysdba"* to see where it gets stuck.

Tanel

On Tue, Oct 15, 2019 at 3:10 PM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> Also check audit dump destination --- sys connections always create an aud
> file - so make sure the audit dump dest is valid and not full and
> writable by oracle.
>
> Chris
>
>
> On Tue, Oct 15, 2019 at 1:35 PM Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> The most common cause of this is the recovery area is full. Look at your
>> alert log and see what it says.
>>
>> On Tue, Oct 15, 2019 at 1:30 PM Tanel Poder <tanel_at_tanelpoder.com> wrote:
>>
>>> While the login hang is ongoing, connect in another terminal window with
>>> a sqlplus preliminary connection & run hanganalyze to see what's preventing
>>> you from logging on:
>>>
>>> 1) sqlplus -prelim "/as sysdba"
>>> 2) oradebug hanganalyze 3
>>>
>>> There are some gotchas to be aware of if you don't see proper
>>> hanganalyze output in the tracefile, I've written about these here:
>>>
>>>
>>> https://blog.tanelpoder.com/2012/05/08/oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object/
>>>
>>> --
>>> Tanel Poder
>>> https://blog.tanelpoder.com/seminar
>>>
>>>
>>> On Tue, Oct 15, 2019 at 11:40 AM Howard Latham <howard.latham_at_gmail.com>
>>> wrote:
>>>
>>>> I'm doing an upgrade from 11.2.0.4 to 18
>>>> The instructions say shut down the target db and startup upgrade from
>>>> the 18 home
>>>> But I can't connect
>>>> Connect from sqlplus connect / as sysdba and connect sys/xxxxxx as
>>>> sysdba both hang
>>>>
>>>> Anyone got any ideas?
>>>> Its RH Linux BTW.
>>>> thanks
>>>>
>>>> Best Wishes
>>>>
>>>> Howard A. Latham
>>>>
>>>>
>>>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>

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