adop failed
with "Patch service is not exist or running"
While applying the
patch ,getting the error "Patch service is not exist or
running".
validating system setup.
Node registry is valid.
Log: /erp_appl/apps/fs1/inst/apps/DBAPRE_host1/logs/appl/rgf/TXK/verifyssh.log
Output: /erp_appl/apps/fs1/inst/apps/DBAPRE_host1/logs/appl/rgf/TXK/out.xml
Remote execution is operational.
[ERROR] Patch service is not exist or running
Package AD_ZD_PREP is invalid.
SQL> alter package apps.AD_ZD_PREP compile;
Warning: Package altered with compilation errors.
SQL> show errors package body apps.AD_ZD_PREP;
Errors for PACKAGE BODY APPS.AD_ZD_PREP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
463/3 PL/SQL: SQL Statement ignored
463/19 PL/SQL: ORA-00942: table or view does not exist
467/5 PL/SQL: SQL Statement ignored
467/21 PL/SQL: ORA-00942: table or view does not exist
501/5 PL/SQL: SQL Statement ignored
501/21 PL/SQL: ORA-00942: table or view does not exist
Run adgrants.sql script
SQL> @adgrants.sql APPS
SQL> alter package apps.AD_ZD_PREP compile;
Package altered.
Now retry adop.It should work.
validating system setup.
Node registry is valid.
Log: /erp_appl/apps/fs1/inst/apps/DBAPRE_host1/logs/appl/rgf/TXK/verifyssh.log
Output: /erp_appl/apps/fs1/inst/apps/DBAPRE_host1/logs/appl/rgf/TXK/out.xml
Remote execution is operational.
[ERROR] Patch service is not exist or running
Package AD_ZD_PREP is invalid.
SQL> alter package apps.AD_ZD_PREP compile;
Warning: Package altered with compilation errors.
SQL> show errors package body apps.AD_ZD_PREP;
Errors for PACKAGE BODY APPS.AD_ZD_PREP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
463/3 PL/SQL: SQL Statement ignored
463/19 PL/SQL: ORA-00942: table or view does not exist
467/5 PL/SQL: SQL Statement ignored
467/21 PL/SQL: ORA-00942: table or view does not exist
501/5 PL/SQL: SQL Statement ignored
501/21 PL/SQL: ORA-00942: table or view does not exist
Run adgrants.sql script
SQL> @adgrants.sql APPS
SQL> alter package apps.AD_ZD_PREP compile;
Package altered.
Now retry adop.It should work.