Category Archives: ORACLE

所有Oracle技术文章

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

启动取消导致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

ORA-600(17175)错误

Posted on 2012/05/31 by yangtingkun

又是一个导致实例崩溃的BUG。 数据库版本10.2.0.4 RAC for Hp-UX 11.31，在出现这个错误的同时还出现了ORA-601的错误： Wed DEC 1 01:57:55 2010 Errors IN file /u01/app/oracle/admin/orcl2/bdump/orcl21_pmon_3250.trc: ORA-00600: internal error code, arguments: [17175], [255], [], [], [], [], [], [] ORA-00601: cleanup LOCK conflict Wed DEC 1 01:57:57 2010 Trace dumping IS … Continue reading →

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

ORA-600(kccsbck_first)错误

Posted on 2012/05/29 by yangtingkun

客户Oracle10.2.0.4 RAC数据库出现ORA-600(kccsbck_first)错误。 详细错误信息为： Wed Oct 14 17:43:34 2009 ALTER DATABASE FORCE LOGGING Wed Oct 14 17:43:34 2009 ORA-12920 signalled during: ALTER DATABASE FORCE LOGGING… Wed Oct 14 17:43:42 2009 ALTER SYSTEM SET db_unique_name=’PRIMARY’ SCOPE=SPFILE; Wed Oct 14 17:44:01 2009 ALTER … Continue reading →

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

系统空间不足产生ORA-1错误

Posted on 2012/05/27 by yangtingkun

ORA-1错误代表唯一冲突，而空间不足时出现这个错误还是第一次碰到。 错误信息如下： Tue May 01 05:00:11 2012 Non critical error ORA-00001 caught while writing TO trace file "/home/oracle/base/diag/rdbms/orcl/orcl/trace/orcl_ora_31131.trc" Error message: Linux-x86_64 Error: 28: No SPACE LEFT ON device Additional information: 1 Writing TO the above trace file IS disabled FOR … Continue reading →

Posted in BUG | Tagged , , | Leave a comment