Re: Connect hangs sqlplus
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 15 Oct 2019 19:25:17 -0400
Message-ID: <b8363de6-4c06-2b7d-7101-9050f85da218_at_gmail.com>
Date: Tue, 15 Oct 2019 19:25:17 -0400
Message-ID: <b8363de6-4c06-2b7d-7101-9050f85da218_at_gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 16 2019 - 01:25:17 CEST