
Check these things and try to solve the issue, if you can't send me the following;

1)Your apps release: --> 12.2.4

2)Your db version: --> 12.1.0.2.0

3)your /etc/hosts file:


::1 localhost
127.0.0.1 localhost loghost
10.128.178.20 prdc1pdb01.dalkia.net prdc1pdb01


4)your db context file

5)your remote listener parameter
6)your local listener parameter


SQL> show parameter listen   

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string      prdc1pdb01-vip:1521
remote_listener                      string      prdc1pdb01-scan:1521



7)your current listener.ora (your local listener's listener.ora)--> (attached document)
8)your current tnsnames.ora (from TNS_ADMIN) --> (attached document)

9)your autoconfig log file (attached document)


10)output of "ping your virtual ipaddress"  , "ping your virtual hostname"--> prdc1pdb01-vip is alive

11)output of "ping your physical paddress" , "ping your physical hostname" --> prdc1pdb01 is alive

12)lsnrctl status <LISTENER_NAME>  --> listener name that is written in your local_listener parameter : --> (attached document)

12)lsnrctl status <LISTENER_NAME>  --> listener name that is written in your remote_listener parameter : --> (attached document)
13)output of select * from fnd_nodes table (formatted)

-->

***********
select NODE_NAME, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, PLATFORM_CODE from fnd_nodes ;

NODE_NAME  LAST_UPDA LAST_UPDATED_BY CREATION_ CREATED_BY LAST_UPDATE_LOGIN PLATFORM_CODE
---------- --------- --------------- --------- ---------- ----------------- ---------------
PRDC1PDB02 14-FEB-17               1 14-FEB-17          1                 0 23
PRDC1PDB01 20-FEB-17               1 14-FEB-17          1                 0 23

select DESCRIPTION, BASEPATH, SUPPORT_CP, SUPPORT_FORMS, SUPPORT_WEB,SUPPORT_ADMIN, STATUS, PING_RESPONSE from fnd_nodes


DESCRIPTIO BASEPATH   SUPPORT_CP SUPPORT_FORMS SUPPORT_WEB SUPPORT_ADMIN STATUS PING_RESPO
---------- ---------- ---------- ------------- ----------- ------------- ------ ----------
                      N 		N 	    N 		N
                      N                 N           N           N

select LAST_MONITORED_TIME, NODE_MODE, NODE_ID, SERVER_ID, SERVER_ADDRESS, HOST, DOMAIN, WEBHOST, VIRTUAL_IP, SUPPORT_DB, APPLTOP_ID from fnd_nodes


LAST_MONI N    NODE_ID SERVER_ID  SERVER_ADDRESS  HOST            DOMAIN          WEBHOST    VIRTUAL_IP      S APPLTOP_ID
--------- - ---------- ---------- --------------- --------------- --------------- ---------- --------------- - ----------
          O      11132                            prdc1pdb02      dalkia.net                 prdc1pdb02-vip  Y
          O      10132                            prdc1pdb01      dalkia.net                 prdc1pdb01-vip  Y

**************
14)output of FND_DATABASES, 

--> 

*********************
FND_DATABASES

select DB_GUID, DB_NAME, DB_DOMAIN, DEFAULT_TNS_ALIAS_GUID, IS_RAC_DB, VERSION from FND_DATABASES

DB_GUID                          DB_NAME  DB_DOMAIN       DEFAULT_TNS_ALIAS_GUID           I VERSION
-------------------------------- -------- --------------- -------------------------------- - -------------
487FDE4ABB220F5EE05402082098795B DBOFINP1 dalkia.net      487FDE4ABB230F5EE05402082098795B Y db121


select CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SYSTEM_GUID, SCAN_NAME, SCAN_PORT from FND_DATABASES

CREATED_BY CREATION_ LAST_UPDATED_BY LAST_UPDA LAST_UPDATE_LOGIN SYSTEM_GUI SCAN_NAME             SCAN_PORT
---------- --------- --------------- --------- ----------------- ---------- -------------------- ----------
         1 14-FEB-17               1 20-FEB-17                 0            prdc1pdb01-scan            1521

