XE: Cambiando el puerto “HTTP” y “FTP” por default en Oracle Express

Cuando instalamos Oracle XE  “Express Ediction” por defecto el puerto HTTP que accesa es el 8080  dentro del  XML DB (XDB).

Así pues cuando tenemos que instalar otro software, por ejemplo Apache TOMCAT entoces los puerto chocan.

Podemos determinar la actual configuracion usando los siguiente comando cuando estamos conectado en Oracle XE  con el usuario administrador SYSTEM o (usuarios DBA):

C:\WINDOWS\system32>sqlplus system@xe

SQL*Plus: Release 10.1.0.2.0 – Production on Mi Jan 25 11:44:33 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 – Beta

SQL> — Obtener el actual status
SQL> select dbms_xdb.gethttpport as “HTTP-Port”
, dbms_xdb.getftpport as “FTP-Port” from dual;

HTTP-Port   FTP-Port
———-          ———-
8080                             0

Podemos cambiar el puerto http y el puerto ftp con el siguiente codigo:

SQL> — setear puerto http y puerto ftp
SQL> begin
2 dbms_xdb.sethttpport(’80’);
3 dbms_xdb.setftpport(‘2100’);
4 end;
5 /

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as “HTTP-Port”
, dbms_xdb.getftpport as “FTP-Port” from dual;

HTTP-Port FTP-Port
———-        ———-
80                        2100

Si lo que queremos  es usar la base de datos XE sin permitir el acceso via http o ftp podemos desactivar ambos:

SQL> — desactivar el acceso http y ftp
SQL> begin
2 dbms_xdb.sethttpport(‘0’);
3 dbms_xdb.setftpport(‘0’);
4 end;
5 /

PL/SQL procedure successfully completed.

SQL> — Obtener el actual status
SQL> select dbms_xdb.gethttpport as “HTTP-Port”
, dbms_xdb.getftpport as “FTP-Port” from dual;

HTTP-Port FTP-Port
———-        ———-
0                                   0

24 pensamientos en “XE: Cambiando el puerto “HTTP” y “FTP” por default en Oracle Express

  1. I do not know if it’s just me or if perhaps everyone else experiencing issues with your blog. It looks like some of the text in your posts are running off the screen. Can somebody else please provide feedback and let me know if this is happening to them as well? This might be a issue with my web browser because I’ve had this happen
    previously. Thanks

    Me gusta

  2. I used to be suggested this blog by way of my cousin. I’m not positive whether this put up is written by way of him as nobody else recognise such targeted about my problem. You’re amazing! Thank you!

    Me gusta

  3. Howdy! This post could not be written any better! Reading through this post reminds me of my good old room mate! He always kept talking about this. I will forward this page to him. Fairly certain he will have a good read. Many thanks for sharing!

    Me gusta

  4. Hey There. I found your blog the use of msn. That is a very well written article. I will be sure to bookmark it and return to read extra of your helpful information. Thanks for the post. I will certainly return.

    Me gusta

  5. Everything posted made a great deal of sense. But, what about this? what if you typed a catchier post title? I ain’t suggesting your information isn’t good., however what if you added a title that grabbed a person’s attention? I mean XE: Cambiando el puerto HTTP y FTP por default en Oracle Express | Base de Datos y Tecnología is kinda vanilla. You could peek at Yahoo’s home page and watch how they create article headlines to get people to open the links. You might try adding a video or a picture or two to grab readers interested about everything’ve written. In my opinion, it would make your website a little bit more interesting.

    Me gusta

  6. Fantastic beat ! I wish to apprentice while you amend your site, how can i subscribe for a blog web site? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear concept

    Me gusta

  7. Hi there very cool site!! Man .. Excellent .. Wonderful .. I will bookmark your website and take the feeds additionally? I’m happy to search out so many useful info here within the submit, we want work out extra techniques in this regard, thank you for sharing. . . . . .

    Me gusta

  8. When I originally commented I appear to have clicked the -Notify me when new comments are added- checkbox and from now on each time a comment is added I recieve 4 emails with the same comment. Perhaps there is an easy method you are able to remove me from that service? Kudos!

    Me gusta

  9. GRACIAS!
    lo he podido hacer correctamente, lo he cambiado por el 8081

    ahora cuando intento entrar via http web me dice:

    http://localhost:8081 está solicitando un nombre de usuario y una contraseña. El sitio dice: “XDB”

    que usuario y contraseña son?
    estos no me funcionan
    usuario: system
    contraseña: (la que use para entrar y cambiar puerto)

    Me gusta

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión /  Cambiar )

Google photo

Estás comentando usando tu cuenta de Google. Cerrar sesión /  Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión /  Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión /  Cambiar )

Conectando a %s