CAUSE
This is an issue with the number of database process/sessions. There are some bugs that reduce the processes/sessions required, and the fixes are included in Patch:19197270 AD:R12.AD.C.DELTA.6 PATCH and later.
SOLUTION
As a workaround, bouncing the database, and raising the number of processes/sessions should let you complete the patch (you will need to restart the patch after you do the workaround). (NOTE: Simply bouncing the database might allow you to continue.)
Reference: adop fails with "ORA-12516: TNS:listener could not find available handler with matching protocol stack" (Doc ID 2105049.1)
The issue I faced was , local_listener was not set in init.ora parameters. Once that was set, I was able to do sqlplus apps/@sid_patch from the app tier and was able to run adop phase=prepare
ReplyDelete