-
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-27301
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
ORA-600(13310)错误
客户10.2.0.4 RAC环境出现ORA-600[13310]错误。 错误信息如下： Sun Aug 1 04:08:24 2010 Errors IN file /oracle/admin/ORCL/udump/orcl1_ora_14964.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-27544: Failed TO map memory region FOR export ORA-27300: OS system dependent operation:socket failed WITH STATUS: 23 ORA-27301: OS failure … Continue reading
私有网络接口丢失导致实例崩溃
客户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
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-4030、ORA-27300错误和大量ORA-7445错误
客户11.2 RAC环境出现大量的ORA-7445错误、ORA-4030错误以及ORA-27300、ORA-27301和ORA-27302错误。 错误信息为： Sat DEC 31 02:33:18 2011 Errors IN file /app/diag/rdbms/orcl/orcl1/trace/orcl1_p015_28613.trc: ORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [ADDR:0xFFFFFFFF7FFE5FE0] [PC:0xFFFFFFFF7ADA92B0] [Address NOT mapped TO object] [] ORA-04030: OUT OF process memory WHEN trying TO allocate 254488 bytes (QERGH hash-agg,kllcqas:kllsltba) … Continue reading
Posted in BUG
Tagged fork failed with status, kgdsdst, ksmpgd_init_ctx, Not enough space, ORA-27300, ORA-27301, ORA-27302, ORA-4030, ORA-7445, skgpspawn3, sskgds_init, _ndoprnt
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
SHUTDOWN IMMEDIATE出现ORA-27144错误
客户的10.2.0.1 RAC for AIX数据库在关闭一个节点时碰到这个错误。 告警日志中信息如下： Tue Jan 10 21:11:42 2012 Shutting down instance (immediate) License high water mark = 721 Tue Jan 10 21:11:42 2012 Stopping Job queue slave processes Tue Jan 10 21:11:42 2012 Job queue slave processes stopped … Continue reading
Posted in BUG
Tagged ORA-27144, ORA-27300, ORA-27301, ORA-27302, shutdown abort, shutdown immediate
Leave a comment
ORA-27300 和skgpspawn3错误
以前碰到过类似的ORA-27300系列错误，问题都是和系统上错误有关，这次的问题也不例外。 详细错误信息如下： Tue May 17 22:01:04 2011 Process startup failed, error stack: Tue May 17 22:01:04 2011 Errors IN file /home/oracle/admin/ARIC/bdump/aric_psp0_866.trc: ORA-27300: OS system dependent operation:fork failed WITH STATUS: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred … 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