Monthly Archives: November 2012

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

Posted on 2012/11/28 by yangtingkun

客户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)错误

Posted on 2012/11/27 by yangtingkun

客户数据库碰到这个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错误

Posted on 2012/11/26 by yangtingkun

记录一个很诡异的问题，在进行一个测试时碰到的，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

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

Posted on 2012/11/25 by yangtingkun

在运行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错误

Posted on 2012/11/24 by yangtingkun

在运行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)错误

Posted on 2012/11/23 by yangtingkun

客户的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)错误

Posted on 2012/11/22 by yangtingkun

客户在创建表空间时，出现这个错误。 详细错误信息为： 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)错误

Posted on 2012/11/21 by yangtingkun

客户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)错误

Posted on 2012/11/20 by yangtingkun

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

Posted on 2012/11/19 by yangtingkun

很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，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