- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-12 18:36:59
|
查看: 1261 |
回复: 0
急,求帮忙!
oracle 11.1.0.7.0
数据库反复报600错误后死机。
Errors in file /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_smon_22158.trc (incident=225657):
ORA-00600: internal error code, arguments: [kcbgcur_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /app/oracle/product/diag/rdbms/dbpub/dbpub/incident/incdir_225657/dbpub_smon_22158_i225657.trc
Fri Dec 31 17:26:22 2010
Errors in file /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_pmon_22136.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 22136): terminating the instance due to error 474
Instance terminated by PMON, pid = 22136
跟踪文件信息:
oracle@dbpub-144:/app/arc> more /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_smon_22158.trc
Trace file /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_smon_22158.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.1.0/db_1
System name: Linux
Node name: dbpub-144
Release: 2.6.27.7-9-default
Version: #1 SMP 2008-12-04 18:10:04 +0100
Machine: x86_64
Instance name: dbpub
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 22158, image: oracle@dbpub-144 (SMON)
*** 2010-12-31 17:05:41.071
*** SESSION ID544.1) 2010-12-31 17:05:41.071
*** CLIENT ID) 2010-12-31 17:05:41.071
*** SERVICE NAME) 2010-12-31 17:05:41.071
*** MODULE NAME) 2010-12-31 17:05:41.071
*** ACTION NAME) 2010-12-31 17:05:41.071
Incident 225653 created, dump file: /app/oracle/product/diag/rdbms/dbpub/dbpub/incident/incdir_225653/dbpub_smon_22158_i225653.trc
ORA-00600: internal error code, arguments: [kcbgcur_1], [], [], [], [], [], [], [], [], [], [], []
************ dump undo block **********
Dump of buffer cache at level 3 for tsn=2, rdba=12737394
BH (0x303f4f6e8) file#: 3 rdba: 0x00c25b72 (3/154482) class: 30 ba: 0x302cfe000
set: 11 bsz: 8192 bsi: 0 sflg: 2 pwc: 0, 0 lid: 0x00000000,0x00000000
dbwrid: 0 obj: -1 objn: 0 tsn: 2 afn: 3
hash: [0x4452b84c8,0x4452b84c8] lru: [0x303f4f8a8,0x303f4f648]
ckptq: [NULL] fileq: [NULL] objq: [0x303f4f928,0x42cb91528]
st: XCURRENT md: NULL tch: 1
flags: gotten_in_current_mode
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
cr pin refcnt: 0 sh pin refcnt: 0
buffer tsn: 2 rdba: 0x00c25b72 (3/154482)
scn: 0x0009.38264c9e seq: 0x08 flg: 0x04 tail: 0x4c9e0208
frmt: 0x02 chkval: 0x0cac type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000302CFE000 to 0x0000000302D00000
302CFE000 0000A202 00C25B72 38264C9E 04080009 [....r[...L&8....]
302CFE010 00000CAC 00110007 000CCC5C 09096AAD [........\....j..]
302CFE020 1FE80000 1AA41C2C 14841810 106013EC [....,.........`.]
302CFE030 0C740FC8 00000BDC 00000000 00000000 [..t.............]
302CFE040 00000000 00000000 00000000 00000000 [................]
Repeat 186 times
302CFEBF0 00180010 001C0020 000C0020 00010001 [.... ... .......]
302CFEC00 00000000 00000000 00000000 00000000 [................]
302CFEC10 0811160A CC5C0000 00C00D04 001567E2 [......\......g..]
302CFEC20 000E0004 000B9E19 00C3B5CD 00386747 [............Gg8.]
302CFEC30 00098000 34AA412A 34250205 00000000 [....*A.4..%4....]
302CFEC40 0288D21B 00000002 32D30000 00000002 [...........2....]
302CFEC50 00100010 0F05C203 33314303 0A15C203 [.........C13....]
302CFEC60 6304C203 0F05C203 33314303 0A15C203 [...c.....C13....]
302CFEC70 0605C203 3FC34802 48021D00 1E003FC3 [.....H.?...H.?..]
302CFEC80 00000000 000000FF 00180010 00580020 [............ .X.]
302CFEC90 00BA01F0 00040004 000143D4 00018EB9 [.........C......]
302CFECA0 00000007 00000000 0711160A CC5C0010 [..............\.]
--More--(0%)
|
|