Author Archives: yangtingkun

ORA-7445(ksfqpcb)错误

Posted on 2012/06/12 by yangtingkun

在Oracle 10.2.0.4 RAC for Windows环境的告警日志中发现了这个错误。 Windows下的Oracle维护的不多，而Windows下的RAC就更少见了，而对应的这个错误也是比较少见的： Wed Oct 13 13:00:07 2010 Errors IN file c:\app\oracle\product\10.2.0\admin\cam\bdump\cam1_arc1_6052.trc: ORA-16038: 日志 2 SEQUENCE# 508 无法归档。 ORA-19504: 无法创建文件"" ORA-00312: 联机日志 2 线程 1: ‘+CAM/cam/onlinelog/group_2.266.724245379’ Wed Oct 13 13:00:32 2010 Errors IN file c:\app\oracle\product\10.2.0\admin\cam\bdump\cam1_m000_3972.trc: ORA-07445: 出现异常错误: … Continue reading →

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

ORA-600(723)错误

Posted on 2012/06/11 by yangtingkun

又是一个内存泄漏的问题。 这个错误号723与ORA-600[729]错误十分接近。而且二者都是内存泄漏相关的错误。错误信息为： Sat Jun 09 16:35:19 2012 Errors IN file c:\app\oracle\product\10.2.0\admin\cam\udump\cam1_ora_6392.trc: ORA-00600: internal error code, arguments: [723], [47560], [47560], [memory leak], [], [], [], []Sat Jun 09 16:35:19 2012 Errors in file c:\app\oracle\product\10.2.0\admin\cam\udump\cam1_ora_6392.trc: ORA-00600: internal error code, arguments: [723], [47560], … Continue reading →

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

ORA-600(kfioUnidentify01)错误

Posted on 2012/06/10 by yangtingkun

Oracle 10.2.0.4 RAC环境的ASM出现这个错误。 错误信息为： Mon Sep 19 18:06:01 2011 Shutting down instance: further logons disabled Mon Sep 19 18:06:01 2011 Shutting down instance (immediate) License high water mark = 10 Mon Sep 19 18:06:01 2011 ERROR: diskgroup DATA was NOT … Continue reading →

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

ORA-600(qcsgpvc3)错误

Posted on 2012/06/09 by yangtingkun

编译包导致的错误。 数据库版本为10.2.0.4 RAC for Linux X86-64，错误信息为： Fri Nov 4 14:27:47 2011 Errors IN file /u01/admin/orcl/udump/orcl1_ora_15210.trc: ORA-00600: internal error code, arguments: [qcsgpvc3], [], [], [], [], [], [], []Fri Nov 4 14:27:47 2011 Errors in file /u01/admin/orcl/udump/orcl1_ora_15210.trc: ORA-00600: internal error code, … Continue reading →

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

ORA-600(1616)和ORA-569错误

Posted on 2012/06/08 by yangtingkun

出现错误的数据库为Oracle 10.2.0.4 RAC for HP-UX。 在RAC的一个节点上出现了ORA-600[1616]错误和ORA-569错误： Sat Apr 7 03:03:09 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl2_smon_27471.trc: ORA-00569: Failed TO acquire global enqueue. Sat Apr 7 03:04:14 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl2_smon_27471.trc: ORA-00569: Failed TO acquire global enqueue. Sat Apr 7 03:04:15 … Continue reading →

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

ORA-600(ksires_1)错误

Posted on 2012/06/07 by yangtingkun

Oracle RAC 10.2.0.4 for HP-UX环境出现ORA-600[ksires_1]错误。 错误信息为： Mon DEC 13 23:00:13 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_m000_1861.trc: ORA-00600: internal error code, arguments: [ksires_1], [], [], [], [], [], [], [] Mon DEC 13 23:00:15 2010 Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl2_m000_1861.trc: ORA-00600: internal error … Continue reading →

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

11g数据泵NETWORK_LINK功能增强

Posted on 2012/06/06 by yangtingkun

11g增强了数据泵的NETWORK_LINK功能，使得远端的导入或导出也支持分区粒度。 在10g的时候，数据泵的NETWORK_LINK只支持表粒度： [orat3@hpserver2 ~]$ expdp test/test network_link=ora10204 dumpfile=tpart.dp logfile=test.log directory=dd TABLES=t_part:p1 Export: Release 10.2.0.4.0 – 64bit Production ON Monday, 4 June, 2012 0:38:31 Copyright (c) 2003, 2007, Oracle. ALL rights reserved. Connected TO: Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 … Continue reading →

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

ORA-7445(kxfrSortGranuleInstance)错误

Posted on 2012/06/05 by yangtingkun

10.2.0.4 RAC for HP-UX上出现了这个错误。 错误信息为： Sat DEC 31 14:48:42 2011 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl1_ora_26183.trc: ORA-07445: exception encountered: core dump [kxfrSortGranuleInstance()+1248] [SIGBUS] [Invalid address alignment] [0x9FFFFFFFBDF45674] [] [] Sat DEC 31 14:49:26 2011 Thread 1 advanced TO log SEQUENCE 68840 CURRENT … Continue reading →

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

ORA-600(qsmqSetupTableMetadata-2)错误

Posted on 2012/06/04 by yangtingkun

客户10.2.0.4 RAC for HP-UX 11.31在物化视图刷新时出现这个错误。 错误信息如下： Thu May 3 22:54:44 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_21657.trc: ORA-00600: internal error code, arguments: [qsmqSetupTableMetadata-2], [], [], [], [], [], [], [] Thu May 3 22:55:20 2012 Errors IN file /u01/app/oracle/admin/ORCL/bdump/orcl1_j000_21657.trc: ORA-12012: error ON … Continue reading →

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

将TIMESTAMP类型的差值转化为秒的方法

Posted on 2012/06/03 by yangtingkun

两个TIMESTAMP之差得到的是INTERVAL类型，而有时我们只需要得到两个时间相差的秒数，如果变成INTERVAL之后，想要获取这个值会非常麻烦。 比较常见的方法是使用EXTRACT来抽取获得的INTERVAL类型的日、时、分和秒来分别计算并求和： SQL> CREATE TABLE t_timestamp (id NUMBER, t1 TIMESTAMP, t2 TIMESTAMP); TABLE created. SQL> INSERT INTO t_timestamp 2 VALUES (1, to_timestamp(’20120603222324′, ‘yyyymmddhh24miss’), to_timestamp(’20120526152354’, ‘yyyymmddhh24miss’)); 1 ROW created. SQL> commit; Commit complete. SQL> SELECT t1 – t2 FROM t_timestamp WHERE … Continue reading →

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