故障现象: oracle 连不上 ,报:ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务错误,重启 oracle 服务就又可以用了,过不了多长时间又连不上了。用 TNSPING 看上去又正常。现把 alert.log 和 .trc 文件内容贴给各位老鸟帮小弟分析一下。alert_oracleDB.log
Fri May 22 15:19:04 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:19:11 2009
ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:19:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:19:22 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:19:25 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:23:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:23:50 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:24:32 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_2508.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:24:34 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:24:38 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:24:40 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:28:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:28:51 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:29:44 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_4908.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:29:46 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:29:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:29:52 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:33:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:33:51 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:34:56 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_4716.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:34:57 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:35:00 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:35:03 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:38:03 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_4716.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:38:05 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:38:09 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_pmon_4328.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:11 2009
PMON: terminating instance due to error 474
Fri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_dbw0_4320.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_lgwr_4324.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_ckpt_3268.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:12 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_j000_5028.trc:
ORA-00474: SMON 进程因错误而终止Fri May 22 15:38:12 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_q001_4752.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:13 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_reco_6104.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:14 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_psp0_4384.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:14 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mman_3832.trc:
ORA-00474: SMON process terminated with errorInstance terminated by PMON, pid = 4328.trc 文件
Dump file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_cjq0_896.trc
Fri May 22 15:38:13 2009
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2925M/4094M, Ph+PgF:4622M/5973M, VA:1309M/2047M
Instance name: oracledbRedo thread mounted by this instance: 1Oracle process number: 10Windows thread id: 896, image: ORACLE.EXE (CJQ0)
*** 2009-05-22 15:38:13.015
*** SERVICE NAME:(SYS$BACKGROUND) 2009-05-22 15:38:13.015
*** SESSION ID:(162.1) 2009-05-22 15:38:13.015
error 474 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00474: SMON process terminated with error请大家帮忙分析一下,小弟头都大了。
Fri May 22 15:19:04 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:19:11 2009
ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:19:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:19:22 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:19:25 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:23:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:23:50 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:24:32 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_2508.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:24:34 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:24:38 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:24:40 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:28:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:28:51 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:29:44 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_4908.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:29:46 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:29:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:29:52 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:33:49 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:33:51 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mmon_6064.trc:
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []Fri May 22 15:34:56 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_4716.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:34:57 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:35:00 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []ORACLE Instance oracledb (pid = 8) - Error 600 encountered while recovering transaction (14, 17) on object 4211.
Fri May 22 15:35:03 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:38:03 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_p000_4716.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:38:05 2009
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Fri May 22 15:38:09 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_smon_5952.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []Fri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_pmon_4328.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:11 2009
PMON: terminating instance due to error 474
Fri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_dbw0_4320.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_lgwr_4324.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:11 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_ckpt_3268.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:12 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_j000_5028.trc:
ORA-00474: SMON 进程因错误而终止Fri May 22 15:38:12 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_q001_4752.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:13 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_reco_6104.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:14 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_psp0_4384.trc:
ORA-00474: SMON process terminated with errorFri May 22 15:38:14 2009
Errors in file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_mman_3832.trc:
ORA-00474: SMON process terminated with errorInstance terminated by PMON, pid = 4328.trc 文件
Dump file d:\oracle\product\10.2.0\admin\oracledb\bdump\oracledb_cjq0_896.trc
Fri May 22 15:38:13 2009
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2925M/4094M, Ph+PgF:4622M/5973M, VA:1309M/2047M
Instance name: oracledbRedo thread mounted by this instance: 1Oracle process number: 10Windows thread id: 896, image: ORACLE.EXE (CJQ0)
*** 2009-05-22 15:38:13.015
*** SERVICE NAME:(SYS$BACKGROUND) 2009-05-22 15:38:13.015
*** SESSION ID:(162.1) 2009-05-22 15:38:13.015
error 474 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00474: SMON process terminated with error请大家帮忙分析一下,小弟头都大了。
==================================================================
Inthirties关注Oracle数据库 维护 优化,安全,备份,恢复,迁移,故障处理如果你需要帮助或想和我一起学习的请联系
联系方式QQ:370140387
QQ群: 85837884(注明:数据库)
电子邮件:[email protected]
网站: http://www.inthirties.com
找到 4211 object 了,但不知如何处理4211 是packages -- sys.dbms_types
4211 是 packages 下的 sys.dbms_types 对象ID不是 index
17代表slot现在实例可以启来吗?
去掉10513 events后再重启.