I have managed to upgrade the OMR to 22.214.171.124 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
/etc/rc.local to add the following line before the call to
su oracle -c "/opt/oracle/app/OracleHomes/agent10g/bin/emctl start agent"
REPOS Database Upgrade to 126.96.36.199
I upgraded the
repos database from 10.1.0.4 to 188.8.131.52 in several stages:
- 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).
- Used OPatch to apply patch 5632264 for the upgrade of the time zone files (procedure is in Readme.txt).
- Installed 184.108.40.206 into a separate home:
/opt/oracle/app/OracleHomes/db11g(see Oracle RDBMS 11G 220.127.116.11.0 Installation for original procedure – note new home directory).
- Used OPatch to patch this new home to 18.104.22.168 (see 11G OCM OPatch 22.214.171.124 on GRIDCTRL for the procedure)
dbuafrom the 126.96.36.199 home to upgrade the
reposdatabase from the patched 10.1.0.5 to 188.8.131.52
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
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";
I have now completed steps #5 and #6 of OCM 11G Planning (1).