Home -> Mailing Lists -> Oracle-L -> Re: Connect hangs sqlplus

Re: Connect hangs sqlplus

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Tue, 15 Oct 2019 14:28:53 -0400
Message-ID: <CAMHX9JKNS64qAMvUVKABYio9Vuk7gDreJKOgzJyoQxWEfo5yOA_at_mail.gmail.com> 








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


Received on Tue Oct 15 2019 - 20:28:53 CEST












Original text of this message