Using ‘opatch lsinventory’ show patched is real? (看到的补丁信息真的靠谱么?)

去年在排查SCN 天花板问题修改相关的几个参数时,发现了这个问题,尤其如果是从别人手中接手的数据库,通常从opatch lsinventory 检查数据库的版本和补丁信息,在12C 的版本中也可以使用DBMS_QOPATCH, 但是有一个库发现之前别人挖了个坑实际安装补丁时应试是出错了,但是从opatch lsinventory查看两节点并没有区别 .。。。

,

RHEL(Red Hat) 5/OL (Oracle Linux) 5 is not supported for 12.2,INS-30131 when install oracle DB 12C R2 on OEL5

在OEL5.8 安装12C R2 beta1时 遇到ins-30131错误, 以前在OEL5装过12c R1,这个错误第一次见,错误日志有两个关键字
”[INS-13001] Environment does not meet minimum requirements.
[INS-30131] Initial setup required for the execution of installer validations failed.

,

hpux psu 10.2.0.4.12 遇到的一些小问题

XX电信就是一个急性子,上午决定升级晚上就要实施,下面记录一下HPUX IA64 10.2.0.4.0 PSU […]

OEL5.8 Install RAC Grid 11203 PRVF-5184 : Check of following Udev attributes failed

PRVF-5184 : Check of following Udev attributes of “rac2:/dev/asm-diskc” failed: “[Owner: Found=’root’ Expected=’grid’, Group: Found=’root’ Expected=’asmadmin’, Permissions: Found=’0600′ Expected=’0660′]”

,

11gr2 install database加大AMM内存时INS-35171

Oracle Error :: INS-35171
Target database memory (stringMB) exceeds at least one of the selected nodes available shared memory (string MB).

,

oracle 11g dbca 找不到asm diskgroup的解决办法

昨天在家里的本本虚拟机里配置11G R2 RAC时,GI安装正常,db soft 安装正常,查看资源asm 磁盘也正常,GI是用的GRID 用户及用ASMLIB配置的ASM DISKGROUP.但到最后一步用ORACLE用户DBCA建库时,在储存选择ASM,无法找到ASMDISKGROUP?

, , ,

Initializing the Oracle ASMLib driver: [FAILED] on RHEL5.1 asmlib安装详情

Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [FAILED]
log:modprobe: FATAL: Module oracleasm not found.

,

grid control 安装总结 (三)之EMD upload error: uploadXMLFiles skipped或忘记OMS密码

[oracle@anbob agent10g]$ bin/emctl upload agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

,

grid control 安装总结 (二)之agentDownload.linux安装AGNET

前一篇提到AGENT的多种安装方式中,如果平台一致最容易的安装方法就是使用agentDownload.linux

grid control 安装总结 (一)

grid control (网格)管理 多个数据库时可以大大提高DBA 的工作效率,当然也有人说会给系统带来一些影响比如引起BUG,从而望而却步,不过ORACLE的 不断的完善还是很让人期待

oracle 9201升级到9208 for windows 步骤

今天有网友说他的数据库服务今天又自动停了,以前也说过查看alert日志并没报错,stackpack也看不出什么 […]

ASMLib and OCFS2在RHEL6不再免费支持

Doc ID 1089399.1: ”For RHEL6 Oracle will only provide ASMLib software and updates via Unbreakable Linux Network(ULN). Oracle will no longer provide ASMLib packages for Red Hat kernels.”

installing oracle 11g r2, No space left on device /tmp

Error in writing to directory /tmp/OraInstall2011-09-17_10-02-06PM. Please ensure that this directory is writable and has atleast 60 MB of disk space.

oracle 9i dbca 报错invalid entrysize(expected xxx but got xxx) 解决方法

今天装oracle 9.2, DBCA用模板建库时提示invalid entrysize( expected ,,其实模板建库就是一个rman 恢复的过程,不知道这是哪块内存区设小了,google了一下发现很多同样的经历