Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

After RU 19.22 was applied, ORA-01219 occurs at each database startup

Database Version 19c with RU 19.22

Microsoft Windows 10

I applied RU 19.22 to my database 19c. Now I see in the alert log, whenever the database is started, error ORA-01219 (database or pluggable database not open: queries allowed on fixed tables or views only). I set an event for this error and culprit statement is

/*

select count(c.source_root_name) from sys.streams$_capture_process c,            sys.streams$_process_params p  where c.capture# = p.process#   and p.process_type = 2   and p.name = :1   and p.value = 'Y'   and bitand(c.flags, 64)= 64 

 

*/

Obviously, this statement is executed, although the database is still in MOUNT state and so the error is triggered. That did not happen until RU 19.21.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center