{"id":2106,"date":"2010-12-22T15:52:00","date_gmt":"2010-12-22T14:52:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/"},"modified":"2010-12-22T15:52:00","modified_gmt":"2010-12-22T14:52:00","slug":"oracle-cluster-11g-r2-listener-down","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/","title":{"rendered":"Oracle Cluster 11g R2 listener down &#8211; que faire ?"},"content":{"rendered":"<p>Dans un environnement Oracle cluster 11g R2, le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom &#8220;locahost&#8221; d\u00e9fini dans le fichier \/etc\/hosts.<\/p>\n<p>La semaine derni\u00e8re lors d&#8217;une op\u00e9ration de migration de r\u00e9seau dans un vlan s\u00e9par\u00e9, les adresses IP de nos serveurs sont rest\u00e9es identiques, leurs noms aussi, seul le nom de domaine a chang\u00e9.<\/p>\n<p>Une recherche sur le support Oracle ne montrait pas de d\u00e9pendance du cluster au nom de domaine.<br \/>\nDonc rien n&#8217;aurait du perturber le fonctionnement du cluster lors de l&#8217;op\u00e9ration.<br \/>\nJe constatais, \u00e0 la fin de la migration, des dysfonctionnements sur l&#8217;un des noeuds. Les ressources suivantes :<\/p>\n<ul>\n<li>instance,<\/li>\n<li>ons,<\/li>\n<li>listener.<\/li>\n<\/ul>\n<p>\u00e9taient OFFLINE. A l&#8217;\u00e9x\u00e9cution de la commande lsnrctl status , je recevais ces messages :<samp>LSNRCTL for Linux: Version 11.2.0.1.0 &#8211; Production on 06-DEC-2010 10:33:20<br \/>\nCopyright (c) 1991, 2009, Oracle.\u00a0 All rights reserved.<br \/>\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))<br \/>\nTNS-12541: TNS:no listener<br \/>\nTNS-12560: TNS:protocol adapter error<br \/>\nTNS-00511: No listener<br \/>\nLinux Error: 111: Connection refused<\/samp><\/p>\n<p>Apr\u00e9s quelques recherches sur le support oracle je pouvais red\u00e9marer le listener, mais dans des conditions non satisfaisantes, puisque les deux resources eons et ons \u00e9taient affect\u00e9es par cette solution.<\/p>\n<p>Une v\u00e9rification des fichiers listener.ora , endpoints_listener.ora ne donna rien. Je decidais donc de lancer netca pour verifier au travers de l&#8217;outil d&#8217;oracle les param\u00e9trages.<\/p>\n<p>Et l\u00e0, surprise , X11 me renvoya le message localhost:port inconnue.<\/p>\n<ul>\n<li>Pourquoi la couche X11 etait elle affect\u00e9e par le changement de domaine?<\/li>\n<li>Pourquoi sur un seul des noeuds ?<\/li>\n<\/ul>\n<p>La r\u00e9ponse vint rapidement \u00e0 la lecture du fichier \/etc\/hosts : celui-ci avait \u00e9t\u00e9 modifi\u00e9 pour remplacer le nom long du syst\u00e8me et par erreur, l&#8217;alias localhost avait \u00e9t\u00e9 transform\u00e9 en locahost.<br \/>\n<span style=\"font-family: verdana,geneva; font-size: 10pt;\">\u00a0<\/span><samp><br \/>\n<\/samp><\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"><samp><\/samp>-rw-r--r-- 2 root root 270 Dec\u00a0 3 11:43 hosts\n\n[root@vmtestorarac2 etc]# cat hosts\n# Do not remove the following line, or various programs\n# that require network functionality will fail.\n127.0.0.1\u00a0\u00a0 \u00a0localhost.localdomain.com locahost\n172.22.1.165\u00a0\u00a0 \u00a0vmtestorarac2.it.dbi-services.com vmtestorarac2\n192.168.1.3\u00a0\u00a0 vmtestorarac1-i\n192.168.1.4\u00a0\u00a0 vmtestorarac2-i<\/pre>\n<p>Le r\u00e9tablissement du nom a imm\u00e9diatement permis le lancement du listener et de ces d\u00e9pendances.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">grid@vmtestorarac2:\/etc\/ [+ASM2] lsnrctl status\n\nLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-DEC-2010 11:34:43\n\nCopyright (c) 1991, 2009, Oracle.\u00a0 All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nSTATUS of the LISTENER\n------------------------\nAlias\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTENER\nVersion\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TNSLSNR for Linux: Version 11.2.0.1.0 - Production\nStart Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 06-DEC-2010 11:26:20\nUptime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 days 0 hr. 8 min. 22 sec\nTrace Level\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 off\nSecurity\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON: Local OS Authentication\nSNMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFF\nListener Parameter File\u00a0\u00a0 \/u00\/app\/11.2.0\/grid_1_0\/network\/admin\/listener.ora\nListener Log File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u00\/app\/grid\/diag\/tnslsnr\/vmtestorarac2\/listener\/alert\/log.xml\nListening Endpoints Summary...\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.22.1.165)(PORT=1521)))\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.22.1.167)(PORT=1521)))\nServices Summary...\nService \"+ASM\" has 1 instance(s).\n Instance \"+ASM2\", status READY, has 1 handler(s) for this service...\nService \"ADMDBXDB.dbi-services.com\" has 1 instance(s).\n Instance \"ADMDB2\", status READY, has 1 handler(s) for this service...\nService \"ADMDB_LEMONT.dbi-services.com\" has 1 instance(s).\n Instance \"ADMDB2\", status READY, has 1 handler(s) for this service...\nThe command completed successfully<\/pre>\n","protected":false},"excerpt":{"rendered":"<p><span style=\"font-family: verdana,geneva; font-size: 10pt;\"><code>Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom \"locahost\" d\u00e9fini dans le fichier \/etc\/hosts.<\/code><\/span><\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[42],"tags":[38,43,17,44],"type_dbi":[],"class_list":["post-2106","post","type-post","status-publish","format-standard","hentry","category-operating-systems","tag-cluster","tag-listener","tag-oracle-11g","tag-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Cluster 11g R2 listener down - que faire ? - dbi Blog<\/title>\n<meta name=\"description\" content=\"Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom &quot;locahost&quot; d\u00e9fini dans le fichier \/etc\/hosts.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Cluster 11g R2 listener down - que faire ?\" \/>\n<meta property=\"og:description\" content=\"Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom &quot;locahost&quot; d\u00e9fini dans le fichier \/etc\/hosts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-22T14:52:00+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Cluster 11g R2 listener down &#8211; que faire ?\",\"datePublished\":\"2010-12-22T14:52:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\"},\"wordCount\":331,\"commentCount\":0,\"keywords\":[\"Cluster\",\"Listener\",\"Oracle 11g\",\"Troubleshooting\"],\"articleSection\":[\"Operating systems\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\",\"name\":\"Oracle Cluster 11g R2 listener down - que faire ? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2010-12-22T14:52:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom \\\"locahost\\\" d\u00e9fini dans le fichier \/etc\/hosts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Cluster 11g R2 listener down &#8211; que faire ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Cluster 11g R2 listener down - que faire ? - dbi Blog","description":"Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom \"locahost\" d\u00e9fini dans le fichier \/etc\/hosts.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Cluster 11g R2 listener down - que faire ?","og_description":"Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom \"locahost\" d\u00e9fini dans le fichier \/etc\/hosts.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/","og_site_name":"dbi Blog","article_published_time":"2010-12-22T14:52:00+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Cluster 11g R2 listener down &#8211; que faire ?","datePublished":"2010-12-22T14:52:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/"},"wordCount":331,"commentCount":0,"keywords":["Cluster","Listener","Oracle 11g","Troubleshooting"],"articleSection":["Operating systems"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/","name":"Oracle Cluster 11g R2 listener down - que faire ? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2010-12-22T14:52:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Dans un environnement cluster le listener ne peut pas d\u00e9marrer avec une erreur sur la d\u00e9finition de nom \"locahost\" d\u00e9fini dans le fichier \/etc\/hosts.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-cluster-11g-r2-listener-down\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Cluster 11g R2 listener down &#8211; que faire ?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2106"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2106\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2106"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}