Re: Oracle 19c DBUA Upgrade Fails

Can you drop the db link and recreate post upgrade ?

On Mon, 14 Sep 2020, 6:16 pm Scott Canaan, <srcdco_at_rit.edu> wrote:

> I’m trying to upgrade an Oracle 12.2.0.1 database to Oracle 19.8 using
> DBUA on Red Hat Linux 7. I’ve done a number of Oracle 19c upgrades with no
> issues. This time, it gets part way through then throws the following
> error:
>
>
>
> ORA-20000: Could not create database link: sys-hub ORA-06512: at
> "SYS.DBMS_PQ_INTERNAL", line 15
> ORA-06512: at line 1
>
> ORA-06512: at "SYS.DBMS_PQ_INTERNAL", line 15 ORA-06512: at line 1
>
> ORA-06512: at line 1
> Oracle Server INVALID 19.8.0.0.0 00:13:32
> Oracle Real Application Clusters OPTION OFF 19.8.0.0.0 00:00:00
> Oracle XML Database UPGRADED 19.8.0.0.0 00:01:52
> Datapatch 00:02:03
> Final Actions 00:02:12
> Post Upgrade 00:00:16
>
> Total Upgrade Time: 00:20:03
>
>
>
> It only gets to 49% complete before it pops up a window saying that it
> failed and the only options given are “Retry” and “Abort”. I’ve opened an
> SR with Oracle, but they have not been at all helpful. The response is
> that the upgrade is complete and I just have to run utlrp 4 or 5 times
> within 3 minutes (I tried it, it doesn’t help) and then run the final
> upgrade step manually followed by the time zone upgrade.
>
> I’ve tried that, but it all fails. What I’m looking for is what needs to
> be fixed before starting the upgrade so the error doesn’t occur. I’ve
> tried asking for that and the response was to do the same thing that
> already doesn’t work.
>
>
>
> Any ideas?
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

--
http://www.freelists.org/webpage/oracle-l