Archive for 六月, 2009

ksvcreate: Process(m000) creation failed

星期二, 六月 23rd, 2009
文档ID:418553.1
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2 to 10.2
This problem can occur on any platform.
 
Symptoms
Switching a Physical Standby Database multiple to READ ONLY Mode will report the following Errors in the ALERT.LOG:
 
ksvcreate: Process(m000) creation failed
 
 
Changes
Switch Physical Standby from READ ONLY to apply and back to READ ONLY.
Cause
The Cause of this Problem has been identified in Bug 5583049.
Solution
There are two Workarounds available:
 
Restart the Instance..
or
 
 
Disable ADDM - Should be re-enabled if Standby takes up the Primary Role
          *
Set SGA_TARGET=0 and set shared_pool_size, db_cache_size, etc if using
            
Automatic SGA Memory Management (ASMM)
 
          *
Set STATISTICS_LEVEL=BASIC to disable statistics gathering
 
References
Bug 5583049 - 'KSVCREATE: PROCESS(M000) CREATION FAILED' AFTER STANDBY OPEN RO MULTIPLE TIMES

asm 和Multi-pathing

星期五, 六月 19th, 2009

有关的文档https://metalink2.oracle.com/metalink/plsql/docs/ASM%20multipathing-dec11.pdf

朋友淘宝小店开张,欢迎大家帮忙宣传

星期四, 六月 18th, 2009

朋友淘宝小店开张,欢迎大家帮忙宣传
店址:http://shop58504922.taobao.com/
也请大家多多提提意见,关于页面方面,以方便我们改进,谢谢

mpio and rdac

星期一, 六月 15th, 2009
mpiordac都是AIX系统下的多路径软件,以下说下两者的区别
1AIX 5307以前,系统默认的是RDAC,如果需要安装MPIO需要安装软件:
devices.sddpcm.53.2.1.0.7.bff
devices.sddpcm.53.rte
devices.fcp.disk.ibm.mpio.rte
5307以后6.1 系统默认的是MPIO
MPIO
 
AIX 52TL10SP4
 
AIX 53TL6SP5
 
AIX 53TL7SP2
 
AIX 61TL0SP2 (default mode is MPIO)
2 管理的命令不同 RDACfget_config -av MPIOmpio_get_config
3  MPIO支持一个控制器和一台主机有多条链路,RDAC不支持
会涉及到一些命令
lsdev -C  lscfg -vl cfgmgr manage_disk_drivers fget_config fcstat等等
 
欢迎大家补充

rawutl

星期一, 六月 1st, 2009
最近在实施一套HP-UX IA64 11.31 FOR ORACLE 10.2.0.4RAC时,在DBCA时遇到一个问题,就是rawutl识别LV大小有问题,比如如下日志:
 
[
AWT-EventQueue-0] [4:15:17:462] [OsUtilsBase.getRawDeviceSize:901] cmds: /u01/app/oracle/product/10.2.0/db/bin/rawutl -s /dev/vghis1/rlvol_sysaux_4128
 
[
AWT-EventQueue-0] [4:15:17:514] [OsUtilsBase.getRawDeviceSize:917] size =
 
33554432
 
我实际的
SYSAUX大小为4G,但是ORACLE就认为是32M,你如果你设置超过32M就会报错
 
8G的数据文件,就给我识别了3920M,仔细检查了LV创建脚本,以及底层问题,发现还是不能解决问题,最后只能按照ORACLE提示安装,或者换个数据文件好像也好。安装完了以后resize datafile 就好了,不知道大家遇到过没?可以给个建议,METALINK上也找过,说是几个so有问题,但是改过权限后还是不行