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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s