R12.2 Apps DBA. Powered by Blogger.

Adop Prepare Failure With Error ORA-12521 R12.2

No comments :
On : 12.2.3 version, when attempting to run adop phase=prepare
the following error occurs.
ERROR
-----------------------
  [ERROR] Failed to execute sql statement :
  begin
  ad_zd_seed.prepare('FND_PROFILE_OPTION_VALUES');
  ad_zd_seed.prepare('WF_RESOURCES');
  ad_zd_seed.prepare('IBY_BEPINFO');
  end;
  [ERROR] Invalid connect string - cannot connect to database
Invalid Connect string - cannot connect to database
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in
connect descriptor
Invalid connect string - cannot connect to database
Invalid Connect string - cannot connect to database
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in
connect descriptor
  [ERROR] Error occured while executing, statement :
  declare
  begin
  ad_zd_log.message('ad.bin.adop','STATEMENT','Sourcing the Run Edition environment: /prodapp/applprod/PROD/fs2/EBSapps/appl/APPSPROD1_srv01appnwr.env');
  exception
  when others then
  raise_application_error(-20001,'Error while calling ad_zd_log.message(ad.bin.adop,STATEMENT,Sourcing the Run Edition environment: /prodapp/applprod/PROD/fs2/EBSapps/appl/APPSPROD1_srv01appnwr.env).' || sqlerrm);
  end;
/
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

No comments :

Post a Comment

Note: only a member of this blog may post a comment.