ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

 Dear Folks,

We have experienced an issue connecting to apps user and getting following error.

NONPROD [*****@servername ~]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jun 29 07:56:15 2021

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor

======

Checked and found service ebs_klqbi missed while checking status of listener.

NONPROD [******@servername ~]$ lsnrctl status $ORACLE_SID

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-JUN-2021 08:27:40

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=servername.domain.tcs)(PORT=1551)))

STATUS of the LISTENER

  Instance "******", status READY, has 1 handler(s) for this service...

The command completed successfully

NONPROD [********@servername ~]$

 ===========

Fix

SQL> Alter session set container=*****;

Session altered.

SQL> BEGIN

DBMS_SERVICE.start_service(service_name => 'ebs_*****');

END;

/ 2 3 4

PL/SQL procedure successfully completed.

Now we are able to connect to apps user.

Thanks.