This discussion is archived
4 Replies Latest reply: Nov 19, 2012 6:28 AM by 974717 RSS

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

974717 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    That did it! Thank you very much.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points