"opatch lsinventory -inactive" shows many inactive patches.Large number of inactive patches can slow down the opatch apply process.Issue still reproduce after executing "opatch util deleteinactivepatches" in this case opatch.properties:retain was set to retain=2.There is also known issue with certain oracle homes where there are more than 1 inactive PSU or RU, a user needs to…

Make DBA Life Easy Blog

30.11.2024

ORA-01157 When Standby Database Open Read Only – Make DBA Life Easy

The following errors occur when trying to open a standby database read only: SQL> alter database open read only;alter database open read only*ERROR at line 1:ORA-10458: standby database requires recoveryORA-01157: cannot identify/lock data file 1 - see DBWR trace fileORA-01110: data file 1: '+DATA2/TESTDB/DATAFILE/system.3203.1186181325' When checking ASM file for SYSTEM tablespace, the file exists but…

Make DBA Life Easy Blog

30.11.2024

RMAN-06023 Although Backups Are Available – Make DBA Life Easy

'RMAN RESTORE DATABASE' command fails with the following errors by using a backup control file: RMAN-00571: ==================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ======== RMAN-00571: ==================================================== RMAN-03002: failure of restore command at 21/11/2024 11:09:9 RMAN-06026: some targets not found - aborting restore ....RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no…

Make DBA Life Easy Blog

31.12.2024

13c OEM Information Publisher Reports: Error rendering element. Exception: ORA-00942: table or view does not exist – Make DBA Life Easy

When using the OEM Reporting System you are limited to access the repository only (MGMT_VIEW). So, the solution is to grant select on schema.table_name to MGMT_VIEW. You need give a read permission to MGMT_VIEW. grant select on sysman.TABLE_NAME to MGMT_VIEW; This will help you remove the error while reporting the data from OEM Information publisher.

home›Make DBA Life Easy Blog

Make DBA Life Easy Blog

Software

Opatch or Opatchauto takes long time Due to High Number of Inactive Patches – Make DBA Life Easy

ORA-01157 When Standby Database Open Read Only – Make DBA Life Easy

RMAN-06023 Although Backups Are Available – Make DBA Life Easy

13c OEM Information Publisher Reports: Error rendering element. Exception: ORA-00942: table or view does not exist – Make DBA Life Easy

home
›
Make DBA Life Easy Blog