虚拟机安装EBSR12

1 环境准备注意是OL6版本

host

192.168.154.125 ebs121.ebsx.com ebs121

vim /etc/sysconfig/network

HOSTNAME=[node_name].[domain_name]

dNS

# Generated by NetworkManager
search ebsx.com
nameserver 8.8.8.8
options attemps:5
options timeout:15
~

限制文件

vi /etc/security/limits.conf

yum install oracle-ebs-server-R12-preinstall

修改安全

vim /etc/selinux/config

防火墙

service iptables stop
chkconfig iptables off

内核参数

vim /etc/sysctl.conf

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
fs.aio-max-nr = 1048576
net.ipv4.tcp_tw_recycle = 0
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 131072
net.ipv4.ip_local_port_range = 10000 65000
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65535
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 262144

sysctl -p

创建用户

groupadd dba
useradd -g dba applmgr
useradd -g dba oracle

passwd applmgr
applmgr
passwd oracle
oracle

mkdir -p /u01/oracle
chown -R oracle:dba /u01/oracle
chmod 775 /u01/oracle
mkdir -p /u01/apps
chown -R applmgr:dba /u01/apps
chmod 775 /u01/apps

软件包

yum install -y openmotif21-2.1.30-11.EL6.i686
xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.0.2.i386

binutils-2.20.51.0.2-5.11.el16.x86_64

---直接装这个吧
yum install oracle-ebs-server-R12-preinstall

ldconfig -v

检查端口

lsof -i TCP:6000

org)

su - root
mkdir -p /u01/oraInventory
chown -R oracle:dba /u01/oraInventory
chmod 775 /u01/oraInventory

vi /etc/oraInst.loc

inventory_loc=/u01/oraInventory
inst_group=dba

chmod g+w /etc/oraInst.loc

2 开始安装

补丁修复

mkdir -p /u01/patches
cd /u01/patches/
unzip /mnt/hgfs/ebsapp/121patches/p6078836_101330_LINUX.zip
cd 6078836/
cp libdb.so.2 /usr/lib/

解压文件

mkdir -p /u01/R121stage
cd /u01/R121stage

unzip -o /mnt/hgfs/ebsapp/12.1/B53824-01_1of4.zip
unzip -o /mnt/hgfs/ebsapp/12.1/B53824-01_2of4.zip
unzip -o /mnt/hgfs/ebsapp/12.1/B53824-01_3of4.zip
unzip -o /mnt/hgfs/ebsapp/12.1/B53824-01_4of4.zip

#ac
unzip -o /mnt/hgfs/ebsapp/12.1/V15680-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15680-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15680-01_3of3.zip

##ac
unzip -o /mnt/hgfs/ebsapp/12.1/V15681-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15681-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15681-01_3of3.zip

unzip -o /mnt/hgfs/ebsapp/12.1/V15682-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15682-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15682-01_3of3.zip

unzip -o /mnt/hgfs/ebsapp/12.1/V15683-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15683-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15683-01_3of3.zip
#

#解压
unzip -o /mnt/hgfs/ebsapp/12.1/V15684-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15684-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15684-01_3of3.zip

##解压
unzip -o /mnt/hgfs/ebsapp/12.1/V15685-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15685-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15685-01_3of3.zip

#解压了
unzip -o /mnt/hgfs/ebsapp/12.1/V15686-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15686-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15686-01_3of3.zip

#解压了
unzip -o /mnt/hgfs/ebsapp/12.1/V15687-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15687-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15687-01_3of3.zip

#解压了
unzip -o /mnt/hgfs/ebsapp/12.1/V15688-01_1of2.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15688-01_2of2.zip
#解压了
unzip -o /mnt/hgfs/ebsapp/12.1/V15689-01.zip
#解压了
unzip -o /mnt/hgfs/ebsapp/12.1/V15690-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15690-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15690-01_3of3.zip

#解压了
unzip -o /mnt/hgfs/ebsapp/12.1/V15691-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15691-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V15691-01_3of3.zip

#解压
unzip -o /mnt/hgfs/ebsapp/12.1/V35224-01_1of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V35224-01_2of3.zip
unzip -o /mnt/hgfs/ebsapp/12.1/V35224-01_3of3.zip

升级unzip

[root@ebs121 Linux_x64]# pwd
/u01/R121stage/startCD/Disk1/rapidwiz/unzip/Linux_x64
[root@ebs121 Linux_x64]# cp unzip /usr/bin/

打安装补丁

cd /u01/R121stage/

3 安装后

环境变量

su - oracle
vim ~/.bash_profile

. /u01/oracle/VIS/db/tech_st/11.1.0/VIS_ebs121.env

su - applmgr
. /u01/apps/VIS/apps/apps_st/appl/APPSVIS_ebs121.env

启停脚本

##停应用
su - applmgr
sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps

#停数据库
su - oracle
sh /u01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_ebs121/addlnctl.sh stop VIS
sh /u01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_ebs121/addbctl.sh stop immediate

####启数据库
su - oracle
sh $ORACLE_HOME/appsutil/scripts/VIS_ebs121/addbctl.sh start
sh $ORACLE_HOME/appsutil/scripts/VIS_ebs121/addlnctl.sh start VIS

