The listener supports no services

[huy91-hub]

Hi everyone, I got the problem of no services for the listener: [root@localhost opt]# docker run -d --name oracle19 -p 1521:1521 -e ORACLE_PWD=Oracle123 -v /home/huynn/Downloads/share:/var/lib/sharedata doctorkirk/oracle-19c:latest be39f1616c747e0f70e1faf45e7eaedc2268f653bc3292586a2c0f0a6748a3e7 [root@localhost opt]# docker logs be39f1616c747e0f70e1faf45e7eaedc2268f653bc3292586a2c0f0a6748a3e7 ORACLE PASSWORD FOR SYS, SYSTEM AND PDBADMIN: Oracle123

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-JUN-2022 04:16:31

Copyright (c) 1991, 2020, Oracle. All rights reserved.

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Log messages written to /opt/oracle/diag/tnslsnr/be39f1616c74/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER

Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 17-JUN-2022 04:16:31 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora Listener Log File /opt/oracle/diag/tnslsnr/be39f1616c74/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The listener supports no services The command completed successfully

I tried to follow doctorkirk'sguide on docker hub or other images but it had a same problem. https://hub.docker.com/r/doctorkirk/oracle-19c

Can anyone help me to solve that? thank you in advance.

[abhisbyk]

@huy91-hub When listener is started, the database is not up and running ( as it is getting created). This is why in the logs its showing The listener supports no services. Once the database creation is complete and it is up and running, you can go inside the container by the following command:

docker exec -it <container-name> bash

and check the status of the listener by the following command:

lsnrctl status

You will see the database service will get registered with the listener dynamically.

If this is not resolving the issue, please paste the output of the listener status after the DB creation. Thanks

[abhisbyk]

@huy91-hub Did it resolved your problem ??

[abhisbyk]

Closing this for now. Please reopen if the above advice does not resolve the problem.

[Nirbhayranaa]

output of lsnrctl status

Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) The listener supports no services The command completed successfully