Adop Prepare Failure With Error 'ORA-12521' (Doc ID 1998916.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Applications DBA - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms