Re: prepare phase failed after upgrade 19c

Posted by satish on Feb 09, 2023; 6:31am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/prepare-phase-failed-after-upgrade-19c-tp11571p11572.html

Dear Erman,

env: 2node application tier and 2 nonde RAc.

We also verified local listener. 1528 is database port. We tried running autoconfig manually on node1 and node2.On node1, It completed in run edition but failed on patch edition with same error. On node2,it completed on both run and patch filesystems.

SQL> sho parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      erpproddb2:1528
parallel_force_local                 boolean     TRUE
SQL> alter session set container=PRODDB;

Session altered.

SQL> sho parameter local

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      erpproddb2:1528