{"id":410,"date":"2018-11-05T13:25:42","date_gmt":"2018-11-05T13:25:42","guid":{"rendered":"https:\/\/blogs.ua.es\/jpm33\/?p=410"},"modified":"2019-05-26T11:15:20","modified_gmt":"2019-05-26T11:15:20","slug":"modificar-puerto-http-para-oracle-xe","status":"publish","type":"post","link":"https:\/\/blogs.ua.es\/jpm33\/2018\/11\/05\/modificar-puerto-http-para-oracle-xe\/","title":{"rendered":"Modificar puerto HTTP para Oracle XE"},"content":{"rendered":"<p><strong>Problema<\/strong><\/p>\n<p>Cuando se instala el SGBD Oracle XE para desarrollo en un entorno local se instala con un servidor de aplicaciones desplegado en el puerto 8080. Este comportamiento es muy molesto cuando queremos usar un servidor tomcat o desplegar aplicaciones spring boot.<\/p>\n<p>Pero es muy sencillo de arreglar, basta abrir una sesi\u00f3n en sqlplus y ejectuar el comando (EXEC DBMS_XDB.SETHTTPPORT(numero_puerto)):<\/p>\n<pre>$ sqplus system\/XE\r\n\r\nSQL*Plus ...\r\nSQL&gt; <strong>Exec DBMS_XDB.SETHTTPPORT(9090);<\/strong>\r\nPL\/SQL procedure sucessfully completed.<\/pre>\n<p><strong><em>OJO:<\/em><\/strong> si queremos deshabilitar el servidor:<\/p>\n<pre><strong>EXEC DBMS_XDB.SETHTTPPORT(0)<\/strong><\/pre>\n<p><strong>Referencias:<\/strong><\/p>\n<p>Referencias vistas el 24 de sep de 2018:<\/p>\n<ul>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/165105\/how-to-disable-oracle-xe-component-which-is-listening-on-8080\">StackOvweflow &#8211; How to disable Oracle XE component which is listening on 8080?<\/a><\/li>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/142868\/change-oracle-port-from-port-8080\">StackOverflow &#8211; Change Oracle port from port 8080<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Problema Cuando se instala el SGBD Oracle XE para desarrollo en un entorno local se instala con un servidor de aplicaciones desplegado en el puerto 8080. Este comportamiento es muy molesto cuando queremos usar un servidor tomcat o desplegar aplicaciones &hellip; <a href=\"https:\/\/blogs.ua.es\/jpm33\/2018\/11\/05\/modificar-puerto-http-para-oracle-xe\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3080,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[676],"tags":[],"class_list":["post-410","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"_links":{"self":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/users\/3080"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/comments?post=410"}],"version-history":[{"count":4,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/410\/revisions"}],"predecessor-version":[{"id":503,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/posts\/410\/revisions\/503"}],"wp:attachment":[{"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/media?parent=410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/categories?post=410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ua.es\/jpm33\/wp-json\/wp\/v2\/tags?post=410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}