Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AutoUpgrade returns errors on PDB$SEED

User_A7RKTSep 5 2020 — edited Sep 14 2020

Hi guys,

I am upgrading a Logical Standby database from 12c R2 to 19c on Linux 7 using AutoUpgrade.

Every thing went fine until I reached to the point of running the AutoUpgrade on Deploy mode.

The utility worked fine for nearly an hour and ended with the following error:

Errors in database [oradb2]

Stage     [POSTFIXUPS]

Operation [STOPPED]

Status    [ERROR]

Info    [

Error: UPG-1604

Errors executing [alter session set container=PDB$SEED;

Cause: Error executing a database command

For further details, see the log file located at /home/oracle/scripts/autoupgrade/oradb2/102/autoupgrade_20200905_user.log]

-------------------------------------------------

Logs: [/home/oracle/scripts/autoupgrade/oradb2/102/autoupgrade_20200905_user.log]

-------------------------------------------------

The log file reports the following error:

2020-09-05 22:47:24.988 ERROR Dispatcher failed: AutoUpgException [UPG-1603#oracle.upgrade.autoupgrade.utils.errors.AutoUpgException: AutoUpgException [UPG-1604#Errors executing [alter session set container=PDB$SEED;

alter session set "_oracle_script"=true;

alter pluggable database close immediate force instances=all;

alter pluggable database open read write instances=all;

Warning: PDB altered with errors.] [PDB$SEED]]]

2020-09-05 22:47:24.992 INFO Starting error management routine

2020-09-05 22:47:24.997 INFO Ended error management routine

2020-09-05 22:47:24.998 ERROR Error running dispatcher for job 102

Cause: Error executing a database command

2020-09-05 22:47:24.998 ERROR Dispatcher failed:

Error: UPG-1604

Errors executing [alter session set container=PDB$SEED;

The alert log file of the database contains the following error:

PDB$SEED(2):Undo initialization finished serial:0 start:8825641 end:8825809 diff:168 ms (0.2 seconds)

PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8

Violations: Type: 1, Count: 1

PDB$SEED(2):***************************************************************

PDB$SEED(2):WARNING: Pluggable Database PDB$SEED with pdb id - 2 is

PDB$SEED(2):         altered with errors or warnings. Please look into

PDB$SEED(2):         PDB_PLUG_IN_VIOLATIONS view for more details.

PDB$SEED(2):***************************************************************

2020-09-05T22:47:24.254992+04:00

PDB$SEED(2):Opening pdb with no Resource Manager plan active

PDB$SEED(2):joxcsys_required_dirobj_exists: directory object exists with required path /u01/app/oracle/product/19.0.0/db_1/javavm/admin/, pid 18241 cid 2

Pluggable database PDB$SEED opened read write

PDB$SEED(2):Completed: alter pluggable database open read write instances=all

2020-09-05T22:59:12.290514+04:00

When I try to login to the database, I see it shutdown.

[oracle@srv1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Sep 5 23:06:43 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1073741824 bytes

Fixed Size                  8801008 bytes

Variable Size             440403216 bytes

Database Buffers          616562688 bytes

Redo Buffers                7974912 bytes

ORA-00205: error in identifying control file, check alert log for more info

Any idea on handling the issue?

This post has been answered by User_A7RKT on Sep 7 2020
Jump to Answer

Comments

jariola
Answer

You can grid edit all interactive repots settings.
Go edit your application and then navigate to Utilities -> Region Utilities -> Update Interactive Report Settings

Marked as Answer by Chandler Bing · Sep 30 2022
Chandler Bing

hi @jariola ,
I checked that and again there is check and uncheck option for each page but yes its fast from go to disable through pages, but is there any other option like just one check box disabled all.
btw thanks for the reply!!!

jariola

but is there any other option like just one check box disabled all.
No, there isn't at least supported way

Chandler Bing

@jariola hi is there same option available for interactive grid ?

jariola

@jariola hi is there same option available for interactive grid ?
Seems there isn't. That would be useful feature.
You could fill feature request about it
https://apexapps.oracle.com/pls/apex/apex_pm/r/ideas/home

Chandler Bing

thanks @jariola

1 - 6

Post Details

Added on Sep 5 2020
14 comments
2,933 views