-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: ORA-29702
私有网络接口丢失导致实例崩溃
客户10.2.0.4 RAC数据库出现网络异常,导致实例崩溃并伴随大量ORA-27300错误。 详细错误信息为: Wed Nov 21 16:37:36 2012 Errors IN file /u01/oracle/app/admin/orcl/udump/orcl2_ora_29173.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:if_not_found failed WITH STATUS: 0 ORA-27301: OS failure message: Error … Continue reading
Posted in ORACLE
Tagged if_not_found, KGXGN, ORA-15064, ORA-27300, ORA-27301, ORA-27302, ORA-27303, ORA-27504, ORA-29702, ora-3113, ORA-603, skgxpvaddr9
Leave a comment
ORA-7445(kclfusion_1)错误
客户10.2.0.4 RAC环境在启动时出现ORA-7445错误。 错误信息为: Wed Jun 27 05:10:51 2012 Starting ORACLE instance (normal) Wed Jun 27 05:11:24 2012 LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 aggr1 192.168.168.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 … Continue reading
HPUX上出现ORA-27300、ORA-27301、ORA-27302的STATUS 11错误
数据库出现ORA-27300、ORA-27301和ORA-27302错误并最终出现ORA-29702错误,导致数据库实例的崩溃。 数据库版本为10.2.0.4 RAC for HP-UX,详细错误信息为: Wed Jun 27 04:31:07 2012 Process startup failed, error stack: Wed Jun 27 04:31:07 2012 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_psp0_1943.trc: ORA-27300: OS system dependent operation:fork failed WITH STATUS: 11 ORA-27301: OS failure message: Resource temporarily unavailable … Continue reading
ORA-600(ksqsgn:join)和ORA-7445(BREAKPOINT)错误
一个Windows环境下的RAC 10.2.0.4在添加节点时,原节点的ASM实例出现这两个错误。 错误信息如下: Sat Jun 09 11:24:21 2012 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 GB2 192.168.7.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 GB1 172.16.7.0 configured FROM OCR … Continue reading
Posted in ORACLE
Tagged BREAKPOINT, cluster, error in lmon process, Error: KGXGN polling error (15), IPCConnect, ksqsgn:join, ORA-29702, ORA-600, ORA-7445, PRIVATE IP, PUBILC IP, RAC
Leave a comment
RAC节点频繁重启出现ORA-29702
数据库的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