{"id":936,"date":"2020-10-02T20:42:34","date_gmt":"2020-10-02T18:42:34","guid":{"rendered":"http:\/\/rootfan.com\/?p=936"},"modified":"2022-04-04T00:05:27","modified_gmt":"2022-04-03T22:05:27","slug":"ressource-oracle-rac-etat-inconnu","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/oracle-rac-resource-unknown-state\/","title":{"rendered":"Comment corriger l'\u00e9tat inconnu de la ressource Oracle RAC"},"content":{"rendered":"<p>Tr\u00e8s souvent, vous pouvez obtenir <strong>Ressources Oracle RAC<\/strong> dans un \u00e9tat inconnu, ce qui est assez ennuyeux car vous ne pourrez pas utiliser la fonction <strong>srvctl<\/strong> de g\u00e9rer cette ressource, de la d\u00e9marrer et de l'arr\u00eater.<\/p>\n\n\n\n<p>Il existe un moyen d'y rem\u00e9dier et je vais vous montrer comment j'ai r\u00e9solu ce probl\u00e8me dans un Exadata RAC \u00e0 2 n\u0153uds.<\/p>\n\n\n\n<p>Commen\u00e7ons par v\u00e9rifier une ressource qui se trouve dans un \u00e9tat inconnu :<\/p>\n\n\n\n<!--more-->\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ crsctl status res ora.pro02int.db -t\n--------------------------------------------------------------------------------\nName           Target  State        Server                   State details\n--------------------------------------------------------------------------------\nCluster Resources\n--------------------------------------------------------------------------------\nora.pro02int.db\n      1        ONLINE  ONLINE       xjhd01db01             Open,HOME=\/u01\/app\/o\n                                                             racle\/product\/19.0.0\n                                                             .0\/dbhome_1,STABLE\n      2        ONLINE  UNKNOWN      xjhd01db02             STABLE\n--------------------------------------------------------------------------------\n<\/pre><\/div>\n\n\n<p>La ressource du n\u0153ud 2 est dans un \u00e9tat inconnu.<\/p>\n\n\n\n<p>J'essaie d'abord d'arr\u00eater et de supprimer l'instance, mais le cluster ne me le permet pas.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl stop instance -d PRO02INT -i PRO02INT2\nPRCR-1191 : The stop request failed because the resource is not running on nodes xjhd01db02.\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl remove instance -d PRO02INT -i PRO02INT2\nRemove instance from the database PRO02INT? (y\/&#x5B;n]) y\nPRKO-3147 : Instance PRO02INT2 cannot be removed because it is the only preferred instance for service(s) PRO02INT_bkup1,PRO02INT_bkup2 for database PRO02INT\n<\/pre><\/div>\n\n\n<p>Il indique que je ne peux pas supprimer l'instance parce que deux services ont cette instance comme pr\u00e9f\u00e9r\u00e9e.<\/p>\n\n\n\n<p>Je modifie ces ressources pour que l'autre instance soit privil\u00e9gi\u00e9e.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl modify service -d PRO02INT -s PRO02INT_bkup1 -n -i PRO02INT1\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl modify service -d PRO02INT -s PRO02INT_bkup2 -n -i PRO02INT1\n<\/pre><\/div>\n\n\n<p>Je peux donc supprimer l'instance et l'ajouter \u00e0 nouveau.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl remove instance -d PRO02INT -i PRO02INT2\nRemove instance from the database PRO02INT? (y\/&#x5B;n]) y\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl add instance -d PRO02INT -i PRO02INT2 -n xjhd01db02\n<\/pre><\/div>\n\n\n<p>Je v\u00e9rifie \u00e0 nouveau et je constate que la ressource est d\u00e9sormais hors ligne.<\/p>\n\n\n\n<p>Bonnes nouvelles \ud83d\ude42 .<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ crsctl status res ora.pro02int.db -t\n--------------------------------------------------------------------------------\nName           Target  State        Server                   State details\n--------------------------------------------------------------------------------\nCluster Resources\n--------------------------------------------------------------------------------\nora.pro02int.db\n      1        ONLINE  ONLINE       xjhd01db01             Open,HOME=\/u01\/app\/o\n                                                             racle\/product\/19.0.0\n                                                             .0\/dbhome_1,STABLE\n      2        OFFLINE OFFLINE                               STABLE\n--------------------------------------------------------------------------------\n<\/pre><\/div>\n\n\n<p>Je peux maintenant d\u00e9marrer l'instance.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl start instance -d PRO02INT -i PRO02INT2\n<\/pre><\/div>\n\n\n<p>Je v\u00e9rifie les services et tout fonctionne correctement.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl status database -d PRO02INT\nInstance PRO02INT1 is running on node xjhd01db01\nInstance PRO02INT2 is running on node xjhd01db02\n&#x5B;oracle@xjhd01db02:PRO02INT2 ~]$ srvctl status service -d PRO02INT\nService PRO02INT_bkup1 is running on instance(s) PRO02INT1\nService PRO02INT_bkup2 is running on instance(s) PRO02INT1\nService PRO02INTplug is running on instance(s) PRO02INT1\n<\/pre><\/div>\n\n\n<p>J'esp\u00e8re que cela vous a \u00e9t\u00e9 utile.<\/p>","protected":false},"excerpt":{"rendered":"<p>Tr\u00e8s souvent, vous pouvez obtenir des ressources Oracle RAC dans un \u00e9tat inconnu et c'est assez ennuyeux parce que vous ne serez pas en mesure d'utiliser srvctl pour g\u00e9rer cette ressource, pour la d\u00e9marrer et l'arr\u00eater. Il y a un moyen d'y rem\u00e9dier et je vais vous montrer comment j'ai r\u00e9solu ce probl\u00e8me dans un syst\u00e8me \u00e0 2 n\u0153uds ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/oracle-rac-resource-unknown-state\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Comment r\u00e9parer l'\u00e9tat inconnu d'une ressource Oracle RAC \"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2916,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"How to Fix Oracle RAC Resource Unknown State","rank_math_title":"","rank_math_description":"Discover how to fix the unknown state of Oracle RAC resources and ensure smooth operation of your cluster.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_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":[31],"tags":[55,54,56],"class_list":["post-936","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-crs","tag-rac","tag-unknown"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-2775196.jpeg?fit=1880%2C1253&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=936"}],"version-history":[{"count":12,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/936\/revisions"}],"predecessor-version":[{"id":1087,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/936\/revisions\/1087"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2916"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}