![\"Oracle-11G-Listener-Oracle\"](\"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png?w=300\")
<\/a><\/p>\nPuede pasar que la base de datos est\u00e9 correctamente levantada y\u00a0no se pueda conectar desde otros servidores, que tambi\u00e9n est\u00e1n\u00a0correctamente configurados (TNSNAMES correcto, etc.). En estos\u00a0casos puede ser que el listener tenga alg\u00fan problema, o\u00a0simplemente que no haya sido iniciado. En ese caso tan s\u00f3lo habr\u00eda\u00a0que arrancar el listener.<\/p>\n
Consultar el estado del mismo, arrancarlo o pararlo es muy sencillo.\u00a0S\u00f3lo hay que abrir una sesi\u00f3n de l\u00ednea de comandos (consola,\u00a0terminal, etc. ) con el usuario con el que se ha instalado la base de\u00a0datos, y ejecutar el comando lsnrctl con los siguientes par\u00e1metros\u00a0para cada caso:<\/p>\n
\uf0b7 Comprobar su estado: > lsnrctl status<\/p>\n
\uf0b7 Parar el listener:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 > lsnrctl stop<\/p>\n
\uf0b7 Levantar el listener:\u00a0 \u00a0\u00a0 > lsnrctl start<\/p>\n
Hay que tener en cuenta que cuando se para el listener no se\u00a0cierran las conexiones que ya est\u00e1n dentro de la base de datos, por\u00a0lo que una parada moment\u00e1nea no suele ser muy traum\u00e1tica, s\u00f3lo\u00a0se rechazar\u00e1n las conexiones que intenten entrar mientras el\u00a0listener est\u00e9 parado, no ha de afectar a nadie que tenga ya una\u00a0sesi\u00f3n abierta.<\/p>\n
Revisar la informaci\u00f3n que contiene el archivo listener.ora ubicado en \u00a0$ORACLE_HOME\/network\/admin.<\/p>\n
Tambi\u00e9n puede ser necesario revisar la informaci\u00f3n del archivo tnsnames.ora en la misma ubicaci\u00f3n que el listener.ora<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Para que desde fuera del servidor donde est\u00e1 instalada la base de\u00a0datos se pueda acceder a la misma el servicio\u00a0denominado\u00a0listener\u00a0ha de estar activado, o … <\/p>\n","protected":false},"author":1,"featured_media":23,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[23],"tags":[36,55,56,58,64],"class_list":["post-22","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-base-de-datos","tag-listener","tag-lsnrctl","tag-oracle","tag-tnsnames"],"yoast_head":"\n
C\u00f3mo arrancar el listener de Oracle - Repositorio Tecno<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo arrancar el listener de Oracle - Repositorio Tecno\" \/>\n<meta property=\"og:description\" content=\" Para que desde fuera del servidor donde est\u00e1 instalada la base de\u00a0datos se pueda acceder a la misma el servicio\u00a0denominado\u00a0listener\u00a0ha de estar activado, o …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Repositorio Tecno\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-04T15:57:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-25T06:12:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png\" \/>\n\t<meta property=\"og:image:width\" content=\"453\" \/>\n\t<meta property=\"og:image:height\" content=\"240\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/atelae.com\\\/#\\\/schema\\\/person\\\/ca17ce24adbc45a87fc0f28900cbcce8\"},\"headline\":\"C\u00f3mo arrancar el listener de Oracle\",\"datePublished\":\"2015-07-04T15:57:19+00:00\",\"dateModified\":\"2024-04-25T06:12:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/\"},\"wordCount\":282,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/atelae.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/oracle-11g-listener-oracle.png\",\"keywords\":[\"base de\u00a0datos\",\"listener\",\"lsnrctl\",\"oracle\",\"tnsnames\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/\",\"url\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/\",\"name\":\"C\u00f3mo arrancar el listener de Oracle - Repositorio Tecno\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/atelae.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/oracle-11g-listener-oracle.png\",\"datePublished\":\"2015-07-04T15:57:19+00:00\",\"dateModified\":\"2024-04-25T06:12:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#primaryimage\",\"url\":\"https:\\\/\\\/atelae.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/oracle-11g-listener-oracle.png\",\"contentUrl\":\"https:\\\/\\\/atelae.com\\\/wp-content\\\/uploads\\\/2015\\\/07\\\/oracle-11g-listener-oracle.png\",\"width\":453,\"height\":240},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/atelae.com\\\/index.php\\\/2015\\\/07\\\/04\\\/como-arrancar-el-listener-de-oracle\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/atelae.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo arrancar el listener de Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/atelae.com\\\/#website\",\"url\":\"https:\\\/\\\/atelae.com\\\/\",\"name\":\"Repositorio Tecno\",\"description\":\"Almac\u00e9n de informaci\u00f3n y soluciones t\u00e9cnicas.\",\"publisher\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/atelae.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/atelae.com\\\/#organization\",\"name\":\"Atelae\",\"url\":\"https:\\\/\\\/atelae.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/atelae.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/atelae.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/hangar_854x640.jpg\",\"contentUrl\":\"https:\\\/\\\/atelae.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/hangar_854x640.jpg\",\"width\":854,\"height\":640,\"caption\":\"Atelae\"},\"image\":{\"@id\":\"https:\\\/\\\/atelae.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/atelae.com\\\/#\\\/schema\\\/person\\\/ca17ce24adbc45a87fc0f28900cbcce8\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/35d251924e65608b5c5bc7e9c66057926822fee2da8a4e38e3d404b419a51b1a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/35d251924e65608b5c5bc7e9c66057926822fee2da8a4e38e3d404b419a51b1a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/35d251924e65608b5c5bc7e9c66057926822fee2da8a4e38e3d404b419a51b1a?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00f3mo arrancar el listener de Oracle - Repositorio Tecno","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:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo arrancar el listener de Oracle - Repositorio Tecno","og_description":" Para que desde fuera del servidor donde est\u00e1 instalada la base de\u00a0datos se pueda acceder a la misma el servicio\u00a0denominado\u00a0listener\u00a0ha de estar activado, o …","og_url":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/","og_site_name":"Repositorio Tecno","article_published_time":"2015-07-04T15:57:19+00:00","article_modified_time":"2024-04-25T06:12:31+00:00","og_image":[{"width":453,"height":240,"url":"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#article","isPartOf":{"@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/"},"author":{"name":"admin","@id":"https:\/\/atelae.com\/#\/schema\/person\/ca17ce24adbc45a87fc0f28900cbcce8"},"headline":"C\u00f3mo arrancar el listener de Oracle","datePublished":"2015-07-04T15:57:19+00:00","dateModified":"2024-04-25T06:12:31+00:00","mainEntityOfPage":{"@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/"},"wordCount":282,"commentCount":0,"publisher":{"@id":"https:\/\/atelae.com\/#organization"},"image":{"@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png","keywords":["base de\u00a0datos","listener","lsnrctl","oracle","tnsnames"],"articleSection":["Oracle"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/","url":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/","name":"C\u00f3mo arrancar el listener de Oracle - Repositorio Tecno","isPartOf":{"@id":"https:\/\/atelae.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#primaryimage"},"image":{"@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png","datePublished":"2015-07-04T15:57:19+00:00","dateModified":"2024-04-25T06:12:31+00:00","breadcrumb":{"@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#primaryimage","url":"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png","contentUrl":"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png","width":453,"height":240},{"@type":"BreadcrumbList","@id":"https:\/\/atelae.com\/index.php\/2015\/07\/04\/como-arrancar-el-listener-de-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/atelae.com\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo arrancar el listener de Oracle"}]},{"@type":"WebSite","@id":"https:\/\/atelae.com\/#website","url":"https:\/\/atelae.com\/","name":"Repositorio Tecno","description":"Almac\u00e9n de informaci\u00f3n y soluciones t\u00e9cnicas.","publisher":{"@id":"https:\/\/atelae.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/atelae.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/atelae.com\/#organization","name":"Atelae","url":"https:\/\/atelae.com\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/atelae.com\/#\/schema\/logo\/image\/","url":"https:\/\/atelae.com\/wp-content\/uploads\/2020\/10\/hangar_854x640.jpg","contentUrl":"https:\/\/atelae.com\/wp-content\/uploads\/2020\/10\/hangar_854x640.jpg","width":854,"height":640,"caption":"Atelae"},"image":{"@id":"https:\/\/atelae.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/atelae.com\/#\/schema\/person\/ca17ce24adbc45a87fc0f28900cbcce8","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/35d251924e65608b5c5bc7e9c66057926822fee2da8a4e38e3d404b419a51b1a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/35d251924e65608b5c5bc7e9c66057926822fee2da8a4e38e3d404b419a51b1a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/35d251924e65608b5c5bc7e9c66057926822fee2da8a4e38e3d404b419a51b1a?s=96&d=mm&r=g","caption":"admin"}}]}},"jetpack_featured_media_url":"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":2,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":215,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/posts\/22\/revisions\/215"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/media\/23"}],"wp:attachment":[{"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atelae.com\/index.php\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Oracle-11G-Listener-Oracle\"](\"https:\/\/atelae.com\/wp-content\/uploads\/2015\/07\/oracle-11g-listener-oracle.png\")
<\/a><\/p>\n