Monthly Archives: November 2012

私有网络接口丢失导致实例崩溃

客户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

ORA-600(kjbrref:pkey)错误

客户数据库碰到这个ORA-600错误,导致实例崩溃。 详细错误信息为: Fri Nov 23 23:38:46 2012 minact-scn: Master returning AS live inst:2 has inc# mismatch instinc:4 cur:6 errcnt:0 Errors IN file /oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lms1_2097994.trc (incident=1520217): ORA-00600: internal error code, arguments: [kjbrref:pkey], [7232], [107], [249516], [0], [], [], [], [], [], [], … Continue reading

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

V$SESSION记录的BLOCKING_SESSION错误

记录一个很诡异的问题,在进行一个测试时碰到的,V$SESSION中记录的BLOCKING_SESSION信息是错误的,可惜这个问题当时没有注意,后续也无法再重现出来,只好作为一个现象记录一下,Oracle给出的一些信息看来也是不完全可信的。 在会话1执行: [tingkun.yang@node1 ~]$ sqlplus test/test SQL*Plus: Release 10.2.0.5.0 – Production ON Sun Nov 25 04:04:00 2012 Copyright (c) 1982, 2010, Oracle. ALL Rights Reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production WITH the Partitioning, … Continue reading

Posted in BUG | Tagged , | Leave a comment

查询外部表出现无法打开日志文件的错误

在运行ORACLE_LOADER类型的外部表查询时报错,无法打开外部表的日志文件。 查询外部表出现KUP-4040错误: 数据库安装在操作系统oracle用户下,默认组为oinstall,当前使用的是操作系统用户tingkun.yang,同样是oinstall组,因此当前用户可以用SYSDBA身份登录数据库。 当前用户tingkun.yang运行sqlplus连接数据库,创建目录和外部表,在读取外部表时报错: [tingkun.yang@enmoteam2 ~]$ id uid=505(tingkun.yang) gid=501(oinstall) groups=501(oinstall),502(dba) [tingkun.yang@enmoteam2 ~]$ ps -ef|grep lgwr oracle 1552 1 0 Sep07 ? 00:04:14 ora_lgwr_enmot2 505 28312 28185 0 22:52 pts/0 00:00:00 grep lgwr [tingkun.yang@enmoteam2 ~]$ sqlplus olasuser/olasuser SQL*Plus: Release 11.2.0.3.0 Production … Continue reading

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

查询外部表出现KUP-4040错误

在运行ORACLE_LOADER类型的外部表查询时出现这个错误。 数据库的情况比较复杂,简单描述一下。数据库是安装在操作系统oracle用户下,默认组为oinstall,当前使用的是操作系统用户tingkun.yang,同样是oinstall组,因此当前用户可以用SYSDBA身份登录数据库。 以当前用户tingkun.yang运行sqlplus连接数据库,创建目录和外部表,在读取外部表时报错: [tingkun.yang@enmoteam2 ~]$ id uid=505(tingkun.yang) gid=501(oinstall) groups=501(oinstall),502(dba) [tingkun.yang@enmoteam2 ~]$ ps -ef|grep lgwr oracle 1552 1 0 Sep07 ? 00:04:14 ora_lgwr_enmot2 505 28312 28185 0 22:52 pts/0 00:00:00 grep lgwr [tingkun.yang@enmoteam2 ~]$ sqlplus olasuser/olasuser SQL*Plus: Release 11.2.0.3.0 Production ON … Continue reading

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

ORA-600(kfioTranslateIO03)和ORA-600(17090)错误

客户的11.2 RAC环境出现这两个ORA-600错误。 详细的错误信息为: Mon Nov 19 19:32:56 2012 ALTER SYSTEM SET local_listener=’ (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.135.128.17)(PORT=1521))))’ SCOPE=MEMORY SID=’orcl1′; NOTE: Loaded library: System ORA-15025: could NOT OPEN disk "/dev/rhdisk10" ORA-27041: unable TO OPEN file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: … Continue reading

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

ORA-600(2901)错误

客户在创建表空间时,出现这个错误。 详细错误信息为: SQL> CREATE TABLESPACE T_DATA DATAFILE ‘/dev/tdat01’ SIZE 13369336K 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE HS_ARCH_DATA DATAFILE ‘/dev/tdat01’ SIZE 13369336K * ERROR at line 1: ORA-00600: internal error code, arguments: [2901], [1671166], [1671167], [], … Continue reading

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

ORA-600(k2qgil:gtx)错误

客户11.2.0.3 RAC出现了ORA-600[k21gil:gtx]错误。 错误信息为: Sat Sep 22 18:45:52 2012 Auto-tuning: Shutting down background process GTX1 Sat Sep 22 19:00:20 2012 Auto-tuning: Starting background process GTX1 Starting background process GTX1 Sat Sep 22 19:00:20 2012 GTX1 started WITH pid=584, OS id=21107 Sat … Continue reading

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

Posted in BUG | Tagged , , | Leave a comment

关闭数据库出现PMON failed to acquire latch信息

很常见的一个信息,以前并没有太在意,不过即使是这种异常信息,Oracle也认为是bug。 关闭数据库时,信息如下: Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started WITH pid=28, OS id=1294500 Tue Aug 16 … Continue reading

Posted in BUG | Tagged , | Leave a comment