R12.2 adop phase=cleanup failed with ORA-20001: Error while calling ad_zd.cleanupORA-01555: snapshot too old:   Leave a comment

Below is an excerpt when i was running adop session.

When i was running adop phase=cleanup i was hit with the below error

[applmgr@r122 ~]$ adop phase=cleanup
Enter the APPS password: 
Enter the SYSTEM password: 
Enter the WLSADMIN password:
Please wait. Validating credentials...

RUN file system context file: /u01/oracle/PROD/fs2/inst/apps/PROD_r122/appl/admin/PROD_r122.xml
PATCH file system context file: /u01/oracle/PROD/fs1/inst/apps/PROD_r122/appl/admin/PROD_r122.xml
************* Start of session *************
 version: 12.2.0
 started at: Wed Jul 24 2013 03:34:53
APPL_TOP is set to /u01/oracle/PROD/fs2/EBSapps/appl
[STATEMENT] Using 4 workers (Default: 4, Recommended maximum limit: 62)
 Cleanup is not done in earlier session
 [START 2013/07/24 03:35:27] adzdoptl.pl run
 ADOP Session ID: 4
 Phase: cleanup
 Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20130724_033421.log
 [START 2013/07/24 03:35:48] cleanup phase
 [EVENT] [START 2013/07/24 03:35:52] Performing Cleanup steps 
 [EVENT] [START 2013/07/24 03:35:57] Running CLEANUP ddls in ddl handler table 
 Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
 ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20130724_033421/PROD_r122/log
 [EVENT] [END 2013/07/24 03:39:43] Running CLEANUP ddls in ddl handler table 
 [EVENT] Cleaning up ABORT DDL from DDL Handler Table
 [START 2013/07/24 03:39:54] Generating All DDL Report
 [EVENT] Report: /u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql
[EVENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20130724_033421/PROD_r122/adzdallddls_20130724_033957.out
[END 2013/07/24 03:39:58] Generating All DDL Report
[EVENT] Calling cleanup in QUICK mode
 [WARNING] Cleanup may take a while. Please wait.
[ERROR] Failed to execute sql statement :
 declare
 result varchar2(10);
 begin
 ad_zd.cleanup('QUICK');
 exception
 when others then
 raise_application_error(-20001,'Error while calling ad_zd.cleanup' || sqlerrm);
 end;
[ERROR] SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jul 24 03:40:01 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> declare
ERROR at line 1:
ORA-20001: Error while calling ad_zd.cleanupORA-01555: snapshot too old:
rollback segment number 2 with name "_SYSSMU2_735814084$" too small
ORA-06512: at line 7
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[UNEXPECTED]Error occurred while calling cleanup plsql API
 [UNEXPECTED]Cleanup phase completed with errors/warnings. Please check logfiles
 Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20130724_033421.log
adop exiting with status = 1 (Fail)
[applmgr@r122 ~]$

To overcome this issue.I have extended the undotablespace using below:

SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where TABLESPACE_NAME like 'APPS_UNDOTS1';
TABLESPACE_NAME    FILE_NAME       
--------------------------------------------------------------------------------------------------------------
APPS_UNDOTS1    /u01/oracle/PROD/data/undo01.dbf

SQL> ALTER DATABASE DATAFILE '/u01/oracle/PROD/data/undo01.dbf' RESIZE 10240M;
Database altered.
SQL>

Then again i executed the adop phase=cleanup
[applmgr@r122 ~]$ adop phase=cleanup
Enter the APPS password: 
Enter the SYSTEM password: 
Enter the WLSADMIN password:
Please wait. Validating credentials...

RUN file system context file: /u01/oracle/PROD/fs2/inst/apps/PROD_r122/appl/admi
n/PROD_r122.xml
PATCH file system context file: /u01/oracle/PROD/fs1/inst/apps/PROD_r122/appl/ad
min/PROD_r122.xml
************* Start of session *************
 version: 12.2.0
 started at: Fri Feb 28 2014 04:11:18
APPL_TOP is set to /u01/oracle/PROD/fs2/EBSapps/appl
[STATEMENT] Using 4 workers (Default: 4, Recommended maximum limit: 59)
 Cleanup is not done in earlier session
 [START 2014/02/28 04:11:45] adzdoptl.pl run
 ADOP Session ID: 4
 Phase: cleanup
 Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20140228_041049.log
 [START 2014/02/28 04:12:03] cleanup phase
 [EVENT] [START 2014/02/28 04:12:06] Performing Cleanup steps 
 [EVENT] [START 2014/02/28 04:12:11] Running CLEANUP ddls in ddl handler table 
 Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=4 restart=no abandon=yes defaultsfile=/u01/oracle/PROD/fs2/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
 ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20140228_041049/PROD_r122/log
 [EVENT] [END 2014/02/28 04:13:26] Running CLEANUP ddls in ddl handler table 
 [EVENT] Cleaning up ABORT DDL from DDL Handler Table
 [START 2014/02/28 04:13:32] Generating All DDL Report
 [EVENT] Report: /u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql
[EVENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20140228_041049/PROD_r122/adzdallddls_20140228_041335.out
[END 2014/02/28 04:13:36] Generating All DDL Report
 [EVENT] Calling cleanup in QUICK mode
[WARNING] Cleanup may take a while. Please wait.
 [EVENT] [END 2014/02/28 04:57:56] Performing Cleanup steps 
 [END 2014/02/28 04:58:05] cleanup phase 
 [START 2014/02/28 04:58:11] Generating AD_ZD_LOGS Report
 [EVENT] Report: /u01/oracle/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql
[EVENT] Output: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/cleanup_20140228_041049/PROD_r122/adzdshowlog.out
[END 2014/02/28 04:58:24] Generating AD_ZD_LOGS Report
 [END 2014/02/28 04:58:25] adzdoptl.pl run
 adop phase=cleanup - Completed Successfully
Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/4/adop_20140228_041049.log
adop exiting with status = 0 (Success)

 

Advertisements

Posted February 28, 2014 by balaoracledba.com in R12.2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: