Upgrading EBS 11i database (9.2.0.6) to 10GR2 database Oracle Headquarters Redwood Shores1 e1698667100526

Upgrading EBS 11i database (9.2.0.6) to 10GR2 database

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