-
编辑 删除
Vertica分布式数据库
Item Limit Number of nodes Maximum 128 (without Vertica assistance). Database size Approximates the number of files times the ...
-
编辑 删除
ORA-15040, ORA-15066, ORA-15042 when ASM disk is not present in all nodes of a R
In this Document Symptoms 10.2.0.2 and below 10.2.0.3 and above Cause 10.2.0.2 and below 10.2.0.3 and above Solution 10.2.0.2 and below 10.2.0.3 and above How to verify the disk is present i...
-
编辑 删除
Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]
Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1] 修改时间 04-JUN-2012 类型 BULLETIN 状态 PUBLISHED In this DocumentPurposeScopeDetails Start up sequence: Cluster status Case 1: OHASD doe...
-
编辑 删除
ORA-15040, ORA-15066, ORA-15042 when ASM disk is not present in all nodes of a Rac Cluster. Adding a
In this Document Symptoms 10.2.0.2 and below 10.2.0.3 and above Cause 10.2.0.2 and below 10.2.0.3 and above Solution 10.2.0.2 and below 10.2.0.3 and above How to verify the disk is present in all the nodes of the cluster. References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.2 - Release: 10.1 to 10.2Information in this document applies to any platform. Symptoms Environments running RAC and ASM, b
-
编辑 删除
<转载>iostat 输出解析
iostat 输出解析 ===============1. /proc/partitions对于kernel 2.4, iostat 的数据的主要来源是 /proc/partitions，而对于kernel 2.6, 数据主要来自/proc/diskstats或者/sys/block/[block-device-name]/stat。先看看 /proc/partitions 中有些什么。# cat /proc/partitionsmajor minor #blocks name rio rmerge rsect ruse wio wmerge wsect wuse running use aveq 3 0 19535040 hda 12524 31127 344371 344360 12941 25534 308434 1097290 -1 15800720 28214662 3 1 7172991 hda1 13 71 168 140 0 0 0 0 0 14
-
编辑 删除
大分区表创建索引，27亿条记录，记录一下
该分区表的大小为352G，在该分区表上创建一个单键值索引create index idx_pres_tdr_starttime on pres_tdr(starttime) local;Index createdElapsed: 01:23:35.32索引大小为27G如果加上nologging参数应该会快些，改天测试下[@more@]
-
编辑 删除
Oracle 10g RAC启动节点报错 Default gateway is not defined
安装配置好RAC之后，启动节点1报错。[oracle@rac1 racg]$ srvctl start nodeapps -n rac1rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=rac1.kevin.com)rac1:ora.rac1.vip:Interface eth0 checked failed (host=rac1.kevin.com)rac1:ora.rac1.vip:Invalid parameters, or failed to bring up VIP (host=rac1.kevin.com)rac1:ora.rac1.vip:checkIf: Default gateway is not defined (host=rac1.kevin.com)rac1:ora.rac1.vip:Interface eth0 checked failed (host=rac1.kevin.com)rac1:ora.rac1.vip:Invalid parameters
-
编辑 删除
Oracle 10g RAC安装过程中，运行root.sh报错error while loading shared libraries: libpthread.so.0
OS：Redhat Linux AS5在节点2上运行root.sh报错，红色字部分[root@rac2 crs]# /u01/crs/oracle/product/10.2.0/crs/root.shWARNING: directory '/u01/crs/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/crs/oracle/product' is not owned by rootWARNING: directory '/u01/crs/oracle' is not owned by rootWARNING: directory '/u01/crs' is not owned by rootWARNING: directory '/u01' is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating i
-
编辑 删除
RAC环境下oracle用户环境变量问题引起数据库无法启动
Oracle 10g RAC+ASM启动node1正常，启动node2发现ASM实例已经启动，但node2的数据库没有启动，在node2上sqlplus / as sysdba登录数据库[oracle@rac2 ~]$sqlplus / as sysdbaSQL>startupORACLE instance started.Total System Global Area 184549376 bytesFixed Size 1218412 bytesVariable Size 96471188 bytesDatabase Buffers 83886080 bytesRedo Buffers 2973696 bytesDatabase mounted.Database opened.数据库可以正常启动，但为什么在启动系统的时候不能自动启动了。检查
-
编辑 删除
使用 VMware Workstation 在 Oracle Enterprise Linux 上安装 Oracle RAC 10g
在网上看到很多文章都是说在vmware server 2.0+rhel 4下实现的oracle 10g RAC，都不推荐使用vmware workstation，原因是共享磁盘有问题，以下是我在vmware workstation 7下成功实现oracle 10g RAC的一些记录。我的操作系统：win7 （32bit）2G内存，每个虚拟机配置700M内存。准备条件：vmware workstation 7 RedHat AS4.6 oracle 10g ocfs2-2.6.9-67.ELsmp-1.2.9-1.el4.i686.rpm ocfs2console-1.2.7-1.el4.i386.rpm ocfs2-tools-1.2.7-1.el4.i386.rpm oracleasm-2.6.9-67.ELsmp-2
-
编辑 删除
数据库关闭情况下删除数据文件导致启动错误：ORA-01157
ORA-01157: 无法标识/锁定数据文件 21 - 请参阅 DBWR 跟踪文件 ORA-01110: 数据文件 21: 'D:RONGHAIRONGHAI2.SQL'。解决办法：以dba身份登录，1、alter database datafile 'D:RONGHAIRONGHAI2.SQL' offline drop如删除多个文件，重复以上步骤。2、shutdown immediate3、startup[@more@]
-
编辑 删除
dmp文件损坏导致ORA-39014 ORA-39029 ORA-31693错误
不知道这样写标题对不对，本来是通过FTP将dmp文件从A机器上传到B机器再导入，因为数据库有几十个G，就采用了并行导出，分成了四个文件。在导入将近结结束时出现了以下错误：ORA-39014: 一个或多个 worker 进程已过早地退出。ORA-39029: worker 进程 3 (进程名为 "DW06") 过早地终止ORA-31671: Worker 进程 DW06 有未处理的异常错误。ORA-00600: 内部错误代码, 参数: [kupfioReadBuffer], [bufDes], [0xCEC37E0], [blksRead], [0], [], [], []ORA-06512: 在 "SYS.KUPW$WORKER", line 1397ORA-06512: 在 line 2作业 &qu
-
编辑 删除
Linux as5 单用户启动方法
单用户适用于对系统进行维护和忘记root密码时可以使用启动linux，出现GRUB界面时按回车进入GRUB启动菜单按e编辑启动项，进入下级菜单之后，再编辑kernel /vmlinuz-2.6.18-8.e15 ro root=/dev/VolGroup00/LogVo100 rhgb quit,并修改成kernel /vmlinuz-2.6.18-8.e15 ro root=/dev/VolGroup00/LogVo100 single quit[@more@]
-
编辑 删除
很不错的桌面的便签工具（ATnotes）
很不错的桌面的便签工具,帮你记录要处理的事情。下载地址：ATnotes[@more@]
-
编辑 删除
Oracle 10g Dynamic Performance v$ view
Oracle 10g Dynamic Performance v$ view[@more@]