##启动应用
su - applmgr
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps

打补丁

Update AS 10g (10.1.2 and 10.1.3) Oracle Homes (Oracle Linux 6, RHEL 6, Oracle Linux 7, and RHEL 7 sonly)

su - applmgr

##备份
[applmgr@ebs121 patches]$ cd /u01/apps/VIS/apps/tech_st/10.1.3/lib/
[applmgr@ebs121 lib]$ cp -p -R stubs stubsBK
[applmgr@ebs121 stubs]$ cd /u01/apps/VIS/apps/tech_st/10.1.2/lib/
[applmgr@ebs121 lib]$ cp -p -R stubs stubsBK

[applmgr@ebs121 ~]$ cd /u01/apps/patches
[applmgr@ebs121 patches]$ unzip p12415211_10105_LINUX.zip
[applmgr@ebs121 lib]$ cd /u01/apps/patches/12415211/files/lib/stubs/

[applmgr@ebs121 stubs]$ cp libgcc_s-2.3.2-stub.so /u01/apps/VIS/apps/tech_st/10.1.2/lib/stubs/

[applmgr@ebs121 stubs]$ cp libgcc_s-2.3.2-stub.so /u01/apps/VIS/apps/tech_st/10.1.3/lib/stubs/

##10.1.2
[applmgr@ebs121 stubs]$ cd /u01/apps/VIS/apps/tech_st/10.1.2/lib/stubs
ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
ln -s libgcc_s.so.1 libgcc_s.so
[applmgr@ebs121 lib]$ echo $ORACLE_HOME
/u01/apps/VIS/apps/tech_st/10.1.2
[applmgr@ebs121 lib]$ /u01/apps/VIS/apps/tech_st/10.1.2/appsutil/clone/adlnktools.sh
[applmgr@ebs121 ~]$ /u01/apps/VIS/apps/tech_st/10.1.2/appsutil/clone/adlnktools.sh

adlnktools.sh started at Fri Nov 4 10:37:49 CST 2022
Log file located at /u01/apps/VIS/inst/apps/VIS_ebs121/logs/ora/10.1.2/install/make_11041037.log

adlnktools.sh completed sucessfully

###10.1.3
[applmgr@ebs121 ~]$ cd /u01/apps/VIS/apps/tech_st/10.1.3/lib/stubs
[applmgr@ebs121 stubs]$ ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1
[applmgr@ebs121 stubs]$ ln -s libgcc_s.so.1 libgcc_s.so
[applmgr@ebs121 stubs]$ /u01/apps/VIS/apps/tech_st/10.1.3/appsutil/clone/adlnkweboh.sh
adlnkweboh.sh started at Fri Nov 4 10:43:47 CST 2022
Log file located at /u01/apps/VIS/inst/apps/VIS_ebs121/logs/ora/10.1.3/install/make_11041043.log

adlnkweboh.sh completed sucessfully

报错了

Error while running adlnktools.sh.
return code = .10.11.13.14.15.16.39.43.45.46.46.47.48.49

## 1.没有进stabus目录
## 2.没有打补丁、打补丁 6078836

su - root
cd /usr/lib
[root@ebs121 lib]# ln -s libdb-4.7.so libdb-4.3.so

4 中文补丁

维护模式

##数据库与应用都开着
su - applmgr
adadmin

AD code level : [B.1]

AD Administration Main Menu
--------------------------------------------------

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration

Enter your choice [6] : 5

Change Maintenance Mode
----------------------------------------

Maintenance Mode is currently: [Disabled].

Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.

Please select an option:

1. Enable Maintenance Mode

2. Disable Maintenance Mode

3. Return to Main Menu

Enter your choice [3] : 1

解压

[applmgr@ebs121 ~]$ cd /u01/apps/patches/

[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/patch/p8576725_12.1.0_R12_GENERIC.zip

打补丁

[applmgr@ebs121 patches]$ cd 8576725/
[applmgr@ebs121 8576725]$ adpatch

输入drv文件

Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/u01/apps/patches/8576725] :
Please enter the name of your AutoPatch driver file : u8576725.drv

关闭维护模式

AD code level : [B.1]

AD Administration Main Menu
--------------------------------------------------

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration

Enter your choice [6] : 5

Please select an option:

1. Enable Maintenance Mode

2. Disable Maintenance Mode

3. Return to Main Menu

Enter your choice [3] : 2

授权中文

转换多语言表

先停掉应用

[applmgr@ebs121 ~]$ adadmin
AD code level : [B.1]

AD Administration Main Menu
--------------------------------------------------

1. Generate Applications Files menu

2. Maintain Applications Files menu

3. Compile/Reload Applications Database Entities menu

4. Maintain Applications Database Entities menu

5. Change Maintenance Mode

6. Exit AD Administration

Enter your choice [6] : 4

Maintain Applications Database Entities
---------------------------------------------------

1. Validate APPS schema

2. Re-create grants and synonyms for APPS schema

3. Maintain multi-lingual tables

4. Check DUAL table

5. Return to Main Menu

