While applying the patch ,getting the error "Patch service is not exist or running".
validating system setup.
Node registry is valid.
Log: /u01/JAYPRE/fs1/inst/apps/JAYPRE_JJ10003/logs/appl/rgf/TXK/verifyssh.log
Output: /u01/JAYPRE/fs1/inst/apps/JAYPRE_JJ10003/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: /u01/JAYPRE/fs1/inst/apps/JAYPRE_JJ10003/logs/appl/rgf/TXK/verifyssh.log
Output: /u01/JAYPRE/fs1/inst/apps/JAYPRE_JJ10003/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.
No comments:
Post a Comment