Monthly Archives: July 2012

ORA-600(kccida_kccsgfsz)错误

客户数据库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)错误

客户的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列对分区锁定显示为空的解决

Oracle10g的DBA_TAB_STATISTICS视图的STATTYPE_LOCKED列没有正确的显示结果。 10g中DBA_TAB_STATISTICS的STATTYPE_LOCKED列对分区锁定显示为空:http://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列对分区锁定显示为空

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错误

客户数据库出现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)错误

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

利用tar向磁带备份恢复文件

可以利用tar命令向磁盘备份文件,同时可以利用tar从磁带中恢复指定文件。 备份的命令为: tar cvf /dev/rmt/0m filename… 恢复的命令为: tar xvf /dev/rmt/0m filename… 从磁带上恢复文件的例子: > tar xvf /dev/rmt/0m /archive/orcl_exp_report_1.dmp /archive/orcl_exp_report_2.dmp x /archive/temp_exp/acdb_exp_report_1.dmp, 3198353408 bytes, 6246784 tape blocks x /archive/temp_exp/acdb_exp_report_2.dmp, 3078950912 bytes, 6013576 tape blocks 恢复时指定的文件名必须是备份到磁带的文件名。

Posted in OPERATING SYSTEM | Tagged , , | Leave a comment

密码即将过期提示的影响

当用户密码即将过期时,在登录时Oracle会提示ORA-28002错误,但是并不会影响正常的登录。 本来认为这个信息并没有太大的影响,但是没想到这个错误会导致SET AUTOTRACE功能失效: solaris*orcl-/home/oracle$ sqlplus test/test SQL*Plus: Release 11.2.0.3.0 Production ON Fri Jul 13 11:27:28 2012 Copyright (c) 1982, 2011, Oracle. ALL rights reserved. ERROR: ORA-28002: the password will expire WITHIN 1 days Connected TO: Oracle DATABASE 11g Enterprise Edition … Continue reading

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

分区表部分分区不可用导致统计信息收集失效

一个客户碰到的具体需求,分区表中有些分区所在的表空间被OFFLINE,导致在删除统计信息时报错。 下面通过例子来说明这个问题: SQL> CREATE TABLE t_part_read (id NUMBER) 2 partition BY range (id) 3 (partition p1 VALUES less than (10) tablespace ts1, 4 partition p2 VALUES less than (20) tablespace ts2, 5 partition pmax VALUES less than (maxvalue) tablespace users); … Continue reading

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

ORA-600(qctopn1)错误

客户11.2.0.2环境数据库出现这个ORA-600错误。 详细错误信息如下: Tue Jun 12 09:50:47 2012 Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_28252.trc (incident=329000): ORA-00600: internal error code, arguments: [qctopn1], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_329000/orcl2_ora_28252_i329000.trc Tue Jun 12 09:51:21 2012 Dumping diagnostic … Continue reading

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