Forum Stats

  • 3,749,895 Users
  • 2,250,074 Discussions
  • 7,866,685 Comments

Discussions

Categories

Change Database Homepage Port

449049
449049 Member Posts: 6
edited Dec 12, 2006 10:14AM in Oracle Database Express Edition (XE)
I use to run Apache Tomcat on port 8080. Does one of you guys know how to change the database homepage port to 8081, or something else?

The installation under Windows XP did not offer such an option.

Thank you.
· Share on TwitterShare on Facebook
«134

Comments

  • Srinivas
    Srinivas Member Posts: 61
    Login to the database with SYSDBA privileges.

    SQL> exec dbms_xdb.sethttpport('8081');

    Bounce the database or start-stop OracleServiceXE.(I am not sure if this is required)

    Try accessing the new port.

    The .url files in ORACLE_HOME have to be updated to keep your start-menu shortcuts working (they may still be pointing to 8080).
    · Share on TwitterShare on Facebook
  • 449049
    449049 Member Posts: 6
    Thank you very much. Problem solved.
    · Share on TwitterShare on Facebook
  • sveh
    sveh Member Posts: 4
    I change it to port 80.
    Restart it isn't required.
    · Share on TwitterShare on Facebook
  • 441000
    441000 Member Posts: 118
    Hello,

    I have done this with port 80.

    When I go to

    http://127.0.0.1/htmldb

    It works fine.

    When I do this:

    http://127.0.0.1/

    I get the text on the browser below, running on Windows 2000. How can I stop the directory being browser and redirect always to http://127.0.0.1/htmldb?
    Index of /
    
Name 	Last modified 	Size
    
i/ 	Wed, 02 Nov 2005 01:00:00 GMT -
    
public/ 	Mon, 10 Oct 2005 10:00:00 GMT-
    
sys/ 	Mon, 10 Oct 2005 10:00:00 GMT


    
-
    · Share on TwitterShare on Facebook
  • sveh
    sveh Member Posts: 4
    Hello!

    Run SQL Command Line, connect as system and write:

    declare
    result boolean;
    v_html varchar2(512);
    begin
    v_html := '<html><body>< a href="/htmldb">Home page< /a></body></html>';
    -- DBMS_XDB.deleteResource('/index.html');
    result := dbms_xdb.createresource('/index.html',v_html);
    commit;
    end;
    /
    · Share on TwitterShare on Facebook
  • 241066
    241066 Member Posts: 776
    Be careful doing this. We may use this page in the production version to display a welcome page, or perhaps even the license details. As such, the production release may attempt to change this page during the upgrade from beta. I doubt we will cater for situations where the page has been removed or changed from what we expect to find there.
    · Share on TwitterShare on Facebook
  • Dietmar Aust
    Dietmar Aust Member Posts: 1,939 Bronze Badge
    Hi Greg,

    perhaps it might be a good choice to have an standalone Apache server running in front of XE for several reasons.

    You could then set up the standalone Apache running on port 80 as a proxy to XE running on port 8080.

    You could then configure it the following way in the httpd.conf:
    ProxyPass /htmldb http://127.0.0.1:8080/htmldb
    ProxyPassReverse /htmldb http://127.0.0.1:8080/htmldb
    ProxyPass /i http://127.0.0.1:8080/i
    ProxyPassReverse /i http://127.0.0.1:8080/i

    and the index.html in your Apache/htdocs directory could do a redirect to /htmldb.
    Done.

    It might be worth considering.

    Regards,
    ~Dietmar.
    · Share on TwitterShare on Facebook
  • 466360
    466360 Member Posts: 40
    edited Nov 10, 2005 12:28AM
    &gt; You could then configure it the following way in the

    &gt; httpd.conf:

    &gt; ProxyPass /htmldb http://127.0.0.1:8080/htmldb

    &gt; ProxyPassReverse /htmldb

    &gt; b http://127.0.0.1:8080/htmldb

    &gt; ProxyPass /i http://127.0.0.1:8080/i

    &gt; ProxyPassReverse /i http://127.0.0.1:8080/i

    &gt;


    Dietmar, thanks for sharing this.


    But WOW ! the response is at least 5 X s.l.o.w.e.r !!!
    <img src="http://www.iamviet.com/forum/images/smilies/smilie_pop_eyes.gif" alt="" />
    · Share on TwitterShare on Facebook
  • 466360
    466360 Member Posts: 40
    edited Nov 10, 2005 12:28AM
    &nbsp;
    · Share on TwitterShare on Facebook
  • 466340
    466340 Member Posts: 52
    But WOW ! the response is at least 5 X s.l.o.w.e.r !!!
    Yeah, I was wondering how that passthrough technique would affect performance. Is there any other way to access XE schema's directly instead of through htmlDB/XDB - is it possible to run apache with mod_plsql?

    I take it that would take a separate oracle home with a licenced version of the DB or appserver to achieve?

    Any thoughts?

    Regards,

    Mike
    · Share on TwitterShare on Facebook
This discussion has been closed.