Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Datapatch for 19.9 DBRU errored when runnning script "?/md/admin/catsem.sql"

Invalid objects


SQL> SELECT owner, object_type, object_name

FROM dba_objects

WHERE status <> 'VALID'; 2 3


OWNER

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

OBJECT_TYPE

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

OBJECT_NAME

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

MDSYS

TYPE

SEM_NODES_ARRAY


MDSYS

TYPE BODY

SEM_GRAPH


SQL> SELECT owner, object_type, object_name

FROM dba_objects

WHERE status <> 'VALID'; 2 3


OWNER

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

OBJECT_TYPE

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

OBJECT_NAME

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

MDSYS

TYPE BODY

SPARQL_SERVICE_IMPL_T

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