《Oracle Applications DBA 基礎》- 14. 從 11i 到 R12的更新

《 Oracle Applications DBA 基礎》- 14. 從 11i 到 R12的更新

=======================

參考資料：

1. Oracle Applications Upgrade Guide: Release 11i to Release 12.0.4

http://download.oracle.com/docs/ ... bat/r1204upg11i.pdf

2. <850008.1> Interesting Documents Concerning E-Business Suite 11i to R12 Upgrades

3. <554509.1> Unable To Login To Oracle Applications After Upgrading

from 11.5.10 to R12  

4. <403339.1> Oracle 10gR2 Database Preparation Guidelines for

an Oracle E-Business Suite Release 12.0.4 Upgrade

5. http://advait.wordpress.com/2008/03/04/

upgrading- oracle -application-11i-to-e-business-suite-r12/

11i 到 R12 的更新過程比較複雜，下面分planning, preparing, upgrade, after upgrade

幾個section 簡單介紹一下，隻是一個大概的印象。主要還是靠閱讀相關的metalink 文檔。

除了tech stack的更新外，一部分精力可能還在各個product 更新後，業務可能遇到的bug，

需要其他進一步的patch。不過，好在11i upgrade 通常也不是一兩天的工作。

14.1 planning for upgrade

=========================

首先清楚自己在什麼版本，一般要求在11.5.10.2 CU2 ，

metalink note <316366.1>: 11.5.10 Oracle E-Business Suite Consolidated Update 2 (CU2) ，

有這樣的解釋：

"11.5.10.2 Maintenance Pack (3480000.drv). This new release of the maintenance pack

includes CU2. You do not have to apply it separately"

"Like the 11.5.10.2 Maintenance Pack, Rapid Install 11.5.10.2 also includes CU2,

so there is no need to apply it separately. "

相關的11.5.10.2 CU2 的patch number:

Patch 3460000: 11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2

Patch 3480000: ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK

檢查 11.5.10 CU2 的 level：

select bug_number from apps.ad_bugs where bug_number ='3460000';

檢查 AD 的 level：

select patch_level from fnd_product_installations where patch_level like '%AD%';

11i.AD.I.5

檢查 check tablespace sizing

select sum(bytes)/1024/1024,TABLESPACE_NAME from

dba_free_space group by TABLESPACE_NAME;

select contents,extent_management,allocation_type

from dba_tablespaces where tablespace_name='TEMP';

檢查 OATM Oracle Application Tablespace Model

檢查 multiple org 是否enabled

select multi_org_flag from apps.fnd_product_groups;

select * from apps.hr_operating_units;

profile option: "MO:Operating Unit"

檢查 db parameters

recyclebin=off

14.2 Preparing for the upgrade

================================

安裝 TUMS (Upgrade Manual Script ) patch 5120936, 步驟如下：

adadmin => adpatch

cd $AD_TOP/patch/115/sql

sqlplus apps/welcome @adtums.sql /usr/tmp

注意： /usr/tmp must be in the "utl_file_dir"

安裝 AD preparation patch: patch 5726010

cd 5726010

sqlplus apps/welcome @adgncons.sql apps welcome

修改 adcrtbsp.sql to reflect your current tablespace information

sqlplus <SYSTEM>/<SYSTEM PASSWORD> @adcrtbsp.sql   

mkdir -p $ORACLE_HOME/appsutil/admin

cp adgrants.sql $ORACLE_HOME/appsutil/admin

sqlplus / as sysdba

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS

run gather statistics

14.3 upgrade

================================

确認 character sets of APPL_TOP

Character Sets

You have to be careful while selecting the character set for APPL_TOP.

### create /u01 ,/u02, /u03 for the R12 tech stacks.

/u01 => appl_top,common_top, 10.1.3,10.1.2

/u02 => inst_top

/u03 => rdbms home ,10.2.3

chown -R applvis:dba /u01

chown -R applvis:dba /u02

chown -R oravis:dba /u03

第一次運作 rapidwiz 安裝新的tech stack：

[[email protected] rapidwiz]# pwd

/media/usbdisk/r1204/StageR12/startCD/Disk1/rapidwiz

[[email protected] rapidwiz]# ./rapidwiz

選項如下：

=> upgrade to R12 => create upgrade file system => apps/welcome

Configuration file written to: /u02/apps/PROD_mis/conf_PROD.txt

Configuration file written to: /u03/db/tech_st/10.2.0/appsutil/conf_PROD.txt

Database logfile - /u03/db/tech_st/10.2.0/appsutil/log/PROD_mis/12121135.log

Appltop logfile - /u02/apps/PROD_mis/logs/12121135.log

更新資料庫 to 10gR2

apply patch 6319846

[[email protected] 6319846]$ $ORACLE_HOME/OPatch/opatch napply -skip_subset -skip_duplicate

sql>@postinstall.sql

apply patch 6110331

如果 apps account locked ，unlock apps， enable maintenance

source R12's env, apply patch 6604842

#$APPL_TOP/admin/topfile.txt

### apply u6394500.drv

cd $AU_TOP/patch/115/driver

adpatch options=nocopyportion,nogenerateportion

可能問題如下：

1. mkdir admin

2. ORA-02303: cannot drop or replace a type with type or table dependents

metalink: <603952.1> Script jtfpfcreate.sql fails during Upgrade to Release 12.0.4

no dependent objects found for type "JTF_PF_CLIENT_OBJECT"

drop type force for all the type listed in <603952.1>.

drop TYPE APPS.JTF_PF_CLIENT_OBJECT force;

use adctrl to restart failed job

### JTF  Java Technology Foundation, used by CRM , iStore,iMarketing

3. ORA-01653: unable to extend table APPLSYS.AD_DEFERRED_JOBS by 16 in tablespace APPS_TS_TX_DATA

restart adpatch

4. /u01/apps/apps_st/appl/jtf/12.0.0/patch/115/sql/jtfpfstart.sql

apparently workaround for point 2 is not good. causing issue here.

just modify the sql and put exit.

5. restart a failed patch process

tell worker to shutdown ;

tell manager that worker failed its job ;

tell manager that worker acknowledges quit ;

restart adpatch;

#######################################

### autoconfig rdbms home

### 第二次運作 rapidwiz 以配置系統。

[[email protected] rapidwiz]# ./rapidwiz

Rapid Install Wizard is validating your file system......

4 dvd labels found

Rapid Install Wizard will now launch the Java Interface.....

[[email protected] rapidwiz]# Appltop logfile - /u02/apps/PROD_mis/logs/12151909.log

14.4  Upgrade 後可能的問題

#############################

can't open any form after login:

java console get this:

Loaded image:

Following Exception occured: java.lang.IllegalArgumentException: Illegal argument for colorScheme applet parameter

java.lang.IllegalArgumentException: Illegal argument for colorScheme applet parameter

        at oracle.forms.engine.Main.initDesktop(Unknown Source)

        at oracle.forms.engine.Main.start(Unknown Source)

        at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

metalink <858367.1> matches .

just deinstall java 1.5 and then open a form again it will pickup the java 1.6.

and ok.

no FND_COLOR_SCHEME in R12. only "java color scheme", and not set.

############################################################