-
编辑 删除
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
-
编辑 删除
大分区表创建索引，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
-
编辑 删除
Oracle 10g Dynamic Performance v$ view
Oracle 10g Dynamic Performance v$ view[@more@]
