Tag Archives: DBA_REGISTRY_HISTORY

PSU补丁安装不全的问题

Posted on 2011/08/23 by yangtingkun

对于PSU补丁的安装，不是简单的opatch apply之后就完成了，还需要运行特定的sql。 在客户数据库中检查补丁情况，发现安装PSU只完成了第一步： fgms:/fgms/oracle/tru64_setupFile/OPatch > ./opatch lsinventory Invoking OPatch 10.2.0.5.0 Oracle Interim Patch Installer version 10.2.0.5.0 Copyright (c) 2010, Oracle Corporation. All rights reserved. Oracle Home : /fgms/oracle10g/db Central Inventory : /fgms/oracle/oraInventory from : /var/opt/oracle/oraInst.loc OPatch version : 10.2.0.5.0 OUI … Continue reading →

Posted in ORACLE | Tagged , , , | Leave a comment

检查数据库CPU和PSU补丁信息

Posted on 2011/08/19 by yangtingkun

简单描述如何检查当前数据库的CPU和PSU补丁安装情况。 正常情况下有两种方法，一种是登录数据库检查DBA_REGISTRY_HIST视图： MODDB2:[/home/oracle]$sqlplus / AS sysdba SQL*Plus: Release 10.2.0.4.0 – Production ON Thu Aug 18 13:04:43 2011 Copyright (c) 1982, 2007, Oracle. ALL Rights Reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production WITH the Partitioning, … Continue reading →

Posted in ORACLE | Tagged , , , | 3 Comments