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

Symptoms/Problem Details :

Unable to connect apps user from a Recently cloned and EBS RUP 12.2.12 applied Application node
sqlplus apps/*****
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.[oracle@clone admin]$ sqlplus apps/****
SQL*Plus: Release 10.1.0.5.0 – Production on Mon Sep 2 11:25:55 2024
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:

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

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

================================
[oracle@clone clone_clone]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Mon Sep 2 11:53:30 2024
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.19.0.0.0
SQL>  Select name from v$active_services;
NAME
—————————————————————-
cdbclone
cdbcloneXDB
SYS$BACKGROUND
SYS$USERS
clone_ebs_patch
clone
7 rows selected.
SQL> exit
ebs_<PDB_SID> found missing in the above result
==================
root cause identified as below:
service name :      ebs_<PDB_SID> was not up and running
NOTE:  ebs_clone  :  is the service name in our case
====================

SOLUTION:

========

1. open a linux terminal
2. Source CDB env
Our pdb sid is: clone
3. export ORACLE_PDB_SID=clone     ( set the PDB env temporarily) 
4-a. sqlplus / as sysdba
4-b. Start the PDB service – ebs_clone
BEGIN
DBMS_SERVICE.START_SERVICE(
service_name => ‘ebs_clone’
);
END;
/
5. connect EBS node, source run fs environment and test now
sqlplus apps/*** OR sqlplus apps/***
connected to apps user successfully now.
===================================
Recorded session below:
[oracle@clone clone_clone]$ export ORACLE_PDB_SID=clone   (Having sourced CDB env)[oracle@clone clone_clone]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Mon Sep 2 11:52:49 2024
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.19.0.0.0
SQL>
BEGIN
DBMS_SERVICE.START_SERVICE(
service_name => ‘ebs_clone’
);
END;
/SQL>   2    3    4    5    6
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.19.0.0.0
[oracle@clone clone_clone]$
===================================
Now Make sure to save the PDB State with above ebs_clone service configured and running.
[oracle@clone clone_clone]$
[oracle@clone clone_clone]$
[oracle@clone clone_clone]$ export ORACLE_PDB_SID=clone
[oracle@clone clone_clone]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Mon Sep 2 11:54:12 2024
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.19.0.0.0
SQL> alter pluggable database “clone” save state;
Pluggable database altered.
SQL>
SQL>
================
Verify the service ebs_clone is now coming as active and running.
[oracle@clone clone_clone]$
[oracle@clone clone_clone]$ export ORACLE_PDB_SID=””
[oracle@clone clone_clone]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Mon Sep 2 11:53:30 2024
Version 19.19.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.19.0.0.0
SQL>  Select name from v$active_services;
NAME
——————-
cdbclone
ebs_clone   <<<— service ebs_clone is now coming as active and running.
cdbcloneXDB
SYS$BACKGROUND
SYS$USERS
clone_ebs_patch
clone
7 rows selected.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.19.0.0.0
[oracle@clone clone_clone]$
======================================