oracle r12停止更新,EBS R12中文升级补丁

D:>CD

D:\oracle\r12\apps\apps_st\appl\ad\12.0.0\bin

D:\oracle\r12\apps\apps_st\appl\ad\12.0.0\bin

>adadmin

按提示输入sysadmin和apps密码，其余可以全部默认，出现主菜单

选择4. Maintain Applications Database Entities menu

选择3. Maintain multi-lingual tables

选择5. Return to Main Menu

选择5. Change Maintenance Mode

选择1. Enable Maintenance Mode

选择3. Return to Main Menu

选择6. Exit AD Administration

二：安装升级补丁

D:\oracle\r12\apps\apps_st\appl\ad\12.0.0\bin

>adpatch

按照提示输入sysadmin和apps密码，输入补丁路径和.drv文件的名字

泡杯茶消遣一下吧，耐心等候，完成后再次运行adadmin,

D:\oracle\r12\apps\apps_st\appl\ad\12.0.0\bin

>adadmin

选择5. Change Maintenance Mode

选择2. Disable Maintenance Mode

选择3. Return to Main Menu

选择6. Exit AD Administration

语言包安装完成

Method 2:

Apply ZHS patch for R11:

1, 解压11.5.10 NLS Pack

$ cd

/oracle/Stage11i/oraNLS/Disk1/nls/stage$

adcrptop.sh /oracle/Stage11i/oraNLS/patch

(需要先建立patch目录)

2, 检查数据库的字符集

sqlplus /nolog sql> connect / as

sysdbasql> select *

from

NLS_DATABASE_PARAMETERS--------------------------------------------NLS_CHARACTERSET

UTF8

3, 使用 license Manager

增加中文语言支持

# su – appdemo

$ cd $AD_TOP/bin

$ ./adlicmgr.sh

update you current licensed products

选择 CN-China

选择 ZHS-Simplified_Chinese (Base language not changed)

4, 停用AP

$cd $ADMIN_SCRIPTS_HOME

$./adstpall.sh apps/apps

5, 使用adadmin 启用维护模式

$ adadmin

5. Change

Maintenance Mode

1. Enable

Maintenance Mode

6, 使用adadmin 维护多语言表

$ adadmin

4. Maintain Applications Database Entities

menu

3. Maintain multi-lingual tables

7, 安装 Oracle 11.5.9 NLS patch

# su – appdemo

$ cd /export/home/Stage11i/oraNLS/patch/ZHS

$ adpatch ( u1159nls.drv)

8, 使用adadmin 禁用维护模式

$ adadmin

5. Change

Maintenance Mode

2. Disable

Maintenance Mode

9, 编辑数据库无效对象

# su – appdemo

$adadmin

2. Maintain

Applications Database Objects menu

2. Compile

APPS schema(s)

sqlplus apps/apps

SQL> select count(*) from dba_objects

2 where status='INVALID' and owner='APPS'

3 /

COUNT(*)

----------

0

Apply ZHS patch for R12:

1, 解压11.5.10 NLS Pack

$ cd

/oracle/Stage11i/oraNLS/Disk1/nls/stage$

adcrptop.sh /oracle/Stage11i/oraNLS/patch

(需要先建立patch目录)

2, 检查数据库的字符集

sqlplus /nolog sql> connect / as

sysdbasql> select *

from

NLS_DATABASE_PARAMETERS--------------------------------------------NLS_CHARACTERSET

UTF8

3, 使用 license Manager 增加中文语言支持(R12没有adlicmgr.sh

脚本)

以sysadmin登陆web，初始密码是sysadmin;

进入System Administration—〉

Oracle Application Manager—〉

License Manager—〉

languages －>

Simplified Chinese－>

submit

(no change base language)

4, 停用AP

$cd $ADMIN_SCRIPTS_HOME

$./adstpall.sh apps/apps

5, 使用adadmin 启用维护模式

$ adadmin

5. Change

Maintenance Mode

1. Enable

Maintenance Mode

6, 使用adadmin 维护多语言表

$ adadmin

4. Maintain Applications Database Entities

menu

3. Maintain multi-lingual tables

7, 安装 Oracle 12.1.1 NLS patch

# su – appdemo

$ cd /export/home/Stage12i/6678700_ZHS

$ adpatch (u6678700.drv)

8, 使用adadmin 禁用维护模式

$ adadmin

5. Change

Maintenance Mode

2. Disable

Maintenance Mode

9, 编辑数据库无效对象

# su – appdemo

$adadmin

2. Maintain

Applications Database Objects menu

2. Compile

APPS schema(s)

sqlplus apps/apps

SQL> select count(*) from dba_objects

2 where status='INVALID' and owner='APPS'

3