Re: DB Restarts during Upgrade

From: Frank Gordon <frankagordon_at_gmail.com>
Date: Wed, 16 Sep 2020 12:56:42 +0100
Message-ID: <CAA0QMtkpXUWQKdHHFQw+SyCxKZt04Md6Hc3JKH_gZhf95XjBzA_at_mail.gmail.com>



Hello,

How did you tell Oracle Restart not to start this database automatically?

srvctl ???

Regards,
Frank

On Tue, Sep 15, 2020 at 10:50 AM Charlotte Hammond < dmarc-noreply_at_freelists.org> wrote:

> Hello,
>
> I'm running a manual 11g to 18c upgrade:
>
> Oracle Restart 19.7
> Source Home 11.2.0.4
> Target Home 18.10.0.0
>
> I have shutdown the database using srvctl from the 11g home.
> I have started the database using sqlplus from the 18c home in upgrade
> mode.
> I have started the upgrade using dbupgrade.
>
> Then, a few minutes in and for no apparent reason, as can be seen in
> ohasd.trc, Oracle Restart tries to restart the database from the old 11g
> home, whilst dbupgrade is still running.
> It seems to start (although an ORA-600[kccsbck_first] is logged), and
> hilarity ensues. Ultimately the upgrade fails with CRS-5702 (resource
> already running) at a point where it attempts to do a restart.
>
> My question is: why does Oracle Restart attempt to bring up the database
> which was cleanly shutdown before the upgrade?
>
> I've used this approach on dozens of other databases without problems, and
> running dbupgrade again on this one seems to work fine too.
>
> Thank you!
> Charlotte
>
>
>

-- 
+353-86-0695383

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 16 2020 - 13:56:42 CEST

Original text of this message