This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Jan 22, 2009 6:33 AM by 681273 RSS

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

498303 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    >
    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 Newbie
    Currently Being Moderated
    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