Hi
I'm literally 2 days oracle-old ; so excuse the poor understanding.
I've installed Oracle XE 18c. I can connect to EM via hostname:5500/em. Then I tried to install APEX. It seemed to install under container XEPDB1. But there was no listener on port 8080, so i added that manually exec DBMS_XDB_CONFIG.SETHTTPSPORT(8080);
I've later found that i should have executed apex_epg_config and unlocked ANONYMOUS user which i then did.
But I can't connect to Apex on url hostname:8080/apex/apex_admin. I'm getting basic http authentication prompt that won't accept my apex admin username and password.
<< this attempt is from within the VM.
[root@centos6 ~]# netstat -tulpn | grep 8080
tcp 0 0 :::8080 :::* LISTEN 14779/tnslsnr
This is what my listener looks like
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=8080))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=hostname)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/product/18c/dbhomeXE/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "8075464a1ac14513e055000000000001" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "xepdb1" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
the database is alive
SQL> show pdbs
CON\_ID CON\_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 XEPDB1 READ WRITE NO
I can alter to the schema, so i know it exists
alter session set current_schema=APEX_180200;
The user for apex is not locked
SQL> select user_name||':'||account_locked||':'||security_group_id from wwv_flow_fnd_user;
USER_NAME||':'||ACCOUNT_LOCKED||':'||SECURITY_GROUP_ID
--------------------------------------------------------------------------------
ADMIN:N:10
I'm not sure what i should be checking next
I'm expecting the App express page to prompt for my username/password, not this prompt. I've seen many threads around wrong credentials, this is not it. This prompt doesn't go no. just reappears without errors.
Thanks
HannaH