正常模式下删除就出错
但是startup migrate然后drop user就会成功
。请大家帮忙。谢谢。
10:33:03 SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
PL/SQL Release 9.2.0.7.0 - Production
CORE9.2.0.7.0 Production
TNS for HPUX: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
10:33:39 SQL> create user test identified by test default tablespace data01 temporary tablespace temp;
User created.
10:35:19 SQL> drop user test cascade;
drop user test cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel[/code]
alertlog 记录
[code]Wed Feb8 10:35:31 2006
Errors in file /data22/oracle/admin/hpdb2/udump/hpdb2_ora_15311.trc:
ORA-07445: exception encountered: core dump [kprball()+1424] [SIGBUS] [unknown code] [0x800003FFBFFFB20F] [] []
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []
/data22/oracle/admin/hpdb2/udump/hpdb2_ora_15311.trc记录
$ tail -100 /data22/oracle/admin/hpdb2/udump/hpdb2_ora_15311.trc
Dump of memory from 0x80000001001BE7C0 to 0x80000001001BE7C8
80000001001BE7C0
8006C050
[...P]
Dump of memory from 0x800003FB8006C050 to 0x800003FB8006C090
800003FB8006C050 F8E9DACB 01010000 80000001 001BC4D8[................]
800003FB8006C060 800003FB 8006C050 00000010 00000000[.......P........]
800003FB8006C070 00000000 00000000 00000000 00000000[................]
Repeat 1 times
kpuuc kpkiu_p [80000001001BE7C8, 80000001001BE8C8) = 00000000 00000000 ...
Dump of memory from 0x80000001001BE7D0 to 0x80000001001BE8C8
80000001001BE7D0 00000000 00000000 00000000 00000000[................]
Repeat 11 times
80000001001BE890 00000002 00000002 00000002 00000000[................]
80000001001BE8A0 00000000 00000000 00000000 00000000[................]
Repeat 1 times
80000001001BE8C0 00000000 00000000
[........]
kpggug_t kpkiuga_p [80000001001BE8C8, 80000001001BE8E0) = 80000001 001BE234 ...
Dump of memory from 0x80000001001BE8D0 to 0x80000001001BE8E0
80000001001BE8D0 80000001 001BE24E 800003FB 8006C050[.......N.......P]
OCISvcCtx * kpnu_lsvchp_p [80000001001BE8E0, 80000001001BE8E8) = 00000000 ...
Dump of memory from 0x80000001001BE8E0 to 0x80000001001BE8E8
80000001001BE8E0
00000000
[....]
OCISession * kpnu_lusrhp_p [80000001001BE8E8, 80000001001BE8F0) = 00000000 ...
Dump of memory from 0x80000001001BE8E8 to 0x80000001001BE8F0
80000001001BE8E0
00000000
[....]
OCIServer * kpnu_lsrvhp_p [80000001001BE8F0, 80000001001BE8F8) = 00000000 ...
Dump of memory from 0x80000001001BE8F0 to 0x80000001001BE8F8
80000001001BE8F0
00000000
[....]
sb2 opixind_p [80000001001BE8F8, 80000001001BE8FC) = 00000000
ub2 opixaln_p [80000001001BE8F8, 80000001001BE8FC) = 00000000
ub2 opixrcd_p [80000001001BE8FC, 80000001001BE900) = 00000000
kgghst * kwqic_p [80000001001BE900, 80000001001BE908) = 800003FB 8006BFE0
Dump of memory from 0x800003FB8006BFE0 to 0x800003FB8006C020
800003FB8006BFE0 800003FB 8006BFB0 00000003 00000000[................]
800003FB8006BFF0 40000000 40400000 40000000 00E58370[@...@@[email protected]]
800003FB8006C000 40000000 00E58380 00000000 00000000[@...............]
800003FB8006C010 00000000 00000000 00000000 000002E0[................]
ub1 * kwqit_p [80000001001BE908, 80000001001BE910) = 00000000 00000000
ub1 * kwqin_p [80000001001BE910, 80000001001BE918) = 00000000 00000000
ub1 kwqiz_p [80000001001BE918, 80000001001BE91C) = 00000000
ub4 kwqis_p [80000001001BE91C, 80000001001BE920) = 00000000
ub4 kwqil_p [80000001001BE920, 80000001001BE924) = 00000000
ub4 kwqisflg_p [80000001001BE924, 80000001001BE928) = 00000000
kwqpoidnd * kwqpo_p [80000001001BE928, 80000001001BE930) = 00000000 ...
Dump of memory from 0x80000001001BE928 to 0x80000001001BE930
80000001001BE920
00000000
[....]
kwqpsctx * kwqps_p [80000001001BE930, 80000001001BE938) = 00000000 00000000
kwqprctx * kwqpr_p [80000001001BE938, 80000001001BE940) = 00000000 00000000
kgghst * kwqma_p [80000001001BE940, 80000001001BE948) = 800003FB 8006BF40
Dump of memory from 0x800003FB8006BF40 to 0x800003FB8006BF80
800003FB8006BF40 800003FB 8006BF10 00000003 00000000[................]
800003FB8006BF50 40000000 40400000 40000000 00E585C0[@...@@..@.......]
800003FB8006BF60 40000000 00E585D0 00000000 00000000[@...............]
800003FB8006BF70 00000000 00000000 00000000 00000118[................]
kwqjw * kwqjwh_p [80000001001BE948, 80000001001BE950) = 00000000 00000000
kwqauap * kwqau_p [80000001001BE950, 80000001001BE958) = 800003FB 80063898
Dump of memory from 0x800003FB80063898 to 0x800003FB800638D8
800003FB80063890
800003FB 8006BEA0
[........]
800003FB800638A0 800003FB 800638A0 800003FB 800638A0[......8.......8.]
800003FB800638B0 414D4552 4943414E 02010000 00000000[AMERICAN........]
800003FB800638C0 800003FB 800638F0 00000055 00000000[......8....U....]
800003FB800638D0 800003FB 800638B0
[......8.]
knceug * kncem_p [80000001001BE958, 80000001001BE960) = 00000000 00000000
ub1 kkziu_p [80000001001BE960, 80000001001BE964) = 09000000
knst * knstu_p [80000001001BE968, 80000001001BE970) = 00000000 00000000
knluga * knlug_p [80000001001BE970, 80000001001BE978) = 00000000 00000000
hogxdef* hogcu_p [80000001001BE978, 80000001001BE980) = 00000000 00000000
qmuga * qmug_p [80000001001BE980, 80000001001BE988) = 00000000 00000000
qmf_ctxp qmffs_p [80000001001BE988, 80000001001BE990) = 00000000 00000000
struct qmhreq * qmhreqp_p [80000001001BE990, 80000001001BE998) = 00000000 ...
Dump of memory from 0x80000001001BE990 to 0x80000001001BE998
80000001001BE990
00000000
[....]
ldxx * qmhdtctx_p [80000001001BE998, 80000001001BE9A0) = 00000000 00000000
struct lxhnd qmhalang_p [80000001001BE9A0, 80000001001BEBD0) = 00000000 ...
Dump of memory from 0x80000001001BE9A0 to 0x80000001001BEBD0
80000001001BE9A0
00000000 00000000 00000000[............]
80000001001BE9B0 00000000 00000000 00000000 00000000[................]
Repeat 33 times
qmxdplsuga * qmxdplsuga_p [80000001001BEBD0, 80000001001BEBD8) = 00000000 ...
Dump of memory from 0x80000001001BEBD0 to 0x80000001001BEBD8
80000001001BEBD0
00000000
[....]
qmpauga * qmpauga_p [80000001001BEBD8, 80000001001BEBE0) = 00000000 ...
Dump of memory from 0x80000001001BEBD8 to 0x80000001001BEBE0
80000001001BEBD0
00000000
[....]
qmxtcug * qmxtcuga_p [80000001001BEBE0, 80000001001BEBE8) = 00000000 ...
Dump of memory from 0x80000001001BEBE0 to 0x80000001001BEBE8
80000001001BEBE0
00000000
[....]
qsmguga * qsmgu_p [80000001001BEBE8, 80000001001BEBF0) = 00000000 00000000
struct _xsawuga * xsawuga_p [80000001001BEBF0, 80000001001BEBF8) = 00000000 ...
Dump of memory from 0x80000001001BEBF0 to 0x80000001001BEBF8
80000001001BEBF0
00000000
[....]
struct _xsoquga * xsoquga_p [80000001001BEBF8, 80000001001BEC00) = 00000000 ...
Dump of memory from 0x80000001001BEBF8 to 0x80000001001BEC00
80000001001BEBF0
00000000
[....]
ub4 ksmugmg2 [80000001001BEC00, 80000001001BEC04) = 0000CDCD
KSTDUMP: In-memory trace dump
TIME:SEQ#ORAPID SID EVENTOP DATA
========================================================================
KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = partial
|
