Re: Connect hangs sqlplus

Another option is to identify that Oracle process (assuming that there is one, you can look for a child process of your local sqlplus command with ps) and run pstack on it to see where it's stuck. The process name should something like this: oracleSID (DESCRIPTION=(LOCAL=YES)(ADDRESS=( *PROTOCOL=beq*))).

Pstack may be to microscopic though, hanganalyze can provide more context (like if you're waiting for a latch or lock, who's holding it at the same time).

On Tue, Oct 15, 2019 at 2:28 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
>>
>>
>>

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