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@xxxxxxxxxxxxxx> 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:
On Tue, Oct 15, 2019 at 11:40 AM Howard Latham <howard.latham@xxxxxxxxx>
I'm doing an upgrade from 126.96.36.199 to 18
The instructions say shut down the target db and startup upgrade from the
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.
Howard A. Latham