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