Tag Archives: RAC

ORA-600(17175)错误

Posted on 2012/05/31 by yangtingkun

又是一个导致实例崩溃的BUG。 数据库版本10.2.0.4 RAC for Hp-UX 11.31，在出现这个错误的同时还出现了ORA-601的错误： Wed DEC 1 01:57:55 2010 Errors IN file /u01/app/oracle/admin/orcl2/bdump/orcl21_pmon_3250.trc: ORA-00600: internal error code, arguments: [17175], [255], [], [], [], [], [], [] ORA-00601: cleanup LOCK conflict Wed DEC 1 01:57:57 2010 Trace dumping IS … Continue reading →

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

ORA-600(kccsbck_first)错误

Posted on 2012/05/29 by yangtingkun

客户Oracle10.2.0.4 RAC数据库出现ORA-600(kccsbck_first)错误。 详细错误信息为： Wed Oct 14 17:43:34 2009 ALTER DATABASE FORCE LOGGING Wed Oct 14 17:43:34 2009 ORA-12920 signalled during: ALTER DATABASE FORCE LOGGING… Wed Oct 14 17:43:42 2009 ALTER SYSTEM SET db_unique_name=’PRIMARY’ SCOPE=SPFILE; Wed Oct 14 17:44:01 2009 ALTER … Continue reading →

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

RAC节点频繁重启出现ORA-29702

Posted on 2012/05/23 by yangtingkun

数据库的Oracle 10204 RAC for Windows出现频繁节点重启的问题。 从告警日志看，当前节点的重启一般发生在节点刚启动或关闭时： Thu May 03 17:22:45 2012 cluster interconnect IPC version:Oracle 9i Winsock2 TCP/IP IPC IPC Vendor 0 proto 0 Version 0.0 PMON started WITH pid=2, OS id=1616 DIAG started WITH pid=3, OS id=120 PSP0 started … Continue reading →

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

ORA-7445(ksuklms)错误

Posted on 2012/05/17 by yangtingkun

客户的11.2.0.2 RAC环境出现了这个ORA-7445[ksuklms]错误。 错误信息为： 2012-05-10 16:25:38.561000 +08:00 Exception [TYPE: SIGSEGV, Address NOT mapped TO object] [ADDR:0x163A] [PC:0x100A554A8, ksuklms()+392] [flags: 0x0, COUNT: 1] Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_ora_28387.trc (incident=449642): ORA-07445: exception encountered: core dump [ksuklms()+392] [SIGSEGV] [ADDR:0x163A] [PC:0x100A554A8] [Address NOT mapped TO object] … Continue reading →

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

ORA-600(kjbrrefp:key)和ORA-600(kjbmprlst:shadow)错误

Posted on 2012/05/16 by yangtingkun

这两个错误是由同一个BUG导致的。 数据库环境11.2.0.2 RAC for Solaris sparc，错误信息如下： 2012-01-29 06:15:10.168000 +08:00 Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_lms3_81.trc (incident=384590): ORA-00600: internal error code, arguments: [kjbrref:pkey], [332269], [202], [137064], [0], [], [], [], [], [], [], [] Incident details IN: /app/diag/rdbms/orcl/orcl1/incident/incdir_384590/orcl1_lms3_81_i384590.trc USE ADRCI OR Support Workbench … Continue reading →

Posted in BUG | 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

节点重配置后IPC发送超时问题

Posted on 2012/05/04 by yangtingkun

客户RAC环境在一个节点重启后，另一个节点出现IPC send timeout信息。 详细错误信息为： Wed May 2 22:07:00 2012 IPC Send timeout detected.Sender: ospid 20808 Receiver: inst 1 binc 1718095761 ospid 16263 Wed May 2 22:07:02 2012 IPC Send timeout detected.Sender: ospid 6677 Receiver: inst 1 binc 1718095761 ospid 16263 … Continue reading →

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

数据库VIP地址无法访问（二）

Posted on 2012/04/29 by yangtingkun

客户的数据库出现VIP地址无法访问的情况。 这一篇描述问题的解决。 数据库VIP地址无法访问（一）：https://yangtingkun.net/?p=798 上一篇通过诊断找到了问题的原因，由于VIP绑定网卡的错误，导致VIP可能漂移到PRIVATE网卡上，从而导致VIP地址对于外部服务器不可见。 找到原因后，解决其实很简单，只需要改正VIP错误的配置即可，简单的代码类似下面的示例： oracle@racdb1 $ srvctl config nodeapps -n racdb1 –a VIP EXISTS.: /racdb1-vip/10.8.60.201/255.255.255.0/aggr1:aggr2 oracle@racdb1 $ srvctl config nodeapps -n racdb2 –a VIP EXISTS.: /racdb2-vip/10.8.60.202/255.255.255.0/aggr1:aggr2oracle@racdb1 $ srvctl config nodeapps -n racdb1 –a VIP exists.: /racdb1-vip/10.8.60.201/255.255.255.0/aggr1:aggr2 oracle@racdb1 $ srvctl … Continue reading →

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

数据库VIP地址无法访问（一）

Posted on 2012/04/28 by yangtingkun

客户的数据库出现VIP地址无法访问的情况。 这一篇描述问题的诊断。 客户的RAC环境重建后，发现两个节点的VIP都无法访问，开始认为是网络问题，但是随后发现整个RAC重启后，其中一个节点的VIP可以访问，而另一个节点的VIP仍然无法访问，因此判断可能是RAC本身的问题。 听到问题描述后，第一个判断是否VIP没有启动，登录数据库服务器后进行了检查： oracle@racdb1 $ lsnrctl STATUS LSNRCTL FOR Solaris: Version 10.2.0.4.0 – Production ON 18-APR-2012 10:22:02 Copyright (c) 1991, 2007, Oracle. ALL rights reserved. Connecting TO (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS OF the LISTENER ———————— Alias LISTENER_RACDB1 Version TNSLSNR FOR Solaris: … Continue reading →

Posted in ORACLE | Tagged , , , , , , | 1 Comment

备份导致ORA-245错误

Posted on 2012/04/24 by yangtingkun

客户的11.2 RAC数据库在备份是出现ORA-245错误。 从告警日志中可以看到错误信息为： Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc: ORA-00245: control file backup operation failedErrors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc: ORA-00245: control file backup operation failed 详细TRACE信息为： Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_18335.trc Oracle DATABASE 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production WITH the Partitioning, REAL … Continue reading →

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