1 2 Previous Next 16 Replies Latest reply: Sep 28, 2011 5:55 AM by EdStevens RSS

    change  ip address and port for Oracle Database 11 g express

    890610
      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
          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
            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
              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
                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
                  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
                    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
                      Billy~Verreynne
                      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
                        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
                          >
                          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
                            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
                              >

                              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
                                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
                                  >

                                  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
                                    Billy~Verreynne
                                    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