Re: Connect hangs sqlplus

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 Oct 2019 19:25:17 -0400

Yes. Your LOG_ARCHIVE_DEST_1 is full. Oracle 12c has a long standing bug which prevents sysdba connection when the default log archive destination is full. That is one of those things that make life interesting for a DBA, that I've recently talked about.

Regards

On 10/15/19 11:41 AM, Howard Latham 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


--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Other related posts: