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
Copyright (c) 1982, 2008, Oracle. All rights reserved.
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.
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.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
Enter value for em_sql_root: /opt/oracle/app/OracleHomes/oms10g/sysman/admin/emdrep/sql
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
View created.
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 |