ora-00600 [kgeade_is_0]
|
1 |
今天一同事遇到一个600错误，比较怪异，发过来看一下，如下: |
[crayon-685d51aecc7468 […]
ORA-01561 & ora-00600 [ktadrprc-1]
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 |
SQL> drop tablespace roger including contents and datafiles; drop tablespace roger including contents and datafiles * ERROR at line 1: ORA-01561: failed to remove all objects in the tablespace specified SQL> select owner,segment_name,segment_type 2 from dba_segments 3 where tablespace_name='ROGER'; OWNER SEGMENT_NAME SEGMENT_TYPE ------------ ------------------ ------------------ ROGER 5.155 TEMPORARY ROGER 5.163 TEMPORARY ROGER 5.171 TEMPORARY ROGER 5.179 TEMPORARY ROGER 5.187 TEMPORARY SQL> select owner,segment_name,segment_type,HEADER_FILE,HEADER_BLOCK,BYTES/1024/1024 2 from dba_segments 3 where owner='ROGER'; OWNER SEGMENT_NAME SEGMENT_TYPE HEADER_FILE HEADER_BLOCK BYTES/1024/1024 ------- --------------- -------------- ----------- ------------ --------------- ROGER 5.155 TEMPORARY 5 155 2 ROGER 5.163 TEMPORARY 5 163 2 ROGER 5.171 TEMPORARY 5 171 2 ROGER 5.179 TEMPORARY 5 179 .75 ROGER 5.187 TEMPORARY 5 187 .75 SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production SQL> select ts# from ts$ where name='ROGER'; TS# ---------- 6 SQL> update seg$ set type# = 3 where ts#=6; 7 rows updated. SQL> commit; Commit complete. SQL> select file#,block#,TYPE# from seg$ where ts#=6; FILE# BLOCK# TYPE# ---------- ---------- ---------- 5 155 3 5 163 3 5 171 3 5 179 3 5 187 3 5 1371 3 5 1379 3 7 rows selected. SQL> drop tablespace roger including contents and datafiles; Tablespace dropped. SQL> select ts#,name,BLOCKSIZE,FLAGS from ts$ order by 1; TS# NAME BLOCKSIZE FLAGS ---------- ------------------------------ ---------- ---------- 0 SYSTEM 8192 1 1 UNDOTBS1 8192 17 2 SYSAUX 8192 33 3 TEMP 8192 2 4 USERS 8192 33 5 UNDOTBS2 8192 17 6 ROGER 8192 33 7 rows selected. SQL> select file#,block#,TYPE# from seg$ where ts#=6; no rows selected SQL> delete from ts$ where ts#=6; 1 row deleted. SQL> show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ---------------------- undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS1 SQL> delete from ts$ where ts#=5; 1 row deleted. SQL> commit; Commit complete. SQL> select ts#,name,BLOCKSIZE,FLAGS from ts$ order by 1; TS# NAME BLOCKSIZE FLAGS ---------- ------------------------------ ---------- ---------- 0 SYSTEM 8192 1 1 UNDOTBS1 8192 17 2 SYSAUX 8192 33 3 TEMP 8192 2 4 USERS 8192 33 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 230686720 bytes Fixed Size 1266776 bytes Variable Size 150997928 bytes Database Buffers 75497472 bytes Redo Buffers 2924544 bytes Database mounted. Database opened. SQL> select file#,STATUS,CHECKPOINT_CHANGE#,ONLINE_CHANGE# from v$datafile; FILE# STATUS CHECKPOINT_CHANGE# ONLINE_CHANGE# ---------- ------- ------------------ -------------- 1 SYSTEM 708092 464631 2 ONLINE 708092 464631 3 ONLINE 708092 464631 4 ONLINE 708092 464631 SQL> select username,account_status,default_tablespace 2 from dba_users 3 where username='ROGER'; no rows selected SQL> select username from dba_users where username like '%ROGER%'; no rows selected ###### 我们发现roger表空间删除一行，roger用户也跟着被删除了。###### 关于drop表后，会变成临时表，这个应该是11gR2的新功能，在去年的一篇文章中，我写过了。 大家可以参考这里， http://hi.baidu.com/xu521huan/blog/item/29cd893db302f7fe3d6d97ba.html 但是我这里的环境是10204，居然会有这个情况，让我有点费解，，这个问题回头还需要研究一下。 最后再用oracle提供的检查数据字典的脚本检查一下，看看是否有数据字典不一致的情况 SQL> show user USER is "SYS" SQL> execute hcheck.full PL/SQL procedure successfully completed. ###### 看来是ok了 ###### SQL> create tablespace roger datafile '/oracle/product/oradata/roger/rogre01.dbf' size 200m autoextend off; Tablespace created. SQL> create user roger identified by roger default tablespace roger; create user roger identified by roger default tablespace roger * ERROR at line 1: ORA-01920: user name 'ROGER' conflicts with another user or role name SQL> drop user ROGER cascade; drop user ROGER cascade * ERROR at line 1: ORA-00600: internal error code, arguments: [ktadrprc-1], [], [], [], [], [], [], [] |
看了下alert log，对于的600错误t […]
最近一周遇到的几个case
最近一周遇到了好几个case，简单的总结一下，跟大家分享. CASE 1. 某客户的一套9208的库，在跑批处 […]