{"id":880,"date":"2020-09-22T10:44:37","date_gmt":"2020-09-22T08:44:37","guid":{"rendered":"http:\/\/rootfan.com\/?p=880"},"modified":"2022-04-04T00:06:37","modified_gmt":"2022-04-03T22:06:37","slug":"verifier-letat-de-pdb-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/check-pdb-status-oracle\/","title":{"rendered":"Comment v\u00e9rifier l'\u00e9tat d'un PDB dans Oracle"},"content":{"rendered":"<p>Il arrive qu'un PDB ait un statut erron\u00e9, comme le statut MIGRATE si vous venez d'effectuer une mise \u00e0 niveau.<\/p>\n\n\n\n<p>La meilleure fa\u00e7on de v\u00e9rifier le statut est d'ex\u00e9cuter la requ\u00eate suivante \u00e0 partir de la CDB<\/p>\n\n\n\n<!--more-->\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nset lines 200\ncolumn HOST_NAME format a50\n\nselect INST_ID, INSTANCE_NUMBER, INSTANCE_NAME, \nHOST_NAME, DATABASE_STATUS, con_id  \nfrom gv$instance;\n\n   INST_ID INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                          DATABASE_STATUS       CON_ID\n---------- --------------- ---------------- -------------------------------------------------- ----------------- ----------\n         1               1 YD001NFR1        con01db01.mydomain.com                             ACTIVE                     0\n         2               2 YD001NFR2        con01db02.mydomain.com                             ACTIVE                     0\n\nset lines 200\ncolumn name format a30\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED \nfrom gv$pdbs;\n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  READ WRITE NO\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n\nalter pluggable database CLML01NFRPLUG close instances=('YD001NFR1');\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED\nfrom gv$pdbs;  \n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  MOUNTED\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n\nalter pluggable database CLML01NFRPLUG open instances=('YD001NFR1');\n\nset lines 200\ncolumn name format a30\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED \nfrom gv$pdbs;\n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  READ WRITE NO\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n<\/pre><\/div>\n\n\n<p>Quelques tests suppl\u00e9mentaires en fermant une instance et en ouvrant \u00e0 nouveau toutes les instances.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter pluggable database CLML01NFRPLUG close instances=('YD001NFR1');\n\nalter pluggable database CLML01NFRPLUG open instances=all;\n\nset lines 200\ncolumn name format a30\n\nselect INST_ID, CON_ID, NAME, OPEN_MODE, RESTRICTED \nfrom gv$pdbs;\n\n   INST_ID     CON_ID NAME                           OPEN_MODE  RES\n---------- ---------- ------------------------------ ---------- ---\n         1          2 PDB$SEED                       READ ONLY  NO\n         1          3 CLML01NFRPLUG                  READ WRITE NO\n         2          2 PDB$SEED                       READ ONLY  NO\n         2          3 CLML01NFRPLUG                  READ WRITE NO\n<\/pre><\/div>\n\n\n<p>J'esp\u00e8re que cela vous a \u00e9t\u00e9 utile.<\/p>","protected":false},"excerpt":{"rendered":"<p>Il arrive qu'une PDB ait un statut erron\u00e9, comme le statut MIGRATE si vous venez d'effectuer une mise \u00e0 niveau. La meilleure fa\u00e7on de v\u00e9rifier le statut est d'ex\u00e9cuter la requ\u00eate suivante \u00e0 partir de la CDB<\/p>","protected":false},"author":1,"featured_media":2917,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"How to Check PDB Status in Oracle","rank_math_title":"","rank_math_description":"Find out how to check the status of PDBs in Oracle and ensure the stability and availability of your databases.","rank_math_robots":null,"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":[53,54],"class_list":["post-880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-pdb","tag-rac"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-540518.jpeg?fit=1880%2C1033&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/880","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=880"}],"version-history":[{"count":17,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/880\/revisions"}],"predecessor-version":[{"id":2919,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/880\/revisions\/2919"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2917"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}