Re: QUESTION: Move the APPS_UNDOTS1 to another location

Posted by Ashok on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/QUESTION-Move-the-APPS-UNDOTS1-to-another-location-tp3168p3172.html

Hi Erman,

When trying to cleanup adop section im getting this erorr

[applmgr@icic patch]$ adop phase=cleanup

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u01/applmgr/PROD/fs1/inst/apps/PROD_icic/appl/admin/PROD_icic.xml
    Patch edition context: /u01/applmgr/PROD/fs2/inst/apps/PROD_icic/appl/admin/PROD_icic.xml
    Patch file system free space: 309.36 GB

Validating system setup.
    [ERROR]     Failed to execute SQL statement:
 select AD_ZD_ADOP.GET_INVALID_NODES() from dual
    [ERROR]     Error Message:
    [ERROR]     ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
    [UNEXPECTED]Error determining whether this is a multi-node instance
[ERROR]     Failed to execute SQL statement:
   select ad_zd_adop.validate_session_id('') from dual

[ERROR]     Error Message:
[ERROR]     ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)


[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 = 2 (Fail)
Thnks
ASHOK