{"id":1335,"date":"2013-07-02T23:58:05","date_gmt":"2013-07-02T15:58:05","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1335"},"modified":"2013-07-03T00:52:31","modified_gmt":"2013-07-02T16:52:31","slug":"ora-7445ptmax%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1335","title":{"rendered":"ORA-7445(ptmax)\u9519\u8bef"},"content":{"rendered":"<p>\u4e00\u4e2a9.2.0.8\u4e0a\u7684bug\u3002<br \/>\n\u867d\u713612c\u5df2\u7ecf\u53d1\u5e03\uff0c\u4f46\u662f\u4ecd\u7136\u6709\u90e8\u5206\u5ba2\u6237\u7684\u6838\u5fc3\u6570\u636e\u5e93\u8fd8\u8dd1\u57289i\u73af\u5883\u4e0a\uff0c\u6709\u78b0\u5230\u4e86\u4e00\u4e2a9208\u4e0a\u7684bug\u3002<\/p>\n<pre lang='SQL'>Thu May 16 14:18:48 2013\r\nErrors in file \/oracle\/oracle\/admin\/orcl\/udump\/orcl_ora_11922.trc:\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38: \u6838\u5fc3\u8f6c\u50a8 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []\r\nThu May 16 14:19:49 2013\r\nErrors in file \/oracle\/oracle\/admin\/orcl\/udump\/orcl_ora_12389.trc:\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38: \u6838\u5fc3\u8f6c\u50a8 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []<\/pre>\n<p>\u8be6\u7ec6TRACE\u4fe1\u606f\uff1a<\/p>\n<pre lang='SQL'>*** SESSION ID:(1298.47235) 2013-05-16 14:18:48.666\r\nException signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x10, PC: [0x1023a0f08, 00000001023A0F08]\r\n*** 2013-05-16 14:18:48.669\r\nksedmp: internal or fatal error\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38: \u6838\u5fc3\u8f6c\u50a8 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []\r\nCurrent SQL statement for this session:\r\nbegin\r\n  -- Call the procedure\r\n  z_r_res_pk.g_num;\r\nend;\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedmp()+328         CALL     ksedst()             00000000B ? 000000000 ?\r\n                                                   000000000 ? 1033CF6C8 ?\r\n                                                   00000003E ?\r\n                                                   FFFFFFFF7FFF1188 ?\r\nssexhd()+676         CALL     ksedmp()             00010380C ? 10380C000 ?\r\n                                                   10380C718 ? 103811000 ?\r\n                                                   000102C00 ? 000000000 ?\r\n__sighndlr()+12      PTR_CALL 0000000000000000     000103814 ?\r\n                                                   FFFFFFFF7FFF8400 ?\r\n                                                   103814000 ? 1038118E8 ?\r\n                                                   000000000 ? 103814908 ?\r\ncall_user_handler()  CALL     __sighndlr()         00000000B ?\r\n+992                                               FFFFFFFF7FFF8400 ?\r\n                                                   FFFFFFFF7FFF8120 ?\r\n                                                   10023F860 ? 000000000 ?\r\n                                                   00000000A ?\r\nsigacthandler()+104  CALL     call_user_handler()  FFFFFFFF7DB00200 ?\r\n                                                   FFFFFFFF7DB00200 ?\r\n                                                   FFFFFFFF7FFF8120 ?\r\n                                                   00000000C ? 000000000 ?\r\n                                                   000000000 ?\r\nptmak()+424          PTR_CALL 0000000000000000     000000000 ?\r\n                                                   FFFFFFFF7FFF8400 ?\r\n                                                   FFFFFFFF7FFF8120 ?\r\n                                                   FFFFFFFF7DB00200 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7DB3E000 ?\r\npdtidc()+4716        CALL     ptmak()              FFFFFFFF7FFF9300 ?\r\n                                                   000000000 ? 000000004 ?\r\n                                                   000000002 ? 000000000 ?\r\n                                                   FFFFFFFF7CE61800 ?\r\npdlifu()+620         CALL     pdtidc()             000000000 ? 00002000C ?\r\n                                                   000000001 ? 000000001 ?\r\n                                                   102FBB000 ? 000102C00 ?\r\nphpcmp()+1016        CALL     phpcog()             000000000 ?\r\n                                                   FFFFFFFF7CE5C150 ?\r\n                                                   00000000C ? 000000011 ?\r\n                                                   FFFFFFFF7FFF9300 ?\r\n                                                   F988B6748 ?\r\npcicog()+184         CALL     phpcmp()             FFFFFFFF7FFF9300 ?\r\n                                                   F988B6748 ? 000000000 ?\r\n                                                   000000004 ? 000000004 ?\r\n                                                   000000000 ?\r\nkkxcog()+288         CALL     pcicog()             FFFFFFFF7FFF9300 ?\r\n                                                   F988B6748 ? 10380C49C ?\r\n                                                   00000AB90 ? 000000001 ?\r\n                                                   000000225 ?\r\nopitca()+4796        CALL     kkxcog()             F988B6748 ? 3800231C0 ?\r\n                                                   000380000 ? 000103813 ?\r\n                                                   103813000 ? 103813F34 ?\r\nrpiswu2()+384        PTR_CALL 0000000000000000     FFFFFFFF7FFF9A60 ?\r\n                                                   000000001 ? 00000000A ?\r\n                                                   000000001 ? 00000001A ?\r\n                                                   F988B6748 ?\r\nkkslod()+5196        CALL     rpiswu2()            F46434118 ? 00010380C ?\r\n                                                   10380C940 ? 10380C978 ?\r\n                                                   000000000 ? 10338B000 ?\r\nkglobld()+696        PTR_CALL 0000000000000000     000000000 ?\r\n                                                   FFFFFFFF7CE64658 ?\r\n                                                   000000000 ? 10380C978 ?\r\n                                                   F98D09B58 ? FD7970EF0 ?\r\nkglobpn()+1284       CALL     kglobld()            000000001 ? 000000000 ?\r\n                                                   F98ECBA88 ? 10380CAB8 ?\r\n                                                   000000001 ? F988B6748 ?\r\nkglpim()+236         CALL     kglobpn()            000000001 ? F922092E8 ?\r\n                                                   000000001 ? 10390E848 ?\r\n                                                   10390EA08 ? 10380DA10 ?\r\nkglpin()+764         CALL     kglpim()             0000000FF ? 10380CAB8 ?\r\n                                                   102DC74E8 ? 010010000 ?\r\n                                                   F988B6748 ? F922092E8 ?\r\nkksfbc()+6956        CALL     kglpin()             000010000 ?\r\n                                                   FFFFFFFF7FFFB278 ?\r\n                                                   F9100F9C8 ? 000000000 ?\r\n                                                   FFFFFFFF7FFFAE28 ?\r\n                                                   FFFFFFFF7FFFA950 ?\r\nkkspsc0()+988        CALL     kksfbc()             000004000 ? 000004000 ?\r\n                                                   000103800 ? 000000000 ?\r\n                                                   000004000 ? 000000000 ?\r\nopiosq0()+936        CALL     kkspsc0()            FFFFFFFF7CE60400 ?\r\n                                                   000000024 ? 102FA3B10 ?\r\n                                                   000000003 ? 000000004 ?\r\n                                                   FFFFFFFF7FFFC5D0 ?\r\nkpooprx()+204        CALL     opiosq0()            10104C000 ? 10380EC78 ?\r\n                                                   000000042 ?\r\n                                                   FFFFFFFF7FFFCC90 ?\r\n                                                   10380EA84 ? 000000016 ?\r\nkpoal8()+528         CALL     kpooprx()            FFFFFFFF7FFFEC2C ?\r\n                                                   FFFFFFFF7FFFCC90 ?\r\n                                                   000000042 ? 103814B90 ?\r\n                                                   000000000 ? 000000024 ?\r\nopiodr()+1720        PTR_CALL 0000000000000000     10380E000 ? 000000000 ?\r\n                                                   FFFFFFFF7FFFEC28 ?\r\n                                                   000000024 ? 000000000 ?\r\n                                                   000000000 ?\r\nttcpip()+1564        PTR_CALL 0000000000000000     000102DD9 ? 00010380C ?\r\n                                                   103814B98 ? 10380CAB8 ?\r\n                                                   10380EFF8 ?\r\n                                                   FFFFFFFF7FFFC5D0 ?\r\nopitsk()+1156        CALL     ttcpip()             103814B90 ? 000000001 ?\r\n                                                   FFFFFFFF7FFFEC28 ?\r\n                                                   000000014 ?\r\n                                                   FFFFFFFF7FFFD718 ?\r\n                                                   FFFFFFFF7FFFD714 ?\r\nopiino()+1504        CALL     opitsk()             000000000 ? 103814B20 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   102E484C8 ? 10380EFE0 ?\r\nopiodr()+1720        PTR_CALL 0000000000000000     000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7FFFFAA0 ?\r\n                                                   000000001 ? 000000001 ?\r\nopidrv()+764         CALL     opiodr()             000102DD9 ? 00010380C ?\r\n                                                   103814B98 ? 10380CAB8 ?\r\n                                                   10380EFF8 ?\r\n                                                   FFFFFFFF7FFFF5C0 ?\r\nsou2o()+16           CALL     opidrv()             00010380C ? 000000004 ?\r\n                                                   10380CAB8 ? 00000003C ?\r\n                                                   10380CAB8 ? 10380C718 ?\r\nmain()+184           CALL     sou2o()              FFFFFFFF7FFFFAC0 ?\r\n                                                   00000003C ? 000000004 ?\r\n                                                   FFFFFFFF7FFFFAA0 ?\r\n                                                   00003B000 ? 00003B030 ?\r\n_start()+380         CALL     main()               000000002 ?\r\n                                                   FFFFFFFF7FFFFC08 ?\r\n                                                   FFFFFFFF7FFFFC20 ?\r\n                                                   000000000 ?\r\n                                                   FFFFFFFF7E100100 ?\r\n                                                   FFFFFFFF7DB00200 ?\r\n--------------------- Binary Stack Dump ---------------------<\/pre>\n<p>\u8fdb\u4e00\u6b65\u68c0\u67e5TRACE\uff0c\u53d1\u73b0\u5f53\u524d\u7a0b\u5e8f\u4e3aDEVELOPER\u5728\u8fdb\u884cDEBUG\u64cd\u4f5c\uff1a<\/p>\n<pre lang='SQL'>PROCESS STATE\r\n-------------\r\nProcess global information:\r\n     process: f474d5360, call: f95814378, xact: 0, curses: f46434118, usrses: f46434118\r\n  ----------------------------------------\r\n  SO: f474d5360, type: 2, owner: 0, flag: INIT\/-\/-\/0x00\r\n  (process) Oracle pid=848, calls cur\/top: f95814378\/f95814378, flag: (0) -\r\n            int error: 0, call error: 0, sess error: 0, txn error 0\r\n  (post info) last post received: 0 0 0\r\n              last post received-location: No post\r\n              last process to post me: none\r\n              last post sent: 0 0 0\r\n              last post sent-location: No post\r\n              last process posted by me: none\r\n    (latch info) wait_event=0 bits=0\r\n    Process Group: DEFAULT, pseudo proc: f443c8d50\r\n    O\/S info: user: oracle, term: UNKNOWN, ospid: 11922\r\n    OSD pid info: Unix process pid: 11922, image: oracle@ysun7 (TNS V1-V3)\r\n    ----------------------------------------\r\n    SO: f46434118, type: 4, owner: f474d5360, flag: INIT\/-\/-\/0x00\r\n    (session) trans: 0, creator: f474d5360, flag: (41) USR\/- BSY\/-\/-\/-\/-\/-\r\n              DID: 0001-0350-00106A26, short-term DID: 0000-0000-00000000\r\n              txn branch: 0\r\n              oct: 47, prv: 0, sql: f98ecb960, psql: fdcc324f8, user: 65\/GZMPCMIS\r\n    O\/S info: user: Administrator, term: S-E-SERVE, ospid: 5944:4000, machine: WORKGROUP\\S-E-SERVE\r\n              program: plsqldev.exe\r\n    application name: PL\/SQL Developer, hash value=1190136663\r\n    action name: Test Window - Script for procedu, hash value=3367543201\r\n    last wait for 'SQL*Net message from client' blocking sess=0x0 seq=34 wait_time=8952\r\n                driver id=54435000, #bytes=1, =0\r\n    temporary object counter: 0\r\n      ----------------------------------------\r\n      SO: f922092e8, type: 52, owner: f46434118, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT PIN: pin=f922092e8 handle=f988b6748 mode=X lock=f9100f9c8\r\n      user=f46434118 session=f46434118 count=0 mask=00ff savepoint=195 flags=[00]\r\n      ----------------------------------------\r\n.\r\n.\r\n.\r\n      SO: f6a2eaba8, type: 51, owner: f46434118, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=f6a2eaba8 handle=f8dbc9320 mode=N\r\n      call pin=faf005300 session pin=0\r\n      htl=f6a2eac18[fa6f5b618,fa6f5b618] htb=fa6f5b618\r\n      user=f46434118 session=f46434118 count=1 flags=[00] savepoint=186\r\n      LIBRARY OBJECT HANDLE: handle=f8dbc9320\r\n      name=SYS.DBMS_DEBUG \r\n      hash=2c51e752 timestamp=10-04-2010 00:55:36\r\n      namespace=BODY\/TYBD flags=KGHP\/TIM\/SML\/[02000000]\r\n      kkkk-dddd-llll=0000-0011-0011 lock=N pin=S latch#=21\r\n      lwt=f8dbc9350[f8dbc9350,f8dbc9350] ltm=f8dbc9360[f8dbc9360,f8dbc9360]\r\n      pwt=f8dbc9380[f8dbc9380,f8dbc9380] ptm=f8dbc9410[f8dbc9410,f8dbc9410]\r\n      ref=f8dbc9330[f8dbc9330, f8dbc9330] lnd=f8dbc9428[f8dbc9428,f8dbc9428]\r\n        LIBRARY OBJECT: object=fb741e720\r\n        type=PKBD flags=EXS\/LOC[0005] pflags=\/SWR [08] status=VALD load=0\r\n        DEPENDENCIES: count=10 size=16\r\n        ACCESSES: count=9 size=16\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 f94627a40 fb741e8c8 I\/P\/A     0 NONE  \r\n            4 fb741e840 fb0c81e68 I\/P\/A     1 NONE  \r\n      ----------------------------------------\r\n      SO: f85863c38, type: 51, owner: f46434118, flag: INIT\/-\/-\/0x00\r\n      LIBRARY OBJECT LOCK: lock=f85863c38 handle=fcbfb58d0 mode=N\r\n      call pin=f83bafa18 session pin=0\r\n      htl=f85863ca8[fa6f5b608,fa6f5b608] htb=fa6f5b608\r\n      user=f46434118 session=f46434118 count=1 flags=[00] savepoint=186\r\n      LIBRARY OBJECT HANDLE: handle=fcbfb58d0\r\n      name=SYS.DBMS_DEBUG \r\n      hash=2c51e751 timestamp=10-04-2010 00:55:32\r\n      namespace=TABL\/PRCD\/TYPE flags=KGHP\/TIM\/SML\/[02000000]\r\n      kkkk-dddd-llll=0000-0215-0215 lock=N pin=S latch#=22\r\n      lwt=fcbfb5900[fcbfb5900,fcbfb5900] ltm=fcbfb5910[fcbfb5910,fcbfb5910]\r\n      pwt=fcbfb5930[fcbfb5930,fcbfb5930] ptm=fcbfb59c0[fcbfb59c0,fcbfb59c0]\r\n      ref=fcbfb58e0[fcbfb58e0, fcbfb58e0] lnd=fcbfb59d8[fa81f4ca0,f9a3a9ef0]\r\n        LIBRARY OBJECT: object=fb62f8710\r\n        type=PCKG flags=EXS\/LOC[0005] pflags= [00] status=VALD load=0\r\n        DEPENDENCIES: count=2 size=16\r\n        ACCESSES: count=1 size=16\r\n        DATA BLOCKS:\r\n        data#     heap  pointer status pins change\r\n        ----- -------- -------- ------ ---- ------\r\n            0 fafa8d3f8 fb62f88b8 I\/P\/A     0 NONE  \r\n            2 fb62f8830 fb68a95f8 I\/-\/A     0 NONE  \r\n            4 fb6f38c50 fd2b7d280 I\/P\/A     1 NONE  \r\n            9 fb6f38ba0 fb6a0f450 I\/-\/A     0 NONE  \r\n      ----------------------------------------<\/pre>\n<p>\u6839\u636eMOS\u6587\u6863ORA-07445 [ptmak()+107] During PL\/SQL Debug [ID 726611.1]\uff0c\u8fd9\u4e2a\u95ee\u9898\u5e94\u8be5\u662fDEBUG\u6a21\u5f0f\u4e0b\u7f16\u8bd1\u5bf9\u8c61\u5bfc\u81f4\u7684\u3002<br \/>\n\u867d\u7136BUG\u7684\u4fe1\u606f\u662f10.2\u4e0a\u7684\uff0c\u4f46\u662f\u4e0d\u6392\u96649.2.0.8\u4e0a\u5b58\u5728\u76f8\u540c\u7684\u95ee\u9898\uff0c\u4e0d\u8981\u4f7f\u7528PL\/SQL\u7684DEBUG\u529f\u80fd\uff0c\u6216\u8005\u7981\u6b62\u8fc7\u7a0b\u7684DEBUG\u9009\u9879\uff0c\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2a\u9519\u8bef\u7684\u4ea7\u751f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u4e2a9.2.0.8\u4e0a\u7684bug\u3002 \u867d\u713612c\u5df2\u7ecf\u53d1\u5e03\uff0c\u4f46\u662f\u4ecd\u7136\u6709\u90e8\u5206\u5ba2\u6237\u7684\u6838\u5fc3\u6570\u636e\u5e93\u8fd8\u8dd1\u57289i\u73af\u5883\u4e0a\uff0c\u6709\u78b0\u5230\u4e86\u4e00\u4e2a9208\u4e0a\u7684bug\u3002 Thu May 16 14:18:48 2013 Errors in file \/oracle\/oracle\/admin\/orcl\/udump\/orcl_ora_11922.trc: ORA-07445: \u51fa\u73b0\u5f02\u5e38: \u6838\u5fc3\u8f6c\u50a8 [00000001023A0F08] [SIGSEGV] [Address not mapped to object] [0x000000010] [] [] Thu May 16 14:19:49 2013 Errors in file \/oracle\/oracle\/admin\/orcl\/udump\/orcl_ora_12389.trc: ORA-07445: \u51fa\u73b0\u5f02\u5e38: \u6838\u5fc3\u8f6c\u50a8 [00000001023A0F08] [SIGSEGV] [Address not &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1335\">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":[1179,118,720,1178],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-lx","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1335"}],"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=1335"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1335\/revisions"}],"predecessor-version":[{"id":1336,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1335\/revisions\/1336"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}