1 2 Previous Next 25 Replies Latest reply: Jan 22, 2009 8:33 AM by 681273 RSS

    Installed Oracle 10g XE but cannot 'Go To Database Home Page'

    498303
      Hi all,

      I've installed Oracle 10g XE on my Win XP machine but cannot navigate to the database home page. The URL http://127.0.0.1:8080/apex will not connect.

      Any ideas?

      Thanks,
      Paul
        • 1. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
          498358
          I am also having the same problem. I installed Oracle 10g XE on my test Windows 2003 Server and tested the home page and it worked. Once I rebooted, it's coming back with page not found. I've also installed 10g XE on my personal XP Pro computer and I've rebooted several times and it's actually bringing up the home page.

          I've looked at IIS and I can't find anything that would prevent 127.0.0.1:8080/apex or localhost:8080/apex from bringing up the home page, but regardless of the address it keeps bringing back page not found.
          • 2. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
            498358
            Also, it may not be an IIS issue. It may be a environment variable (path) issue. What do I need to look for to try and resolve this issue?
            • 3. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
              498303
              I've not managed to come up with any answers as yet but will be back trying again tomorrow. Report back if you come up with anything.

              Thanks,
              Paul
              • 4. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                498290
                Same problem here, on Windows XP Pro. Perhaps an XP compatibility issue?

                I hope someone has a fix.

                Thanks!

                Dave.
                • 5. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                  498358
                  Well, I wouldn't call it an XP compatibility issue since the XP Pro install on my personal machine works for me. For me, it's my Windows Server 2003 machine having problems.

                  Kenan
                  • 6. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                    455356
                    I've got the same problem. I've got mySQL installed on the same computer. When I go to http://127.0.0.1/ I get the mySQL folders. Maybe both installations are using the same IP address?
                    • 7. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                      498899
                      Hi all,

                      We faced the same problem but when we reinstalled, it worked ok.
                      • 8. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                        Hans Forbrich
                        Oracle XE has it's own forum - to register and discuss XE problems with XE experts use URL http://www.oracle.com/technology/xe/registration

                        A few things to think about when troubleshooting XE connectivity problems:

                        1) Listener must be up (first)
                        2) Database must be up
                        3) Listener must recognize database
                        4) Listener must be monitoring for APEX (Home page)
                        5) Port for Apex must be available (8080, the default, is also default for tomcat and others)
                        6) All Oracle admin stuff must be handled by a user in the right group (ORA_DBA group in Windows, DBA in Linux). The group must have been set up using a local administrator (administrator, root) that can update the registry, create groups, and write to the disk.


                        I'll walk thru the steps of getting it all running in Linux - assuming successful install. Listener and database are services so use control panel appropriately. I start with database and listener down and show the various outputs
                        oracle@fuzzy:~> lsnrctl status

                        LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-MAR-2006 07:58:27

                        Copyright (c) 1991, 2005, Oracle.  All rights reserved.

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                        TNS-12541: TNS:no listener
                        TNS-12560: TNS:protocol adapter error
                          TNS-00511: No listener
                           Linux Error: 2: No such file or directory
                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fuzzy)(PORT=1521)))
                        TNS-12541: TNS:no listener
                        TNS-12560: TNS:protocol adapter error
                          TNS-00511: No listener
                           Linux Error: 111: Connection refused

                        oracle@fuzzy:~> # start the listener. Use control panel in Windows
                        oracle@fuzzy:~> lsnrctl start

                        LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-MAR-2006 08:00:45

                        Copyright (c) 1991, 2005, Oracle.  All rights reserved.

                        Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

                        TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                        System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
                        Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
                        Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
                        Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fuzzy.forbrichcomputing.ca)(PORT=1521)))

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                        STATUS of the LISTENER
                        ------------------------
                        Alias                     LISTENER
                        Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                        Start Date                16-MAR-2006 08:00:45
                        Uptime                    0 days 0 hr. 0 min. 0 sec
                        Trace Level               off
                        Security                  ON: Local OS Authentication
                        SNMP                      OFF
                        Default Service           XE
                        Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
                        Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
                        Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fuzzy.forbrichcomputing.ca)(PORT=1521)))
                        Services Summary...
                        Service "PLSExtProc" has 1 instance(s).
                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                        The command completed successfully
                        oracle@fuzzy:~> # make sure the database is running. Idle instance is not good
                        oracle@fuzzy:~> sqlplus / as sysdba

                        SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 16 08:02:59 2006

                        Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                        Connected to an idle instance.

                        SQL> rem start the database.  Use control panel in WIndows
                        SQL> startup
                        ORACLE instance started.

                        Total System Global Area  289406976 bytes
                        Fixed Size                  1258488 bytes
                        Variable Size              92277768 bytes
                        Database Buffers          192937984 bytes
                        Redo Buffers                2932736 bytes
                        Database mounted.
                        Database opened.
                        SQL> exit
                        Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
                        oracle@fuzzy:~> Check if listener knows about DB and APEX
                        oracle@fuzzy:~> lsnrctl status

                        LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-MAR-2006 08:04:56

                        Copyright (c) 1991, 2005, Oracle.  All rights reserved.

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                        STATUS of the LISTENER
                        ------------------------
                        Alias                     LISTENER
                        Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                        Start Date                16-MAR-2006 08:00:45
                        Uptime                    0 days 0 hr. 4 min. 10 sec
                        Trace Level               off
                        Security                  ON: Local OS Authentication
                        SNMP                      OFF
                        Default Service           XE
                        Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
                        Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
                        Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fuzzy.forbrichcomputing.ca)(PORT=1521)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fuzzy.forbrichcomputing.ca)(PORT=8080))(Presentation=HTTP)(Session=RAW))
                        Services Summary...
                        Service "PLSExtProc" has 1 instance(s).
                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                        Service "XE" has 1 instance(s).
                          Instance "XE", status READY, has 1 handler(s) for this service...
                        Service "XEXDB" has 1 instance(s).
                          Instance "XE", status READY, has 1 handler(s) for this service...
                        Service "XE_XPT" has 1 instance(s).
                          Instance "XE", status READY, has 1 handler(s) for this service...
                        The command completed successfully
                        oracle@fuzzy:~> Great - it has a handle for database (XE) and Apex (XEXDB)
                        oracle@fuzzy:~> but Apex is on 8080, which conflicts with Tomcat. Move Apex
                        oracle@fuzzy:~> sqlplus system/oracle

                        SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 16 08:06:37 2006

                        Copyright (c) 1982, 2005, Oracle.  All rights reserved.


                        Connected to:
                        Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

                        SQL> exec dbms_xdb.sethttpport(8090);

                        PL/SQL procedure successfully completed.

                        SQL> select dbms_xdb.gethttpport() from dual;

                        DBMS_XDB.GETHTTPPORT()
                        ----------------------
                                          8090

                        SQL> exit
                        Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
                        oracle@fuzzy:~> Check that Apex is on 8090
                        oracle@fuzzy:~> lsnrctl status

                        LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 16-MAR-2006 08:08:52

                        Copyright (c) 1991, 2005, Oracle.  All rights reserved.

                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                        STATUS of the LISTENER
                        ------------------------
                        Alias                     LISTENER
                        Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                        Start Date                16-MAR-2006 08:00:45
                        Uptime                    0 days 0 hr. 8 min. 6 sec
                        Trace Level               off
                        Security                  ON: Local OS Authentication
                        SNMP                      OFF
                        Default Service           XE
                        Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
                        Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
                        Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fuzzy.forbrichcomputing.ca)(PORT=1521)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fuzzy.forbrichcomputing.ca)(PORT=8090))(Presentation=HTTP)(Session=RAW))
                        Services Summary...
                        Service "PLSExtProc" has 1 instance(s).
                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                        Service "XE" has 1 instance(s).
                          Instance "XE", status READY, has 1 handler(s) for this service...
                        Service "XEXDB" has 1 instance(s).
                          Instance "XE", status READY, has 1 handler(s) for this service...
                        Service "XE_XPT" has 1 instance(s).
                          Instance "XE", status READY, has 1 handler(s) for this service...
                        The command completed successfully
                        oracle@fuzzy:~> # now check http://fuzzy:8090/apex/ with a browser - success
                        • 9. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                          499215
                          Hi Paul,

                          I experienced exactly the same problem. After spending 6 hours trying to follow suggestions from several forums, I read an advice to set the locale to en-us.
                          My locale was originally set to nl (dutch).
                          So i did the following (maybe not all steps are necessary):
                          - Un-installed OracleXE,
                          - restart the computer,
                          - set my locale to en-us,
                          - logoff my windows account,
                          - logon my windows account,
                          - re-installed OracleXE.

                          I could go directly to "Database homepage" at http://127.0.0.1:8080/apex without any other adjustments.
                          Later I changed my locale back to nl (dutch).
                          Everything works perfectly well.

                          Best regards,
                          Rui Rosado
                          • 10. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                            499390
                            I am trying to get 10gXE on an XP - Professional -

                            I followed your instructions up to a point Paul,

                            When I try to start up the DB, this is the error I get :
                            c:\ sqlplus ...
                            SQL> startup
                            ORA-01078: failure in processing system parameters
                            ORA-01565: error in identifying file 'C:\Progra~1\Oracle10g\app\oracle\product\1
                            0.2.0\server\dbs/spfileXE.ora'
                            ORA-27041: unable to open file
                            OSD-04002: unable to open file
                            O/S-Error: (OS 2) The system cannot find the file specified.
                            SQL>

                            Thing is : the dbs folder is not created under the app\oracle\...\server directory - how do I get that created? should it have been created automagically by the install?

                            Any help is appreciated -

                            Thanks in advance
                            • 11. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                              498303
                              That is bizarre!!

                              Just to clarify, the issue of changing the regional settings (locale) of my machine to English US solved the issue!

                              Thanks for your help on this matter.

                              Paul
                              • 12. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                                500009
                                Trying to install Express to Debian 'testing'. Install went fine. But browser will not let me connect to 8080 via http://localhost:8080/apex in FireFox. I get a pop-up "Connection refused.... 8080". I do have Apache2 installed but that just looks at 80 so there should be no conflict. I can get :631 for cups without an issue.

                                Maybe the following will help:


                                LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-MAR-2006 13:24:39

                                Copyright (c) 1991, 2005, Oracle. All rights reserved.

                                Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
                                STATUS of the LISTENER
                                ------------------------
                                Alias LISTENER
                                Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
                                Start Date 20-MAR-2006 12:42:34
                                Uptime 0 days 0 hr. 42 min. 5 sec
                                Trace Level off
                                Security ON: Local OS Authentication
                                SNMP OFF
                                Default Service XE
                                Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
                                Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
                                Listening Endpoints Summary...
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=debian1.aldomain)(PORT=1521)))
                                Services Summary...
                                Service "PLSExtProc" has 1 instance(s).
                                Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                                The command completed successfully
                                =============

                                I try: sqlplus system/oracle and it askes for name and password but nothing I put in seems to work.

                                I understand there is a forum for Express but I can't find it anywhere.

                                I'm an experienced Linux guy and let me tell you that if Oracle wants this Express thing to fly, they need to make this install 'slam dunk' or we just won't bother and will stick with MySQL. I really want to give Oracle a look-see but I'm not sure where to turn and I'm about ready to give up the ghost. Any help is appreciated.

                                Thanks,

                                Al
                                • 13. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                                  Hans Forbrich
                                  >
                                  I understand there is a forum for Express but I can't
                                  find it anywhere.
                                  Look about 4 messages previous in this thread and you will find:

                                  "Oracle XE has it's own forum - to register and discuss XE problems with XE experts use URL http://www.oracle.com/technology/xe/registration "

                                  Once you have registered, you can sign in to the forums and voila - the link to the XE forum is there. But you do have to sign in.

                                  >
                                  I'm an experienced Linux guy and let me tell you that
                                  if Oracle wants this Express thing to fly, they need
                                  to make this install 'slam dunk' or we just won't
                                  Come on over to the forum. Lots of people have made it work. I've found it a slam dunk when following the instructions.

                                  The challenge seem to include:

                                  1) tomcat and other things like to use port 8080.

                                  - funny thing ... I've seen a bunch of installs - people turn off the conflicting apps during the install. Then they reboot the machine and forget that the apps fire up and use the ports.

                                  If you can get Oracle's CLI running, the best thying to do is change the port as described in the 2 day DBA manual.

                                  2) firewalls do wierd things to ports

                                  - a consistent show stopper is having firewalls block the APEX ports

                                  2a) and bad /etc/hosts (and dhcp in general) does strange things to the listener's host setting

                                  $ORACLE_HOME/network/admin/listener.ora points to machine names.

                                  3) starting things in the wrong order just doesnt work

                                  Oracle XE uses a Listener - does a similar job to inetd, but for Oracle purposes. It needs to listen on port 1521 and the APEX port (default 8080).

                                  The database service registers itself and it's apex requirement to an listener when it's running. The listener must be up first. Funny thing about pre-reqs ...


                                  By far the most XE install problems I've seen in Linux have come from assumptions about the network config not matching the rather simple requirements Oracle has set.

                                  And in Windows, 99.9% of the problems I've encountered result from using a userid that does not have full local administrator privs. Domain administrator, non-admin user simply do not have the right privileges, but people insist on using them.
                                  • 14. Re: Installed Oracle 10g XE but cannot 'Go To Database Home Page'
                                    501120
                                    First I get the same error with using the IP. If I change it to http://localhost:8080/apex/ it works.

                                    If that doesn't work try stopping the world wide web publishing service and try http://localhost:8080/apex/ again.
                                    1 2 Previous Next