Categotry Archives: oracle错误

kcbgtcr_13 on active dataguard

0

Posted on by

今天在acitve dataguard上报出一个错误,在监控表空间时报出的,

经查为bug Bug 12848798 – OERI:kcbgtcr_13 on active dataguard [ID 12848798.8]

数据库版本为:11.2.0.3.5 

错误内容:

	ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [], [], [], [], [], [], [], [], [], []

在查询V$或者X$会报出的。

下载补丁:12848798可解决

Affects:

Product (Component)

Oracle Server (Rdbms)

Range of versions believed to be affected

Versions >= 10.2 but BELOW 12.1

Versions confirmed as being affected

Platforms affected

Generic (all / most platforms affected)

Fixed:

The fix for 12848798 is first included in

 

ORA-08104: this index object ##### is being online built or rebuilt

0

Posted on by

这个错误由于在异常终止online rebuild的时候,还没来得及清理相应的临时段和标志位,系统认为online rebuild操作还在进行造成的。

根据文章 Session Was Killed During The Rebuild Of Index ORA-08104 (文档 ID 375856.1)说明
 
1.等smon清理
 
2.在10g之后用dbms_repair.online_index_clean手工清理这些信息,在Oracle 9i下,需要打Bug 3805539 后才可以使用该工具
DECLARE
RetVal BOOLEAN;
OBJECT_ID BINARY_INTEGER;
WAIT_FOR_LOCK BINARY_INTEGER;
BEGIN
OBJECT_ID := 53367;
WAIT_FOR_LOCK := NULL;
RetVal := SYS.DBMS_REPAIR.ONLINE_INDEX_CLEAN ();
COMMIT;
END;
/
 
 
3.修改字典数据

(1)先查看ind$ flags 标志,如果不正确,就减去512.

       sql>update ind$ set flags=flags-512 where obj#=<object id>;

(2)drop journal table,这个步骤可能会报资源忙,因为有大量的日志正在插入,可以反复重试一下。

       sql>drop table <owner>.sys_journal_<object_id>;

 

注意:

       这个步骤不能反,如果先删除sys_journal_<object_id>临时表,然后再修改index的flags状态,则会报出ora-600 [4610]号错误,即数据字典不一致的错误。

 
 
 

Exclude (Automatic) Statistics Gathering from external objects

0

Posted on by

数据库在自动收集统计信息时,报如下错误:

ORA-20011: Approximate NDV failed:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error

检查到是一个外部表收集统计信息的错误

 

管方的建议是:

用DBMS_STATS.LOCK_TABLE_STATS 不让他收集统计信息

或者直接drop table

 

但由于外部表又不能删除,只好

DBMS_STATS.LOCK_TABLE_STATS ('ownname','tabname');

 

有没有lock可以通过这个视图查看

SELECT stattype_locked FROM dba_tab_statistics;

 

Process J000 is dead 报错

1

Posted on by

今天数据库后台报错:

Thu Dec 26 02:00:00 2013
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Thu Dec 26 02:06:36 2013
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Thu Dec 26 02:06:46 2013
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_21975.trc:
Process J000 died, see its trace file

 

 

查了下官方文档,说系统资源耗尽完:

 

CAUSE

This is caused by lack of OS resources or incorrect configuration, where more memory is required and Operating system reaches the limits set.

SOLUTION

* For Unix Platforms:

– run the HCVE script found in NOTE.250262.1 which is responsible to check for the OS resources and perform the suggested changes.

* For Windows platforms, 32 bit architecture:

– enable the /3GB switch in the boot.ini file, following the steps mentioned in Note 225349.1 – Address Windowing Extensions (AWE) or VLM on Windows Platforms

 

果然top一看,有一个占用将近8个cpu的进程,该机器一共就8个cpu;然后直接kill掉后,观察一切正常了。

top - 10:12:11 up 23 days, 16:39,  3 users,  load average: 7.99, 7.87, 7.89
Tasks: 296 total,   1 running, 295 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.1%us,  0.1%sy, 99.8%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   8110496k total,  5220400k used,  2890096k free,   135824k buffers
Swap:  8191992k total,    17660k used,  8174332k free,  4289168k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                   
31308 root      20   0  760m  11m  888 S 798.1  0.1   3801:42 hald-daemon -B -c /etc/hald-daemon.conf                                                                  
24170 oracle    -2   0 3829m  16m  14m S  1.0  0.2   0:09.45 ora_vktm_orcl                                                                                            
24974 oracle    20   0 15168 1356  908 R  0.7  0.0   0:00.23 top