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
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 gustaMe gusta
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 gustaMe gusta
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 gustaMe gusta
Quality posts is the main to invite the visitors to visit the site, that’s what this site is providing.
Me gustaMe gusta
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 gustaMe gusta
I know this website gives quality based posts and additional data, is there any other site which gives such things in quality?
Me gustaMe gusta
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 gustaMe gusta
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 gustaMe gusta
It’s genuinely very difficult in this active life to listen news on TV, therefore I just use web for that reason, and take the newest news.
Me gustaMe gusta
Hi there, I desire to subscribe for this webpage to obtain hottest updates, thus where can i do it please assist.
Me gustaMe gusta
Everything is very open with a precise clarification of the challenges. It was really informative. Your website is extremely helpful. Thanks for sharing!
Me gustaMe gusta
Heya i’m for the primary time here. I came across this board and I find It truly useful & it helped me out much. I am hoping to offer something back and aid others like you aided me.
Me gustaMe gusta
This is my first time go to see at here and i am truly happy to read everthing at single place.
Me gustaMe gusta
I am truly thankful to the holder of this site who has shared this impressive paragraph at here.
Me gustaMe gusta
Nice replies in return of this matter with real arguments and telling all on the topic of that.
Me gustaMe gusta
Ahaa, its pleasant dialogue concerning this post at this place at this web site, I have read all that, so now me also commenting at this place.
Me gustaMe gusta
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 gustaMe gusta
Because the admin of this website is working, no hesitation very shortly it will be well-known, due to its quality contents.
Me gustaMe gusta
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 gustaMe gusta
What’s up, always i used to check weblog posts here in the early hours in the break of day, since i enjoy to learn more and more.
Me gustaMe gusta
It’s actually a nice and helpful piece of info. I am glad that you just shared this useful information with us. Please stay us up to date like this. Thanks for sharing.
Me gustaMe gusta
Why people still make use of to read news papers when in this technological world the whole thing is presented on web?
Me gustaMe gusta
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 gustaMe gusta
I all the time used to study article in news papers but now as I am a user of web therefore from now I am using net for content, thanks
to web.
Me gustaMe gusta