RMAN Recovery Catalog Issues after 12.2 Upgrade

Well, after the upgrade of the DB to 12.2 the next step is to upgrade the RMAN Recovery Catalog to the same version in order to be able to run backups using it. The process is pretty straight forward..    Connect to RMAN using target and catalog.    Execute upgrade catalogRMAN> upgrade catalog;This finishes correctly. But then… Continue reading RMAN Recovery Catalog Issues after 12.2 Upgrade

Upgrade OPatch for OEM 13c R2 Agents

Opatch utility has to be updated often as Oracle delivers regular updates to it. I was used to version 12 and it only required an overwrite of the OPatch directory. Well, not anymore with version 13c R2.I will walk you through an OPatch upgrade from 13.8 to 13.9 version.First export your agent ORACLE_HOME: $: export… Continue reading Upgrade OPatch for OEM 13c R2 Agents

How to upgrade the RMAN recovery catalog to 12c?

Some days back I faced an issue while trying to upgrade the RMAN recovery catalog to support 12c databases.RMAN> upgrade catalog;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-07539: insufficient privileges to create or upgrade the catalog schemaThe problem is that for 12c the catalog owner requires additional privileges. The solution is to run the… Continue reading How to upgrade the RMAN recovery catalog to 12c?

Upgrade Oracle Enterprise Manager to 12.1.0.4

Enterprise Manager 12.1.0.4 was just released and now is time to test and document the process. The official documentation can be obtained from here (http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/upgrading_12101_PS1_gtgstrtd.htm) and this document cover the steps I followed and may not work on yours (I’m not responsible of any issues/problems caused to your system).This document covers Oracle Enterprise Manager upgrade… Continue reading Upgrade Oracle Enterprise Manager to 12.1.0.4