{"id":1449,"date":"2012-11-22T23:20:03","date_gmt":"2012-11-22T15:20:03","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1449"},"modified":"2013-07-31T17:23:48","modified_gmt":"2013-07-31T09:23:48","slug":"ora-6002901%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1449","title":{"rendered":"ORA-600(2901)\u9519\u8bef"},"content":{"rendered":"

\u5ba2\u6237\u5728\u521b\u5efa\u8868\u7a7a\u95f4\u65f6\uff0c\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002
\n\u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n

SQL> CREATE TABLESPACE T_DATA DATAFILE '\/dev\/tdat01' SIZE 13369336K \r\n  2  EXTENT MANAGEMENT LOCAL \r\n  3  SEGMENT SPACE MANAGEMENT AUTO;\r\nCREATE TABLESPACE HS_ARCH_DATA DATAFILE '\/dev\/tdat01' SIZE 13369336K \r\n* \r\nERROR at line 1: \r\nORA-00600: internal error code, arguments: [2901], [1671166], [1671167], [], [], [], [], []<\/pre>\n
\u5bf9\u5e94\u7684\u8be6\u7ec6TRACE\u4fe1\u606f\u4e3a\uff1a<\/p>\n
*** 2012-11-20 16:25:39.981 \r\nksedmp: internal or fatal error \r\nORA-00600: internal error code, arguments: [2901], [1671166], [1671167], [], [], [], [], [] \r\nCurrent SQL statement for this session: \r\nCREATE TABLESPACE T_DATA DATAFILE '\/dev\/tdat01' SIZE 13369336K \r\nEXTENT MANAGEMENT LOCAL \r\nSEGMENT SPACE MANAGEMENT AUTO \r\n----- Call Stack Trace ----- \r\ncalling              call     entry                argument values in hex \r\nlocation             type     point                (? means dubious value) \r\n-------------------- -------- -------------------- ---------------------------- \r\nksedst+001c          bl       ksedst1              000000000 ? 110074DE8 ? \r\nksedmp+0290          bl       ksedst               104C20490 ? \r\nksfdmp+02d8          bl       03F34EF4 \r\nkgeriv+0108          bl       _ptrgl \r\nkgesiv+0080          bl       kgeriv               1104BD230 ? 000000010 ? \r\n                                                   000000000 ? 1109724D0 ? \r\n                                                   000000000 ? \r\nksesic2+0060         bl       kgesiv               6368646174303100 ?<\/pre>\n
\u8fd9\u4e2aORA-600[2901]\u7684\u9519\u8bef\u7ecf\u5e38\u51fa\u73b0\u5728\u521b\u5efa\u8868\u7a7a\u95f4\u6216\u6dfb\u52a0\u6570\u636e\u6587\u4ef6\u7684\u8fc7\u7a0b\u4e2d\uff0c\u5f53Oracle\u5c1d\u8bd5\u521d\u59cb\u5316\u6570\u636e\u6587\u4ef6\u65f6\u53d1\u73b0\u6570\u636e\u6587\u4ef6\u7684\u7a7a\u95f4\u4e0d\u6ee1\u8db3\u521b\u5efa\u8bed\u53e5\u7684\u8981\u6c42\u65f6\uff0c\u5c31\u4f1a\u5f15\u53d1\u8fd9\u4e2a\u9519\u8bef\u3002
\n\u5176\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4e3a\u6570\u636e\u6587\u4ef6\u53ef\u7528\u7684BLOCK\u6570\uff0c\u800c\u7b2c\u4e09\u4e2a\u53c2\u6570\u4e3a\u5f53\u524d\u9700\u8981\u521b\u5efa\u7684\u6570\u636e\u6587\u4ef6\u6240\u9700\u7684BLOCK\u6570\uff1a<\/p>\n
SQL> select 13369336*1024\/8\/1024 from dual;\r\n13369336*1024\/8\/1024\r\n--------------------\r\n             1671167<\/pre>\n
\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5c06\u6570\u636e\u6587\u4ef6\u7f29\u5c0f\u4e00\u70b9\u5c31\u53ef\u4ee5\u4e86\u3002\u76f8\u6bd4\u8f83\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u66f4\u6709\u6280\u672f\u542b\u91cf\u3002
\n\u6839\u636e\u5ba2\u6237\u7684\u4e3b\u673a\u5de5\u7a0b\u5e08\u53cd\u9988\uff0c\u5728AIX\u4e0a\u521b\u5efaVG\u7684\u65f6\u5019\u6ca1\u6709\u5c06\u7c7b\u578b\u8bbe\u7f6e\u4e3aBIG\u7c7b\u578b\uff0c\u5bfc\u81f4\u5728\u521b\u5efa\u88f8\u8bbe\u5907\u65f6mklv\u6307\u5b9a\u7684-T O\u53c2\u6570\u6ca1\u6709\u751f\u6548\uff0c\u8fd9\u6837LVCB\u5c31\u5360\u7528\u4e86\u88f8\u8bbe\u5907\u7684\u7b2c\u4e00\u4e2a\u5757\uff0c\u4ece\u800c\u5bfc\u81f4Oracle\u521b\u5efa\u6570\u636e\u6587\u4ef6\u65f6\u7a7a\u95f4\u4e0d\u8db3\uff0c\u4ece\u800c\u5f15\u53d1\u4e86ORA-600\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5ba2\u6237\u5728\u521b\u5efa\u8868\u7a7a\u95f4\u65f6\uff0c\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002 \u8be6\u7ec6\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a SQL> CREATE TABLESPACE T_DATA DATAFILE ‘\/dev\/tdat01’ SIZE 13369336K 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO; CREATE TABLESPACE HS_ARCH_DATA DATAFILE ‘\/dev\/tdat01’ SIZE 13369336K * ERROR at line 1: ORA-00600: internal error code, arguments: [2901], [1671166], [1671167], [], … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[1273,1277,1275,1276,8,1274],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-nn","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1449"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1449"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1449\/revisions"}],"predecessor-version":[{"id":1451,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1449\/revisions\/1451"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}