Database Administration (MOSC)

MOSC Banner

Registry Module invalid after installation from DATABASE RELEASE UPDATE 19.9.0.0.0

SQL> shutdown immediate;

SQL> startup restrict

SQL> @?/rdbms/admin/catalog.sql

SQL> @?/rdbms/admin/catproc.sql

SQL> @?/rdbms/admin/utlrp.sql

SQL> SELECT comp_name, status, version FROM dba_registry where STATUS not like 'VALID';

COMP_NAME                                    STATUS                          VERSION

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

Oracle Database Packages and Types           VALID                         19.0.0.0.0


there are still invalid objects:

ALERT_TYPE                      TYPE                   SYS

AQ$_AGENT                       TYPE                   SYS

AQ$_DEQUEUE_HISTORY             TYPE                   SYS

AQ$_DEQUEUE_HISTORY_T           TYPE                   SYS

AQ$_EVENT_MESSAGE               TYPE                   SYS

AQ$_EVENT_MESSAGE               TYPE                   SYS

AQ$_HISTORY                     TYPE                   SYS

AQ$_JMS_BYTES_MESSAGE           TYPE                   SYS

AQ$_JMS_BYTES_MESSAGES          TYPE                   SYS

AQ$_JMS_HEADER                  TYPE                   SYS

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