{"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":"oracle-rac-recurso-estado-desconocido","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/oracle-rac-resource-unknown-state\/","title":{"rendered":"C\u00f3mo Solucionar el Estado Desconocido de los Recursos de Oracle RAC"},"content":{"rendered":"

A menudo se puede conseguir Recursos de Oracle RAC<\/strong> en un estado desconocido y esto es bastante molesto porque usted no ser\u00e1 capaz de utilizar srvctl<\/strong> para gestionar ese recurso, para ponerlos en marcha y pararlos.<\/p>\n\n\n\n

Hay una forma de solucionarlo y os voy a mostrar c\u00f3mo lo he resuelto en un Exadata RAC de 2 nodos.<\/p>\n\n\n\n

Comprobemos primero un recurso que se encuentra en estado desconocido:<\/p>\n\n\n\n\n\n\n

\n[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
El recurso en el nodo 2 est\u00e1 en estado desconocido.<\/p>\n\n\n\n
Primero intento parar y eliminar la instancia, pero el cluster no me deja.<\/p>\n\n\n
\n[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[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl remove instance -d PRO02INT -i PRO02INT2\nRemove instance from the database PRO02INT? (y\/[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
Dice que no puedo eliminar la instancia porque dos servicios tienen esa instancia como preferida.<\/p>\n\n\n\n
Modifico esos recursos para tener la otra instancia como preferida.<\/p>\n\n\n
\n[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl modify service -d PRO02INT -s PRO02INT_bkup1 -n -i PRO02INT1\n[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl modify service -d PRO02INT -s PRO02INT_bkup2 -n -i PRO02INT1\n<\/pre><\/div>\n\n\n
As\u00ed que ahora puedo eliminar la instancia y a\u00f1adirla de nuevo.<\/p>\n\n\n
\n[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl remove instance -d PRO02INT -i PRO02INT2\nRemove instance from the database PRO02INT? (y\/[n]) y\n[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl add instance -d PRO02INT -i PRO02INT2 -n xjhd01db02\n<\/pre><\/div>\n\n\n
Vuelvo a comprobarlo y veo que el recurso est\u00e1 ahora fuera de l\u00ednea.<\/p>\n\n\n\n
Buenas noticias \ud83d\ude42 .<\/p>\n\n\n
\n[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
Ahora puedo iniciar la instancia.<\/p>\n\n\n
\n[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl start instance -d PRO02INT -i PRO02INT2\n<\/pre><\/div>\n\n\n
Compruebo los servicios y todo funciona correctamente.<\/p>\n\n\n
\n[oracle@xjhd01db02:PRO02INT2 ~]$ srvctl status database -d PRO02INT\nInstance PRO02INT1 is running on node xjhd01db01\nInstance PRO02INT2 is running on node xjhd01db02\n[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
Espero que te haya sido \u00fatil.<\/p>","protected":false},"excerpt":{"rendered":"
Bastante a menudo puedes tener recursos Oracle RAC en un estado desconocido y esto es bastante molesto porque no podr\u00e1s usar srvctl para gestionar ese recurso, para arrancarlo y pararlo. Hay una forma de solucionarlo y os voy a mostrar como lo he solucionado en un nodo de 2 ... <\/p>\n
Seguir leyendo \"C\u00f3mo solucionar el estado desconocido de recursos de 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\/es\/wp-json\/wp\/v2\/posts\/936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=936"}],"version-history":[{"count":12,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/936\/revisions"}],"predecessor-version":[{"id":1087,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/936\/revisions\/1087"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2916"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=936"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=936"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}