EBS R12.2 Adop Prepare Failure With Error ORA-12521

 

Cause
The issue is caused by TNS_ADMIN configuration files on Patch file system is not updated.
To implement the solution, please execute the following steps:
a. Please execute the following actions on the both nodes.
1. Source Patch File system env file
2. Backup all files under $TNS_ADMIN
3. Run adgentns.pl on Patch file system
perl $AD_TOP/bin/adgentns.pl contextfile=$CONTEXT_FILE appspass=
4. check the Confirm that DB connection is established from Patch file system.
b. rerun the adop phase=prepare

Oracle EBS R12.2 Bounce script

 
. /u01/app/EBS/EBSapps.env run
adstpall.sh apps/apps<<EOF
Welcome_1
EOF
 
echo "Waiting for 60 seconds..."
sleep 60
ps aux  |  grep FNDLIB  |  awk '{print $2}'  |  xargs  kill -9
ps aux  |  grep FNDSM  |  awk '{print $2}'  |  xargs  kill -9
 
ps aux  |  grep FND
 
. /u01/app/EBS/EBSapps.env run
adstrtal.sh apps/apps<<EOF
Welcome_1
EOF