1) the ports seem to be mismatched, e.g. 1521 & 1522 both being forwarded to 1522 in the container. I think it should be
-p 1521:1521 -p 1522:1522
2) The service names / listeners described are wrong
e.g. it's MYATP_low.adb.oraclecloud.com as the service name, not MYATP_low_tls
Debug logs:
lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-JUL-2024 15:25:59
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)(FIREWALL=OFF)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 02-JUL-2024 15:22:26
Uptime 0 days 0 hr. 3 min. 32 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/2c744e698213/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)(FIREWALL=OFF)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=1522)(FIREWALL=OFF)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=2c744e698213)(PORT=5950))(Security=(my_wallet_directory=/u01/app/oracle/wallets/tls_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "MYATP_high.adb.oraclecloud.com" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
Service "MYATP_low.adb.oraclecloud.com" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
Service "MYATP_medium.adb.oraclecloud.com" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
Service "MYATP_tp.adb.oraclecloud.com" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
Service "MYATP_tpurgent.adb.oraclecloud.com" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
Service "POD1" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
Service "POD1XDB" has 1 instance(s).
Instance "POD1", status READY, has 1 handler(s) for this service...
Service "myatp" has 1 instance(s).
Instance "POD1", status READY, has 4 handler(s) for this service...
The command completed successfully
Noticed 2 inaccuracies
1) the ports seem to be mismatched, e.g. 1521 & 1522 both being forwarded to 1522 in the container. I think it should be
-p 1521:1521 -p 1522:1522
2) The service names / listeners described are wrong e.g. it's MYATP_low.adb.oraclecloud.com as the service name, not MYATP_low_tls
Debug logs:
lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 02-JUL-2024 15:25:59
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)(FIREWALL=OFF))) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 02-JUL-2024 15:22:26 Uptime 0 days 0 hr. 3 min. 32 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/2c744e698213/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)(FIREWALL=OFF))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=0.0.0.0)(PORT=1522)(FIREWALL=OFF))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=2c744e698213)(PORT=5950))(Security=(my_wallet_directory=/u01/app/oracle/wallets/tls_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "MYATP_high.adb.oraclecloud.com" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... Service "MYATP_low.adb.oraclecloud.com" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... Service "MYATP_medium.adb.oraclecloud.com" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... Service "MYATP_tp.adb.oraclecloud.com" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... Service "MYATP_tpurgent.adb.oraclecloud.com" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... Service "POD1" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... Service "POD1XDB" has 1 instance(s). Instance "POD1", status READY, has 1 handler(s) for this service... Service "myatp" has 1 instance(s). Instance "POD1", status READY, has 4 handler(s) for this service... The command completed successfully