I run a small XE database plus an Apex application on an Oracle Cloud compute instance. Recently it went down because passwords expired for several of the user IDs utilized by APEX.
I connected via command line, and in sqlplus I reset passwords and unlocked APEX_PUBLIC_USER, ORDS_PUBLIC_USER, APEX_REST_PUBLIC_USER, APEX_LISTENER.
I reset XE:
sudo systemctl restart oracle-xe-18c
Then I edited the various pool .xml files to include the new password, and took ORDS down and back up.
Now the logs all seem to show a server (XE and ORDS) running properly - but still no access to the APEX app - nor remote SQL Developer access. The ORDS logs show no expired password or invalid credential errors.
It's a severe problem - and even though I have an Oracle Cloud compute instance, MOS is saying they can't help me with XE. (Nor with ORDS, it seems, if it's working in concert with XE). I'm an experienced SQL/PLSQL developer, and pretty good with the linux command line, but a novice DBA.
I'm attaching files with a recent ORDS log and the output of Netstat -a -o
Here's what I get with lsnrctrl status:
lsnrctl status
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 10-MAR-2021 21:55:03
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 10-MAR-2021 20:28:09
Uptime 0 days 1 hr. 26 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /opt/oracle/product/18c/dbhomeXE/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/tekrep-xe-v1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=tekrep-xe-v1.sub04192231110.tekrepdatacente.oraclevcn.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/product/18c/dbhomeXE/admin/XE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "86fef1e197516f25e0530200000a0145" 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
[opc@tekrep-xe-v1 scripts]$
Any help would be enormously appreciated.
netstat-a-o.txt (9.18 KB)ords-20210310.log (59.16 KB)