11G OCM Upgrade OMR to 11.1.0.7


I have managed to upgrade the OMR to 11.1.0.7 after I had installed the OMR as 10.1.0.4 in 11G OCM Install OEM 10.2.0.5 With New Database.

Automatic Startup of Agent

I updated /etc/rc.local to add the following line before the call to dbstart:

su oracle -c "/opt/oracle/app/OracleHomes/agent10g/bin/emctl start agent"

REPOS Database Upgrade to 11.1.0.7

I upgraded the repos database from 10.1.0.4 to 11.1.0.7 in several stages:

  1. Used OUI to upgrade from 10.1.0.4 to 10.1.0.5 in a manual upgrade via patchset 4505133 (procedure is in Readme.txt).
  2. Used OPatch to apply patch 5632264 for the upgrade of the time zone files (procedure is in Readme.txt).
  3. Installed 11.1.0.6 into a separate home: /opt/oracle/app/OracleHomes/db11g (see Oracle RDBMS 11G 11.1.0.6.0 Installation for original procedure – note new home directory).
  4. Used OPatch to patch this new home to 11.1.0.7 (see 11G OCM OPatch 11.1.0.7 on GRIDCTRL for the procedure)
  5. Used dbua from the 11.1.0.7 home to upgrade the repos database from the patched 10.1.0.5 to 11.1.0.7

Post-Upgrade Steps

Grid Control Target Configuration

I had to delete the repos.yaocm.id.au target from Grid Control and add it back in again to get the correct Oracle home.

Setup of Service Names

I decided against setting up the service names as described in 11G OCM Listener on GRIDCTRL.

RMAN Catalogue Creation

Since I destroyed the original RMAN catalogue when dropped everything in 11G OCM Install OEM 10.2.0.5 With New Database, I had to repeat the procedure in 11G OCM Base Recovery Catalogue:

CREATE SMALLFILE TABLESPACE "RMAN_CATALOG" DATAFILE '/opt/oracle/app/oradata/REPOS/rman_catalog01.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER "RMAN" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "RMAN_CATALOG" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "RECOVERY_CATALOG_OWNER" TO "RMAN";
ALTER USER "RMAN" QUOTA UNLIMITED ON "RMAN_CATALOG";

Status Update

I have now completed steps #5 and #6 of OCM 11G Planning (1).

Advertisements

One thought on “11G OCM Upgrade OMR to 11.1.0.7

  1. 11G OCM Upgrade OMR to 11.1.0.7 (2) « Yet Another OCM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s