Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

datapatch first time on a CDB 12.2

DBD::Oracle::db prepared failed: ORA-00942: table or view does not exist

select .... from dba_registry

from line 1365 in the $ORCLE_HOME/sqlpatch/sqlpatch.pm script

the dba registry_sqlpatch is empty because this is the first time running the OPatch

registry$sqlpatch empty

  • I ran catproc and utlrp
  • there are no invalid objects
  • dba_registry table its compaining about is there with 5 rows.

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