03 Patch GRIDCTRL

Check OMS Current Patch Level

In the OMS home on GRIDCTRL, opatch lsinventory reveals, in part:

Invoking OPatch 10.2.0.4.5
Oracle Interim Patch Installer version 10.2.0.4.5
Copyright (c) 2008, Oracle Corporation. All rights reserved.
Oracle Home : /opt/oracle/app/OracleHomes/oms10g
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.5
OUI version : 10.2.0.5.0
OUI location : /opt/oracle/app/OracleHomes/oms10g/oui
Log file location : /opt/oracle/app/OracleHomes/oms10g/cfgtoollogs/opatch/opatch2012-07-30_15-18-40PM.log

Patch history file: /opt/oracle/app/OracleHomes/oms10g/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /opt/oracle/app/OracleHomes/oms10g/cfgtoollogs/opatch/lsinv/lsinventory2012-07-30_15-18-40PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):

Enterprise Manager Patchset 10.2.0.5.0
Oracle Enterprise Manager Grid Console 10.2.0.1.0
There are 2 products installed in this Oracle Home.

So, I am running OEM 10.2.0.5, not an earlier version as I feared in 02 Problem Installing VM Manager.

Download Patch

The relevant Oracle Support document is How to Enable Oracle VM Management Pack in EM Grid Control 10.2.0.5 [ID 1125013.1].

I downloaded the patch, 9714260, and staged it via OEM into /opt/oracle/app/OracleHomes/oms10g/EMStagedPatches/9714260/9714260/.

Update OPatch

The README file for patch 9714260 says that:

To apply this patch, OPatch 10.2.0.4.7 or greater is required.

Unfortunately, I am using OPatch 10.2.0.4.5. Missed it by that much!

The README file points to OPatch - Where Can I Find the Latest Version of OPatch? [Video] [ID 224346.1].

Downloaded Patch 6880880.

pscp p6880880_102000_LINUX.zip oracle@192.168.1.252:/tmp

On GRIDCTRL,

[oracle@gridctrl oms10g]$ mv OPatch OPatch_10_2_0_4_5
[oracle@gridctrl oms10g]$ unzip -d . /tmp/p6880880_102000_LINUX.zip
Archive: /tmp/p6880880_102000_LINUX.zip
creating: ./OPatch/
…
[oracle@gridctrl oms10g]$ cd OPatch
[oracle@gridctrl OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.5.1

OPatch is added to path, and confirmed set up of Software Library.

[oracle@gridctrl OPatch]$ echo $PATH
/opt/oracle/app/OracleHomes/oms10g/OPatch:/opt/oracle/app/OracleHomes/oms10g/bin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
[oracle@gridctrl OPatch]$ which opatch
/opt/oracle/app/OracleHomes/oms10g/OPatch/opatch
[oracle@gridctrl OPatch]$ PARDeploy -check
Software Library is setup

Post Apply Script

OPatch worked fine, but the post apply SQL script failed with the following messages:

[oracle@gridctrl 9714260]$ . oraenv
ORACLE_SID = [oms] ? repos
[oracle@gridctrl 9714260]$ sqlplus sysman

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Jul 30 23:04:35 2012

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning option

SQL> @post_install_script.sql

Repository Owner: SYSMAN
job_queue_processes value before running post_install_script
---------------- ---------------
SID Job Queue value
---------------- ---------------
repos 10

PL/SQL procedure successfully completed.

SP2-0310: unable to open file "/opt/oracle/app/OracleHomes/db11g/sysman/admin/emdrep/sql/vt/latest/virtualization/ovm_admin_oper_pkgbody.sql"
SP2-0310: unable to open file "/opt/oracle/app/OracleHomes/db11g/sysman/admin/emdrep/sql/vt/latest/virtualization/virtualization_views.sql"
SP2-0310: unable to open file "/opt/oracle/app/OracleHomes/db11g/sysman/admin/emdrep/sql/vt/upgrade/vt-bug-9650239.sql"

PL/SQL procedure successfully completed.

job_queue_processes value after running post_install_script
---------------- ---------------
SID Job Queue value
---------------- ---------------
repos 10

PL/SQL procedure successfully completed.

However, these three (3) missing files exist in other directories, one of which is:

SQL> !pwd
/opt/oracle/app/OracleHomes/oms10g/EMStagedPatches/9714260/9714260

SQL> !ls -l files/sysman/admin/emdrep/sql/vt/latest/virtualization/ovm_admin_oper_pkgbody.sql

-rw-rw-r-- 1 oracle oinstall 25092 Jun 15 2010 files/sysman/admin/emdrep/sql/vt/latest/virtualization/ovm_admin_oper_pkgbody.sql
SQL> !ls -l files/sysman/admin/emdrep/sql/vt/latest/virtualization/virtualization_views.sql

-rw-rw-r-- 1 oracle oinstall 18187 Jun 15 2010 files/sysman/admin/emdrep/sql/vt/latest/virtualization/virtualization_views.sql

SQL> !ls -l files/sysman/admin/emdrep/sql/vt/upgrade/vt-bug-9650239.sql
-rw-rw-r-- 1 oracle oinstall 2192 Jun 15 2010 files/sysman/admin/emdrep/sql/vt/upgrade/vt-bug-9650239.sql

Based on no real knowledge, I just decided to run these procedures to see what happens:

SQL> @files/sysman/admin/emdrep/sql/vt/latest/virtualization/ovm_admin_oper_pkgbody.sql

Package body created.

No errors.
SQL> @files/sysman/admin/emdrep/sql/vt/latest/virtualization/virtualization_views.sql
Enter value for em_sql_root: /opt/oracle/app/OracleHomes/oms10g/sysman/admin/emdrep/sql

View created.

Enter value for em_sql_root: /opt/oracle/app/OracleHomes/oms10g/sysman/admin/emdrep/sql

View created.

SQL> @files/sysman/admin/emdrep/sql/vt/upgrade/vt-bug-9650239.sql

PL/SQL procedure successfully completed.

02 Problem Installing VM Manager

04 Finish OEM Virtualisation Intallation