Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Authentification request when trying to log into APEX (localhost:9080/apex)

550504Jun 16 2009
Hello all,

I installed Oracle XE with APEX 3.2, which worked fine for me for a while.
Latterly I don't get the page where I have to enter the workspace, username and password.

A popup asking for authentification appears saying "...display of the webiste: 'XDB'".
I try to login and afterwards the next authetification window appears, but this time it displays "... display of the webiste: 'APEX'".
(in German: http://127.0.0.1:9080 verlangt einen Benutzernamen und ein Passwort. Ausgabe der Website: "XDB"
http://127.0.0.1:9080 verlangt einen Benutzernamen und ein Passwort. Ausgabe der Website: "APEX")

I don't know what to do now...

It seems that I have to change something in the configuration, but where and what?
(note: standard port 8080 has been changed to port 9080 as 8080 is already used)

Thnx a lot for your help!

Harry





-----
tnsnames.ora:
XE, XE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myhost.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
-----
lsnrctl status:
STATUS des LISTENER

Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Startdatum 16-JUN-2009 08:42:42
Uptime 0 Tage 0 Std. 0 Min. 1 Sek.
Trace-Ebene off
Sicherheit ON: Local OS Authentication
SNMP OFF
Standard-Service XE
Parameterdatei des Listener C:\oraclexe\app\oracle\product\10.2.0\server\network
\admin\listener.ora
Log-Datei des Listener C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Zusammenfassung Listening-Endpunkte...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost.net)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost.net)(PORT=9080))(P
resentation=HTTP)(Session=RAW))
Services ▄bersicht...
Dienst "CLRExtProc" hat 1 Instance(s).
Instance "CLRExtProc", Status UNKNOWN, hat 1 Handler f³r diesen Dienst...
Dienst "PLSExtProc" hat 1 Instance(s).
Instance "PLSExtProc", Status UNKNOWN, hat 1 Handler f³r diesen Dienst...
Dienst "XEXDB" hat 1 Instance(s).
Instance "xe", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "XE_XPT" hat 1 Instance(s).
Instance "xe", Status READY, hat 1 Handler f³r diesen Dienst...
Dienst "xe" hat 1 Instance(s).
Instance "xe", Status READY, hat 1 Handler f³r diesen Dienst...
-----
listener.ora
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 = localhost)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2009
Added on Jun 16 2009
0 comments
1,761 views