Create CDB Error: Signature of package “SYS.DBMS_BACKUP_RESTORE” has been changed

The following errors occur when creating a CDB database with patch level 19.23.

ERROR=RMAN-00571: =======================================================
ERROR=RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS 
ERROR=RMAN-00571: ============================================
ERROR=ORA-04062: signature of package "SYS.DBMS_BACKUP_RESTORE" has been changed

SEVERE: [FATAL] Error while restoring PDB backup piece
oracle.sysman.assistants.util.step.StepExecutionException: Error while restoring PDB backup piece

WORKAROUND

As a workaround, by selecting the “Custom database” option instead of “General Purpose Database”.

PL/SQL package SYS.DBMS_BACKUP_RESTORE version PL/SQL package SYS.DBMS_RCVMAN version in TARGET database is not current

Try to connect to RMAN catalog with the following errors:

PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.20.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.20.00.00 in TARGET database is not current
connected to target database: TESTDB (DBID=1231118758)
connected to recovery catalog database

CAUSE

Once the DBRU/DBRUR is applied datapatch was not run. While DBRU/DBRUR will update the binary datpatch would ensure the dictionary are also updated

SOLUTION

Crosscheck if datapatch was run.

SET PAGESIZE 100
SET LINESIZE 300
COLUMN status FORMAT A10
COLUMN description FORMAT A40
COLUMN source_version FORMAT A10
COLUMN target_version FORMAT A10

select CON_ID,
TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
PATCH_ID,
PATCH_TYPE,
ACTION,
DESCRIPTION,
SOURCE_VERSION,
TARGET_VERSION
from CDB_REGISTRY_SQLPATCH
order by CON_ID, action_time, patch_id;

Run datapatch if it was not run:

$ORACLE_HOME/OPatch/datapatch -verbose

select * from pdb_plug_in_violations where status <> 'RESOLVED';

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sq

EM GC_Domain OHS Target Alerts with Error: “The Percentage Of Requests That Resulted In Errors Is X%”

The OHS log at <GC_INST>/user_projects/domains/GCDomain/servers/ohs1/logs/ohs1.log shows messages like the following:

[2018-08-07T10:37:08.5618-05:00] [OHS] [ERROR:32] [] [core.c] [client_id: <client ip address>] [host_id: <OMS hostname>] [host_addr: <OMS IP address>] [tid: 140073893857024] [user: oracle] [ecid: 0000MIjGpMU3b6M5mNT4iZ1RHes^00000F] [rid: 0:5701] [VirtualHost: <OMS hostname>:0] client denied by server configuration: <PATH TO $GC_INST>/WebTierIH1/config/OHS/ohs1/htdocs/empbs

Cause

One of the agents was trying to upload data to the EM repository using the unlocked http url, and the EM OMS upload repository is locked.

The agent can be found by using the client IP address in the ohs1.log file, as indicated here: [client_id: <client ip address>]

Solution

Secure that agent on the machine identified by that IP address by running:

emctl secure agent

This will prompt for the registration password. If you or your administrators do not have this password one can be set following this note: Note 1367946.1 – Enterprise Manager Cloud Control Security: How to Create or Edit the Agent Registration Password for Agent to OMS Secure Communication

ORA-14473: Mapping table cannot be dropped while there are failed online partition maintenance

Potential Reason: Rollback is still undergoing for a failed table rebuilding or table removing to new tablespace, etc.

ORA-00054: resource busy and acquire with NOWAIT

To check which session is holding the object:

select a.inst_id, sid, serial#, username, machine  
from gv$session a, gv$locked_object b, dba_objects c
where b.object_id = c.object_id
and a.sid = b.session_id
and a.inst_id=b.inst_id
and OBJECT_NAME='TABLENAME';


INST_ID SID   SERIAL#  USERNAME    MACHINE    OWNER      OBJECT_NAME          
------- ----- ------- ---------- -----------  ---------- ------------- 
2       3365  42069      SYS      TESTSERVER  TESTUSER   TABLENAME

Kill the session, then the error should disappear.