Tag Archives: ORA-27300

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 , , , , , , , , , , , | 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

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

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

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 , , , , , , , , , , , | 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

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

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 , , , , , | 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

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