OS: CentOS 8, Oracle Linux8.10
I tried/reinstalled/ re-created free db several times but am still facing the same problem.
The listener can be auto start once the free db was created. but when I stop the listener (lsnrctl stop) or reboot the OS. The listener cannot be started with error message as below.
Starting /opt/oracle/product/23ai/dbhomeFree/bin/tnslsnr: please wait...
TNS-12547: TNS:lost contact
TNS-12560: Database communication protocol error.
TNS-00517: Lost contact Linux Error: 32: Broken pipe
the listener.ora created by default is below:
DEFAULT_SERVICE_LISTENER = FREE
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ROG)(PORT = 1539))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)