Archive for February 2014

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)

 

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

New Look and Feel of R12.2.3   3 comments

After upgrade to R12.2.3. I see the look and feel has been changed as below. But i dont see any changes in forms. Please find the screenshots.

2014-02-28 12_45_38-

2014-02-28 12_46_41-Home

2014-02-28 12_47_10-

 

 

2014-02-28 13_26_28-

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

New StartCD for R12.2 has been released   2 comments

Recently Oracle has released new start CD for R12.2 STARTCD 12.2.0.47_5. 

The startCD 12.2.0.47 for Oracle E-Business Suite has been replaced with Patch 17873425. This patch is now available in My Oracle Support.

Two supported upgrade paths are available. Choose the one that best suits your needs:

  • § Use startCD 12.2.0.47 to upgrade to Release 12.2.2 or 12.2.3. This will include JDK7 as part of the installation.
  • § Use startCD 12.2.0.46 to upgrade to Release 12.2.2 or 12.2.3, in conjunction with the AD/TXK.Delta.3 patches. This will retain JDK6.

startCD Version

JDK Version

AD/TXK Codelevel

Release Supported

startCD 12.2.0.46

JDK6

R12.TXK.C.DELTA.2/R12.AD.C.delta.2

12.2.2

startCD 12.2.0.46

JDK6

R12.TXK.C.DELTA.3/R12.AD.C.delta.3

12.2.3

startCD 12.2.0.47

 JDK7

R12.TXK.C.DELTA.2/R12.AD.C.delta.2

 None

 startCD 12.2.0.47

 JDK7

R12.TXK.C.DELTA.3/R12.AD.C.delta.3

12.2.2

startCD 12.2.0.47

JDK7

R12.TXK.C.DELTA.3/R12.AD.C.delta.3

12.2.3

Please find the patch number is as below

start

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