This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Sep 28, 2011 3:55 AM by EdStevens RSS

change  ip address and port for Oracle Database 11 g express

890610 Newbie
Currently Being Moderated
Hi,

I would like to know, how to change the default ip address (127.0.0.1) and port(8080) for Oracle Database 11 g express edition

Ray
  • 1. Re: change  ip address and port for Oracle Database 11 g express
    sb92075 Guru
    Currently Being Moderated
    user4670686 wrote:
    Hi,

    I would like to know, how to change the default ip address (127.0.0.1) and port(8080) for Oracle Database 11 g express edition
    databases do not have IP Address only OS/Network Interface Cards do.
    Since you decided not to share with us any details about your environment, no answer is possible now.

    Is GOOGLE broken for you?
  • 2. Re: change  ip address and port for Oracle Database 11 g express
    890610 Newbie
    Currently Being Moderated
    I do have Oracle 11g server running on local windows machine . JBoss server is also using the ip address 127.0.0.1 and port 8080, so I don't want mess up with port , Do oracle have server.xml files (or such files) to override entry for ip address and port , Is there any other simple way other than making entry to host file under driver/etc folder ?
  • 3. Re: change  ip address and port for Oracle Database 11 g express
    sb92075 Guru
    Currently Being Moderated
    http://www.lmgtfy.com/?q=Oracle+express+change+port

    http://www.lmgtfy.com/?q=Oracle+windows+change+ip
  • 4. Re: change  ip address and port for Oracle Database 11 g express
    890610 Newbie
    Currently Being Moderated
    I tried the following command for changing port and ran select command it got changed to 99. But when I tried to access it through url (http://127.0.0.1:8090/apex/f?p=4950) it failed

    SQL> begin
    2 dbms_xdb.sethttpport('99');
    3 dbms_xdb.setftpport('2199');
    4 end;
    5 /

    When I opened up the Get Started menu under Oracle Express Edition 11g (windows start menu) still it points to http://127.0.0.1:8080/apex/f?p=4950, 8080 port?. Does process id 4950 needs to get changed.
  • 5. Re: change  ip address and port for Oracle Database 11 g express
    890610 Newbie
    Currently Being Moderated
    I tried the following command for changing port and ran select command it got changed to 99. But when I tried to access it through url (http://127.0.0.1:8099/apex/f?p=4950) it failed

    SQL> begin
    2 dbms_xdb.sethttpport('99');
    3 dbms_xdb.setftpport('2199');
    4 end;
    5 /

    When I opened up the Get Started menu under Oracle Express Edition 11g (windows start menu) still it points to http://127.0.0.1:8080/apex/f?p=4950, 8080 port?. Does process id 4950 needs to get changed.

    Edited by: user4670686 on Sep 26, 2011 5:57 PM
  • 6. Re: change  ip address and port for Oracle Database 11 g express
    890610 Newbie
    Currently Being Moderated
    I tried the following command for changing port and ran select command it got changed to 99. But when I tried to access it through url (http://127.0.0.1:8090/apex/f?p=4950) it failed

    SQL> begin
    2 dbms_xdb.sethttpport('99');
    3 dbms_xdb.setftpport('2199');
    4 end;
    5 /

    When I opened up the Get Started menu under Oracle Express Edition 11g (windows start menu) still it points to http://127.0.0.1:8080/apex/f?p=4950, 8080 port?. Does process id 4950 needs to get changed.
  • 7. Re: change  ip address and port for Oracle Database 11 g express
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    user4670686 wrote:
    I tried the following command for changing port and ran select command it got changed to 99. But when I tried to access it through url (http://127.0.0.1:8090/apex/f?p=4950) it failed

    SQL> begin
    2 dbms_xdb.sethttpport('99');
    3 dbms_xdb.setftpport('2199');
    4 end;
    5 /
    Why are you violating basic networking standards by abusing both the well-known and registered port ranges?
    When I opened up the Get Started menu under Oracle Express Edition 11g (windows start menu) still it points to http://127.0.0.1:8080/apex/f?p=4950, 8080 port?. Does process id 4950 needs to get changed.
    Of course it still points to the original setting. You made a parameter change in the database server. You cannot expect the database to go and find and update all shortcuts, desktop menus, client code, scripts and what not for you too to cater for that database server parameter change.
  • 8. Re: change  ip address and port for Oracle Database 11 g express
    890610 Newbie
    Currently Being Moderated
    I dont want to change the default port for JBoss so I need to use port 8099 for Oracle, I have given wrong port in my previous post , can you help me in understanding why this url is not connecting to 8099. Please find the right url http://127.0.0.1:8099/apex/f?p=4950.
  • 9. Re: change  ip address and port for Oracle Database 11 g express
    Paulie Pro
    Currently Being Moderated
    >
    I would like to know, how to change the default ip address (127.0.0.1) and port(8080) for Oracle Database 11 g express edition
    I would suggest that you uninstall and reinstall. IIRC, you are offered a choice of APEX port on install. Don't choose a low
    port number - I always go for the port number + 1 in the event of a conflict - it's easy to remember. Tomcat also uses
    8080 by default - so I just set it to 8081 - works a treat.

    You won't be able to change 127.0.0.1 (though why you would want to is beyond me) - it's the "home" address
    of every machine under the TCP/IP protocol - having it as your home for your Oracle database and/or APEX
    install won't affect any other programme running on the machine - the important thing is the the port - obviously
    you can't have two services running on the same "port" (ports being a virtual concept).

    HTH,


    Paul...

    Ray
  • 10. Re: change  ip address and port for Oracle Database 11 g express
    890610 Newbie
    Currently Being Moderated
    Hi ,

    Thanks Paul.At the time of server install I do not find option to change the port from 8080 to 8081, What is APEX port ? Where can I find it among the configuration files ?

    Ram
  • 11. Re: change  ip address and port for Oracle Database 11 g express
    Paulie Pro
    Currently Being Moderated
    >

    Thanks Paul.At the time of server install I do not find option to change the port from 8080 to 8081,
    What is APEX port ? Where can I find it among the configuration files ?
    The Oracle database normally runs on port 1521 IIRC, this means that the database* responds to requests
    on that port number. BTW, you didn't mention your operating system.

    APEX is Oracle's application express and runs off port 8080 by default. In APEX there's an Apache web server
    or some such buried in there somewhere.

    You specifically* mention port 8080 in your original post, so I'm assuming you have some sort of conflict
    with APplication EXpress. As I said, Tomcat uses port 8080 by default as do a number of apps - see here
    http://wiki.answers.com/Q/What_uses_port_8080.

    When you install XE (or under Linux set it up to run for the first time) you are asked what port you wish to run
    APEX under - if you're having a conflict use 8081 or whatever (but not below 1023). Then you use
    http://127.0.0.1:8081/apex to connect to Oracle application express. That's what I do and it works fine.

    Leave 127.0.0.1 alone - it has nothing to do with any problems you may be having - you can't change it anyway.

    HTH,


    Paul...

    Ram
  • 12. Re: change  ip address and port for Oracle Database 11 g express
    EdStevens Guru
    Currently Being Moderated
    Paulie wrote:
    >

    Thanks Paul.At the time of server install I do not find option to change the port from 8080 to 8081,
    What is APEX port ? Where can I find it among the configuration files ?
    The Oracle database normally runs on port 1521 IIRC, this means that the database* responds to requests
    on that port number. BTW, you didn't mention your operating system.
    BZZTT!!!
    The database doesn't run on any port at all. The database doesn't require any networking.
    1521 is the default port for the listener, which is a completely separate process from any of the databases it is servicing. And yes, I mean any of the databases the listener is servicing, because one single listener, with the default name of LISTENER, using the default listener port of 1521, is quite capable of - was designed to - service multiple database instances of multiple versions running from multiple ORACLE_HOMEs.

    >
    APEX is Oracle's application express and runs off port 8080 by default. In APEX there's an Apache web server
    or some such buried in there somewhere.

    You specifically* mention port 8080 in your original post, so I'm assuming you have some sort of conflict
    with APplication EXpress. As I said, Tomcat uses port 8080 by default as do a number of apps - see here
    http://wiki.answers.com/Q/What_uses_port_8080.

    When you install XE (or under Linux set it up to run for the first time) you are asked what port you wish to run
    APEX under - if you're having a conflict use 8081 or whatever (but not below 1023). Then you use
    http://127.0.0.1:8081/apex to connect to Oracle application express. That's what I do and it works fine.

    Leave 127.0.0.1 alone - it has nothing to do with any problems you may be having - you can't change it anyway.

    HTH,


    Paul...

    Ram
  • 13. Re: change  ip address and port for Oracle Database 11 g express
    Paulie Pro
    Currently Being Moderated
    >

    The Oracle database normally runs on port 1521 IIRC, this means that the database* responds to requests
    on that port number. BTW, you didn't mention your operating system.
    BZZTT!!!
    The database doesn't run on any port at all. The database doesn't require any networking.
    1521 is the default port for the listener, which is a completely separate process from any of the databases it is servicing.
    Yes, my bad. Just a bit of poetic licence to simplify matters - of course the database can be running without anything
    listening on 1521 or any other port - just wouldn't be much good except as a single user app - which kinda defeats
    the purpose of having Oracle at all - SQLite would be your man here - maintenance &c. excepted.

    The listener does get launched by default though, so it's not that* big a leap - kind of you to point it
    out though, for thoroughness.

    And yes, I mean any of the databases the listener is servicing, because one single listener, with the
    default name of LISTENER, using the default listener port of 1521, is quite capable of - was designed
    to - service multiple database instances of multiple versions running from multiple ORACLE_HOMEs.
    Yep - OK - thanks for clarification <Paulie suitably humbled...>


    Paul...
  • 14. Re: change  ip address and port for Oracle Database 11 g express
    BillyVerreynne Oracle ACE
    Currently Being Moderated
    EdStevens wrote:

    The database doesn't run on any port at all. The database doesn't require any networking.
    Actually it does. Never say never and all that... :-)

    Dispatcher processes actively binds and listens on tcp ports:
    [root@dev1 ~]# ps -fu oracle | grep ora_d0 
    oracle   12879     1  0 Sep26 ?        00:00:00 ora_d000_dev1
    oracle   12881     1  0 Sep26 ?        00:00:00 ora_d001_dev1
    [root@dev1 ~]# 
    [root@dev1 ~]# lsof -p 12879 | grep -i tcp
    oracle  12879 oracle   34u  IPv6          961045066                 TCP *:17536 (LISTEN)
    [root@dev1 ~]# lsof -p 12881 | grep -i tcp
    oracle  12881 oracle   34u  IPv6          961045153                 TCP *:43691 (LISTEN)
    There's also peer networking between database processes over UDP. E.g.
    [root@dev1 ~]# ps -fu oracle | grep ora_pmon
    oracle   12811     1  0 Sep26 ?        00:00:59 ora_pmon_dev1
    [root@dev1 ~]# lsof -n -p 12811 | grep IP
    oracle  12811 oracle   23u  IPv4          961038506                 UDP 169.254.14.242:12618 
    oracle  12811 oracle   26u  IPv4          961038507                 UDP 127.0.0.1:11706 
    oracle  12811 oracle   29u  IPv4          961038522                 UDP 169.254.14.242:56164 
    oracle  12811 oracle   30u  IPv6          961038542                 UDP [::1]:29294 
    oracle  12811 oracle   31u  IPv4          961038587                 TCP 10.251.95.239:41767->10.251.95.63:ncube-lm (ESTABLISHED)
    oracle  12811 oracle   34u  IPv4          961437087                 TCP 10.251.95.64:39032->10.251.95.64:ncube-lm (ESTABLISHED)
    The last 2 tcp connections of the process monitor process are to listeners - port 1521 is officially registered for ncube and not Oracle. The official registered tcp port for Oracle, as per the Internet Assigned Numbers Authority is 1527. Have always wondered why Oracle winded up using 1521 instead..?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points