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