I have managed to upgrade the OMR to 18.104.22.168 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 22.214.171.124
I upgraded the
repos database from 10.1.0.4 to 126.96.36.199 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 188.8.131.52 into a separate home:
/opt/oracle/app/OracleHomes/db11g(see Oracle RDBMS 11G 184.108.40.206.0 Installation for original procedure – note new home directory).
- Used OPatch to patch this new home to 220.127.116.11 (see 11G OCM OPatch 18.104.22.168 on GRIDCTRL for the procedure)
dbuafrom the 22.214.171.124 home to upgrade the
reposdatabase from the patched 10.1.0.5 to 126.96.36.199
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).