{"id":428,"date":"2011-12-27T23:58:13","date_gmt":"2011-12-27T15:58:13","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=428"},"modified":"2011-12-28T08:00:00","modified_gmt":"2011-12-28T00:00:00","slug":"ora-600unable-to-load-xdb-library%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=428","title":{"rendered":"ORA-600(unable to load XDB library)\u9519\u8bef"},"content":{"rendered":"<p>AIX\u4e0a\u76849206\u6570\u636e\u5e93\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\n\u5728alert\u6587\u4ef6\u4e2d\u53d1\u73b0\u5927\u91cf\u7684\u7c7b\u4f3c\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>Mon Dec 19 16:43:13 2011\r\nErrors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_15400980.trc:\r\nORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []<\/pre>\n<p>\u68c0\u67e5\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\uff0c\u53d1\u73b0\u662f\u5728\u5220\u9664PERFSTAT\u7528\u6237\uff1a<\/p>\n<pre lang='SQL'>\/oracle9\/app\/admin\/db\/udump\/db1_ora_15400980.trc\r\nOracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production\r\nWith the Partitioning option\r\nJServer Release 9.2.0.6.0 - Production\r\nORACLE_HOME = \/oracle9\/app\/product\/9.2.0\r\nSystem name:\tAIX\r\nNode name:\tdb_1\r\nRelease:\t1\r\nVersion:\t6\r\nMachine:\t00F64FF34C00\r\nInstance name: db1\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 79\r\nUnix process pid: 15400980, image: oracle@db_1 (TNS V1-V3)\r\n*** SESSION ID:(29.33289) 2011-12-19 16:43:13.766\r\nDynamic link error: \t0509-022 Cannot load module \/oracle9\/app\/product\/9.2.0\/lib32\/libxdb.so.\r\n\t0509-103   The module has an invalid magic number.\r\n*** 2011-12-19 16:43:13.774\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\ndrop user perfstat cascade\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp+0148          bl       ksedst               10257BA84 ?\r\nksfdmp+0018          bl       01FD2604             \r\nkgerinv+00e8         bl       _ptrgl               \r\nkgeasnmierr+004c     bl       kgerinv              000000000 ? 000000000 ?\r\n                                                   1000C5328 ? 1025C36B8 ?\r\n                                                   11031DDC8 ?\r\nsqmtbGetSharedData+  bl       kgeasnmierr          1100062F8 ? 110342E48 ?\r\n0088                                               1025C36C0 ? 000000000 ?\r\n                                                   00000007D ? 00000007D ?\r\n                                                   968DBE1E7339340 ? 000000040 ?\r\nqmtLoadSharedData+0  bl       sqmtbGetSharedData   FFFFFFFFFFFA658 ? 000000000 ?\r\n074                                                000000000 ? 1103453C0 ?\r\n                                                   FFFFFFFFFFF4590 ? 1025C2B78 ?\r\n                                                   000000002 ? 110163730 ?\r\nqmtbInit+00b8        bl       qmtLoadSharedData    110345238 ?\r\nqmtInit+01f8         bl       qmtbInit             7000000BA25FF10 ?\r\nqm_init_sga_pass1+0  bl       qmtInit              1100062F8 ?\r\n13c                                                \r\nqm_init_uga+0138     bl       qm_init_sga_pass1    \r\nqmtsDropUser+0130    bl       qm_init_uga          \r\nkzdukl+25d4          bl       qmtsDropUser         11031D636 ? 8000000000008 ?\r\n                                                   24B0000024B ?\r\nkzudrp+023c          bl       kzdukl               11031D4C8 ?\r\nopiexe+2800          bl       kzudrp               3500000035 ?\r\nopiosq0+0ae0         bl       opiexe               410320340 ? FFFFFFFFFFFC378 ?\r\n                                                   FFFFFFFFFFFA658 ?\r\nkpooprx+0174         bl       opiosq0              000000004 ? 000000002 ?\r\n                                                   000000000 ? 000000001 ?\r\nkpoal8+033c          bl       kpooprx              FFFFFFFFFFFC5E4 ?\r\n                                                   FFFFFFFFFFFC378 ?\r\n                                                   1A0000001A ? 100000001 ?\r\n                                                   000000000 ? 24000000000024 ?\r\n                                                   080000000 ? 000007FFF ?\r\nopiodr+08e8          bl       _ptrgl               \r\nttcpip+0c54          bl       _ptrgl               \r\nopitsk+0c28          bl       ttcpip               11000D210 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ? 000000000 ?\r\nopiino+0798          bl       opitsk               000000000 ? 000000000 ?\r\nopiodr+08e8          bl       _ptrgl               \r\nopidrv+032c          bl       opiodr               3C77616974 ? 4101C7438 ?\r\n                                                   FFFFFFFFFFFF6C0 ? 000000001 ?\r\nsou2o+0028           bl       opidrv               3C00000005 ? 44043C000 ?\r\n                                                   FFFFFFFFFFFF6C0 ?\r\nmain+0138            bl       01FD2328             \r\n__start+0098         bl       main                 000000000 ? 000000000 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u663e\u7136\u5bfc\u81f4\u8fd9\u4e2aORA-600\u9519\u8bef\u7684\u4e3b\u8981\u539f\u56e0\u662fDynamic link error\uff0c\u5728\u8be6\u7ec6TRACE\u6587\u4ef6\u4e2d\u4e5f\u4f53\u73b0\u4e86\u8fd9\u4e00\u70b9\u3002<br \/>\n\u67e5\u8be2MOS\u53d1\u73b0\u8fd9\u662fAIX\u4e0a\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e\u4e0d\u5f53\u6240\u81f4\uff0c\u8be6\u60c5\u53ef\u4ee5\u53c2\u8003\u6587\u6863While Running catupgrd.sql On AIX: ORA-00600 [unable to load XDB library] [ID 759401.1]\u3002\u867d\u7136\u5f53\u524d\u5e76\u4e0d\u662f\u5728\u6267\u884c\u5347\u7ea7\u64cd\u4f5c\uff0c\u4f46\u662f\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u76f8\u540c\u7684\u3002<br \/>\n\u7531\u4e8e\u73af\u5883\u53d8\u91cfLIBPATH\u4e2d\uff0c64\u4f4d\u7684library\u8def\u5f84\u5e94\u8be5\u572832\u4f4d\u4e4b\u524d\uff0c\u800c\u5f53\u524d\u73af\u5883\u4e2d\u7684\u914d\u7f6e\u662f\u76f8\u53cd\u7684\uff0c\u8fd9\u5c31\u9020\u6210\u4e86Oracle\u9700\u8981\u8bfb\u53d6\u5bf9\u5e94\u7684library\u65f6\uff0c\u51fa\u73b0\u52a8\u6001\u8fde\u63a5\u9519\u8bef\u3002<br \/>\n\u89e3\u51b3\u65b9\u6cd5\u5c31\u662f\u6539\u53d8\u5f53\u524d\u9519\u8bef\u7684\u914d\u7f6e\uff0c\u9996\u5148\u5173\u95ed\u6570\u636e\u5e93\uff0c\u7136\u540eunset LIBPATH\u548cLD_LIBRARY_PATH\uff0c\u91cd\u65b0\u8bbe\u7f6eexport LIBPATH=$ORACLE_HOME\/lib:$ORACLE_HOME\/lib32\uff0c\u7136\u540e\u91cd\u542f\u6570\u636e\u5e93\uff0c\u91cd\u65b0\u6267\u884c\u62a5\u9519\u7684\u547d\u4ee4\u6216\u811a\u672c\u5373\u53ef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>AIX\u4e0a\u76849206\u6570\u636e\u5e93\u51fa\u73b0\u8fd9\u4e2a\u9519\u8bef\u3002 \u5728alert\u6587\u4ef6\u4e2d\u53d1\u73b0\u5927\u91cf\u7684\u7c7b\u4f3c\u9519\u8bef\uff1a Mon Dec 19 16:43:13 2011 Errors in file \/oracle9\/app\/admin\/db\/udump\/db1_ora_15400980.trc: ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], [] \u68c0\u67e5\u5bf9\u5e94\u7684TRACE\u6587\u4ef6\uff0c\u53d1\u73b0\u662f\u5728\u5220\u9664PERFSTAT\u7528\u6237\uff1a \/oracle9\/app\/admin\/db\/udump\/db1_ora_15400980.trc Oracle9i Enterprise Edition Release 9.2.0.6.0 &#8211; 64bit Production With the &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=428\">Continue reading <span class=\"meta-nav\">&rarr;<\/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":[208,16,331,8,330],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-6U","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/428"}],"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=428"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/428\/revisions"}],"predecessor-version":[{"id":429,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/428\/revisions\/429"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}