Tag Archives: DBA_REGISTRY_HISTORY

PSU补丁安装不全的问题

对于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补丁信息

简单描述如何检查当前数据库的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