[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

I got the issue below while running prepare phase. I was able to fix the issue with the solution below and thus i am sharing it here.

Cause :

Query the below parameter in db context file.

grep  s_patch_service entry $CONTEXT_FILE

(This is was not present in my context file, thus the error was tripping)

Soultion :

1. Ensure that the below parameters in the database context file are set to: $ORACLE_HOME/appsutil/jre

"s_jretop , s_jdktop

Parameter "ADJVAPRG" needs to be set to $ORACLE_HOME/appsutil/jre/bin/java</ADJVAPRG>

2. Execute admkappstil.pl on the apps node.

3. Copy the generated appsutil.zip to db node and unzip.

4. Execute autoconfig on the database tier.

5. Ensure s_patch_service entry exists in the db context file. 

6. Re-test adop prepare phase.

7. Migrate the solution as appropriate to other environments.