ORA-04063: package body "APPS.AD_ZD_PREP" has errors adop prepare phase failed
[applint2@ebsx01appd10 ~]$ adop phase=prepareEnter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials...
Initializing...
Run Edition context : /u15/home/ebsint2/fs1/inst/apps/ebsint2_ebsx01appd10/appl/admin/ebsint2_ebsx01appd10.xml
Patch edition context: /u15/home/ebsint2/fs2/inst/apps/ebsint2_ebsx01appd10/appl/admin/ebsint2_ebsx01appd10.xml
Patch file system freespace: 422.31 GB
Validating system setup...
Node registry is valid.
Logfile location /u15/home/ebsint2/fs1/inst/apps/ebsint2_ebsx01appd10/logs/appl/rgf/TXK/verifyssh.log
xml output = /u15/home/ebsint2/fs1/inst/apps/ebsint2_ebsx01appd10/logs/appl/rgf/TXK/out.xml
Remote execution is operational.
[ERROR] Failed to execute SQL statement :
declare
l_msg varchar2(4000);
begin
ad_zd_adop.adop_database_validations(l_msg);
dbms_output.put_line(l_msg);
end;
[ERROR] Error Message :
[ERROR] ORA-04063: package body "APPS.AD_ZD_PREP" has errors
[ERROR] ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
[ERROR] ORA-06512: at "APPS.AD_ZD_ADOP", line 2443
[ERROR] ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute)
[UNEXPECTED]Error occurred while performing database validations
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
Sol:
Tried to compile the package "AD_ZD_PREP" but failed with the following error
SQL> alter package AD_ZD_PREP compile body;
Warning: Package Body altered with compilation errors.
SQL> sho errors
Errors for PACKAGE BODY AD_ZD_PREP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
419/3 PL/SQL: SQL Statement ignored
419/19 PL/SQL: ORA-00942: table or view does not exist
423/5 PL/SQL: SQL Statement ignored
423/21 PL/SQL: ORA-00942: table or view does not exist
457/5 PL/SQL: SQL Statement ignored
457/21 PL/SQL: ORA-00942: table or view does not exist
SQL>
SQL> desc DBMS_OBJECTS_APPS_UTILS
ERROR:
ORA-04043: object DBMS_OBJECTS_APPS_UTILS does not exist
Issue was grants on the sys object "xdb$moveSchemaTab" to apps
SQL> grant select,update,delete,insert on sys.xdb$moveSchemaTab to apps;
Grant succeeded.
Now compiled the package "AD_ZD_PREP"
SQL> alter package apps.AD_ZD_PREP compile body;
Package body altered.
SQL>
run [applint2@ebsx01appd10 ~]$ adop phase=prepare
ADOP cycle completed without any further issues, cause for the above issue could be failed run of adgrants.sql
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.