Here is the error that I’m facing after upgrading the client from 11.24 to 11.28.
Error :[Rollback segments update failed:[ SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jun 1 16:38:42 2023 Version 19.12.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. SQL> SQL> SQL> SQL> Connected. SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 select distinct 'U,', c.name || ':' || s.tablespace_name from cdb_segments s, v$CONTAINERS c where s.owner in ('SYS', 'SYSTEM') and c.CON_ID = s.CON_ID * ERROR at line 1: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only SQL> SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.12.0.0.0 ].]
I have already added the sORARUNBKPONDBROLE option with value ‘1’. Please help me to fix this issue.
Best answer by Gowri Shankar
View original