ERRORS
关注
分享
扫一扫
文章平均质量分 70
huang_tg
张开了翅膀，但还在路上奔跑，起飞阶段！
展开
-
ORA-16012
ORA-16012: Archive log standby database identifier mismatch原创 2010-07-02 14:31:00 · 1398 阅读 · 0 评论 -
ORA-27300，ORA-27301，ORA-27302，ORA-04030导致crashed database
ORA-27300: OS system dependent operation:fork failed with status: 11/12;ORA-27301: OS failure message: Resource temporarily unavailable/Not enough space;ORA-04030: out of process memory when trying to allocate 1049136 bytes (KSFD vec heap,KSFD contig原创 2011-03-15 11:28:00 · 5986 阅读 · 0 评论 -
ksbsrv: No startup acknowledgement from forked process after 30 seconds
本文转自oracle metalink 388781.1，alter日志中报ksbsrv: No startup acknowledgement from forked process after 30 seconds，随后恢复正常，不过奇怪的是当时数据库是比较闲的。转载 2011-05-17 11:09:00 · 1534 阅读 · 0 评论 -
How to Find Blocking Session for Mutex Wait Event cursor: pin S wait on X
How to Find Blocking Session for Mutex Wait Event cursor: pin S wait on X具体参考metalink文章786507.1原创 2011-04-18 16:39:00 · 889 阅读 · 0 评论 -
ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [KJMPSCH:RCVRD]
接到客户的电话，说他们数据库1号节点13号晚上21:06分的时候有过强制重启，环境为两个节点的RAC DB版本为10.2.0.4 OS版本为Red Hat as 4 up ,以下为alert日志信息Mon Jun 13 21:06:50 2011Errors in file /u01/app/oracle/admin/ncdb/bdump/ncdb1_lms5_29371.trc:OR原创 2011-06-15 16:14:00 · 1759 阅读 · 0 评论 -
oracle监听问题：WARNING: Subscription for node down event still pending
今天重启RAC数据库一个节点的监听时出现如下问题：$ lsnrctl statusLSNRCTL for HPUX: Version 10.2.0.5.0 - Production on 23-JUN-2011 09:45:01Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (ADDRESS=原创 2011-06-23 10:27:00 · 5757 阅读 · 0 评论 -
Master Note：'Warning: Subscription For Node Down Event Still Pending' In Listener Log
Warning: Subscription For Node Down Event Still Pending In Listener Log [ID 372959.1] 修改时间 11-FEB-2011 类型 PROBLEM 状态 PUBLISHED In this D转载 2011-06-24 10:35:00 · 1557 阅读 · 0 评论 -
Oracle 10g RAC中的DRM问题及关闭
在RAC环境中，Oracle使用GRD（Global Resource Service）来记录各个RAC节点的资源信息，具体通过GCS（Global Cache Service）和GES（Global Enqueue Service）这两个服务进行管理。转载 2011-07-05 15:35:20 · 2295 阅读 · 2 评论 -
ORA-12519、TNS-12519: TNS:no appropriate service handler found
今天监控的同事打电话来说有个数据库有段时间无法连接。检查节点服务状态正常，监听状态正常，alert日志没有值得注意的信息。但是在今天日志里面发现了如下报错：TNS-12519: TNS:no appropriate service handler found11-JUL-2011原创 2011-07-11 16:05:58 · 2671 阅读 · 0 评论 -
HP UNIX 11.31因为内存耗尽导致ORA-12549错误
有个数据库因为内存耗尽导致重启，以下为alert日志记录的错误信息：Mon Jun 13 15:27:47 EAT 2011ERROR: Failed to connect with connect string:(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/product/10.2.0/db_tmp/bin/oracle原创 2011-06-14 11:15:00 · 3179 阅读 · 0 评论 -
GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED
检查alert日志时发现的信息GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED ，OS:HP UNIX 11.31 DB:Oracle 10GR2 RAC Release 10.2.0.5原创 2011-02-16 10:37:00 · 6073 阅读 · 0 评论 -
ORA-27300 ORA-27301 ORA-27302: failure occurred at: skgpalive1
ORA-27300 ORA-27301 ORA-27302: failure occurred at: skgpalive1原创 2011-02-25 14:36:00 · 4888 阅读 · 0 评论 -
ORA-01624
ORA-01624: log 1 needed for crash recovery of thread 1原创 2010-07-02 17:15:00 · 12849 阅读 · 0 评论 -
ORA-00054
重建索引时遇到ORA-00054:resource busy and acquire with NOWAIT specified错误的解决办法原创 2010-07-06 18:35:00 · 5500 阅读 · 0 评论 -
Oracle 10g Recreate EM
Oracle 10g Recreate EM原创 2010-09-11 23:10:00 · 884 阅读 · 0 评论 -
SP2-0618: Cannot find the Session Identifier
本文介绍使用autotrace报SP2-0618，SP2-0611错误的解决方法。原创 2010-09-04 12:40:00 · 1351 阅读 · 0 评论 -
ORA-15186
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted]原创 2010-12-01 09:18:00 · 1786 阅读 · 0 评论 -
CRS-0184
CRS-0184: Cannot communicate with the CRS daemon原创 2010-12-03 11:00:00 · 10182 阅读 · 0 评论 -
ORA-3136
Oracle10gR2 ORA-3136错误解决方法。原创 2010-12-27 13:36:00 · 1840 阅读 · 0 评论 -
Memory Notification: Library Cache Object loaded into SGA
alert日志中出现Memory Notification: Library Cache Object loaded into SGA的解决方法。原创 2011-01-27 17:30:00 · 1041 阅读 · 0 评论 -
Troubleshooting ORA-1652 Errors in RAC
RAC环境下ORA-1652 的解决方法。原创 2011-02-25 10:55:00 · 1641 阅读 · 0 评论 -
ASMLib: oracleasm createdisk command fails: Device '/dev/emcpowera1 is not a partition
悲催的一天，在redhat linux 5.4上搭建oracle10g rac，多路径软件为EMC PowerPath5.3在安装搞asm的时候连续遇到问题，先是在运行/etc/init.d/oracleasm configure的时候报错，传说出现这个问题是因为selinux原创 2011-09-28 18:00:17 · 3511 阅读 · 0 评论