Adop Prepare Failure With Error ORA-12521 R12.2
On : 12.2.3 version, when attempting to run adop phase=preparethe 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
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.