***********************

applsys.FND_DATABASE_INSTANCES,

-->
applsys.FND_DATABASE_INSTANCES, 

SQL> select DB_GUID, INSTANCE_NAME, INSTANCE_NUMBER, SID, DEFAULT_TNS_ALIAS_GUID, LOCAL_LISTENER_ALIAS, REMOTE_LISTENER_ALIAS from applsys.FND_DATABASE_INSTANCES ;

DB_GUID                          INSTANCE_NAME    INSTANCE_NUMBER SID              DEFAULT_TNS_ALIAS_GUID           LOCAL_LISTENER_ALIAS             REMOTE_LISTENER_ALIAS
-------------------------------- ---------------- --------------- ---------------- -------------------------------- -------------------------------- --------------------------------
487FDE4ABB220F5EE05402082098795B DBOFINP12                      2 DBOFINP12        488083269052653EE0540208202F7579 488083269053653EE0540208202F7579 487FDE4ABB290F5EE05402082098795B
487FDE4ABB220F5EE05402082098795B DBOFINP11                      1 DBOFINP11        487FDE4ABB240F5EE05402082098795B 487FDE4ABB250F5EE05402082098795B 487FDE4ABB290F5EE05402082098795B


select CONFIGURATION, DESCRIPTION, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SERVER_GUID, INTERCONNECT_NAME, INSTANCE_GUID, SID_GUID from applsys.FND_DATABASE_INSTANCES

CONF DESC CREATE CREATI LAST_UPDA LAST_UPDA LAST_UPD  SERVER_GUID                      INTERCONNE     INSTANCE_GUID                    SID_GUID
---- ---- ------ ------ --------- --------- --------  -------------------------------- -------------- -------------------------------- --------------------------------
               1 14-FEB-17     1    14-FEB-17  0      488083269050653EE0540208202F7579 prdc1pdb02-vip 488083269054653EE0540208202F7579 488083269055653EE0540208202F7579
                                                                                                                           

               1 14-FEB-17     1    20-FEB-17  0      487FDE4ABB200F5EE05402082098795B prdc1pdb01-vip 487FDE4ABB260F5EE05402082098795B 487FDE4ABB270F5EE05402082098795B
                                                                                                                           


************************
applsys.FND_TNS_LISTENERS

select * from applsys.FND_TNS_LISTENERS

LISTENER_GUID                       LISTENER_NAME            CREATED_BY CREATION_ LAST_UPDATED_BY LAST_UPDA LAST_UPDATE_LOGIN SERVER_GUID                      TNS_ALIAS_GUID
----------------------------------- ------------------------ ---------- --------- --------------- --------- ----------------- -------------------------------- --------------------------------
488083269058653EE0540208202F7579    prdc1pdb02_DBOFINP1_DB            1 14-FEB-17               1 14-FEB-17                 0 488083269050653EE0540208202F7579 488083269053653EE0540208202F7579
487FDE4ABB2C0F5EE05402082098795B    prdc1pdb01_DBOFINP1_DB            1 14-FEB-17               1 20-FEB-17                 0 487FDE4ABB200F5EE05402082098795B 487FDE4ABB250F5EE05402082098795B


*************************

applsys.FND_TNS_LISTENER_PORTS

LISTENER_PORT_GUID               LISTENER_GUID                       PROTOCOL         PORT CREATED_BY CREATION_ LAST_UPDATED_BY LAST_UPDA LAST_UPDATE_LOGIN
-------------------------------- ----------------------------------- ---------- ---------- ---------- --------- --------------- --------- -----------------
48808326905A653EE0540208202F7579 488083269058653EE0540208202F7579    TCP              1521          1 14-FEB-17               1 14-FEB-17                 0
487FDE4ABB2E0F5EE05402082098795B 487FDE4ABB2C0F5EE05402082098795B    TCP              1521          1 14-FEB-17               1 20-FEB-17                 0




