USE_SID_AS_SERVICE breaks sid connection to non-pdb databases
I am working through upgrading our EBS database to 19c.
NOTE 2530665.1 says this:
"Note: If you are using the grid listener, then set the following parameter in the $GRID_HOME/network/admin/listener.ora
file and bounce the listener on each of the Oracle RAC nodes: USE_SID_AS_SERVICE_<LISTENER_NAME>=ON"
I made that change and my upgrade worked fine. However, later that evening when we cloned one of our other EBS databases that is currently 12c non-pdb, it failed because the scripts couldn't connect to the sid. It failed with the following error:
ORA-12514: TNS:listener does not currently know of service requested in connect