Category Archives: ORACLE

所有Oracle技术文章

ORA-600(1265)错误

Posted on 2012/07/25 by yangtingkun

客户的数据库出现ORA-600错误，错误函数为1265。 数据库版本为10.2.0.4 for Linux，错误信息为： Fri Aug 26 22:00:11 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: [1265], [0x42180EA78], [], [], [], [], [], [] Fri Aug 26 22:00:13 2011 Errors IN file /opt/app/oracle/admin/orcl/udump/orcl1_ora_16655.trc: ORA-00600: internal error code, arguments: … Continue reading →

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

ORA-600(kclfusion_1)错误

Posted on 2012/07/24 by yangtingkun

10.2.0.4 RAC for HP-UX，出现600错误并导致实例崩溃。 数据库错误信息如下： Thu Oct 29 19:49:19 2009 SMON: enabling cache recovery Thu Oct 29 19:49:19 2009 LNS: Standby redo logfile selected FOR thread 2 SEQUENCE 48 FOR destination LOG_ARCHIVE_DEST_2 Thu Oct 29 19:49:19 2009 ARC0: Standby redo … Continue reading →

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

ORA-600(KSSRMP1)错误

Posted on 2012/07/23 by yangtingkun

10.2.0.4 RAC的ASM实例出现这个错误。 错误信息为： Mon Mar 14 11:45:00 2011 Errors IN file /home/oracle/admin/+ASM/udump/+asm2_ora_717148.trc: ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], [] Mon Mar 14 11:45:01 2011 Trace dumping IS performing id=[cdmp_20110314114501] Mon Mar 14 11:45:06 2011 … Continue reading →

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

分区表UNUSED列后的EXCHANGE PARTITION操作

Posted on 2012/07/22 by yangtingkun

碰到一个有意思的问题，如果分区表执行过SET UNUSED操作，那么是否还可以进行分区的EXCHANGE操作。 一个简单的测试就可以说明这个问题： SQL> CREATE TABLE t_part_unused 2 (id NUMBER, name varchar2(30), other varchar2(30)) 3 partition BY range (id) 4 (partition p1 VALUES less than (10), 5 partition pmax VALUES less than (maxvalue)); TABLE created. SQL> INSERT INTO t_part_unused 2 … Continue reading →

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

ORA-600(kccida_kccsgfsz)错误

Posted on 2012/07/21 by yangtingkun

客户数据库10.1.0.4碰到这个ORA-600错误。 详细错误信息为： Sat Feb 4 13:04:31 2006 ALTER DATABASE MOUNT Sat Feb 4 13:04:31 2006 Errors IN file /oracle/admin/orcl/bdump/orcl_ckpt_122986.trc: ORA-00600: internal error code, arguments: [kccida_kccsgfsz], [], [], [], [], [], [], [] Sat Feb 4 13:04:32 2006 Errors IN file … Continue reading →

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

ORA-600(KSSRMP2)错误

Posted on 2012/07/20 by yangtingkun

客户的Oracle 10.1.0.4环境碰到这个错误。 详细错误信息为： Wed DEC 14 21:10:27 2005 Errors IN file /oracle/admin/ocrl/bdump/ocrl_smon_160060.trc: ORA-00600: internal error code, arguments: [KSSRMP2], [0x1102F0128], [0], [0], [], [], [], [] ORA-01157: cannot identify/LOCK DATA file 201 – see DBWR trace file ORA-01110: DATA file 201: … Continue reading →

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

10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空的解决

Posted on 2012/07/19 by yangtingkun

Oracle10g的DBA_TAB_STATISTICS视图的STATTYPE_LOCKED列没有正确的显示结果。 10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空：https://yangtingkun.net/?p=1023 上文提到了DBA_TAB_STATISTICS中的STATTYPE_LOCKED列在10g中对于分区锁定统计信息显示为空，那么在10g中有没有办法获取到正确的结果呢： SQL> SELECT TABLE_NAME, partition_name, last_analyzed, stattype_locked 2 FROM dba_tab_statistics 3 WHERE owner = USER 4 AND TABLE_NAME = ‘T_PART’; TABLE_NAME PARTITION_NAME LAST_ANAL STATT —————————— —————————— ——— —– T_PART 16-JUL-12 T_PART P1 T_PART P2 16-JUL-12 T_PART PMAX 16-JUL-12 … Continue reading →

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

10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空

Posted on 2012/07/18 by yangtingkun

Oracle10g的DBA_TAB_STATISTICS视图的STATTYPE_LOCKED列没有正确的显示结果。 看一个简单的例子： SQL> SELECT * FROM v$version; BANNER —————————————————————- Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 – 64bi PL/SQL Release 10.2.0.5.0 – Production CORE 10.2.0.5.0 Production TNS FOR Linux: Version 10.2.0.5.0 – Production NLSRTL Version 10.2.0.5.0 – Production SQL> CREATE … Continue reading →

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

ORA-4031导致CJQ进程出现ORA-1003错误

Posted on 2012/07/17 by yangtingkun

客户数据库出现ORA-4031错误，随后出现了大量的ORA-1003和ORA-604错误。 数据库版本为10.2.0.3 RAC for HP-UX，详细的报错信息为： Mon Jul 16 15:30:30 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/orcl2_ora_2389.trc: ORA-00603: ORACLE server SESSION TERMINATED BY fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable TO allocate 32 bytes OF shared memory ("shared … Continue reading →

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

ORA-7445(plcurClose)错误

Posted on 2012/07/16 by yangtingkun

11.2.0.2 RAC环境，碰到这个错误。 详细错误信息为： Tue Mar 13 14:25:17 2012 Exception [TYPE: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x37434AD, plcurClose()+27] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_29472.trc (incident=279439): ORA-07445: exception encountered: core dump [plcurClose()+27] [SIGSEGV] [ADDR:0x0] [PC:0x37434AD] [SI_KERNEL(general_protection)] [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_279439/orcl2_ora_29472_i279439.trc USE … Continue reading →

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