Enter your choice [5] : 3

打中文补丁

开启维护模式

adadmin 5 1

解压文件

[applmgr@ebs121 ~]$ cd /u01/apps/patches/
[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/V16181-01.zip
[applmgr@ebs121 patches]$ cd 6678700_ZHS/

打补丁

[applmgr@ebs121 patches]$ cd 6678700_ZHS/
[applmgr@ebs121 6678700_ZHS]$ adpatch

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications AutoPatch

Version 12.0.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.

Your default directory is '/u01/apps/VIS/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

The default directory is [/u01/apps/patches/6678700_ZHS] :
Please enter the name of your AutoPatch driver file : u6678700.drv

Enter the number of parallel workers [8] : 16

可以监控状态

##新开ssh
[applmgr@ebs121 ~]$ adctrl

AD Controller Menu
---------------------------------------------------

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] : 1

Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Run AutoPatch R120 eamlkup.ldt Running
2 Run AutoPatch R120 csmmenu.ldt Running
3 Run AutoPatch R120 csplkup.ldt Running
4 Run AutoPatch R120 csrlkup.ldt Running
5 Run AutoPatch R120 cuglkup.ldt Running
6 Run AutoPatch R120 domdatasec.ldt Running
7 Run AutoPatch R120 cuamenu.ldt Running
8 Run AutoPatch R120 domafobj.ldt Running
9 Run AutoPatch R120 cspnstab.ldt Running
10 Run AutoPatch R120 dddmenu.ldt Running
11 Run AutoPatch R120 czlkup.ldt Running
12 Run AutoPatch R120 dnamenu.ldt Running
13 Run AutoPatch R120 czmenu.ldt Running
14 Run AutoPatch R120 domlkup.ldt Running
15 Run AutoPatch R120 cspmenu.ldt Running
16 Run AutoPatch R120 domattachmenu.ldt Running

中途遇到情况

Completed: file ASTPDFSD.ldt on worker 3 for product ast username APPS.
Assigned: file XLIFFLoader.class on worker 3 for product xdo username XDO. FAILED: file XLIFFLoader.class on worker 3 for product xdo username XDO.
Deferred: file XLIFFLoader.class on worker 3 for product xdo username XDO. (Deferment number 2 for this job)
Completed: file asopmrge.ldt on worker 4 for product aso username APPS.
Assigned: file XLIFFLoader.class on worker 3 for product xdo username XDO.
FAILED: file XLIFFLoader.class on worker 3 for product xdo username XDO.
Program completed successfully

CPS.

There are now 23 jobs remaining (current phase=A1):
10 running, 0 ready to run and 13 waiting.

Program completed successfully

ATTENTION: All workers either have failed or are waiting:

FAILED: file XLIFFLoader.class on worker 3.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

监控情况

##先不要暂停，另开一个窗口
[applmgr@ebs121 ~]$ adctrl

AD Controller Menu
---------------------------------------------------

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] :

Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Run AutoPatch R120 Wait
2 Run AutoPatch R120 Wait
3 Run AutoPatch R120 XLIFFLoader.class FAILED
4 Run AutoPatch R120 Wait
5 Run AutoPatch R120 Wait
6 Run AutoPatch R120 Wait
7 Run AutoPatch R120 Wait
8 Run AutoPatch R120 Wait
9 Run AutoPatch R120 Wait
10 Run AutoPatch R120 Wait
11 Run AutoPatch R120 Wait
12 Run AutoPatch R120 Wait
13 Run AutoPatch R120 Wait
14 Run AutoPatch R120 Wait
15 Run AutoPatch R120 Wait
16 Run AutoPatch R120 Wait

Review the messages above, then press [Return] to continue.

执行修复

再开一个窗口，登录applmgr用户，要应用了环境变量的

adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=ebs121.ebsx.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))" -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME $FA_TOP/patch/115/publisher/defs/FADTXD.xml

adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=ebs121.ebsx.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))" -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME $FA_TOP/patch/115/publisher/templates/US/FADTXD.rtf

[applmgr@ebs121 ~]$ adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=ebs121.ebsx.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))" -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE 00 -XDO_FILE_TYPE XML-DATA-TEMPLATE -FILE_NAME $FA_TOP/patch/115/publisher/defs/FADTXD.xml
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

AD Java

Version 12.0.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...
Temporarily resetting CLASSPATH to:
"/u01/apps/VIS/apps/apps_st/appl/ad/12.0.0/java/adjava.zip:/u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u01/apps/VIS/apps/apps_st/comn/java/lib/appsborg.zip:/u01/apps/VIS/apps/tech_st/10.1.2/forms/java:/u01/apps/VIS/apps/tech_st/10.1.2/forms/java/frmall.jar:/u01/apps/VIS/apps/tech_st/10.1.2/jlib/ewt3.jar:/u01/apps/VIS/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u01/apps/VIS/apps/apps_st/comn/java/classes"

Calling /u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
XDOLoader started: Tue Nov 08 16:42:47 CST 2022

