Monthly Archives: June 2012

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

Oracle高可用最佳实践

Posted on 2012/06/02 by yangtingkun

如果需要了解或架构高可用环境，建议看一下这篇文档。 这篇文档介绍了Oracle高可用相关的知识点，包括ASM、CLUSTER、RAC、DATA GUARD、GOLDENGATE、BACKUP、RESTORE等等，此外还介绍了高可用环境的监控，以及如何利用这些高可用功能来减少维护的停机时间。 从文档的名称高可用最佳实践和文档的页数高，这篇文档中不会包括这些知识点的具体概念，而应该是这些功能在哪些场合使用最合适，以及相互之间如何配合。 照例给出网址：http://www.oracle.com/pls/db112/to_toc?pathname=server.112%2Fe10803%2Ftoc.htm&remark=portal+%28Books%29

Posted in NEWS | Leave a comment

启动取消导致ORA-600(2658)错误

Posted on 2012/06/01 by yangtingkun

客户数据库在SHUTDOWN的过程中执行了取消操作，导致了ORA-600错误。 数据库版本为10.2.0.4 RAC for HP-UX，详细错误信息为： Thu Oct 22 15:05:14 2009 Shutting down instance: further logons disabled Thu Oct 22 15:05:15 2009 Stopping background process QMNC Thu Oct 22 15:05:15 2009 Stopping background process CJQ0 Thu Oct 22 15:05:17 2009 Stopping … Continue reading →

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