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
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
On Tue, Oct 15, 2019 at 3:10 PM Chris Taylor <
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.
On Tue, Oct 15, 2019 at 1:35 PM Andrew Kerber <andrew.kerber@xxxxxxxxx>
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 188.8.131.52 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.
Howard A. Latham
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'