Parameters passed to XDOLoader...
[FILE_NAME] [/u01/apps/VIS/apps/apps_st/appl/fa/12.0.0/patch/115/publisher/defs/FADTXD.xml]
[DB_USERNAME] [apps]
[XDO_FILE_TYPE] [XML-DATA-TEMPLATE]
[LOB_CODE] [FADTXD]
[JDBC_CONNECTION] [(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=ebs121.ebsx.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))]
[LANGUAGE] [00]
[DB_PASSWORD] [******]
[LOB_TYPE] [DATA_TEMPLATE]
[UPLOAD] [UPLOAD]
[APPS_SHORT_NAME] [OFA]

Start uploading...
Target file: FADTXD.xml
Updating the record in XDO_LOBS: FADTXD.xml
Done updating the file in XDO_LOBS: FADTXD.xml

XDOLoader done successfully: Tue Nov 08 16:42:58 CST 2022

[applmgr@ebs121 ~]$ adjava -ms128m -mx256m -nojit oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps -JDBC_CONNECTION "(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=ebs121.ebsx.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))" -LOB_TYPE TEMPLATE_SOURCE -APPS_SHORT_NAME OFA -LOB_CODE FADTXD -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE RTF -TRANSLATE Y -FILE_NAME $FA_TOP/patch/115/publisher/templates/US/FADTXD.rtf

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

AD Java

Version 12.0.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...
Temporarily resetting CLASSPATH to:
"/u01/apps/VIS/apps/apps_st/appl/ad/12.0.0/java/adjava.zip:/u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/lib/dt.jar:/u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/lib/tools.jar:/u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre/lib/rt.jar:/u01/apps/VIS/apps/apps_st/comn/java/lib/appsborg.zip:/u01/apps/VIS/apps/tech_st/10.1.2/forms/java:/u01/apps/VIS/apps/tech_st/10.1.2/forms/java/frmall.jar:/u01/apps/VIS/apps/tech_st/10.1.2/jlib/ewt3.jar:/u01/apps/VIS/apps/tech_st/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar:/u01/apps/VIS/apps/apps_st/comn/java/classes"

Calling /u01/apps/VIS/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java ...
XDOLoader started: Tue Nov 08 16:43:45 CST 2022

Parameters passed to XDOLoader...
[TERRITORY] [US]
[FILE_NAME] [/u01/apps/VIS/apps/apps_st/appl/fa/12.0.0/patch/115/publisher/templates/US/FADTXD.rtf]
[DB_USERNAME] [apps]
[XDO_FILE_TYPE] [RTF]
[LOB_CODE] [FADTXD]
[TRANSLATE] [Y]
[JDBC_CONNECTION] [(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL =tcp)(HOST=ebs121.ebsx.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))]
[LANGUAGE] [en]
[DB_PASSWORD] [******]
[LOB_TYPE] [TEMPLATE_SOURCE]
[UPLOAD] [UPLOAD]
[APPS_SHORT_NAME] [OFA]

Start uploading...
Target file: FADTXD.rtf
Updating the record in XDO_LOBS: FADTXD.rtf
Done updating the file in XDO_LOBS: FADTXD.rtf

XDOLoader done successfully: Tue Nov 08 16:44:06 CST 2022

重启worker

Review the messages above, then press [Return] to continue.

AD Controller Menu
---------------------------------------------------

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

Enter your choice [1] : 2

Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 3

重新监控

Enter your choice [1] : 1

Control
Worker Code Context Filename Status
------ -------- ----------------- -------------------------- --------------
1 Run Generic R120 AKDAPREG.fmx Running
2 Run Generic R120 AKDATTRS.fmx Running
3 Run Generic R120 AKDFLOWB.fmx Running
4 Run Generic R120 AKDFLOWS.fmx Running
5 Initial Generic R120 AKDOBFKS.fmx Assigned
6 Initial Generic R120 AKDOBJWB.fmx Assigned
7 Run Generic R120 AKDOBPKS.fmx Running
8 Run Generic R120 AKDPICKF.fmx Running
9 Initial Generic R120 AKDQUERY.fmx Assigned
10 Initial Generic R120 AKDREGNS.fmx Assigned
11 Initial Generic R120 AKDRELOR.fmx Assigned
12 Initial Generic R120 ALRALERT.fmx Assigned
13 Initial Generic R120 ALRASDDL.fmx Assigned
14 Initial Generic R120 ALRASDPG.fmx Assigned
15 Initial Generic R120 ALRPRRPA.fmx Assigned
16 Initial Generic R120 ALRPRSAP.fmx Assigned

完成

将近3个小时

/u01/apps/VIS/apps/apps_st/appl/admin/VIS/out/adt541205.lst

for details.

Purging timing information for prior sessions.

