Io exception: Connection refused during patch because wrong service_name is used
Patch 4298372 fails, and the adworker log shows it's trying to connect with the wrong connection string.
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
Connecting to APPS@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb2.scint.businesswire.com)(PORT=7377))(CONNECT_DATA=(SERVICE_NAME=BILLISC2))) -- UTF8
Unable to connect to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oradb2.scint.businesswire.com)(PORT=7377))(CONNECT_DATA=(SERVICE_NAME=BILLISC2)))
The SERVICE_NAME should not be BILLISC2. BILLISC2 is name of an instance in the RAC cluster, not a service. How do I correct the connection information?