R12.2 Apps DBA. Powered by Blogger.

R12.2 adop phase=prepare failed to execute bisdblrp.sql

No comments :
WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[PROFILE PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/bin/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I
/oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /oaph/oracle/oaphappl/fs1/EBSapps/appl/au/12.0.0/perl -I
/oaph/oracle/oaphappl/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi
/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/scripts/adexecsql.pl sqlfile=/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/install
bisdblrp.sql INSTE8_PRF 1
Solution:
Drop the duplicate DB Links and then manually run the bisdblrp.sql script and the re-run autoconfig.
drop database link APPS_TO_APPS.WORLD  (which is owned by obt_aa)
drop database link EDW_APPS_TO_WH.WORLD  (which is owned by obt_aa)
Run the failing script (bisdblrp.sql) manually:
# cd /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/install/
# sqlplus apps/<passwd>
SQL>@bisdblrp.sql
when prompted define the apps username, apps password and the DBNAME for this instance

No comments :

Post a Comment

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