Tag Archives: DDL

ORA-600(KSSADP1)错误

Posted on 2012/10/09 by yangtingkun

客户9.2.0.8 RAC for AIX环境出现ORA-600[KSSADP1]错误。 错误信息为： Thu Apr 19 21:16:45 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_442896.trc: ORA-00600: internal error code, arguments: [KSSADP1], [], [], [], [], [], [], [] Thu Apr 19 21:16:45 2012 Errors IN file /oracle/app/admin/orcl/udump/orcl1_ora_442896.trc: ORA-00600: internal error code, … Continue reading →

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

ORA-7445(kqlSubheapPin)错误

Posted on 2012/09/11 by yangtingkun

Oracle 10.2.0.4 for X86-64数据库出现ORA-7445[kqlSubheapPin]错误。 错误信息为： Tue Jul 26 13:27:05 2011 Errors IN file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: core dump [kqlSubheapPin()+84] [SIGSEGV] [Address NOT mapped TO object] [0x000000110] [] []Tue Jul 26 13:27:05 2011 Errors in file /opt/app/oracle/admin/ora/udump/ora1_ora_6729.trc: ORA-07445: exception encountered: … Continue reading →

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

DDL触发器设置导致DDL无法执行（二）

Posted on 2012/02/24 by yangtingkun

公司测试数据库发现执行DDL报错。 继续描述问题的诊断和解决。 DDL触发器设置导致DDL无法执行（一）:http://yangtingkun.itpub.net/post/468/526410 从对象定义是找不到问题的原因的，只能通过10046跟踪一下： SQL> ALTER SESSION SET EVENTS ‘10046 TRACE NAME CONTEXT FOREVER, LEVEL 12’; Session altered. SQL> CREATE TABLE T_CREATE (ID NUMBER); CREATE TABLE T_CREATE (ID NUMBER) * ERROR at line 1: ORA-00604: error occurred at recursive SQL … Continue reading →

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

DDL触发器设置导致DDL无法执行（一）

Posted on 2012/02/23 by yangtingkun

公司测试数据库发现执行DDL报错。 由于篇幅所限，这里简单描述一下问题产生的现象。 打算进行个测试，结果发现建表时报错： SQL> CREATE TABLE T_EXCHANGE (ID NUMBER, CREATED DATE, TYPE VARCHAR2(18)) 2 PARTITION BY RANGE (CREATED) SUBPARTITION BY LIST (TYPE) 3 (PARTITION P1 VALUES LESS THAN (TO_DATE(’2012-1′, ‘YYYY-MM’)) 4 (SUBPARTITION P1SP1 VALUES (’TABLE’), 5 SUBPARTITION P1SP2 VALUES (’INDEX’), … Continue reading →

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