DB performance issue – V$BACKUP_PIECE_DETAILS makes issue

Problem Reported:

After installing OEM13C, below query using more temp space and blocking entire CPU

SELECT MEDIA
FROM V$BACKUP_PIECE_DETAILS
WHERE SESSION_KEY=:B3 ANDSESSION_RECID=:B2 ANDSESSION_STAMP=:B1 ANDDEVICE_TYPE = ‘SBT_TAPE’ANDROWNUM= 1


Cause:

Known Bug

Bug 14078947 : SELECT FROM V$RMAN_STATUS VERY SLOW WHEN DATABASE IS OPEN


Environment :

1. OEM 13.2
2. Destination – Oracle 11gR2 cluster Database

Solution / workaround:

1. Need to update bug patch
2. Below metric can be disable from OEM monitoring, since it’s a new metric in OEM13.2

Turn Off “High Availability Media Backup”

Oracle 13c Cluster target addition Error

Problem Reported:
Discovering and promoting targets – Failed to connect to the database. Connection failure may be due to a slow network, or a intervening firewall.

Environment:
Oracle 13c , Getting error while adding Cluster Database

Solution:
Firewall access required for all cluster IP’s , normally DBA’s used to get access for DB listener alone.