4 Replies Latest reply: Nov 19, 2012 8:28 AM by 974717 RSS

    "Get Started" URL is rejected and XE database does not appear to start

    974717
      Hi,

      Brand new to Oracle, so I apologize for my ignorance. Have spent 3 days trying to launch the Get Started URL that Oracle puts on my desktop, or connect with Rapid SQL. I've spent all day today trolling these forums and am unable to resolve this issue.

      OS: Windows 7 Enterprise SP1
      System: i7 @ 2.7GHz, 8GB RAM, 64-bit
      DB: OracleXE 11g

      Error message from Chrome when I try to connect to http://127.0.0.1:8080/apex/f?p=4950: Error 102 (net::ERR_CONNECTION_REFUSED): The server refused the connection.

      --------------

      Here is the result of my TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 16-NOV-2
      012 14:42:28

      Used parameter files:
      C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora

      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = CONNECTL
      AP28.awi.state.fl.us)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVIC
      E_NAME = XE)))
      OK (0 msec)

      ------------

      Here is the result of my LSNRCTL> status
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
      ction
      Start Date 16-NOV-2012 13:41:57
      Uptime 0 days 1 hr. 2 min. 50 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Default Service XE
      Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
      dmin\listener.ora
      Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\CONNECTLAP28\liste
      ner\alert\log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CONNECTLAP28.awi.state.fl.us)(PORT=1
      521)))
      Services Summary...
      Service "CLRExtProc" has 1 instance(s).
      Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully

      -------------------------

      Here is the result of my sqlplus / as sysdba

      SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 16 14:47:53 2012

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

      ERROR:
      ORA-28056: Writing audit records to Windows Event Log failed
      OSD-00512: Message 512 not found; product=RDBMS; facility=SOSD
      O/S-Error: (OS 1722) The RPC server is unavailable.
      ORA-28056: Writing audit records to Windows Event Log failed
      OSD-00512: Message 512 not found; product=RDBMS; facility=SOSD
      O/S-Error: (OS 1722) The RPC server is unavailable.

      Enter user-name: system
      Enter password:
      ERROR:
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Process ID: 0
      Session ID: 0 Serial number: 0

      I have uninstalled and reinstalled the 64-bit version, the 32-bit version, repaired, stopped and started services, changed KEY_XE.reg, and the properties of the Get Started URL. No luck so far. Please let me know what I can do.

      Thanks in advance.
        • 1. Re: "Get Started" URL is rejected and XE database does not appear to start
          orafad
          971714 wrote:

          Error message from Chrome when I try to connect to http://127.0.0.1:8080/apex/f?p=4950:
          No use in connecting as long as listener does not show the required 8080 endpoint.
          Listening Endpoints Summary...
          Services Summary...
          No sign of XE instance there.


          >
          ERROR:
          ORA-28056: Writing audit records to Windows Event Log failed
          OSD-00512: Message 512 not found; product=RDBMS; facility=SOSD
          O/S-Error: (OS 1722) The RPC server is unavailable.
          Now it's getting close to root cause.

          Fix the "Event log" issue. Then re-install XE.

          Normally this means clearing out enough entries in one or several of the windows event logs. However I'm note sure with the underlying RPC server unavailable error. Perhaps clearing Event logs and a reboot is needed.


          Btw, very nice to see plenty of clues posted right away in a thread!

          For future XE related discussions, keep to the dedicated forum:
          Oracle Database Express Edition (XE)
          • 2. Re: "Get Started" URL is rejected and XE database does not appear to start
            974717
            Thank you for getting back to me so quickly!

            When I signed in to Event Viewer, I got an error message that my event services weren't running, so I downloaded this fix from Microsoft: http://support.microsoft.com/kb/2478117
            That started my Event Services and allowed me to sign into Event Viewer and clear my logs. They are all clear now.

            Then I repaired my version of 11G and rebooted, but am still unable to connect to the database or the Get Started URL.

            Here are my statuses:

            LSNRCTL> status
            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
            ction
            Start Date 16-NOV-2012 16:31:35
            Uptime 0 days 0 hr. 2 min. 30 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Default Service XE
            Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
            dmin\listener.ora
            Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\CONNECTLAP28\liste
            ner\alert\log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CONNECTLAP28.awi.state.fl.us)(PORT=1
            521)))
            Services Summary...
            Service "CLRExtProc" has 1 instance(s).
            Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
            Service "PLSExtProc" has 1 instance(s).
            Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
            The command completed successfully
            LSNRCTL> exit


            sqlplus / as sysdba

            SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 16 16:34:42 2012

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

            Connected to an idle instance.

            SQL>

            At least it's a different error message now! Any ideas?

            Edited by: 971714 on Nov 16, 2012 1:40 PM

            Edited by: 971714 on Nov 16, 2012 1:41 PM

            Edited by: 971714 on Nov 16, 2012 1:41 PM
            • 3. Re: "Get Started" URL is rejected and XE database does not appear to start
              orafad
              Uninstall then install anew. Likely the problem with event log did not allow install to complete in the first place.
              • 4. Re: "Get Started" URL is rejected and XE database does not appear to start
                974717
                That did it! Thank you very much.