sqlplus -s APPS/***** @/u01/apps/VIS/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000

Done purging timing information for prior sessions.

AutoPatch is complete.

AutoPatch may have written informational messages to the file
/u01/apps/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.lgi

Errors and warnings are listed in the log file
/u01/apps/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

and in other log files in the same directory.

关闭维护模式

adadmin
5
2

5 升级12.1.3

打补丁 9239089

##关闭应用，不关数据库

[applmgr@ebs121 R121stage]$ cd /u01/apps/patches/
[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9239089_R12.AD.B_R12_LINUX.zip

使用oracle用户复制adgrants.sql

[oracle@ebs121 ~]$ mkdir $ORACLE_HOME/appsutil/admin
[oracle@ebs121 ~]$ cd /u01/apps/patches/9239089/admin/
[oracle@ebs121 admin]$ cp adgrants.sql $ORACLE_HOME/appsutil/admin/

执行脚本

sqlplus / as sysdba
@$ORACLE_HOME/appsutil/admin/adgrants.sql APPLSYS

执行成功后

进入维护模式

adadmin 5 1

[applmgr@ebs121 admin]$ cd /u01/apps/patches/9239089/
[applmgr@ebs121 9239089]$ adpatch
输入SYSTEM密码 manager
u9239089.drv

几分钟后打完

升级补丁前

重新链接高级供应链规划（ASCP

[applmgr@ebs121 9239089]$ cd $AD_TOP/bin
[applmgr@ebs121 bin]$ vim adrelinknew.sh
##查找这行
##CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'
##1729行

##修改为：
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

扩展表空间

--
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/reference1.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/reference2.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/reference3.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;

--
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/gcats1_oid.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;

--
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/orabpel.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
--
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/uddisys01.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
--
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/APPS_TS_TX_DATA03.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/APPS_TS_TX_DATA02.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/APPS_TS_TX_DATA.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
--
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/APPS_TS_TX_IDX01.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;
ALTER DATABASE DATAFILE '/u01/oracle/VIS/db/apps_st/data/APPS_TS_TX_IDX02.dbf' AUTOEXTEND ON NEXT 50M MAXSIZE 4G;

修改$ORACLE_HOME/dbs/init.ora文件

[oracle@ebs121 bin]$ cd $ORACLE_HOME/dbs
[oracle@ebs121 dbs]$ vi initVIS.ora

_disable_fast_validate=TRUE

升级补丁

解压文件

[applmgr@ebs121 bin]$ cd /u01/apps/patches/
/usr/bin/unzip /mnt/hgfs/resource/EBS/Oracle\ E-Business\ Suite\ 12.1.3/V36339-01_1of6.zip
1-6个zip

打补丁

[applmgr@ebs121 patches]$ cd 9239090/
[applmgr@ebs121 9239090]$ adpatch

manager
u9239090.drv

##提示中文补丁，输入yes
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
This base patch contains files which may require translation
depending on the languages you currently have installed.

Oracle Corporation recommends that you obtain any translated versions of this
patch for each of your non-US languages PRIOR to applying this base patch.

The translated version of the patch should be applied immediately AFTER
applying this base patch.
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Do you wish to apply this patch now [No] ? yes

2.5小时后续报错了

The following Oracle Forms objects did not generate successfully:

au resource ASTSLLIB.pll
au resource OKLCSAST.pll
au resource OKLCSREQ.pll
au resource OKLCSGTR.pll
au resource OKLCSASD.pll
au resource OKLCSHDR.pll
au resource OKLCSSTT.pll
au resource CSCUTILS.pll

完善后，花了4个小时

/u01/apps/VIS/apps/apps_st/appl/admin/VIS/out/adt543206.lst

for details.

Purging timing information for prior sessions.

sqlplus -s APPS/***** @/u01/apps/VIS/apps/apps_st/appl/ad/12.0.0/sql/adtpurge.sql 10 1000

Done purging timing information for prior sessions.

AutoPatch is complete.

AutoPatch may have written informational messages to the file
/u01/apps/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.lgi

Errors and warnings are listed in the log file
/u01/apps/VIS/apps/apps_st/appl/admin/VIS/log/adpatch.log

and in other log files in the same directory.

fig:

中文补丁

[applmgr@ebs121 patches]$ cd /u01/apps/patches/
[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9239090_R12_zhs.zip
[applmgr@ebs121 patches]$ cd 9239090_ZHS/

u9239090.drv

后续补丁，注意顺序

9239095

[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9239095_R12_GENERIC.zip
[applmgr@ebs121 patches]$ cd 9239095/
u9239095.drv

9817770

[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9817770_R12.ATG_PF.B_R12_LINUX.zip
[applmgr@ebs121 patches]$ cd 9817770/
[applmgr@ebs121 9817770]$ adpatch
u9817770.drv

9966055

[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9966055_R12.FND.B_R12_GENERIC.zip
[applmgr@ebs121 patches]$ cd 9966055/
[applmgr@ebs121 9966055]$ adpatch
u9966055.drv

执行到这里，可以关闭维护模式了 adadmin 5 2

autoconfig

应用节点

[applmgr@ebs121 9966055]$ $ADMIN_SCRIPTS_HOME/adautocfg.sh
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......

[applmgr@ebs121 9966055]$ cd $AD_TOP/bin/
[applmgr@ebs121 bin]$ perl admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /u01/apps/VIS/inst/apps/VIS_ebs121/admin/log/MakeAppsUtil_11161140.log
output located at /u01/apps/VIS/inst/apps/VIS_ebs121/admin/out/appsutil.zip
MakeAppsUtil completed successfully.
[applmgr@ebs121 bin]$ cd $INST_TOP/admin/out
[applmgr@ebs121 out]$ pwd
/u01/apps/VIS/inst/apps/VIS_ebs121/admin/out
##appsutil.zip

使用oracle用户复制至

su - oracle
[oracle@ebs121 ~]$ cd /u01/apps/VIS/inst/apps/VIS_ebs121/admin/out
[oracle@ebs121 out]$ cp appsutil.zip $ORACLE_HOME/
cd $ORACLE_HOME
[oracle@ebs121 11.1.0]$ unzip -o appsutil.zip
[oracle@ebs121 11.1.0]$ cd appsutil/scripts/VIS_ebs121/
[oracle@ebs121 VIS_ebs121]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/VIS/db/tech_st/11.1.0/appsutil/log/VIS_ebs121/11161227/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/oracle/VIS/db/tech_st/11.1.0
Classpath : :/u01/oracle/VIS/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/u01/oracle/VIS/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/u01/oracle/VIS/db/tech_st/11.1.0/appsutil/java:/u01/oracle/VIS/db/tech_st/11.1.0/jlib/netcfg.jar:/u01/oracle/VIS/db/tech_st/11.1.0/jlib/ldapjclnt11.jar

Using Context file : /u01/oracle/VIS/db/tech_st/11.1.0/appsutil/VIS_ebs121.xml

Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

fig:

6 升级DB 11.2.0.4

应用补丁

关闭应用服务，开启维护模式adadmin 5 1

9062910

[applmgr@ebs121 ~]$ cd /u01/apps/patches/
[applmgr@ebs121 patches]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9062910_12.1.0_R12_GENERIC.zip
[applmgr@ebs121 patches]$ cd 9062910/
[applmgr@ebs121 9062910]$ adpatch
u9062910.drv

9868229

applmgr@ebs121 9062910]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p9868229_R12.BOM.C_R12_GENERIC.zip
[applmgr@ebs121 9062910]$ cd 9868229/
[applmgr@ebs121 9868229]$ adpatch

[applmgr@ebs121 9868229]$ /usr/bin/unzip /mnt/hgfs/resource/EBS/121patch/p10163753_R12.BIV.B_R12_GENERIC.zip
[applmgr@ebs121 9868229]$ cd 10163753/
[applmgr@ebs121 10163753]$ adpatch

关闭维护模式 adadmin 5 2

安装11gR2数据库

关闭数据库，解压补丁集

su - oracle
[oracle@ebs121 ~]$ mkdir -p /u01/oracle/patch_set
[oracle@ebs121 ~]$ mkdir -p /u01/oracle/VIS/db/tech_st/11.2.0

cd /u01/oracle/patch_set
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_1of7.zip
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_2of7.zip
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_3of7.zip
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_4of7.zip
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_5of7.zip
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_6of7.zip
/usr/bin/unzip /mnt/hgfs/resource/oracle11204/p13390677_112040_Linux-x86-64_7of7.zip

以图形化界面进入

export ORACLE_BASE=/u01/oracle/VIS
export ORACLE_HOME=/u01/oracle/VIS/db/tech_st/11.2.0
cd /u01/oracle/patch_set/database

fig:

点击fix来解决警告项

fig:

安装example数据库

[oracle@ebs121 patch_set]$ cd examples/
[oracle@ebs121 examples]$ ./runInstaller

fig:

设置环境变量

[oracle@ebs121 ~]$ vi ~/.bash_profile

export ORACLE_SID=VIS

export ORACLE_BASE=/u01/oracle/VIS
export ORACLE_HOME=/u01/oracle/VIS/db/tech_st/11.2.0
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PERL5LIB=$ORACLE_HOME/perl/lib/5.8.3:$ORACLE_HOME/perl/lib/site_perl/5.8.3
export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
export TNS_ADMIN=/u01/oracle/VIS/db/tech_st/11.2.0/network/admin/VIS_ebs121
export PATH=$PATH:$ORACLE_HOME/OPatch

[oracle@ebs121 ~]$ source ~/.bash_profile

[oracle@ebs121 ~]$ cd $ORACLE_HOME
[oracle@ebs121 11.2.0]$ mv perl/ perl.old
[oracle@ebs121 11.2.0]$ cp -r /u01/oracle/VIS/db/tech_st/11.1.0/perl/ .
[oracle@ebs121 11.2.0]$ ll | grep perl
drwxr-xr-x 6 oracle dba 4096 Nov 17 10:04 perl
drwxr-xr-x 5 oracle dba 4096 Nov 17 09:46 perl.old

perl $ORACLE_HOME/nls/data/old/cr9idata.pl

打oracle补丁

cd /u01/oracle/patch_set/
unzip /mnt/hgfs/resource/EBS/orapatch/p4247037_112040_Generic.zip
unzip /mnt/hgfs/resource/EBS/orapatch/p17402822_112040_Linux-x86-64.zip
unzip /mnt/hgfs/resource/EBS/orapatch/p17468141_112040_Linux-x86-64.zip
unzip /mnt/hgfs/resource/EBS/orapatch/p17501296_112040_Generic.zip
unzip /mnt/hgfs/resource/EBS/orapatch/p17892268_112040_Linux-x86-64.zip
unzip /mnt/hgfs/resource/EBS/orapatch/p19393542_112040_Linux-x86-64.zip

[oracle@ebs121 patch_set]$ cd 4247037/
[oracle@ebs121 4247037]$ opatch apply
#打剩余的补丁
17402822
17468141
17501296
17892268
19393542
##检查
opatch lsinventory
Interim patches (6) :

升级数据库

启动旧数据库

但不启动监听

[oracle@ebs121 ~]$ . /u01/oracle/VIS/db/tech_st/11.1.0/VIS_ebs121.env
[oracle@ebs121 ~]$ sh $ORACLE_HOME/appsutil/scripts/VIS_ebs121/addbctl.sh start

删除索引

[oracle@ebs121 ~]$ sqlplus / as sysdba
SQL> drop table sys.enabled$indexes;
drop table sys.enabled$indexes
*
ERROR at line 1:
ORA-00942: table or view does not exist
##不知道为什么

Pre-Upgrade Information Tool

运行新数据的tools

[oracle@ebs121 ~]$ . /u01/oracle/VIS/db/tech_st/11.1.0/VIS_ebs121.env
[oracle@ebs121 ~]$ sqlplus / as sysdba
SQL> SPOOL upgrade_info.log
SQL> @/u01/oracle/VIS/db/tech_st/11.2.0/rdbms/admin/utlu112i.sql

开启自动扩展

SELECT 'ALTER DATABASE DATAFILE ''' || dd.file_name || ''' AUTOEXTEND ON NEXT
50M MAXSIZE 4G;'
FROM dba_data_files dd;

select 'ALTER DATABASE TEMPFILE ''' || dd.file_name || ''' AUTOEXTEND ON NEXT
50M MAXSIZE 4G;' from dba_temp_files dd;

注释
#plsql_native_library_dir = /u01/oracle/VIS/db/tech_st/11.1.0/plsql/nativelib

#plsql_native_library_subdir_count = 149
修改为
job_queue_processes = 16

清空回收站、字典收集统计信息

SQL> PURGE DBA_RECYCLEBIN;

DBA Recyclebin purged.

SQL> EXECUTE dbms_stats.gather_dictionary_stats;

PL/SQL procedure successfully completed.xxxxxxxxxx Which three statements are true about UNDO and REDOSQL> PURGE DBA_RECYCLEBIN;DBA Recyclebin purged.SQL> EXECUTE dbms_stats.gather_dictionary_stats;PL/SQL procedure successfully completed.

重新检查

编辑文件

[oracle@ebs121 admin]$ echo VIS:/u01/oracle/VIS/db/tech_st/11.1.0:N >>/etc/oratab

启动DBUA

开启新窗口，启动新数据库的DBUA

fig:

虚拟机性能不高，选择并行数为3

fig:

升级结束

fig:

创建新数据库参数

创建新的监听文件

cd /u01/oracle/VIS/db/tech_st/11.1.0/network/admin
[oracle@ebs121 admin]$ cp -r VIS_ebs121/ /u01/oracle/VIS/db/tech_st/11.2.0/network/admin/

把11.1的修改未11.2.0

[oracle@ebs121 VIS_ebs121]$ sed -i 's#11.1.0#11.2.0#g' sqlnet.ora
[oracle@ebs121 VIS_ebs121]$ sed -i 's#11.1.0#11.2.0#g' listener.ora
[oracle@ebs121 VIS_ebs121]$ sed -i 's#11.1.0#11.2.0#g' tnsnames.ora

创建新的参数文件

[oracle@ebs121 dbs]$ cp /u01/oracle/VIS/db/tech_st/11.1.0/dbs/VIS_ebs121_ifile.ora /u01/oracle/VIS/db/tech_st/11.2.0/dbs/

[oracle@ebs121 dbs]$ cp /u01/oracle/VIS/db/tech_st/11.1.0/dbs/initVIS.ora
/u01/oracle/VIS/db/tech_st/11.2.0/dbs/
[oracle@ebs121 dbs]$ sed -i 's#11.1.0#11.2.0#g' initVIS.ora
[oracle@ebs121 dbs]$ vi initVIS.ora

#创建diagnostic_dest目录
mkdir -p /u01/oracle/VIS/db/tech_st/11.2.0/admin/VIS_ebs121

启动新数据库

su - oracle
[oracle@ebs121 ~]$ sqlplus / as sysdba
SQL> startup pfile='/u01/oracle/VIS/db/tech_st/11.2.0/dbs/initVIS.ora'
SQL> create spfile from pfile;

File created.

补丁后操作

开启监听
lsnrctl start VIS
SQL> drop user mgdsys cascade;

User dropped.

SQL> @/u01/oracle/VIS/db/tech_st/11.2.0/md/admin/catmgdidcode.sql
@/u01/oracle/VIS/db/tech_st/11.2.0/md/support/patchset_mgdsys_validity.sql

@/u01/oracle/patch_set/17501296/postdeinstall.sql

执行adgrant

[oracle@ebs121 ~]$ cp /u01/apps/VIS/apps/apps_st/appl/admin/adgrants.sql $ORACLE_HOME/
[oracle@ebs121 ~]$ cd $ORACLE_HOME
[oracle@ebs121 11.2.0]$ sqlplus "/ as sysdba" @adgrants.sql APPS

Set CTXSYS 参数

[oracle@ebs121 11.2.0]$ cp /u01/apps/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adctxprv.sql $ORACLE_HOME
cd $ORACLE_HOME
sqlplus apps/apps
SQL> @adctxprv.sql manager CTXSYS

sqlplus / as sysdba
SQL> exec ctxsys.ctx_adm.set_parameter('file_access_role', 'public');

验证工作流规则集

[oracle@ebs121 sql]$ cp /u01/apps/VIS/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/wfaqupfix.sql $ORACLE_HOME/
[oracle@ebs121 sql]$ cd $ORACLE_HOME
[oracle@ebs121 11.2.0]$ sqlplus apps/apps
SQL> @wfaqupfix.sql APPLSYS APPS

运行 autoconfig

su - applmgr
[applmgr@ebs121 ~]$ perl $AD_TOP/bin/admkappsutil.pl
su - oracle
[oracle@ebs121 ~]$ cp /u01/apps/VIS/inst/apps/VIS_ebs121/admin/out/appsutil.zip $ORACLE_HOME
[oracle@ebs121 ~]$ cd $ORACLE_HOME
[oracle@ebs121 11.2.0]$ unzip -o appsutil.zip
##需要图形环境
[oracle@ebs121 11.2.0]$ perl $ORACLE_HOME/appsutil/bin/adbldxml.pl

##参考旧的
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile=/u01/oracle/VIS/db/tech_st/11.2.0/appsutil/VIS_ebs121.xml

收集 SYS 统计信息

[oracle@ebs121 11.2.0]$ cp /u01/apps/VIS/apps/apps_st/appl/admin/adstats.sql $ORACLE_HOME
[oracle@ebs121 11.2.0]$ cd $ORACLE_HOME
[oracle@ebs121 11.2.0]$ sqlplus / as sysdba

SQL> alter system enable restricted session;
SQL> @adstats.sql
##执行成功后
[oracle@ebs121 11.2.0]$ sqlplus / as sysdba
SQL> alter system disable restricted session;
SQL> exit

重建 apps 授权和同义词

su - applmgr
adadmin
选择
4. Maintain Applications Database Entities menu
选择
2. Re-create grants and synonyms for APPS schema

修改新的环境变量

##可以应用这个环境变量了
[oracle@ebs121 11.2.0]$ vi ~/.bash_profile
. /u01/oracle/VIS/db/tech_st/11.2.0/VIS_ebs121.env

修改启停脚本

[oracle@ebs121 ~]$ vim startDB.sh
sh $ORACLE_HOME/appsutil/scripts/VIS_ebs121/addbctl.sh start
sh $ORACLE_HOME/appsutil/scripts/VIS_ebs121/addlnctl.sh start VIS
[oracle@ebs121 ~]$ vim shutdownDB.sh
sh /u01/oracle/VIS/db/tech_st/11.2.0/appsutil/scripts/VIS_ebs121/addlnctl.sh stop VIS
sh /u01/oracle/VIS/db/tech_st/11.2.0/appsutil/scripts/VIS_ebs121/addbctl.sh stop immediate

重启应用与数据库

验证升级

fig:

同步工作流视图

fig:

posted on 2023-02-23 20:12 兔哥DB 阅读(257) 评论(0) 编辑收藏举报

刷新页面返回顶部

虚拟机安装EBSR12

1 环境准备 注意是OL6版本

host

dNS

限制文件

修改安全

防火墙

内核参数

创建用户

软件包

检查端口

org)

2 开始安装

补丁修复

解压文件

升级unzip

打安装补丁

3 安装后

环境变量

启停脚本

打补丁

4 中文补丁

维护模式

解压

打补丁

授权中文

转换多语言表

打中文补丁

开启维护模式

解压文件

打补丁

可以监控状态

中途遇到情况

监控情况

执行修复

重启worker

重新监控

完成

关闭维护模式

5 升级12.1.3

打补丁 9239089

升级补丁前

升级补丁

中文补丁

后续补丁，注意顺序

autoconfig

6 升级DB 11.2.0.4

应用补丁

9062910

9868229

安装11gR2数据库

关闭数据库，解压补丁集

以图形化界面进入

安装example数据库

设置环境变量

打oracle补丁

升级数据库

启动旧数据库

删除索引

Pre-Upgrade Information Tool

开启自动扩展

清空回收站、字典收集统计信息

重新检查

启动DBUA

创建新数据库参数

创建新的监听文件

创建新的参数文件

启动新数据库

补丁后操作

执行adgrant

Set CTXSYS 参数

验证工作流规则集

运行 autoconfig

收集 SYS 统计信息

重建 apps 授权和同义词

修改新的环境变量

修改启停脚本

重启应用与数据库

同步工作流视图

导航

1 环境准备注意是OL6版本