Concurrent managers down EBS R12.2 - 19c

[satish]

Dear Erman,

Regular bounce of our test instance ->concurrent managers down.

Logfile:

AFPPSPL--  28-FEB-2023 12:36:28
        Call to PingProcess failed for FNDCPGSC
Unable to contact Applications TNS Listener for FNDSM_ERPSUPPORT_SUPPDB on $NODE.  The Listener may be down or the TNS address is not properly configured for this name. (NODE=ERPSUPPORT)
An error occured in client-side routine afpsmccs for Service Manager FNDSM_ERPSUPPORT_SUPPDB.  The routine returned code 144.

Check for preceding errors and as well as the service manager log file for further details."



listener is up and running. We have below entries in tnsnames.ora

FNDFS_suppcdb_ERPSUPPORT=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPSUPPORT.ttd.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

FNDFS_suppcdb_ERPSUPPORT.ttd.com=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPSUPPORT.ttd.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )


FNDSM_ERPSUPPORT_suppcdb=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPSUPPORT.ttd.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDSM)
            )
        )

FNDSM_ERPSUPPORT.ttd.com_suppcdb=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ERPSUPPORT.ttd.com)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDSM)
            )
        )



From the error,we observe it is trying to contact FNDSM_ERPSUPPORT_SUPPDB instead of FNDSM_ERPSUPPORT_suppcdb and it fails.


[applsupp@erpsupport log]$ tnsping FNDSM_ERPSUPPORT_SUPPDB

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 28-FEB-2023 18:20:44

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:
/u01/SUPPDBAPPS/fs2/inst/apps/SUPPDB_erpsupport/ora/10.1.2/network/admin/sqlnet_ifile.ora

TNS-03505: Failed to resolve name
[applsupp@erpsupport log]$
[applsupp@erpsupport log]$
[applsupp@erpsupport log]$
[applsupp@erpsupport log]$ tnsping FNDSM_ERPSUPPORT_suppcdb

TNS Ping Utility for Linux: Version 10.1.0.5.0 - Production on 28-FEB-2023 18:20:52

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:
/u01/SUPPDBAPPS/fs2/inst/apps/SUPPDB_erpsupport/ora/10.1.2/network/admin/sqlnet_ifile.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ERPSUPPORT.ttd.com)(PORT=1626)) (CONNECT_DATA= (SID=FNDSM)))
OK (10 msec)
[applsupp@erpsupport log]$


 Can you please guide.

Thanks,
Satish

[ErmanArslansOracleBlog]

So, you have a workaround (just for saving the day) .. I mean you may add the necessary TNS (that wrong tns entry) to your apps tier listener ora, and it will be a workaround for you.

However; to fix it, you need to review your config.. Apps Tier config. suppdb should be suppcdb or vice versa.. Check that. (Check by reviewing the EBS 12.2 - DB 19C interoperability documents)..

A context file update, and an autoconfig may be needed..

[satish]

Dear Erman,

What will be correct entry for FNDSM in tnsnames.ora, FNDSM_ERPSUPPORT_SUPPDB or FNDSM_ERPSUPPORT_suppcdb? Please advice.

Thanks,
Satish

[ErmanArslansOracleBlog]

PDB name should be there as a suffix.