Skip to Main Content

APEX

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!

installed Apex but can't log in

User_ICWACMar 29 2021

Hi, I've run the install-scripts to set up Apex. I'm having trouble loggin in:
http://localhost:8080/apex/apex_admin
or
http://localhost:8080/apex

The login-window pops up with: "Sign in to access this site" and "Username" and "Password".
I'm 99% sure that I'm using the right authentication but the login-window just keeps asking for it again and again.
I tried to change my credentials by running @apxchpwd with sqlplus ( and got no errors )
and then going back to the login page...but it does not stop asking for user and pass.

I'm using Apex with Oracle XE version 18. Apex version 19.2
Do I have to grant access to my admin - user? I've tried to log in as ANONYMOUS or APEX_190200,
even ANONYMOUS@XE. I also tried this:

DECLARE
BEGIN
EXECUTE IMMEDIATE 'ALTER USER ANONYMOUS IDENTIFIED BY VEFUR2021 ACCOUNT UNLOCK CONTAINER=ALL'; --APEX_PUBLIC_USER
EXECUTE IMMEDIATE 'ALTER USER APEX_PUBLIC_USER IDENTIFIED BY VEFUR2021 ACCOUNT UNLOCK CONTAINER=ALL'; --
EXECUTE IMMEDIATE 'ALTER USER APEX_190200 IDENTIFIED BY VEFUR2021 ACCOUNT UNLOCK CONTAINER=ALL'; --
END;
/
SELECT DBMS_XDB.getHTTPPort FROM DUAL; --> 8080 (ok)
SELECT username FROM DBA_USERS WHERE ACCOUNT_STATUS='OPEN';
SYS
SYSTEM
ANONYMOUS
XDB
APEX_PUBLIC_USER
HARALDUR
APEX_190200
grant connect to APEX_190200;
GRANT RESOURCE TO APEX_190200;
grant connect to ANONYMOUS;
GRANT RESOURCE TO ANONYMOUS;

Do you have any suggestions?

kind regards,
Haraldur

Comments
Post Details
Added on Mar 29 2021
12 comments
3,469 views