I have upgraded my EBS 11.5.10 database (9.2.6.0) to release 10gR2 (10.2.0.2.0). I have followed note 362203.1 from Metalink to perform the upgrade. Here are some tips or problems I ran into… 1. The first patch is 5478710 (TXK (FND & ADX) AUTOCONFIG ROLLUP PATCH O) After applying the patch make a new appsutil.zip file… [oracle@ebs1 5478710]$ $ADPERLPRG $AD_TOP/bin/admkappsutil.pl Starting the generation of appsutil.zip Log file located at /appl/prodappl/admin/log/MakeAppsUtil_12200852.log output located at /appl/prodappl/admin/out/appsutil.zip MakeAppsUtil completed successfully. After creating the appsutil.zip copy the appsutil.zip to the rdbms ORACLE_HOME and unzip it in this directory. The appsutil.zip should be copied to the new 10g ORACLE_HOME!!!! 2. the parameter aq_tm_processes must be set to 0. According to note 263809.1 (manual upgrades to 10gr1)… Comment out the AQ_TM_PROCESSES parameter, put in a new and set this explicitly to zero, during the upgrade 3. When running catupgrd.sql ERROR at line 1: ORA-06553: PLS-213: package STANDARD not accessible adjust the init.ora. Commend out the following lines.. #plsql_optimize_level = 2 #MP #plsql_code_type = native #MP #plsql_native_library_dir = /prod11i/plsql_nativelib #plsql_native_library_subdir_count = 149 4. Re-create grants and synonyms using adadmin Maintain Applications Database Entities ————————————————— 1. Validate APPS schema 2. Re-create grants and synonyms for APPS schema Following error occurs… declare * ERROR at line 1: ORA-04063: package body "SYSTEM.AD_DDL" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYSTEM.AD_DDL" ORA-06512: at line 19 Seems a known problem according to Metalink. Note 387745.1 brings the sollution… Run utlrp.sql …. [oracle@ebs2 admin]$ sqlplus /nolog SQL*Plus: Release 10.2.0.2.0 – Production on Thu Dec 28 15:39:13 2006 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. SQL> conn sys as sysdba Enter password: Connected. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup upgrade ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 1264892 bytes Variable Size 415236868 bytes Database Buffers 645922816 bytes Redo Buffers 11317248 bytes Database mounted. Database opened. SQL> @utlirp.sql SQL>shutdown SQL>startup SQL>@utlrp.sql Problem solved… Again run adadmin
