Category Archives: ORACLE

所有Oracle技术文章

ORA-600(qerrmOStart2)错误

Posted on 2012/05/15 by yangtingkun

客户11.2.0.2 RAC for Solaris 10出现ORA-600错误。 错误信息为： Fri May 11 14:22:45 2012 Errors IN file /oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_25552.trc (incident=194913): ORA-00600: 内部错误代码, 参数: [qerrmOStart2], [1740], [ORA-01740: 标识符中缺失双引号 ], [], [], [], [], [], [], [], [], [] Incident details IN: /oracle/diag/rdbms/orcl/orcl2/incident/incdir_194913/orcl2_ora_25552_i194913.trc Fri May 11 … Continue reading →

Posted in BUG | Tagged , , , , , , | Leave a comment

ORA-600(qkaffsindex5)错误

Posted on 2012/05/14 by yangtingkun

客户11.2.0.2 RAC for Solaris10上的错误。 错误信息为： 2012-05-04 22:00:04.768000 +08:00 BEGIN automatic SQL Tuning Advisor run FOR special tuning task "SYS_AUTO_SQL_TUNING_TASK" 2012-05-04 22:00:17.279000 +08:00 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j002_5730.trc (incident=231810): ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

ORA-7445(dbgrlWriteAlertDetail_int)和ORA-4030导致实例崩溃

Posted on 2012/05/13 by yangtingkun

客户11.2.0.2 RAC for Solaris 10 sparc单实例出现ORA-7445和ORA-4030操作，导致实例崩溃。 这个错误比较严重： 2012-05-04 02:02:26.403000 +08:00 Archived Log entry 949 added FOR thread 1 SEQUENCE 518 ID 0x70a64e83 dest 1: Archived Log entry 950 added FOR thread 1 SEQUENCE 519 ID 0x70a64e83 dest 1: Thread 1 … Continue reading →

Posted in BUG | Tagged , , , , , , , , | Leave a comment

ORA-600(ksnpost:ksnigb)错误

Posted on 2012/05/12 by yangtingkun

客户10.2.0.5 RAC for HP-UX ia64出现ORA-600(ksnpost:ksnigb)的错误。 错误信息如下： Wed Apr 25 16:32:21 UTC 2012 Errors IN file /oracle/app/admin/orcl/bdump/orcl2_ora_17014.trc: ORA-00600: Message 600 NOT found; No message file FOR product=RDBMS, facility=ORA; arguments: [ksnpost:ksnigb] Wed Apr 25 16:32:55 UTC 2012 Trace dumping IS performing id=[cdmp_20120425163255] … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

在线索引重建被取消导致大量ORA-600(kghstack_underflow_internal_3)错误

Posted on 2012/05/11 by yangtingkun

客户在比较繁忙的时刻执行了索引的REBUILD操作，导致大量会话被锁，最终对ONLINE REBUILD操作执行了取消操作，引发了一系列更严重的ORA-600错误。 登录数据库后，发现两个节点上ORACLE_BASE所在目录都已经100%占用。数据库无法正常通过/ AS SYSDBA方式登录。 查询告警日志发现大量的ORA-600和ORA-7445错误： Tue May 08 21:20:26 EAT 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl2_ora_1555.trc: ORA-07445: exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalid permissions FOR mapped object] [0x000000000] [] [] Tue May 08 21:20:27 EAT 2012 Errors IN file … Continue reading →

Posted in ORACLE | Tagged , , , , , , , | Leave a comment

RAC环境启动单实例报错ORA-1105

Posted on 2012/05/10 by yangtingkun

客户的4节点RAC环境，其中一个节点实例出现故障，发现无法正常启动。 检查CLUSTER和告警日志信息，发现节点1心跳超时，被踢出集群。服务器重新启动后，数据库实例没有自动启动。 告警日志信息为： Mon Apr 16 03:42:39 2012 Thread 1 advanced TO log SEQUENCE 22348 (LGWR switch) CURRENT log# 16 seq# 22348 mem# 0: +DATA/orcl/onlinelog/group_16.291.766326571 CURRENT log# 16 seq# 22348 mem# 1: +DATA/orcl/onlinelog/group_16.293.766330969 Mon Apr 16 15:02:58 2012 Starting ORACLE … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

10G开始Oracle区分物化视图和表

Posted on 2012/05/09 by yangtingkun

在9i以前，很多功能都是不区分表和物化视图的区别的，到了10g以后。很多功能会将表和物化视图区分对待。 原本通用的COMMENT ON TABLE语句，对物化视图不再有效，必须要使用COMMENT ON MATERIALIZED VIEW语句代替。 SQL> SELECT * FROM V$VERSION; BANNER —————————————————————- Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 – 64bi PL/SQL Release 10.2.0.4.0 – Production CORE 10.2.0.4.0 Production TNS FOR Linux: Version 10.2.0.4.0 – Production NLSRTL Version … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

ORA-600(qertbFetchByRowID)错误

Posted on 2012/05/08 by yangtingkun

以前也碰到过这个错误，不过由于无法直接连接数据库，没有办法深入分析。这次虽然同样没有办法连接数据库，但是获取了更详细的信息，基本确定导致问题的原因。 错误信息如下： Wed May 09 10:41:32 2012 Errors IN file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], [], [], [], [], []Wed May 09 10:41:32 2012 Errors in file /oracle/admin/orcl/udump/orcl_ora_423466.trc: ORA-00600: internal error code, arguments: [qertbFetchByRowID], [], [], … Continue reading →

Posted in BUG | Tagged , , , , | Leave a comment

安装ORACLE时在Linux上设置内核参数的含义

Posted on 2012/05/07 by yangtingkun

前两天看到一篇Redhat官方的Oracle安装文档，对于Linux内核参数的修改描述的非常清晰。 安装Oracle之前，除了检查操作系统的硬件和软件是否满足安装需要之外，一个重点就是修改内核参数，其中最主要的是和内存相关的参数设置。 SHMMAX参数：Linux进程可以分配的单独共享内存段的最大值。一般设置为内存总大小的一半。这个值的设置应该大于SGA_MAX_TARGET或MEMORY_MAX_TARGET的值，因此对于安装Oracle数据库的系统，shmmax的值应该比内存的二分之一大一些。 # grep MemTotal /proc/meminfo # cat /proc/sys/kernel/shmmax# grep MemTotal /proc/meminfo # cat /proc/sys/kernel/shmmax 上面的命令是检查系统内存的大小，以及当前shmmax的设置。 # echo 21474836480 > /proc/sys/kernel/shmmax # sysctl -w kernel.shmmax=21474836480 # echo "kernel.shmmax=21474836480" >> /etc/sysctl.conf# echo 21474836480 > /proc/sys/kernel/shmmax # sysctl -w kernel.shmmax=21474836480 # … Continue reading →

Posted in ORACLE | Tagged , , , , , , , , | Leave a comment

9i出现内存分配错误

Posted on 2012/05/06 by yangtingkun

在9.2.0.8 RAC环境中，告警日志频繁出现内存分配错误的信息。 错误信息如下： Wed May 2 10:20:43 2012 Trace dumping IS performing id=[cdmp_20120502102043] There are 1444 memory allocation errors FOR object-level stat IN the LAST 15 minutes . . . There are 1605 memory allocation errors FOR object-level stat IN … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment