This discussion is archived
1 Reply Latest reply: Apr 5, 2013 7:57 AM by clcarter RSS

Unable to access Oracle Database Express Edtion homepage after instalation

1000659 Newbie
Currently Being Moderated
Hello,

I've installed Oracle Database Express Edtion in a machine running windows vista, the application was successfully installed but when I try to access http://127.0.0.1:8080/apex, the webpage is not available.

When I try to connect to sqlplus with sysadmin credentials I get the error: ORA-12638: Credential retrieval failed.

tnsping to localhost using IP or machine name returns OK.

The content of listener.ora is:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = soniapc.faleixo.local)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)


Bellow there are the results of commands lsnrctl status and lsnrctl service.

Anyone could help?
Thank you


C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-ABR-2013 23:25
:25

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 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 04-ABR-2013 23:25:03
Uptime 0 days 0 hr. 0 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SONIAPC.faleixo.local)(PORT=1521)))
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

C:\>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-ABR-2013 23:25
:40

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
  • 1. Re: Unable to access Oracle Database Express Edtion homepage after instalation
    clcarter Expert
    Currently Being Moderated
    Note the Listener Endpoints section, there must be a port 8080 entry for Apex to be happy.

    This can happen when something isn't quite correct with the host network client configuration.

    If the host has multiple NICs, that can complicate things. If not, or if you want the the listener to work on all interfaces, in your listener.ora file the configuration bit:
    ... (HOST=SONIAPC.faleixo.local) ...
    Can be changed to HOST= 0.0.0.0 to let the listener create endpoints on any IP belonging to the host. That should fix the Apex service and web pages.

    Stop the listener and update the listener.ora HOST= setting. The HOST= can be a hostname, or it can be an IPv4 address. When using hostname, it has to be the correct hostname

    Or, stop the listener, and move (rename) the listener.ora configuration file. If you rename the file to i.e. listener.ora.bak that should fix it as well. The web pages should start working within a few minutes after starting the listener, or to hurry things up a bit get the instance to register with the listener after its restarted. In a command box (Start/Run/cmd.exe):
    lsnrctl start
    ...
    sqlplus /nolog
    connect system
    ... password ... Connected.
    alter system register;
    exit;
    lsnrctl stat
    ...
    lsnrctl serv
    ...

Legend

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