This discussion is archived
1 2 3 Previous Next 37 Replies Latest reply: Dec 12, 2006 7:14 AM by pcharan RSS

Change Database Homepage Port

449049 Newbie
Currently Being Moderated
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.
  • 1. Re: Change Database Homepage Port
    Srinivas Newbie
    Currently Being Moderated
    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).
  • 2. Re: Change Database Homepage Port
    449049 Newbie
    Currently Being Moderated
    Thank you very much. Problem solved.
  • 3. Re: Change Database Homepage Port
    136321 Newbie
    Currently Being Moderated
    I change it to port 80.
    Restart it isn't required.
  • 4. Re: Change Database Homepage Port
    441000 Newbie
    Currently Being Moderated
    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
         

    -                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
  • 5. Re: Change Database Homepage Port
    136321 Newbie
    Currently Being Moderated
    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;
    /
  • 6. Re: Change Database Homepage Port
    241066 Newbie
    Currently Being Moderated
    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.
  • 7. Re: Change Database Homepage Port
    DietmarAust Oracle ACE
    Currently Being Moderated
    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.
  • 8. Re: Change Database Homepage Port
    466360 Newbie
    Currently Being Moderated
    &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="" />
  • 9. Re: Change Database Homepage Port
    466360 Newbie
    Currently Being Moderated
     
  • 10. Re: Change Database Homepage Port
    466340 Newbie
    Currently Being Moderated
    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
  • 11. Re: Change Database Homepage Port
    466340 Newbie
    Currently Being Moderated
    ok, so I just read up on dbms_epg, so that answers the first part...

    http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_epg.htm

    I guess there's still the performance question though...
  • 12. Re: Change Database Homepage Port
    MarceloF.Ochoa Oracle ACE
    Currently Being Moderated
    Hi Mike:
    You can use DBPrism Servlet Engine mod_plsql emulation.
    http://www.dbprism.com.ar/dbprism/doc/Home.html
    Latest version (CVS) works perfect with HTMLDB installed on XE, you can download a zip version from files section of Yahoo groups:
    http://groups.yahoo.com/group/dbprism/files/patchs/
    htmldb-11-08-05.zip is ready to use deployment for OC4J and Tomcat mapped as http://localhost:8888/htmldb/ for example.
    You only need to download the HTMLDB static resources (http://localhost:8080/i) using wget or any download accelerator program and put them into the ORACLE_HOME/j2ee/home/default-web-app or into TOMCAT_HOME/webapps/ROOT for example.
    Your performance will be enhanced using this configuration and you will have many other features provides by DBPrism.
    Best regards, Marcelo.
  • 13. Re: Change Database Homepage Port
    DietmarAust Oracle ACE
    Currently Being Moderated
    Hi,

    I could reproduce the problem using the latest Apache 2 (2.0.55) and it was terribly slow.

    Using Apache 1.3.33 it was REALLY FAST, no performance differences at all.

    Don't know why it is so slow using Apache2, but Apache 1.3.33 works really well.

    Regards,
    ~Dietmar.

    P.S.: I used both on Windows XP SP2, haven't checked on Linux

    Message was edited by:
    daust_de
  • 14. Re: Change Database Homepage Port
    466340 Newbie
    Currently Being Moderated
    Thanks for the pointers on DBPrism Marcelo, I'll check it out.

    Dietmar - I did a search on proxypass performance, and came up with a mention of a bug in Apache 2 from http://www.apacheweek.com/features/reverseproxies -

    Check libxml2 is installed. If you have a version older than 2.5.10, then upgrade - there's a bug in earlier versions that can, in some particular cases, severely affect performance.

    Not sure if thats it, but it could be the culprit.

    Cheers,

    Mike
1 2 3 Previous Next