ebs_patch or <INSTANCE>_ebs_patch services

Posted by Harin on Feb 14, 2018; 3:29am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ebs-patch-or-INSTANCE-ebs-patch-services-tp5198.html

Hi Erman,


Hope you are doing good. I have a question regarding patch services : ebs_patch or <INSTANCE>_ebs_patch.

How does database determine that all connection from these service will connect to patch edition only
? I mean we can create any service say x and connect with that to database (and shows database as open).
But if we do so using these it says : "ebs_patch service ORA-00604: error occurred at recursive SQL level 1 ORA-20099: E-Business Suite Patch Edition does not exist. ORA-06512: at line 29".

I understand that patch service is  used for connecting to patch edition when patch cycle is open (please correct me if wrong) but how does it map a service to an edition?

Regards
Harin