4 Replies Latest reply: Sep 27, 2010 3:10 AM by Billy~Verreynne RSS

    http://127.0.0.1:8080/apex  (Windows XP SP3)

    748742
      Before I posted this message, I have searched through your Oracle discussion page and have read some of the replies for those who had the same problem that I am having accessing the Oracle Datababase Home Page. I have tried to follow some of the instructions that were posted there but I got no luck and some of them do NOT make any sense or ambiguous or just blah, blah, blah!! Once again, I haven't had any problem with the Oracle 10g Express Edition that i have installed on my Windows machine for the past 1 year. Now I am getting this error message "http://127.0.0.1:8080/apex". I am able to ping via the great DOS Command and I got through without any problem at all with the 127.0.0.1 without inputting the 8080. I have also added port 8080 onto the Windows Firewall option (FYI).

      Anyway, I like to find what's wrong and what are the fix so that I can get back onto "Oracle Database Home Page". Please clarify the steps that are need to solve the problem. Once again, I am using Windows XP Profession with SP3. I haven't had any problem w/ the Oracle 10g Express Edition home page until today. Please help.
        • 1. Re: http://127.0.0.1:8080/apex  (Windows XP SP3)
          sb92075
          I haven't had any problem w/ the Oracle 10g Express Edition home page until today.
          What changed?
          Software does not spontaneously break.
          • 2. Re: http://127.0.0.1:8080/apex  (Windows XP SP3)
            Aman....
            Well, I also don't know the answer since I don't use this product. And this forum is for the core database product and its related topics. So I would suggest that you close the thread here and repost it on Apex's native forum(see below for link) where there are people who are using it day in and day out. Chances would be better to get a more correct reply from there,
            Oracle Application Express (APEX)

            HTH
            Aman....
            • 3. Re: http://127.0.0.1:8080/apex  (Windows XP SP3)
              Catch 22
              Is the listener running:

              'lsnrctl status' to make sure that the listener is running and listening on the http port.

              what is the contents of your hosts file?

              Is the database running?
              • 4. Re: http://127.0.0.1:8080/apex  (Windows XP SP3)
                Billy~Verreynne
                user12045999 wrote:
                Now I am getting this error message "http://127.0.0.1:8080/apex".
                This means one of 2 basic things:
                - the XE Listener is not running (check under Windows Services)
                - the Apex EPG is not configured in the XE database
                I am able to ping via the great DOS Command and I got through without any problem at all with the 127.0.0.1 without inputting the 8080.
                Do not confuse the 32bit command console of Windows with MS-DOS. They have very little in common (only shares common command names and nothing else).
                Anyway, I like to find what's wrong and what are the fix so that I can get back onto "Oracle Database Home Page". Please clarify the steps that are need to solve the problem.
                Check if the Listener is running. You can do that by looking at the services applet (Control Panel | Administration | Services).

                You can also do that via the command line command "+lsnrctl status+".

                You can test network connectivity to the listener using telnet, e.g. "+telnet 127.0.0.1 8080+" (press enter a few times upon a successful connection in order to disconnect).

                For Apex to work, you need EPG configured. This can be complex as all stylesheets, javascript and images required by Apex need to be loaded into the XDB (XML DB) portion of the Oracle database. Then XDB need to be configured with a DAD (Database Access Descriptor) - where this descriptor defines the "+apex+" location of the "+http://127.0.0.1:8080/apex+" URL and how to service web requests to it.

                If you download Apex (zip) from Oracle, you will find a configuration script called apex_epg_config_core.sql that does this. It can be used as a template of how to configure the "+apex+" DAD.

                Finally, you need the Oracle XE instance to register itself, and its XDB endpoints, with the XE Listener. For that, the initialisation parameter LOCAL_LISTENER needs to be correctly configured (or null for using the default configuration for the parameter).

                You now need to isolate the problem (listener not running/epg dad not configured/etc) and if unable to correct it, report back with the details of what you found and what you have tried.