Home > sql > Change default port 8080 in Oracle XE

Change default port 8080 in Oracle XE

When two services in system running with the same port, example “8080″, you cant able to get access to those services. For this we have to change the listening port number of any services to other than “8080″ port.

Here I have given how to change the listening port number of Oracle XE Database.

1. To get the current HTTP Listener Port number and FTP Port number, use the below query

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Room>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 22 19:05:48 2011

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

Enter user-name: system
Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

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

 HTTP-Port   FTP-Port
---------- ----------
      8090          0

SQL>

2. To change the HTTP Listener Port number, use the below single command in SQL window.


SQL> begin
  2  dbms_xdb.sethttpport('80');
  3  end;
  4  /

About these ads
Categories: sql Tags: , ,
  1. anonymous
    June 15, 2011 at 8:14 pm | #1

    Many thanks to you! I’ve solved my problem now.

  2. November 23, 2011 at 1:57 am | #2

    Thank dude it’s working.

  3. June 22, 2012 at 6:43 am | #3

    Thanks its been a gr8 help;

  4. February 2, 2013 at 5:33 am | #4

    I’ve been browsing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me.
    In my view, if all webmasters and bloggers made good content as you
    did, the net will be a lot more useful than ever before.

  5. February 6, 2013 at 2:19 pm | #5

    This design is steller! You most certainly know how to keep a reader entertained.
    Between your wit and your videos, I was almost moved to start my
    own blog (well, almost…HaHa!) Excellent job. I really enjoyed what you had to say, and more than
    that, how you presented it. Too cool!

  6. March 17, 2013 at 4:50 pm | #6

    Hi there, after reading this remarkable article i am as well cheerful to
    share my familiarity here with mates.

  7. March 19, 2013 at 6:43 pm | #7

    There is definately a lot to find out about this
    subject. I love all the points you have made.

  8. March 29, 2013 at 4:13 pm | #9

    You could definitely see your enthusiasm within the article you write.
    The arena hopes for more passionate writers like you who aren’t afraid to mention how they believe. Always go after your heart.

  9. smart circle directv sam’s club
    May 24, 2013 at 12:47 am | #10

    I have learn several good stuff here. Certainly worth bookmarking for revisiting.
    I wonder how much effort you place to create this sort of
    great informative site.

  10. May 30, 2013 at 5:27 pm | #11

    Hello there! This is my first visit to your blog! We are a group of volunteers and starting a new
    project in a community in the same niche. Your blog provided us beneficial information to work
    on. You have done a outstanding job!

  11. June 5, 2013 at 5:24 am | #12

    Good site you’ve got here.. It’s hard to find
    excellent writing like yours nowadays. I truly appreciate people like you!
    Take care!!

  12. June 6, 2013 at 10:39 pm | #13

    I take good care of such info a whole lot.

  13. June 23, 2013 at 7:33 am | #14

    I’m not sure where you’re getting your information, but great topic.
    I needs to spend some time learning more or understanding more.

    Thanks for magnificent information I was looking for this
    info for my mission.

  14. July 2, 2013 at 8:02 am | #15

    Somebody necessarily help to make seriously articles I
    might state. This is the very first time I frequented your website page and thus far?
    I surprised with the analysis you made to make this actual post incredible.
    Magnificent process!

  15. July 15, 2013 at 3:44 am | #16

    What’s up to every one, it’s genuinely a nice for me to go to see this
    web site, it includes priceless Information.

  16. July 19, 2013 at 6:25 pm | #17

    I believe that is one of the so much important information for me.
    And i am satisfied reading your article. However should statement on some
    general issues, The site taste is perfect, the articles is in point of fact nice
    : D. Just right task, cheers

  17. August 5, 2013 at 10:23 pm | #18

    Everything is very open with a clear description of the challenges.

    It was definitely informative. Your site is very useful.
    Thanks for sharing!

  18. August 15, 2013 at 6:12 pm | #19

    Wow! Finally I got a web site from where I be able
    to genuinely obtain helpful facts regarding my study and knowledge.

  19. September 21, 2013 at 1:56 am | #20

    You’re so cool! I do not suppose I have read through something like that
    before. So great to discover somebody with unique thoughts
    on this subject matter. Really.. thank you for starting this up.

    This website is something that’s needed on the web, someone with
    a little originality!

  20. November 25, 2013 at 4:54 pm | #21

    wonderful submit, very informative. I ponder why the other specialists of this sector do not notice this. You should proceed your writing. I am confident, you have a great readers’ base already!

  21. November 25, 2013 at 5:30 pm | #22

    Greetings! I’ve been following your weblog for a while now and finally got the bravery to go ahead and give you a shout out from Kingwood Texas! Just wanted to mention keep up the good work!

  22. February 20, 2014 at 6:13 am | #23

    Hello my loved one! I wish to say that this article is amazing,
    nice written and include approximately all significant infos.
    I’d like to peer extra posts like this .

  23. March 7, 2014 at 11:13 pm | #24

    Good site you’ve got here.. It’s difficult to find good quality writing like yours these days.
    I honestly appreciate individuals like you! Take care!!

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: