13 Replies Latest reply: Nov 8, 2012 10:44 PM by 973358 RSS

    Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)

    973358
      Hello there,

      After installing for the first time the Database 11g Express Edition on my PC, I cannot connect to the local host, in order to access the home page of the database. The error encountered is from the browser, saying that it cannot find the page. Please help.

      This question is posted after *7 hours* of searching the web (mainly on this forum) on which I haven't found my solution, so please read the following before you answer:

      OS: Windows 7 Ultra 32bit
      Operating port - the default 8080, which is not used by any other service at this moment (verified with netstat)
      Status of Listener: running (verified with lstnerl status)
      Browser: Chrome with no proxy (whatsoever)
      Services running (and restarted to make sure): OracleServiceXe, OracleXETNSListener and I have manually started OracleXeClrAgent and MTSRecovery
      Database: running, according to the "Start Database" batch

      Observations:
      - when issuing netstat in the above presented conditions, I have nothing on port 8080, where the HTTP Server should be
      - according to the executable made by ORACLE, my database is running but when trying to connect with "sqlplus /nolog" as "system" it gives me error number 01033: initialization or shutdown in progress, which is weird. Even weirder is that the prompt changes to SQL, after this error (like nothing happened).

      I don't know what to do, honestly. I have tried everything that I found in the search section until the moment, but nothing helped. Can you please lay it out to me, in a simple form so that anyone could understand? My knowledge is limited, this is the first time when I play with Oracle.
        • 1. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
          sb92075
          970355 wrote:
          Hello there,

          After installing for the first time the Database 11g Express Edition on my PC, I cannot connect to the local host, in order to access the home page of the database. The error encountered is from the browser, saying that it cannot find the page. Please help.

          This question is posted after *7 hours* of searching the web (mainly on this forum) on which I haven't found my solution, so please read the following before you answer:

          OS: Windows 7 Ultra 32bit
          Operating port - the default 8080, which is not used by any other service at this moment (verified with netstat)
          Status of Listener: running (verified with lstnerl status)
          Browser: Chrome with no proxy (whatsoever)
          Services running (and restarted to make sure): OracleServiceXe, OracleXETNSListener and I have manually started OracleXeClrAgent and MTSRecovery
          Database: running, according to the "Start Database" batch

          Observations:
          - when issuing netstat in the above presented conditions, I have nothing on port 8080, where the HTTP Server should be
          - according to the executable made by ORACLE, my database is running but when trying to connect with "sqlplus /nolog" as "system" it gives me error number 01033: initialization or shutdown in progress, which is weird. Even weirder is that the prompt changes to SQL, after this error (like nothing happened).

          I don't know what to do, honestly. I have tried everything that I found in the search section until the moment, but nothing helped. Can you please lay it out to me, in a simple form so that anyone could understand? My knowledge is limited, this is the first time when I play with Oracle.
          open Command Window & enter the lines below EXACTLY as presented here

          sqlplus
          / as sysdba
          shutdown abort
          startup
          exit

          COPY all the results from above then PASTE all back here
          • 2. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
            973358
            You're exact commands did not work, but here's what I did:
            #sqlplus /nolog (sqlplus asked for an user) LE: I tried logging with "system" user and it showed the same results
            #connect /as sysdba
            #shutdown abort
            #startup

            As a result, the Oracle instance was first shut, and then started. On the last step I received "ORA-00205 error in identifying control file, check alert log for more info".
            Don't know where to find this file..
            • 3. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
              973358
              C:\Users\Silviu>sqlplus

              SQL*Plus: Release 11.2.0.2.0 Production on V Noi 9 03:17:03 2012

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

              Enter user-name: system
              Enter password:
              ERROR:
              ORA-01033: ORACLE initialization or shutdown in progress
              Process ID: 0
              Session ID: 0 Serial number: 0


              Enter user-name: /as sysdba

              Connected to:
              Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

              SQL> shutdown abort
              ORACLE instance shut down.
              SQL> startup
              ORACLE instance started.

              Total System Global Area 644468736 bytes
              Fixed Size 1385488 bytes
              Variable Size 192941040 bytes
              Database Buffers 444596224 bytes
              Redo Buffers 5545984 bytes
              ORA-00205: error in identifying control file, check alert log for more info

              This is the complete log (I've registered as a forum user now)
              • 4. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                sb92075
                970355 wrote:
                You're exact commands did not work, but here's what I did:
                #sqlplus /nolog (sqlplus asked for an user) LE: I tried logging with "system" user and it showed the same results
                #connect /as sysdba
                #shutdown abort
                #startup

                As a result, the Oracle instance was first shut, and then started. On the last step I received "ORA-00205 error in identifying control file, check alert log for more info".
                Don't know where to find this file..
                check alert log for more info
                do OS file FIND of "alert_XE.log" filename.

                the controlfile typically resides in the same folder as where "system01.dbf" file resides;
                which is usually somewhere under the "oradata" folder.
                • 5. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                  973358
                  I have not find such a file. And the only thing available in Oradata is an empty folder, called XE.

                  L.E: Oh wait, I found it.

                  Edited by: 970355 on Nov 8, 2012 5:55 PM

                  ORA-205 signalled during: ALTER DATABASE MOUNT...
                  Fri Nov 09 03:17:48 2012
                  MMNL started with pid=16, OS id=2084
                  Fri Nov 09 03:37:42 2012
                  Shutting down instance (abort)
                  License high water mark = 1
                  USER (ospid: 2736): terminating the instance
                  Instance terminated by USER, pid = 2736
                  Fri Nov 09 03:37:44 2012
                  Instance shutdown complete
                  Fri Nov 09 03:37:53 2012
                  Starting ORACLE instance (normal)
                  LICENSE_MAX_SESSION = 0
                  LICENSE_SESSIONS_WARNING = 0
                  Picked latch-free SCN scheme 2
                  Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
                  Autotune of undo retention is turned on.
                  IMODE=BR
                  ILAT =18
                  LICENSE_MAX_USERS = 0
                  SYS auditing is disabled
                  Starting up:
                  Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production.
                  Using parameter settings in server-side pfile C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DATABASE\INITXE.ORA
                  System parameters with non-default values:
                  sessions = 172
                  spfile = "C:\ORACLEXE\APP\ORACLE\PRODUCT\11.2.0\SERVER\DBS\SPFILEXE.ORA"
                  memory_target = 1G
                  control_files = "C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF"
                  compatible = "11.2.0.0.0"
                  db_recovery_file_dest = "C:\oraclexe\app\oracle\fast_recovery_area"
                  db_recovery_file_dest_size= 10G
                  undo_management = "AUTO"
                  undo_tablespace = "UNDOTBS1"
                  remote_login_passwordfile= "EXCLUSIVE"
                  dispatchers = "(PROTOCOL=TCP) (SERVICE=XEXDB)"
                  shared_servers = 4
                  job_queue_processes = 4
                  audit_file_dest = "C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP"
                  db_name = "XE"
                  open_cursors = 300
                  diagnostic_dest = "C:\ORACLEXE\APP\ORACLE"
                  Fri Nov 09 03:38:06 2012
                  PMON started with pid=2, OS id=4000
                  Fri Nov 09 03:38:07 2012
                  PSP0 started with pid=3, OS id=6032
                  Fri Nov 09 03:38:07 2012
                  VKTM started with pid=4, OS id=2264 at elevated priority
                  VKTM running at (10)millisec precision with DBRM quantum (100)ms
                  Fri Nov 09 03:38:07 2012
                  GEN0 started with pid=5, OS id=4392
                  Fri Nov 09 03:38:07 2012
                  DIAG started with pid=6, OS id=2572
                  Fri Nov 09 03:38:07 2012
                  DBRM started with pid=7, OS id=1536
                  Fri Nov 09 03:38:07 2012
                  DIA0 started with pid=8, OS id=4844
                  Fri Nov 09 03:38:07 2012
                  MMAN started with pid=9, OS id=4692
                  Fri Nov 09 03:38:07 2012
                  DBW0 started with pid=10, OS id=3072
                  Fri Nov 09 03:38:07 2012
                  LGWR started with pid=11, OS id=6096
                  Fri Nov 09 03:38:07 2012
                  CKPT started with pid=12, OS id=4976
                  Fri Nov 09 03:38:07 2012
                  SMON started with pid=13, OS id=5992
                  Fri Nov 09 03:38:07 2012
                  RECO started with pid=14, OS id=4652
                  Fri Nov 09 03:38:07 2012
                  MMON started with pid=15, OS id=1344
                  Fri Nov 09 03:38:07 2012
                  starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                  Fri Nov 09 03:38:07 2012
                  MMNL started with pid=16, OS id=5212
                  starting up 4 shared server(s) ...
                  ORACLE_BASE from environment = C:\oraclexe\app\oracle
                  Fri Nov 09 03:38:07 2012
                  ALTER DATABASE MOUNT
                  ORA-00210: cannot open the specified control file
                  ORA-00202: control file: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF'
                  ORA-27041: unable to open file
                  OSD-04002: unable to open file
                  O/S-Error: (OS 2) The system cannot find the file specified.
                  ORA-205 signalled during: ALTER DATABASE MOUNT...

                  Edited by: 970355 on Nov 8, 2012 5:58 PM
                  • 6. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                    orafad
                    Well maybe you should have searched this forum: Oracle Database Express Edition (XE)

                    Among first things to check is if log files under config\log\ directory, e.g. cloneRmanRestore.log, contain any errors from db creation during installation.
                    • 7. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                      973358
                      Please, don't send any more links unless it's toward my specific problem. I've searched, as I said, for 7 hours. I'm full of it. I'm at the point of throwing my PC out of the window.

                      Thank you.
                      • 8. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                        orafad
                        What is the "specific problem" exactly?

                        If you don't aim to find out what the problem is and why it is, easiest way forward, or at least to the side, is probably to deinstall XE, then make sure Windows event logs are free/not full, then re-install (and hope for better luck).

                        Edited by: orafad on Nov 9, 2012 3:12 AM
                        • 9. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                          sb92075
                          from Command Window issue OS command below

                          dir /q/t C:\ORACLEXE\APP\ORACLE\ORADATA\XE\
                          • 10. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                            973358
                            You were right. It seems that I had some problems with the memory. Certain files could not be created during installation because I was low on storage. This is a bit strange, considering the software required around 500MB and I had 2GB free.

                            Leaving that aside, I've reinstalled on another drive and it has worked. The only problem that seems to be now is that I cannot go pass the logon screen - from the browser. I insert the "system" user and the password set when installing, and it does nothing. My firewall is shut btw.

                            When I log in from the command line using #sqlplus, the user and the SAME password, it works. Any ideas?

                            P.S: This happens for Apex. When I try to go to 127.0.0.1:htmldb it says that the requested URL has not been found

                            Edited by: 970355 on Nov 8, 2012 6:49 PM
                            • 11. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                              orafad
                              Which of the login screens? Try to navigate and log on per Getting Started guide. http://docs.oracle.com/cd/E17781_01/index.htm

                              Note that Apex user != database user, which might be one explanation to the login/password difference you perceived.

                              The html db url posted is wrong (bad port number) and htmldb is also an older term, which may not exist or work in recent versions of the product (can't remember how it behaved in 2.x and 3.x).


                              As sb said below, this is a separate question and is better off in a separate thread.

                              Edited by: orafad on Nov 9, 2012 5:18 AM
                              • 12. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                                sb92075
                                consider closing this thread & opening a new in the APEX sub-forum

                                Oracle Application Express (APEX)
                                • 13. Re: Cannot connect to 127.0.0.1:8080/apex or /htmldb (home page problems)
                                  973358
                                  Thank you very much for the help guys. I'll see what I can do from now on.