8 Replies Latest reply on Mar 11, 2010 2:00 AM by 725793

    Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!

    Shra1
      Can anyone please advice, about some problems we're having running apex from windows xp box? We installed apex/epg on 10gXE on windows xp box, the app seems to run great with the url.

      http://127.0.0.1:8080/apex/f?p=111:1 (standard apex epg runtime url)

      Now, the network admin changed the windows box to have Static IP address and made it to 10.10.0.7...we rebooted the machine and also able to ping it in dos prompt.

      We're having trouble running the apex login with the new url...

      http://10.10.0.7:8080/apex/f?p=111:1

      Really appreciate any pointers or help in the above as we need to take deploy the above setup to a similar produciton box this week.

      Shravan
        • 1. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
          flavioc
          Are you trying to open the page with a browser located on the same machine or from another pc?

          Flavio
          -----
          http://oraclequirks.blogspot.com
          • 2. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
            Shra1
            Hi Flavio...The goal is to deploy the dev-instance to the users for testing...so, they need to log into apex from their machines to this dev-box via IE/Mozilla browser...If this works, Production box deployment will also be pursued on the same lines...Pls advice for any thoughts as what might be missing here - as it worked well with an other client in the past.
            • 3. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
              flavioc
              I understand but you didn't reply to my question, when you are trying to open the page with that IP address are you performing the operation from the same pc or from another client?

              If you are on the same machine and that machine has address 10.10.10.7 or whatever, you should be able to open the page without problems.
              If you are trying the operation from another machine, it could be that the two machines are not located on the same subnet, hence you cannot reach apex.
              Also, in XP may be there is some setting in the firewall that prevents you from accessing that address. Try to disable the firewall altogether and see if that improves the situation. If that works then you know you have to mess around with the firewall, if not, you'll have to look elsewhere...

              Flavio

              ----
              http://oraclequirks.blogspot.com
              1 person found this helpful
              • 4. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
                jariola
                Hi,

                This might help
                http://download.oracle.com/docs/cd/B25329_01/doc/install.102/b25143/toc.htm#BABFGGAG

                Br,Jari
                1 person found this helpful
                • 5. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
                  Shra1
                  Flavio..Thanks again..I tried with accessing apex app. on the SAME machine where apex/10gXE is installed with the static-ip reference in the url...That didn't work and also didn't work from an other machine, sitting right next to this machine (quick test failed from 2 machines)..

                  The fire-wall is OFF. I looked on forums further today...Do you think I may have to change the listener.ora on the host-machine to take the new IP into the listener.ora file as follows

                  LISTENER =
                  (DESCRIPTION_LIST =
                  (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
                  (ADDRESS = (PROTOCOL = TCP)(HOST = new_static_ip_address)(PORT = 1521))
                  )
                  )

                  and re-start the listener.ora? Pls. advice any further ideas...thanks for your time.
                  • 6. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
                    725793
                    Doesn't make much sense to me if you can't access it on the same machine.

                    Can you verify that 10.10.0.7 is in fact the machines ip address by issuing ipconfig in the command prompt (just to satisfy my curiosity)?

                    Also, can you ping that machine - from other machines in the same network?

                    Also, I don't see why you would need to edit the TNS entry? if you have the hostname in their, then it should resolve the ip address to that particular hostname.

                    Edited by: tr3nton on Mar 10, 2010 1:30 PM
                    • 7. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
                      Shra1
                      Thanks for your reply..

                      I was able to connect on the same machine as http://127.0.0.1:8080/apex/f?p=111:1 - However after apex was installed, I asked the network admin to give this machine a static IP address - 10.0.0.7 (eg) - I can ping the new machine and also when I pinged using the domain name from an other machine in the network - ping new_apex_test_box - its returning the new static IP address 10.0.0.7...However, when I tried to log into apex from the 2nd machine inside the network (behind the firewall) using the new static ip url, http://10.0.0.7:8080/apex/f?p=111:1, the browser simply cannot find the page!

                      Note: After the IP has been changed to static Ip, I rebooted the host-machine and the database/listener started automatically via windows-services.

                      Some other blog forums say that I may have to modify the listener.ora on the host-machine (10.0.0.7) and publish the domain within the network...Not sure what's going on...Please advice further for any tips.
                      • 8. Re: Running Oracle Apex on 10gXE/EPG config - Static IP Address Issues. Help!
                        725793
                        Can you connect to the database through a tool such as sqldeveloper or toad, with the hostname?