Concurrent managers after upgrade 19c

Posted by satish on Jan 28, 2023; 6:19am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Concurrent-managers-after-upgrade-19c-tp11524.html

Dear Erman,

After EBS upgrade to 19c. We are unable to start concurrent managers. We are on R12.2.5


Log:

[appluat@erpuatapp01 log]$ cat UATDB_0128.mgr

========================================================================
Starting UATDB_0128@UATDB_BALANCE Internal Concurrent Manager -- shell process ID 5081

          logfile=/u01/UATAPPS/fs_ne/inst/UATDB_erpuatapp01/logs/appl/conc/log/UATDB_0128.mgr
          PRINTER=noprint
           mailto=appluat
          restart=N
             diag=N
            sleep=30
             pmon=4
           quesiz=1
          Reviver is ENABLED




+---------------------------------------------------------------------------+
Application Object Library: Concurrent Processing version 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

Internal Concurrent Manager started : 28-JAN-2023 11:09:52

+---------------------------------------------------------------------------+
28-JAN-2023 11:09:52
Unsuccessful in TNS ping of node ERPUATAPP01, error reported: Listener Not Found.
Could not contact Service Manager FNDSM_ERPUATAPP01_uatcdb. The TNS alias could not be located, the listener process on ERPUATAPP01 could not be contacted, or the listener failed to spawn the Service Manager process.
28-JAN-2023 11:09:52
Unsuccessful in TNS ping of node ERPUATAPP02, error reported: Listener Not Found.
Could not contact Service Manager FNDSM_ERPUATAPP02_uatcdb. The TNS alias could not be located, the listener process on ERPUATAPP02 could not be contacted, or the listener failed to spawn the Service Manager process.

                   Process monitor session started : 28-JAN-2023 11:09:52

                     Process monitor session ended : 28-JAN-2023 11:09:53
[appluat@erpuatapp01 log]$


UATDB is PDB
uatcdb is UATCDB

We then changed UATDB as uatcdb in tnsnames.ora for FNDFS and FNDSM as below.Concurrent managers are started. But when we run autoconfig,the changes are gone. Is it expected?

[appluat@erpuatapp02 admin]$ grep -i uatcdb tnsnames.ora

FNDFS_uatcdb_ERPUATAPP01=
FNDFS_uatcdb_ERPUATAPP01.ttd.com=
FNDFS_uatcdb_ERPUATAPP02=
FNDFS_uatcdb_ERPUATAPP02.ttd.com=
FNDSM_ERPUATAPP01_uatcdb=
FNDSM_ERPUATAPP01.ttd.com_uatcdb=
FNDSM_ERPUATAPP02_uatcdb=
FNDSM_ERPUATAPP02.ttd.com_uatcdb=

[appluat@erpuatapp02 admin]$


Please guide.

Thanks,
Satish