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

Bas Klaassen
0 0
Read Time:2 Minute, 37 Second

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

About Post Author

Bas Klaassen

Oracle Consultant at AMIS
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %
Next Post

Project Experience with Acegi Security, Spring MVC and Oracle MapViewer

For a customer with an interesting business we had to build a web application that has a RIA front end, displays data on maps, authenticates thru a web service that is connected with a back office customer subscription system, and that can handle any kind of data (for example shops, […]
%d bloggers like this: