ORA-12514 TNSlistener does not currently know of service requested in connect descriptor

by

In this post we will covers ‘How to resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

How to fix ORA-12514 TNSlistener does not currently know of service?

ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (*******/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkPrepareACTables.pl)
TIME    : Sat Sep  8 10:25:42 2018
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
Invalid Connect string – cannot connect to database
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Here we are facing the issue while applying the patch.

Unable to connect database using system user in patch edition file system
Oracle APPS 12.2.5

Unable to connect database using system user in patch edition file system.

Check the file edition.

$echo $FILE_EDITION

$patch

Error will reproduce as below.

$sqlplus apps/apps

ERROR:

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

Connect db server:

sqlplus / as sysdba

Corrective action: –

SQL> alter system set service_names='<SID>’,’ebs_patch’  scope=memory;

SQL>alter system register;

alter system set service_names='<SID>’,’ebs_patch’,'<SID>_patch’,'<SID>_ebs_patch’ scope=memory;


SQL>alter system set LOCAL_LISTENER=<SID> scope=memory;
System altered.

SQL> alter system set LOCAL_LISTENER=<SID> scope=spfile;
System altered.

SQL> alter system set LOCAL_LISTENER=<SID> scope=both;
System altered.

Then check for if ebs_patch listner service is running or not.

lsnrctl status SID

$tnsping SID —->from both DB and apps server.

Now try to connect the Database from patch env using apps user.

If connecting database successfully, you may proceed patching.

 

Leave a Comment