-
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-27303
IP地址被清空导致实例重启
客户10.2.0.4 RAC for Solaris 10环境突然出现了实例重启的现象。 数据库正常运行到下午3点左右，随后两个节点分别重启，其中一个节点上的实例无法自动启动。检查两个实例的告警日志发现，在节点重启前，两个节点都出现了明显的ORA-27504错误： Wed Apr 10 15:00:05 2013 Errors IN file /oracle/admin/orcl/udump/orcl1_ora_10997.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 … Continue reading
Posted in ORACLE
Tagged ifconfig, if_not_found, IPC Send timeout, ip_arp_done: init failed, ORA-27300, ORA-27301, ORA-27302, ORA-27303, ORA-27504, ORA-29740, ORA-603, skgxpvaddr9
Leave a comment
私有网络接口丢失导致实例崩溃
客户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
sqlplus直连数据库出现ORA-27504错误
客户数据库使用sqlplus直连方式连接数据库报错，而如果使用tnsnames方式则可以正常连接。 详细错误信息为： Thu Apr 26 10:17:56 2012 Errors IN file /oracle/admin/trs/udump/trs2_ora_2619.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-27504: IPC error creating OSD context ORA-27300: OS system dependent operation:IPC init failed WITH STATUS: 65 ORA-27301: OS failure message: Package … Continue reading
DBCA建库导致已有数据库出现ORA-27140错误
通过DBCA在服务器上创建一个额外的实例，结束后以外发现，原有的数据库实例出现了异常。 简单描述一下系统环境，Oracle 11.2.0.2 for Linux x86-64，随后又安装了GRID，创建了ASM磁盘组。原有的数据库有部分表空间和REDO存放在ASM磁盘组中。 为了测试，通过DBCA创建了额外的实例，事实上，通过DBCA又先后创建了两个数据库实例，第二个数据库实例创建后一切正常，将第二个实例关闭，通过DBCA创建第三个数据库实例时，导致服务器上的第一个实例出现了异常。 检查实例1上的告警日志，可以发现大量下面的错误信息： 2011-08-30 10:20:54.502000 +08:00 Process W000 died, see its trace file 2011-08-30 10:20:58.518000 +08:00 Process W000 died, see its trace file 2011-08-30 10:21:02.524000 +08:00 Process W000 died, see its trace file 2011-08-30 10:21:06.527000 … Continue reading