txkSetADOPPatchSrvName.sh and RAC srvctl services

[Artyom Kuznetsov]

Hi Erman,

I faced with the interesting issue after applying the latest AD-TXK. There is a script txkSetADOPPatchSrvName.sh that changes service_names DB parameter during adconfig on the database to "DB_NAME, DB_NAME_ebs_patch". But in our RAC configuration, we have DB_NAME_BALANCE service configured in srvctl, it is used in the middle tier to balance connections across RAC nodes. So, after txkSetADOPPatchSrvName.sh changes service_names parameter, DB_NAME_BALANCE service registration disappears from the listener. Did you faced with hte same issue?

Regards,
Artyom

[ErmanArslansOracleBlog]

Hi,

that script is a wrapper .. The real work is done by txkSetADOPPatchSrvName.pl
It seems the value of your service_names parameter is overwritten by that script.
However, that script is smart enough to check your service names and append accordingly.(rather than overwriting) -- at least in TXK level 11 -- 28840822..

1)How did you add that service exactly? Did you add your service properly?

Normally you should have added it using ->  Configuring and Managing Oracle E-Business Suite Release 12.2.x Forms and Concurrent Processing for Oracle RAC (Doc ID 2029173.1) - Section 3: Creating and Managing Services.

2) Is your service name available in DBA_SERVICES? SELECT name FROM DBA_SERVICES..

3) Send me the log -> txkSetADOPPatchSrvName.log

4) What patch did you apply? for upgrading to which TXK Level?

[Artyom]

Hi!

Thank you very much for the answer. After completing the installation, I see that middle tier service name changed to ebs_DB_NAME. So that middle tier correctly connects to the database, and DB_NAME_BALANCE service name is not needed anymore.

Regards,
Artyom