{"id":257,"date":"2017-02-03T16:43:44","date_gmt":"2017-02-03T08:43:44","guid":{"rendered":"http:\/\/www.lisq.net.cn\/?p=257"},"modified":"2017-02-03T16:47:30","modified_gmt":"2017-02-03T08:47:30","slug":"ora-942-%e5%a4%9a%e7%94%a8%e6%88%b7%e5%ad%98%e5%9c%a8%e4%b8%80%e6%a0%b7%e7%9a%84%e5%af%b9%e8%b1%a1%e5%90%8d%e7%a7%b0%e5%9b%9e%e5%af%bc%e8%87%b4bug","status":"publish","type":"post","link":"https:\/\/www.lisq.net\/?p=257","title":{"rendered":"ORA-942 \u591a\u7528\u6237\u5b58\u5728\u4e00\u6837\u7684\u5bf9\u8c61\u540d\u79f0\u4f1a\u5bfc\u81f4BUG"},"content":{"rendered":"<p><strong>Bug 9577583 &#8211; False ORA-942 or other errors when multiple schemas have identical object names (<\/strong><strong>\u6587\u6863 ID 9577583.8)<\/strong><\/p>\n<p><strong><u>Affects<\/u><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Product (<em>Component<\/em>)<\/strong><\/td>\n<td>Oracle Server (Rdbms)<\/td>\n<\/tr>\n<tr>\n<td><strong>Range of versions\u00a0<em>believed<\/em>\u00a0to be affected<\/strong><\/td>\n<td>Versions &gt;= 10.2 but BELOW 12.1<\/td>\n<\/tr>\n<tr>\n<td><strong>Versions\u00a0<em>confirmed<\/em>\u00a0as being affected<\/strong><\/td>\n<td>\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#AFFECTS_11.2.0.1\">11.2.0.1<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#AFFECTS_11.1.0.7\">11.1.0.7<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#AFFECTS_10.2.0.5\">10.2.0.5<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#AFFECTS_10.2.0.4\">10.2.0.4<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td><strong>Platforms affected<\/strong><\/td>\n<td>Generic (all \/ most platforms affected)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Note that this fix can cause \/ expose the problem described in\u00a0<\/strong><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=13080778.8\"><strong>Bug:13080778<\/strong><\/a><\/p>\n<p><strong><u>Fixed<\/u><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>This issue is fixed in<\/strong><\/td>\n<td colspan=\"2\">\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#FIXED_12.1.0.1\">12.1.0.1 (Base Release)<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#FIXED_11.2.0.2\">11.2.0.2 (Server Patch Set)<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=10389035.8\">11.2.0.1 Bundle Patch 8 for Exadata Database<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=1114533.1\">11.2.0.1 Patch 4 on Windows Platforms<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=560295.1\">11.1.0.7 Patch 36 on Windows Platforms<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=342443.1\">10.2.0.5 Patch 6 on Windows Platforms<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=342443.1\">10.2.0.4 Patch 39 on Windows Platforms<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr>\n<td colspan=\"3\"><strong><u>Symptoms:<\/u><\/strong><\/td>\n<td colspan=\"2\"><strong><u>Related To:<\/u><\/strong><\/td>\n<\/tr>\n<tr>\n<td colspan=\"3\">\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_BADCURSOR\">Wrong\/Bad Shared Cursor<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_CORR_LOG\">Corruption (Logical)<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_DUMP\">Process May Dump (ORA-7445) \/ Abend \/ Abort<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_ERROR\">Error May Occur<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_WRONGRES\">Wrong Results<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=18536.1\">ORA-942<\/a>\u00a0\/\u00a0<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=18622.1\">ORA-1031<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=1200558.1\">ORA-600 [pfri.c: pfri8: plio mismatch]<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=34782.1\">ORA-600 [17114]<\/a><\/li>\n<li>Dump in or under\u00a0<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=310593.1\">pfrust<\/a>\u00a0\/\u00a0<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=469922.1\">pfrlnitinit<\/a>\u00a0\/\u00a0<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=310198.1\">kglpnp<\/a>\u00a0\/\u00a0<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=1288489.1\">pfrdd0d1dpf<\/a><\/li>\n<\/ul>\n<\/td>\n<td colspan=\"2\">\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_PLSQL\">PL\/SQL<\/a><\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=245840.1#TAGS_RMAN\">RMAN (Recovery Manager)<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><u>Description<\/u><\/strong><\/p>\n<p>ORA-942, or other unexpected errors, can occur when running in a setup<\/p>\n<p>where multiple schemas have identical objects and users are only expected<\/p>\n<p>to access objects in their own schemas.<\/p>\n<p>The problem can cause a SQL built for a given user to incorrectly<\/p>\n<p>have dependency \/ translation \/ access table entries for other<\/p>\n<p>users objects:<\/p>\n<p>&#8211; If there is no permission on those objects then various errors can occur.<\/p>\n<p>&#8211; If the current user does have permission on those objects then SQL may<\/p>\n<p>execute using objects from the wrong schema leading to wrong results<\/p>\n<p>or logical data corruption.<\/p>\n<p>This problem can also lead to various dumps when executing PLSQL<\/p>\n<p>especially when the PLSQL is executed from RMAN or Internal Errors<\/p>\n<p>due to memory corruptions.<\/p>\n<p>Rediscovery Notes:<\/p>\n<p>A library_cache dump of the problem cursor shows that the child<\/p>\n<p>cursor has incorrect entries in the dependency table.<\/p>\n<p>Note:<\/p>\n<p>This fix can expose the issue described in <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=13080778.8\">bug 13080778<\/a>.<\/p>\n<p>If using this fix it is advisable to also get the fix for <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?parent=DOCUMENT&amp;sourceId=9577583.8&amp;id=13080778.8\">bug 13080778<\/a><\/p>\n<p>and 10165083 . All 3 fixes conflict and so a merge patch may be needed,<\/p>\n<p>depending on which release you are on.<\/p>\n<p><strong><u>Getting a Fix<\/u><\/strong><\/p>\n<p>Use one of the &#8220;Fixed&#8221; versions listed above<\/p>\n<p><em>(for Patch Sets \/ bundles use the latest version available as<\/em><\/p>\n<p><em>\u00a0 contents are cumulative &#8211; the &#8220;Fixed&#8221; version listed above is<\/em><\/p>\n<p><em>\u00a0 the first version where the fix is included)<\/em><\/p>\n<p>or<\/p>\n<p>You can check for existing interim patches here: <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/ui\/patch\/PatchDetail.jspx?parent=DOCUMENT&amp;sourceId=9577583.8&amp;patchId=9577583\">Patch:9577583<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bug 9577583 &#8211; False ORA- &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[8],"tags":[12],"class_list":["post-257","post","type-post","status-publish","format-standard","hentry","category-8","tag-bug"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-49","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=257"}],"version-history":[{"count":2,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/257\/revisions"}],"predecessor-version":[{"id":259,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/257\/revisions\/259"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}