TNS-12514: TNS:listener does not currently know of service requested in connect descriptor – The listener supports no services
Cause:
Listener status shows no services related to database. This is one of the scenarios out of multiple error occurence
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpprod)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
Workaround:
There are multiple solutions for the error based on the exact cause. In my case, i registered the service manually in database
<msg time='2021-10-28T12:36:33.421+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='dpprod'
host_addr='192.168.56.233'>
<txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
</txt>
</msg>
I register the service manually
SQL> alter system register;
System altered.
Post registration, the connection is established
<msg time='2021-10-28T12:36:57.593+05:30' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='dpprod'
host_addr='192.168.56.233'>
<txt>28-OCT-2021 12:36:57 * service_register * dpprod * 0
</txt>
</msg>
Service name reflect in listener status output
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpprod)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dpprod)(PORT=5500))(Security=(my_wa llet_directory=/u01/app/oracle/admin/DPPROD/xdb_wallet))(Presentation=HTTP)(Sess ion=RAW))
Services Summary...
Service "DPPROD" has 1 instance(s).
Instance "dpprod", status READY, has 1 handler(s) for this service...
Service "dpprodXDB" has 1 instance(s).
Instance "dpprod", status READY, has 1 handler(s) for this service...
The command completed successfully