Oracle E-Business Suite 12.2.10 Installation Guidelines
大约 44 分钟
Oracle E-Business Suite 12.2.10 Installation Guidelines
本文介绍如何在 Linux 7.9 上安装 Oracle E-Business Suite 12.2.10。
操作系统
根据官方文档和最佳实践，建议将 Oracle E-Business Suite 12.2.10 安装在 Linux 7.9 操作系统上。
操作系统环境如下：
| OS | Host Name | IP | CPU | Memory | Swap | Disk |
|---|---|---|---|---|---|---|
| RHEL 7.9 | ebst2.stonecoding.net | 192.168.92.152 | 4 | 16 GB | 8 GB | 500 |
本文是将应用和数据库安装在同一主机上。
安装系统
根据配置，参考文档 Linux Administration 创建虚拟机并安装 RHEL 7.9 操作系统。
配置系统
防火墙
关闭防火墙：
[root@ebst2 ~]# systemctl stop firewalld
[root@ebst2 ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
SELinux
关闭 SELinux：
[root@ebst2 ~]# getenforce
Enforcing
[root@ebst2 ~]# sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config
[root@ebst2 ~]# init 6
[root@ebst2 ~]# getenforce
Disabled
依赖包
配置本地 YUM，然后安装以下依赖包：
[root@ebst2 ~]# yum install -y binutils compat-libcap1 gcc gcc-c++ glibc.i686 glibc glibc-common glibc-devel.i686 glibc-devel libaio.i686 libaio libaio-devel libgcc.i686 libgcc libgomp libstdc++-devel.i686 libstdc++-devel libstdc++.i686 libstdc++ libXi libXp.i686 libXp libXtst libXtst.i686 make gdbm.i686 gdbm redhat-lsb sysstat util-linux elfutils-libelf-devel libaio-devel unixODBC unixODBC.i686 unixODBC-devel.i686 unixODBC-devel xorg-x11-utils libXrender ksh perl-File-CheckTree motif motif-devel vim net-tools cifs-utils unzip
在官方网站下载额外依赖包到 Windows 目录，启用目录共享：
再在 Windows 宿主机上启用 SMB 1.0/CIFS 文件共享支持并重启：
安装：
[root@ebst2 ~]# mkdir /mnt/hgfs
[root@ebst2 ~]# mount -t cifs //192.168.92.1/software /mnt/hgfs -o user=xxxx,password=xxxx,vers=2.0
[root@ebst2 ~]# echo "mount -t cifs //192.168.92.1/software /mnt/hgfs -o user=xxxx,password=xxxx,vers=2.0" >> /etc/rc.local
[root@ebst2 ~]# chmod +x /etc/rc.d/rc.local
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/rhel7dependency/
[root@ebst2 rhel7dependency]# yum localinstall -y --nogpgcheck compat-libstdc++-33-3.2.3-72.el7.i686.rpm compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm compat-libstdc++-296-2.96-144.0.2.el7.i686.rpm xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm openmotif21-2.1.30-11.el7.i686.rpm sharutils-4.13.3-8.el7.x86_64.rpm
[root@ebst2 rhel7dependency]# which ar gcc g++ ksh ld linux32 make startx
/usr/bin/ar
/usr/bin/gcc
/usr/bin/g++
/usr/bin/ksh
/usr/bin/ld
/usr/bin/linux32
/usr/bin/make
/usr/bin/startx
内核参数
修改以下内核参数：
[root@ebst2 ~]# vim /etc/sysctl.conf
kernel.sem = 250 32000 100 142
kernel.shmall = 4294967296
kernel.shmmax = 68719476736
kernel.shmmni = 4096
kernel.msgmax = 8192
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 10000 65000
net.ipv4.tcp_tw_recycle = 0
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
[root@ebst2 ~]# sysctl -p
kernel.sem = 250 32000 100 142
kernel.shmall = 4294967296
kernel.shmmax = 68719476736
kernel.shmmni = 4096
kernel.msgmax = 8192
kernel.msgmnb = 65535
kernel.msgmni = 2878
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 10000 65000
net.ipv4.tcp_tw_recycle = 0
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
资源限制
修改资源限制：
[root@ebst2 ~]# vim /etc/security/limits.conf
* hard nofile 65536
* soft nofile 4096
* hard nproc 16384
* soft nproc 2047
* hard stack 16384
* soft stack 10240
主机名
验证 /etc/hosts 文件的格式如下：
127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]
[root@ebst2 ~]# vim /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.92.152 ebst2.stonecoding.net ebst2
验证 /etc/hostname 文件的格式如下：
[node_name].[domain_name]
[root@ebst2 ~]# cat /etc/hostname
ebst2.stonecoding.net
如果文件 /etc/sysconfig/networking/profiles/default/network 存在, 则删除：
[root@ebst2 ~]# rm /etc/sysconfig/networking/profiles/default/network
rm: cannot remove ‘/etc/sysconfig/networking/profiles/default/network’: No such file or directory
测试：
[root@ebst2 ~]# ping 192.168.92.152 -c 1
PING 192.168.92.152 (192.168.92.152) 56(84) bytes of data.
64 bytes from 192.168.92.152: icmp_seq=1 ttl=64 time=0.012 ms
--- 192.168.92.152 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.012/0.012/0.012/0.000 ms
[root@ebst2 ~]# ping ebst2 -c 1
PING ebst2.stonecoding.net (192.168.92.152) 56(84) bytes of data.
64 bytes from ebst2.stonecoding.net (192.168.92.152): icmp_seq=1 ttl=64 time=0.012 ms
--- ebst2.stonecoding.net ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.012/0.012/0.012/0.000 ms
[root@ebst2 ~]# ping ebst2.stonecoding.net -c 1
PING ebst2.stonecoding.net (192.168.92.152) 56(84) bytes of data.
64 bytes from ebst2.stonecoding.net (192.168.92.152): icmp_seq=1 ttl=64 time=0.010 ms
--- ebst2.stonecoding.net ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.010/0.010/0.010/0.000 ms
DNS
调整 DNS 解析参数：
[root@ebst2 ~]# vim /etc/resolv.conf
# Generated by NetworkManager
search stonecoding.net
nameserver 192.168.92.2
options attempts:5
options timeout:15
线程模型
在 Linux 中实现了两种线程模型：LinuxThreads（从 glibc 2.4 开始不支持较旧的实现）和现代的 NPTL（本机 POSIX 线程库）。为了在 Linux 上安装和运行 E-Business Suite，NPTL 模型必须是操作系统的配置线程实现。可以使用以下命令进行检查：
[root@ebst2 ~]# getconf GNU_LIBPTHREAD_VERSION
NPTL 2.17
创建链接
[root@ebst2 ~]# cd /usr/lib64
[root@ebst2 lib64]# ln -s libXm.so.4.0.4 libXm.so.2
目录
创建用于存放数据库和应用的目录：
[root@ebst2 ~]# mkdir -p /u01/db
[root@ebst2 ~]# mkdir -p /u01/app
[root@ebst2 ~]# mkdir -p /u01/stage
用户
创建 dba 组，再创建 oracle 和 applmgr 用户，分别对应数据库和应用，然后修改前面创建目录的属组：
[root@ebst2 ~]# groupadd dba
[root@ebst2 ~]# useradd -g dba oracle
[root@ebst2 ~]# useradd -g dba applmgr
[root@ebst2 ~]# chown -R oracle:dba /u01/db
[root@ebst2 ~]# chown -R applmgr:dba /u01/app
[root@ebst2 ~]# echo "Abcd1234" | passwd --stdin oracle
Changing password for user oracle.
passwd: all authentication tokens updated successfully.
[root@ebst2 ~]# echo "Abcd1234" | passwd --stdin applmgr
Changing password for user applmgr.
passwd: all authentication tokens updated successfully.
仓库目录
[root@ebst2 ~]# echo inventory_loc=/u01/db/oraInventory > /etc/oraInst.loc
[root@ebst2 ~]# echo inst_group=dba >> /etc/oraInst.loc
[root@ebst2 ~]# su - oracle
[oracle@ebst2 ~]$ mkdir /u01/db/oraInventory
[oracle@ebst2 ~]$ logout
端口
确认 OPMN 端口号是否冲突。应用缺省的 OPMN 服务的端口号是 6000，这个可能和 Linux 服务器的 X11 图形控制台端口有冲突。
为了解决这个问题，在安装和升级前执行以下命令以检查端口号 6000 是否被占用。
[root@ebst2 ~]$ netstat -tuan | grep 6000
如果被占用，需要在 Linux 服务器上禁用图形控制台登录程序，使用 root 帐号，通过以下命令可以完成：
- 找到使用端口号 6000 的程序
lsof -i TCP:6000 - 使用
kill -9命令结束之前步骤中找到的程序 - 执行
netstat -a | grep 6000确保不会再有占用端口 6000 的程序出现 - 执行命令
systemctl set-default multi-user.target
服务
检查 /etc/services 的大小。为了避免在安装 12.2 时注册 10.1.2 Oracle Home 发生 Java stack overflow 错误，请务必备份 /etc/services。如果文件的注释行数很多（>~1300），请删除这些注释行并在安装完成后再进行恢复。
[root@ebst2 ~]$ grep ^# /etc/services | wc -l
102
由于注释的行数为 102 行，小于 1300，故此处不做修改。
重启
[root@ebst2 ~]# ldconfig -v
[root@ebst2 ~]# init 6
安装包
解压
进入安装包目录并解压：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/package/
[root@ebst2 package]# unzip \*.zip -d /u01/stage
创建临时区
[root@ebst2 package]# cd /u01/stage/startCD/Disk1/rapidwiz/
[root@ebst2 rapidwiz]# export DISPLAY=192.168.92.1:0.0
[root@ebst2 rapidwiz]# ./RapidWizVersion
Oracle E-Business Suite Rapid Install Wizard
Version 12.2.0.51
(c) Copyright 2000-2011 Oracle Corporation. All rights reserved.
[root@ebst2 rapidwiz]# cd bin
[root@ebst2 bin]# ./buildStage.sh
Build Stage Menu
------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu
Enter your choice [4]: 1
Rapid Install Platform Menu
------------------------------------------------------
1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu
Enter your choice [5]: 2
Specify the directory containing the zipped installation media:
/mnt/hgfs/ebs/12.2.10/stage/package
几次回车，进行 Stage Area 的创建和验证：
Finished unzipping shiphome.
Finished unzipping Oracle Software Delivery Cloud one-off patches.
Finished copying additional patches.
Stage area verified.
然后选择 2，将补丁拷贝到临时区：
Build Stage Menu
------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu
Enter your choice [4]: 2
Rapid Install Platform Menu
------------------------------------------------------
1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu
Enter your choice [5]: 2
Finished copying additional patches.
安装补丁 32947483
使用 startCD 12.2.0.51 创建临时区后，需要安装补丁 32947483。
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/startcd/
[root@ebst2 startcd]# unzip p32947483_R12_GENERIC.zip
[root@ebst2 startcd]# cd 32947483/
[root@ebst2 32947483]# sh patchRIStage.sh
Patch directory is /mnt/hgfs/ebs/12.2.10/stage/patch/startcd/32947483
Enter the location of the Rapid Install Stage area:/u01/stage
安装补丁后，再次运行 buildStage.sh，拷贝补丁到临时区：
[root@ebst2 32947483]# cd /u01/stage/startCD/Disk1/rapidwiz/bin/
[root@ebst2 bin]# ./buildStage.sh
Build Stage Menu
------------------------------------------------------
1. Create new stage area
2. Copy patches to existing stage area
3. List files in TechPatches directory
4. Exit menu
Enter your choice [4]: 2
Rapid Install Platform Menu
------------------------------------------------------
1. Oracle Solaris SPARC (64-bit)
2. Linux x86 (64-bit)
3. IBM AIX on Power Systems (64-bit)
4. HP-UX Itanium
5. Exit Menu
Enter your choice [5]: 2
安装 EBS
安装
启动安装向导，如果应用和数据库位于不同的服务器上，则先在数据库服务器上运行。
[root@ebst2 bin]# cd /u01/stage/startCD/Disk1/rapidwiz/
[root@ebst2 rapidwiz]# export DISPLAY=192.168.92.1:0.0
[root@ebst2 rapidwiz]# ./rapidwiz
Rapid Install Wizard is validating your file system......
CMDDIR=/u01/stage/startCD/Disk1/rapidwiz
Rapid Install Wizard will now launch the Java Interface.....
保存默认选择 “Install Oracle E-Business Suite Release 12.2.0”：
不勾选 “I wish to receive security updates via My Oracle Support”：
点击 “Yes”：
保持默认选择 “Create a new configuration”：
保持默认的端口设置：
配置数据库节点：
许可类型选择 “Suite Licensing"：
选择所有功能：
选择特定国家功能，在中国使用需要选择 “China - CN”：
国际化设置：
其中：
- ”Languages“ 选择 “American_English - US” 和 “Simplified_Chinese - ZHS”
- “Default territory” 选择 “CHINA”
- “Database character set” 选择 “AL32UTF8”
- “APPL_TOP character set” 选择 “AL32UTF8”
- “IANA character set” 选择 “UTF8”
配置应用节点：
设置密码：
查看节点信息：
系统检查：
安装前验证系统配置，满足安装要求：
组件安装回顾：
点击 “Yes”，开始安装：
安装进度：
安装日志：
Configuration file written to: /u01/app/PROD/fs1/inst/apps/PROD_ebst2/conf_PROD.txt
Configuration file written to: /u01/app/PROD/fs2/inst/apps/PROD_ebst2/conf_PROD.txt
Configuration file written to: /u01/db/PROD/12.1.0/appsutil/conf_PROD.txt
Database logfile - /u01/db/PROD/12.1.0/appsutil/log/PROD_ebst2/10211623.log
Second Appltop logfile - /u01/app/PROD/fs2/inst/apps/PROD_ebst2/logs/10211623.log
First File System logfile - /u01/app/PROD/fs1/inst/apps/PROD_ebst2/logs/10211623.log
安装后验证系统配置：
安装完成：
完成后查看空间占用情况：
[root@ebst2 ~]# du -sh /u01/*
30G /u01/app
86G /u01/db
48G /u01/stage
配置
环境变量
DB 用户，修改 .bash_profile 添加变量：
[root@ebst2 ~]# su - oracle
[oracle@ebst2 ~]$ echo '. /u01/db/PROD/12.1.0/PROD_ebst2.env ' >> .bash_profile
[oracle@ebst2 ~]$ source .bash_profile
[oracle@ebst2 ~]$ env | grep ORACLE
ORACLE_SID=PROD
ORACLE_HOME=/u01/db/PROD/12.1.0
APP 用户，修改 .bash_profile 添加变量：
[root@ebst2 ~]# su - applmgr
[applmgr@ebst2 ~]$ echo 'source /u01/app/PROD/fs1/EBSapps/appl/APPSPROD_ebst2.env' >> .bash_profile
[applmgr@ebst2 ~]$ source .bash_profile
文件权限
在多用户安装环境下，需要授予 Net Service Listeners 使用的临时文件 /var/tmp/.oracle 777 权限。
[root@ebst2 ~]# ll -d /var/tmp/.oracle/
drwxrwxrwt 2 oracle dba 74 Oct 21 18:52 /var/tmp/.oracle/
[root@ebst2 ~]# chmod 777 /var/tmp/.oracle
[root@ebst2 ~]# ll -d /var/tmp/.oracle/
drwxrwxrwx 2 oracle dba 74 Oct 21 18:52 /var/tmp/.oracle/
数据库连接
默认情况下 SQL*Net 权限验证只允许本机访问。把 tcp.validnode_checking 设为 no，或者在 tcp.invited_nodes 加入允许访问的IP或机器名。
[oracle@ebst2 ~]$ vim /u01/db/PROD/12.1.0/network/admin/PROD_ebst2/sqlnet.ora
###############################################################
#
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
#
#$Header: NetServiceHandler.java 120.28.12020000.7 2015/10/16 08:24:18 kmandal ship $
#
###############################################################
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = no
tcp.invited_nodes=(EBST2.stonecoding.net)
SQLNET.INBOUND_CONNECT_TIMEOUT =60
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
IFILE=/u01/db/PROD/12.1.0/network/admin/PROD_ebst2/sqlnet_ifile.ora
升级 EBS
下面将 EBS 升级到 12.2.10。
配置数据库
数据库补丁
安装补丁 17537119，然后检查数据库需要安装的补丁：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/
[root@ebst2 patch]# mkdir 17537119
[root@ebst2 patch]# unzip p17537119_R12_GENERIC.zip -d 17537119/
[root@ebst2 patch]# su - oracle
[oracle@ebst2 ~]$ mkdir /u01/db/PROD/12.1.0/appsutil/etcc
[oracle@ebst2 ~]$ cp -a /mnt/hgfs/ebs/12.2.10/stage/patch/17537119/db /u01/db/PROD/12.1.0/appsutil/etcc/
[oracle@ebst2 ~]$ cp -a /mnt/hgfs/ebs/12.2.10/stage/patch/17537119/checkDBpatch.sh /u01/db/PROD/12.1.0/appsutil/etcc/
[oracle@ebst2 ~]$ cd /u01/db/PROD/12.1.0/appsutil/etcc/
[oracle@ebst2 etcc]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2022 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file: /u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Using context file from currently set database environment:
/u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Starting Database EBS Technology Codelevel Checker, Version 120.94
Sat Oct 21 19:36:00 CST 2023
Log file for this session : /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_19447.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database PROD is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Creating DB-ETCC results table.
Created the table to store DB-ETCC results.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.63
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.38
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 90 days old.
Check if a newer version is available in patch 17537119.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2
Missing Bugfix: 8975044 -> Patch 8975044
Missing Bugfix: 14666816 -> Patch 32901495
Missing Bugfix: 17777718 -> Patch 32901495
Missing Bugfix: 18793246 -> Patch 18793246
Missing Bugfix: 18881811 -> Patch 25599890
Missing Bugfix: 19068380 -> Patch 19068380
Missing Bugfix: 19189525 -> Patch 33649800
Missing Bugfix: 19239846 -> Patch 33649800
Missing Bugfix: 19509982 -> Patch 33649800
Missing Bugfix: 19591608 -> Patch 19591608
Missing Bugfix: 19665139 -> Patch 33649800
Missing Bugfix: 20627866 -> Patch 33649800
Missing Bugfix: 20766180 -> Patch 20766180
Missing Bugfix: 20868862 -> Patch 32901495
Missing Bugfix: 21028698 -> Patch 33649800
Missing Bugfix: 21106027 -> Patch 33649800
Missing Bugfix: 21293453 -> Patch 33569841
Missing Bugfix: 21321429 -> Patch 21321429
Missing Bugfix: 21322448 -> Patch 21322448
Missing Bugfix: 21387964 -> Patch 33649800
Missing Bugfix: 21614112 -> Patch 33649800
Missing Bugfix: 21751519 -> Patch 32901495
Missing Bugfix: 21813400 -> Patch 33649800
Missing Bugfix: 21864513 -> Patch 21864513
Missing Bugfix: 21904072 -> Patch 21904072
Missing Bugfix: 21967332 -> Patch 21967332
Missing Bugfix: 22024071 -> Patch 33649800
Missing Bugfix: 22146267 -> Patch 33649800
Missing Bugfix: 22229581 -> Patch 32901495
Missing Bugfix: 22331786 -> Patch 33649800
Missing Bugfix: 22452653 -> Patch 32901495
Missing Bugfix: 22496904 -> Patch 22496904
Missing Bugfix: 22568797 -> Patch 33649800
Missing Bugfix: 22660003 -> Patch 33649800
Missing Bugfix: 22666802 -> Patch 33649800
Missing Bugfix: 22731026 -> Patch 25599890
Missing Bugfix: 22737974 -> Patch 32901495
Missing Bugfix: 23089357 -> Patch 23089357
Missing Bugfix: 23125826 -> Patch 23125826
Missing Bugfix: 23220453 -> Patch 33649800
Missing Bugfix: 23604553 -> Patch 32901495
Missing Bugfix: 23632545 -> Patch 33649800
Missing Bugfix: 23645516 -> Patch 33649800
Missing Bugfix: 24326444 -> Patch 33649800
Missing Bugfix: 24385983 -> Patch 33649800
Missing Bugfix: 24560906 -> Patch 24560906
Missing Bugfix: 24589081 -> Patch 33649800
Missing Bugfix: 25099339 -> Patch 33649800
Missing Bugfix: 25139545 -> Patch 32901495
Missing Bugfix: 25305405 -> Patch 25305405
Missing Bugfix: 25643931 -> Patch 25643931
Missing Bugfix: 25906117 -> Patch 25906117
Missing Bugfix: 25971286 -> Patch 33649800
Missing Bugfix: 26336977 -> Patch 33649800
Missing Bugfix: 26436717 -> Patch 33649800
Missing Bugfix: 26654363 -> Patch 33649800
Missing Bugfix: 26658759 -> Patch 33649800
Missing Bugfix: 26742604 -> Patch 32901495
Missing Bugfix: 26798411 -> Patch 33649800
Missing Bugfix: 27929509 -> Patch 33649800
Missing Bugfix: 27997875 -> Patch 33649800
Missing Bugfix: 28201045 -> Patch 33649800
Missing Bugfix: 28507324 -> Patch 28653113
Missing Bugfix: 28542455 -> Patch 29842421
Missing Bugfix: 29125374 -> Patch 33649800
Missing Bugfix: 30758943 -> Patch 30758943
Missing Bugfix: 31404014 -> Patch 31404014
Missing Bugfix: 32355765 -> Patch 33649800
Missing Bugfix: 32652143 -> Patch 33649800
Missing Bugfix: 32988028 -> Patch 33649800
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2 (No PSU or Bundle applied)
-------------------------------------------------------------------------------
Patch 8975044
- Filename: p8975044_121020_Linux-x86-64.zip
Patch 32901495
- Filename: p32901495_121020_Linux-x86-64.zip
Patch 18793246
- Filename: p18793246_121020_Generic.zip
Patch 25599890
- Filename: p25599890_121020_Generic.zip
Patch 19068380
- Filename: p19068380_121020_Linux-x86-64.zip
Patch 33649800
- Filename: p33649800_121020_Linux-x86-64.zip
Patch 19591608
- Filename: p19591608_121020_Linux-x86-64.zip
Patch 20766180
- Filename: p20766180_121020_Generic.zip
Patch 33569841
- Filename: p33569841_121020_Linux-x86-64.zip
Patch 21321429
- Filename: p21321429_121020_Generic.zip
Patch 21322448
- Filename: p21322448_121020_Linux-x86-64.zip
Patch 21864513
- Filename: p21864513_121020_Linux-x86-64.zip
Patch 21904072
- Filename: p21904072_121020_Linux-x86-64.zip
Patch 21967332
- Filename: p21967332_121020_Linux-x86-64.zip
Patch 22496904
- Filename: p22496904_121020_Linux-x86-64.zip
Patch 23089357
- Filename: p23089357_121020_Linux-x86-64.zip
Patch 23125826
- Filename: p23125826_121020_Linux-x86-64.zip
Patch 24560906
- Filename: p24560906_121020_Linux-x86-64.zip
Patch 25305405
- Filename: p25305405_121020_Linux-x86-64.zip
Patch 25643931
- Filename: p25643931_121020_Linux-x86-64.zip
Patch 25906117
- Filename: p25906117_121020_Linux-x86-64.zip
Patch 28653113
- Filename: p28653113_121020_Generic.zip
Patch 29842421
- Filename: p29842421_121020_Linux-x86-64.zip
Patch 30758943
- Filename: p30758943_121020_Linux-x86-64.zip
Patch 31404014
- Filename: p31404014_121020_Linux-x86-64.zip
Apply the required patches and rerun this script
You should check the patch READMEs for minimum opatch version requirements.
The latest opatch is available from My Oracle Support via Patch 6880880.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required patches for Database release
12.1.0.2.0 is available on My Oracle Support via:
Patch 33570871
- EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JAN 2022
Note: This zip does not include Release Updates, Bundle Patches or Patch Set Updates.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions for these patches.
Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.
Stored Technology Codelevel Checker results in the database PROD successfully.
Finished checking fixes for Oracle Database: Sat Oct 21 19:36:08 CST 2023
Log file for this session: /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_19447.log
===============================================================================
根据输出结果，下载补丁 33570871 并解压：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/
[root@ebst2 patch]# mkdir 33570871
[root@ebst2 patch]# unzip p33570871_121020_Linux-x86-64.zip -d 33570871/
检查是否有冲突：
[root@ebst2 patch]# su - oracle
[oracle@ebst2 ~]$ cd /mnt/hgfs/ebs/12.2.10/stage/patch/33570871/
[oracle@ebst2 33570871]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAmongPatchesWithDetail -phBaseDir etcc-bundle/LINUX_X86-64/database/12.1.0.2/
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/db/PROD/12.1.0
Central Inventory : /u01/db/oraInventory
from : /u01/db/PROD/12.1.0/oraInst.loc
OPatch version : 12.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/db/PROD/12.1.0/cfgtoollogs/opatch/opatch2023-10-21_20-05-39PM_1.log
Invoking prereq "checkconflictamongpatcheswithdetail"
Prereq "checkConflictAmongPatchesWithDetail" passed.
OPatch succeeded.
[oracle@ebst2 33570871]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir etcc-bundle/LINUX_X86-64/database/12.1.0.2/
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/db/PROD/12.1.0
Central Inventory : /u01/db/oraInventory
from : /u01/db/PROD/12.1.0/oraInst.loc
OPatch version : 12.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/db/PROD/12.1.0/cfgtoollogs/opatch/opatch2023-10-21_20-06-13PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
ZOP-47: The patch(es) has supersets with other patches installed in the Oracle Home (or) among themselves.
ZOP-40: The patch(es) has conflicts with other patches installed in the Oracle Home (or) among themselves.
Prereq "checkConflictAgainstOHWithDetail" failed.
Summary of Conflict Analysis:
Patches that can be applied now without any conflicts are :
8975044, 18793246, 19068380, 19591608, 20766180, 21321429, 21322448, 21864513, 21904072, 22496904, 23089357, 24560906, 25599890, 25643931, 25906117, 28653113, 30758943, 31404014, 32901495, 33569841, 33649800
Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :
18893947, 19779059, 20830911, 21188532, 21967332, 23125826, 25305405, 29842421
Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
18607546, 19291380, 19393542, 19472320, 19627012, 19649152, 20093776, 20181016, 20294666, 20798891, 20887355, 21626377, 22223463
Following patches will be rolled back from Oracle Home on application of the patches in the given list :
21443504, 21153266, 20476776, 18966843, 19835133, 18485835, 20204035, 19896336, 18689530
Conflicts/Supersets for each patch are:
Patch : 18607546
Bug SubSet of 20830911
Subset bugs are:
18607546
Patch : 19291380
Identical duplicate of 19291380
Patch : 19393542
Identical duplicate of 19393542
Patch : 19472320
Identical duplicate of 19472320
Patch : 19627012
Identical duplicate of 19627012
Patch : 19649152
Identical duplicate of 19649152
Patch : 20093776
Identical duplicate of 20093776
Patch : 20181016
Identical duplicate of 20181016
Patch : 20294666
Identical duplicate of 20294666
Patch : 20798891
Identical duplicate of 20798891
Patch : 20887355
Identical duplicate of 20887355
Patch : 21626377
Identical duplicate of 21626377
Patch : 21967332
Conflict with 18893947
Conflict details:
/u01/db/PROD/12.1.0/lib/libgeneric12.a:qcdo.o
Patch : 22223463
Identical duplicate of 22223463
Patch : 23125826
Conflict with 20830911
Conflict details:
/u01/db/PROD/12.1.0/lib/libserver12.a:ktsp.o
Patch : 25305405
Conflict with 21188532
Conflict details:
/u01/db/PROD/12.1.0/lib/libserver12.a:kkqvm.o
Patch : 28653113
Bug Superset of 18966843
Super set bugs are:
18966843
Bug Superset of 20204035
Super set bugs are:
15894842, 20123899
Patch : 29842421
Bug Conflict with 19779059
Conflicting bugs are:
19382851
Patch : 32901495
Bug Superset of 20476776
Super set bugs are:
20476776
Patch : 33569841
Bug Superset of 21153266
Super set bugs are:
21153266
Patch : 33649800
Bug Superset of 21443504
Super set bugs are:
20245930, 19487147, 20588502, 18674024, 20825533, 20413820, 20936905, 18964939, 19536415, 21091431
Bug Superset of 19835133
Super set bugs are:
19835133
Bug Superset of 18485835
Super set bugs are:
18485835
Bug Superset of 19896336
Super set bugs are:
19896336
Bug Superset of 18689530
Super set bugs are:
18689530
OPatch succeeded.
没有冲突的补丁有 8975044, 18793246, 19068380, 19591608, 20766180, 21321429, 21322448, 21864513, 21904072, 22496904, 23089357, 24560906, 25599890, 25643931, 25906117, 28653113, 30758943, 31404014, 32901495, 33569841, 33649800，安装这些补丁：
[root@ebst2 ~]# su - applmgr
[applmgr@ebst2 ~]$ $ADMIN_SCRIPTS_HOME/adstpall.sh apps/Abcd1234
[applmgr@ebst2 ~]$ logout
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/33570871/etcc-bundle/LINUX_X86-64/database/12.1.0.2/
[root@ebst2 12.1.0.2]# unzip \*.zip
[root@ebst2 ~]# su - oracle
[oracle@ebst2 ~]$ cd $ORACLE_HOME/appsutil/scripts/PROD_ebst2
[oracle@ebst2 PROD_ebst2]$ ./addlnctl.sh stop PROD
[oracle@ebst2 PROD_ebst2]$ ./addbctl.sh stop immediate
[oracle@ebst2 PROD_ebst2]$ $ORACLE_HOME/OPatch/opatch napply /mnt/hgfs/ebs/12.2.10/stage/patch/33570871/etcc-bundle/LINUX_X86-64/database/12.1.0.2/ -id 8975044,18793246,19068380,19591608,20766180,21321429,21322448,21864513,21904072,22496904,23089357,24560906,25599890,25643931,25906117,28653113,30758943,31404014,32901495,33569841,33649800 -skip_subset -skip_duplicate
Oracle Interim Patch Installer version 12.1.0.1.10
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /u01/db/PROD/12.1.0
Central Inventory : /u01/db/oraInventory
from : /u01/db/PROD/12.1.0/oraInst.loc
OPatch version : 12.1.0.1.10
OUI version : 12.1.0.2.0
Log file location : /u01/db/PROD/12.1.0/cfgtoollogs/opatch/opatch2023-10-21_20-34-31PM_1.log
Verifying environment and performing prerequisite checks...
Conflicts/Supersets for each patch are:
Patch : 28653113
Bug Superset of 18966843
Super set bugs are:
18966843
Bug Superset of 20204035
Super set bugs are:
15894842, 20123899
Patch : 32901495
Bug Superset of 20476776
Super set bugs are:
20476776
Patch : 33569841
Bug Superset of 21153266
Super set bugs are:
21153266
Patch : 33649800
Bug Superset of 21443504
Super set bugs are:
20245930, 19487147, 20588502, 18674024, 20825533, 20413820, 20936905, 18964939, 19536415, 21091431
Bug Superset of 19835133
Super set bugs are:
19835133
Bug Superset of 18485835
Super set bugs are:
18485835
Bug Superset of 19896336
Super set bugs are:
19896336
Bug Superset of 18689530
Super set bugs are:
18689530
Patches [ 21443504 21153266 20476776 18966843 19835133 18485835 20204035 19896336 18689530 ] will be rolled back.
OPatch continues with these patches: 8975044 18793246 19068380 19591608 20766180 21321429 21322448 21864513 21904072 22496904 23089357 24560906 25599890 25643931 25906117 28653113 30758943 31404014 32901495 33569841 33649800
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/db/PROD/12.1.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '8975044' to OH '/u01/db/PROD/12.1.0'
Rolling back interim patch '21443504' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '21443504' from inventory
Rolling back interim patch '21153266' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '21153266' from inventory
Rolling back interim patch '20476776' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '20476776' from inventory
Rolling back interim patch '18966843' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '18966843' from inventory
Rolling back interim patch '19835133' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '19835133' from inventory
Rolling back interim patch '18485835' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '18485835' from inventory
Rolling back interim patch '20204035' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
RollbackSession removing interim patch '20204035' from inventory
Rolling back interim patch '19896336' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '19896336' from inventory
Rolling back interim patch '18689530' from OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '18689530' from inventory
OPatch back to application of the patch '8975044' after auto-rollback.
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '18793246' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying interim patch '19068380' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '19591608' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '20766180' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '21321429' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying interim patch '21322448' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '21864513' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '21904072' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '22496904' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '23089357' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '24560906' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '25599890' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying interim patch '25643931' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '25906117' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '28653113' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying interim patch '30758943' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '31404014' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '32901495' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms.install.seeddb, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Applying interim patch '33569841' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Applying interim patch '33649800' to OH '/u01/db/PROD/12.1.0'
Patching component oracle.rdbms, 12.1.0.2.0...
Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching component oracle.rdbms.rman, 12.1.0.2.0...
Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Patching component oracle.rdbms.util, 12.1.0.2.0...
Patches 8975044,18793246,19068380,19591608,20766180,21321429,21322448,21864513,21904072,22496904,23089357,24560906,25599890,25643931,25906117,28653113,30758943,31404014,32901495,33569841,33649800 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/db/PROD/12.1.0/cfgtoollogs/opatch/opatch2023-10-21_20-34-31PM_1.log
OPatch completed with warnings.
启动数据库，再次使用 ETCC 进行检查：
[oracle@ebst2 PROD_ebst2]$ ./addbctl.sh start
[oracle@ebst2 PROD_ebst2]$ cd /u01/db/PROD/12.1.0/appsutil/etcc/
[oracle@ebst2 etcc]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2022 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file: /u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Using context file from currently set database environment:
/u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Starting Database EBS Technology Codelevel Checker, Version 120.94
Sat Oct 21 20:42:36 CST 2023
Log file for this session : /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_5211.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database PROD is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.63
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.38
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 90 days old.
Check if a newer version is available in patch 17537119.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2
Missing Bugfix: 21967332 -> Patch 21967332
Missing Bugfix: 23125826 -> Patch 23125826
Missing Bugfix: 25305405 -> Patch 25305405
Missing Bugfix: 28542455 -> Patch 29842421
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2 (No PSU or Bundle applied)
-------------------------------------------------------------------------------
Patch 21967332
- Filename: p21967332_121020_Linux-x86-64.zip
Patch 23125826
- Filename: p23125826_121020_Linux-x86-64.zip
Patch 25305405
- Filename: p25305405_121020_Linux-x86-64.zip
Patch 29842421
- Filename: p29842421_121020_Linux-x86-64.zip
Apply the required patches and rerun this script
You should check the patch READMEs for minimum opatch version requirements.
The latest opatch is available from My Oracle Support via Patch 6880880.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required patches for Database release
12.1.0.2.0 is available on My Oracle Support via:
Patch 33570871
- EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JAN 2022
Note: This zip does not include Release Updates, Bundle Patches or Patch Set Updates.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions for these patches.
Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.
Stored Technology Codelevel Checker results in the database PROD successfully.
Finished checking fixes for Oracle Database: Sat Oct 21 20:42:44 CST 2023
Log file for this session: /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_5211.log
===============================================================================
根据输出结果，下载补丁 21967332，23125826，25305405，29842421 并解压：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/dbpatch/
[root@ebst2 dbpatch]# unzip \*.zip
关闭数据库安装补丁：
[root@ebst2 ~]# su - oracle
[oracle@ebst2 ~]$ cd $ORACLE_HOME/appsutil/scripts/PROD_ebst2
[oracle@ebst2 PROD_ebst2]$ ./addbctl.sh stop immediate
[oracle@ebst2 PROD_ebst2]$ cd /mnt/hgfs/ebs/12.2.10/stage/patch/dbpatch/
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch rollback -id 18893947
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch apply 21967332
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch rollback -id 20830911
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch apply 23125826
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch rollback -id 21188532
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch apply 25305405
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch rollback -id 19779059
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch apply 29842421
启动数据库，再次使用 ETCC 进行检查：
[oracle@ebst2 dbpatch]$ cd $ORACLE_HOME/appsutil/scripts/PROD_ebst2
[oracle@ebst2 PROD_ebst2]$ ./addbctl.sh start
[oracle@ebst2 PROD_ebst2]$ cd /u01/db/PROD/12.1.0/appsutil/etcc/
[oracle@ebst2 etcc]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2022 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file: /u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Using context file from currently set database environment:
/u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Starting Database EBS Technology Codelevel Checker, Version 120.94
Sat Oct 21 21:08:13 CST 2023
Log file for this session : /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_12020.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database PROD is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.63
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.38
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 90 days old.
Check if a newer version is available in patch 17537119.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2
Missing Bugfix: 18607546 -> Patch 18607546
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Database Release 12.1.0.2 (No PSU or Bundle applied)
-------------------------------------------------------------------------------
Patch 18607546
- Filename: p18607546_121020_Linux-x86-64.zip
Apply the required patches and rerun this script
You should check the patch READMEs for minimum opatch version requirements.
The latest opatch is available from My Oracle Support via Patch 6880880.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required patches for Database release
12.1.0.2.0 is available on My Oracle Support via:
Patch 33570871
- EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JAN 2022
Note: This zip does not include Release Updates, Bundle Patches or Patch Set Updates.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions for these patches.
Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.
Stored Technology Codelevel Checker results in the database PROD successfully.
Finished checking fixes for Oracle Database: Sat Oct 21 21:08:18 CST 2023
Log file for this session: /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_12020.log
===============================================================================
根据输出结果，下载补丁 18607546 并解压：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/dbpatch/
[root@ebst2 dbpatch]# unzip p18607546_121020_Linux-x86-64.zip
关闭数据库安装补丁：
[root@ebst2 ~]# su - oracle
[oracle@ebst2 ~]$ cd $ORACLE_HOME/appsutil/scripts/PROD_ebst2
[oracle@ebst2 PROD_ebst2]$ ./addbctl.sh stop immediate
[oracle@ebst2 PROD_ebst2]$ cd /mnt/hgfs/ebs/12.2.10/stage/patch/dbpatch/
[oracle@ebst2 dbpatch]$ $ORACLE_HOME/OPatch/opatch apply 18607546
启动数据库，再次使用 ETCC 进行检查：
[oracle@ebst2 dbpatch]$ cd $ORACLE_HOME/appsutil/scripts/PROD_ebst2
[oracle@ebst2 PROD_ebst2]$ ./addlnctl.sh start PROD
[oracle@ebst2 PROD_ebst2]$ ./addbctl.sh start
[oracle@ebst2 PROD_ebst2]$ cd /u01/db/PROD/12.1.0/appsutil/etcc/
[oracle@ebst2 etcc]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2022 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file: /u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Using context file from currently set database environment:
/u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Starting Database EBS Technology Codelevel Checker, Version 120.94
Sat Oct 21 21:16:22 CST 2023
Log file for this session : /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_14326.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database PROD is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema : APPS
- APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.63
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.38
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 90 days old.
Check if a newer version is available in patch 17537119.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.1.0.1.10.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2
All the required one-off bugfixes are present in Database ORACLE_HOME.
+-----------------------------------------------------------------------------+
Stored Technology Codelevel Checker results in the database PROD successfully.
Finished checking fixes for Oracle Database: Sat Oct 21 21:16:28 CST 2023
Log file for this session: /u01/db/PROD/12.1.0/appsutil/etcc/log/checkDBpatch_14326.log
===============================================================================
所有数据库补丁都打好了。
数据库参数
确认数据库参数 optimizer_adaptive_features 为 false：
SQL> show parameter optimizer_adaptive_features
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_adaptive_features boolean FALSE
设置数据库参数 _disable_actualization_for_grant 为 true：
SQL> alter system set "_disable_actualization_for_grant"=true;
System altered.
调整数据文件
数据文件默认是关闭自动扩展的。
SQL> select tablespace_name,file_name,bytes/1024/1024/1024 Gb,maxbytes/1024/1024/1024 MGb,autoextensible from dba_data_files order by 1;
TABLESPACE_NAME FILE_NAME GB MGB AUT
------------------------------ ------------------------------------------------------------ ---------- ---------- ---
APPS_TS_ARCHIVE /u01/db/PROD/data/a_archive01.dbf .845703125 0 NO
APPS_TS_INTERFACE /u01/db/PROD/data/a_int01.dbf 1.00195313 0 NO
APPS_TS_INTERFACE /u01/db/PROD/data/a_int02.dbf .014648438 0 NO
APPS_TS_MEDIA /u01/db/PROD/data/a_media01.dbf 1.66235352 0 NO
APPS_TS_NOLOGGING /u01/db/PROD/data/a_nolog01.dbf .0625 0 NO
APPS_TS_QUEUES /u01/db/PROD/data/a_queue01.dbf .48828125 0 NO
APPS_TS_QUEUES /u01/db/PROD/data/a_queue02.dbf .48828125 0 NO
APPS_TS_SEED /u01/db/PROD/data/a_ref06.dbf 1.953125 0 NO
APPS_TS_SEED /u01/db/PROD/data/a_ref05.dbf 1.953125 0 NO
APPS_TS_SEED /u01/db/PROD/data/a_ref04.dbf 1.953125 0 NO
APPS_TS_SEED /u01/db/PROD/data/a_ref02.dbf 1.14453125 0 NO
APPS_TS_SEED /u01/db/PROD/data/a_ref03.dbf .495117188 0 NO
APPS_TS_SEED /u01/db/PROD/data/a_ref01.dbf 1.46484375 0 NO
APPS_TS_SUMMARY /u01/db/PROD/data/a_summ01.dbf 1.11914063 0 NO
APPS_TS_TOOLS /u01/db/PROD/data/apps_ts_tools01.dbf .48828125 0 NO
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data03.dbf 1.43066406 0 NO
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data01.dbf 1.7578125 0 NO
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data04.dbf 1.703125 0 NO
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data02.dbf 1.61877441 0 NO
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind01.dbf 1.08789063 0 NO
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind02.dbf 1.47741699 0 NO
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind03.dbf 1.68945313 0 NO
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind06.dbf 1.07800293 0 NO
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind05.dbf 1.80847168 0 NO
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind04.dbf 1.7578125 0 NO
APPS_UNDOTS1 /u01/db/PROD/data/undo02.dbf .9765625 0 NO
APPS_UNDOTS1 /u01/db/PROD/data/undo01.dbf 1.953125 0 NO
CTXD /u01/db/PROD/data/ctxd01.dbf .020507813 0 NO
ODM /u01/db/PROD/data/odm.dbf .01171875 0 NO
OLAP /u01/db/PROD/data/olap.dbf .016601563 0 NO
OWAPUB /u01/db/PROD/data/owad01.dbf .009765625 0 NO
PORTAL /u01/db/PROD/data/portal01.dbf .09765625 0 NO
SYSAUX /u01/db/PROD/data/sysaux01.dbf .9765625 0 NO
SYSAUX /u01/db/PROD/data/sysaux02.dbf .9765625 0 NO
SYSTEM /u01/db/PROD/data/system09.dbf 1.46484375 0 NO
SYSTEM /u01/db/PROD/data/system25.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system22.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system21.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system20.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system19.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system18.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system17.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system16.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system15.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system14.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system13.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system12.dbf 1.49316406 0 NO
SYSTEM /u01/db/PROD/data/system11.dbf 1.14746094 0 NO
SYSTEM /u01/db/PROD/data/system10.dbf 1 0 NO
SYSTEM /u01/db/PROD/data/system01.dbf .9765625 0 NO
SYSTEM /u01/db/PROD/data/system02.dbf .9765625 0 NO
SYSTEM /u01/db/PROD/data/system03.dbf .9765625 0 NO
SYSTEM /u01/db/PROD/data/system04.dbf .9765625 0 NO
SYSTEM /u01/db/PROD/data/system05.dbf .9765625 0 NO
SYSTEM /u01/db/PROD/data/system06.dbf .732421875 0 NO
SYSTEM /u01/db/PROD/data/system07.dbf .732421875 0 NO
SYSTEM /u01/db/PROD/data/system08.dbf 1.7578125 0 NO
SYSTEM /u01/db/PROD/data/system24.dbf 1.953125 0 NO
SYSTEM /u01/db/PROD/data/system23.dbf 1.953125 0 NO
59 rows selected.
SQL> select tablespace_name,file_name,bytes/1024/1024/1024 Gb,maxbytes/1024/1024/1024 MGb,autoextensible from dba_temp_files order by 1;
TABLESPACE_NAME FILE_NAME GB MGB AUT
------------------------------ ------------------------------------------------------------ ---------- ---------- ---
TEMP1 /u01/db/PROD/data/temp01.dbf 1.07421875 0 NO
TEMP1 /u01/db/PROD/data/temp0001.dbf .9765625 0 NO
TEMP2 /u01/db/PROD/data/temp02.dbf 1 0 NO
扩展 UNDO 表空间数据文件：
SQL> alter database datafile '/u01/db/PROD/data/undo01.dbf' resize 5G;
Database altered.
SQL> alter database datafile '/u01/db/PROD/data/undo02.dbf' resize 5G;
Database altered.
扩展临时表空间临时文件：
SQL> alter database tempfile '/u01/db/PROD/data/temp01.dbf' resize 5G;
Database altered.
SQL> alter database tempfile '/u01/db/PROD/data/temp0001.dbf' resize 5G;
Database altered.
SQL> alter database tempfile '/u01/db/PROD/data/temp02.dbf' resize 5G;
Database altered.
生成修改其他数据文件自动扩展的脚本：
SQL> select 'ALTER DATABASE DATAFILE ''' || file_name || ''' AUTOEXTEND ON;' from dba_data_files where tablespace_name != 'APPS_UNDOTS1' and autoextensible='NO';
'ALTERDATABASEDATAFILE'''||FILE_NAME||'''AUTOEXTENDON;'
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system09.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system08.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system07.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system06.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system05.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system04.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system03.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system10.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system11.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system12.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system13.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system14.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system15.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system16.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system17.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system18.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system19.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system20.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system21.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system22.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system23.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system24.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/system25.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_media01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_queue01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_archive01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_nolog01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_summ01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_int01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/portal01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_int02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref03.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/apps_ts_tools01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/olap.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/odm.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_queue02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/owad01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind05.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind04.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind03.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data03.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind06.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data04.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/ctxd01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/sysaux02.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/sysaux01.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref04.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref05.dbf' AUTOEXTEND ON;
ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref06.dbf' AUTOEXTEND ON;
57 rows selected.
然后执行脚本：
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system09.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system08.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system07.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system06.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system05.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system04.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system03.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system10.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system11.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system12.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system13.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system14.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system15.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system16.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system17.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system18.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system19.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system20.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system21.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system22.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system23.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system24.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/system25.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_media01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_queue01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_archive01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_nolog01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_summ01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_int01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/portal01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_int02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref03.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/apps_ts_tools01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/olap.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/odm.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_queue02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/owad01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind05.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind04.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind03.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data03.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_ind06.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_txn_data04.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/ctxd01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/sysaux02.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/sysaux01.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref04.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref05.dbf' AUTOEXTEND ON;
Database altered.
SQL> ALTER DATABASE DATAFILE '/u01/db/PROD/data/a_ref06.dbf' AUTOEXTEND ON;
Database altered.
最后结果如下：
SQL> select tablespace_name,file_name,bytes/1024/1024/1024 Gb,maxbytes/1024/1024/1024 MGb,autoextensible from dba_data_files order by 1;
TABLESPACE_NAME FILE_NAME GB MGB AUT
------------------------------ ------------------------------------------------------------ ---------- ---------- ---
APPS_TS_ARCHIVE /u01/db/PROD/data/a_archive01.dbf .845703125 31.9999847 YES
APPS_TS_INTERFACE /u01/db/PROD/data/a_int01.dbf 1.00195313 31.9999847 YES
APPS_TS_INTERFACE /u01/db/PROD/data/a_int02.dbf .014648438 31.9999847 YES
APPS_TS_MEDIA /u01/db/PROD/data/a_media01.dbf 1.66235352 31.9999847 YES
APPS_TS_NOLOGGING /u01/db/PROD/data/a_nolog01.dbf .0625 31.9999847 YES
APPS_TS_QUEUES /u01/db/PROD/data/a_queue01.dbf .48828125 31.9999847 YES
APPS_TS_QUEUES /u01/db/PROD/data/a_queue02.dbf .48828125 31.9999847 YES
APPS_TS_SEED /u01/db/PROD/data/a_ref06.dbf 1.953125 31.9999847 YES
APPS_TS_SEED /u01/db/PROD/data/a_ref05.dbf 1.953125 31.9999847 YES
APPS_TS_SEED /u01/db/PROD/data/a_ref04.dbf 1.953125 31.9999847 YES
APPS_TS_SEED /u01/db/PROD/data/a_ref02.dbf 1.14453125 31.9999847 YES
APPS_TS_SEED /u01/db/PROD/data/a_ref03.dbf .495117188 31.9999847 YES
APPS_TS_SEED /u01/db/PROD/data/a_ref01.dbf 1.46484375 31.9999847 YES
APPS_TS_SUMMARY /u01/db/PROD/data/a_summ01.dbf 1.11914063 31.9999847 YES
APPS_TS_TOOLS /u01/db/PROD/data/apps_ts_tools01.dbf .48828125 31.9999847 YES
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data03.dbf 1.43066406 31.9999847 YES
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data01.dbf 1.7578125 31.9999847 YES
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data04.dbf 1.703125 31.9999847 YES
APPS_TS_TX_DATA /u01/db/PROD/data/a_txn_data02.dbf 1.61877441 31.9999847 YES
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind01.dbf 1.08789063 31.9999847 YES
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind02.dbf 1.47741699 31.9999847 YES
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind03.dbf 1.68945313 31.9999847 YES
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind06.dbf 1.07800293 31.9999847 YES
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind05.dbf 1.80847168 31.9999847 YES
APPS_TS_TX_IDX /u01/db/PROD/data/a_txn_ind04.dbf 1.7578125 31.9999847 YES
APPS_UNDOTS1 /u01/db/PROD/data/undo02.dbf 5 0 NO
APPS_UNDOTS1 /u01/db/PROD/data/undo01.dbf 5 0 NO
CTXD /u01/db/PROD/data/ctxd01.dbf .020507813 31.9999847 YES
ODM /u01/db/PROD/data/odm.dbf .01171875 31.9999847 YES
OLAP /u01/db/PROD/data/olap.dbf .016601563 31.9999847 YES
OWAPUB /u01/db/PROD/data/owad01.dbf .009765625 31.9999847 YES
PORTAL /u01/db/PROD/data/portal01.dbf .09765625 31.9999847 YES
SYSAUX /u01/db/PROD/data/sysaux01.dbf .9765625 31.9999847 YES
SYSAUX /u01/db/PROD/data/sysaux02.dbf .9765625 31.9999847 YES
SYSTEM /u01/db/PROD/data/system09.dbf 1.46484375 31.9999847 YES
SYSTEM /u01/db/PROD/data/system25.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system22.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system21.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system20.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system19.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system18.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system17.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system16.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system15.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system14.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system13.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system12.dbf 1.49316406 31.9999847 YES
SYSTEM /u01/db/PROD/data/system11.dbf 1.14746094 31.9999847 YES
SYSTEM /u01/db/PROD/data/system10.dbf 1 31.9999847 YES
SYSTEM /u01/db/PROD/data/system01.dbf .9765625 31.9999847 YES
SYSTEM /u01/db/PROD/data/system02.dbf .9765625 31.9999847 YES
SYSTEM /u01/db/PROD/data/system03.dbf .9765625 31.9999847 YES
SYSTEM /u01/db/PROD/data/system04.dbf .9765625 31.9999847 YES
SYSTEM /u01/db/PROD/data/system05.dbf .9765625 31.9999847 YES
SYSTEM /u01/db/PROD/data/system06.dbf .732421875 31.9999847 YES
SYSTEM /u01/db/PROD/data/system07.dbf .732421875 31.9999847 YES
SYSTEM /u01/db/PROD/data/system08.dbf 1.7578125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system24.dbf 1.953125 31.9999847 YES
SYSTEM /u01/db/PROD/data/system23.dbf 1.953125 31.9999847 YES
59 rows selected.
配置应用
应用补丁
检查应用需要安装的补丁：
[root@ebst2 ~]# su - applmgr
[applmgr@ebst2 ~]$ cp -a /mnt/hgfs/ebs/12.2.10/stage/patch/17537119/ .
[applmgr@ebst2 ~]$ cd 17537119/
[applmgr@ebst2 17537119]$ ./checkMTpatch.sh
+===============================================================+
| Copyright (c) 2005, 2022 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Application Tier Technology Codelevel Checker |
+===============================================================+
Using context file from currently set applications environment:
/u01/app/PROD/fs1/inst/apps/PROD_ebst2/appl/admin/PROD_ebst2.xml
Starting Application Tier Technology Codelevel Checker
Version: 120.0.12020000.53.
Sun Oct 22 13:17:30 CST 2023
Log file for this session: /home/applmgr/17537119/log/checkMTpatch_60879.log
Bugfix XML file version: 120.0.12020000.54
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.40
This file will be used for mapping bugfixes to patches.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Connecting to database.
Database connection successful.
The installed AD.C.13 codelevel supports storing the results in the database.
Checking for ETCC results table.
Table to store results already exists in database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/app/PROD/fs1/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
Missing Bugfix: 17353142 -> Patch 32922089
Missing Bugfix: 20643256 -> Patch 32922089
Missing Bugfix: 16041055 -> Patch 32922089
Missing Bugfix: 16910762 -> Patch 32922089
Missing Bugfix: 20270659 -> Patch 32922089
Missing Bugfix: 17372642 -> Patch 32922089
Missing Bugfix: 17566694 -> Patch 32922089
Missing Bugfix: 20240480 -> Patch 32922089
Missing Bugfix: 19304738 -> Patch 32922089
Missing Bugfix: 20391574 -> Patch 32922089
Missing Bugfix: 22351071 -> Patch 32922089
Missing Bugfix: 21024122 -> Patch 32922089
Missing Bugfix: 19588847 -> Patch 32922089
Missing Bugfix: 19639173 -> Patch 32922089
Missing Bugfix: 20545718 -> Patch 32922089
Missing Bugfix: 22524329 -> Patch 32922089
Missing Bugfix: 23123655 -> Patch 32922089
Missing Bugfix: 23728755 -> Patch 32922089
Missing Bugfix: 24315226 -> Patch 32922089
Missing Bugfix: 24480018 -> Patch 32922089
Missing Bugfix: 24808044 -> Patch 32922089
Missing Bugfix: 24620875 -> Patch 32922089
Missing Bugfix: 25355211 -> Patch 32922089
Missing Bugfix: 23538157 -> Patch 32922089
Missing Bugfix: 23538170 -> Patch 32922089
Missing Bugfix: 13557392 -> Patch 32922089
Missing Bugfix: 25506193 -> Patch 32922089
Missing Bugfix: 25342269 -> Patch 25342269
Missing Bugfix: 26048089 -> Patch 32922089
Missing Bugfix: 25990479 -> Patch 32922089
Missing Bugfix: 1770039 -> Patch 32922089
Missing Bugfix: 27491934 -> Patch 27491934
Missing Bugfix: 25790854 -> Patch 32922089
Missing Bugfix: 32878968 -> Patch 32922089
The above list shows missing bugfixes for Oracle Forms and Reports.
These results have been stored in the database.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.
These results have been stored in the database.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/app/PROD/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
Missing Bugfix: 21300463 -> Patch 22288381
Missing Bugfix: 21892015 -> Patch 22288381
Missing Bugfix: 24567879 -> Patch 33311587
Missing Bugfix: 20900385 -> Patch 33311587
Missing Bugfix: 25205368 -> Patch 32287205
Missing Bugfix: 26837992 -> Patch 33311587
Missing Bugfix: 21305938 -> Patch 33311587
Missing Bugfix: 20913582 -> Patch 33311587
Missing Bugfix: 22218211 -> Patch 33311587
Missing Bugfix: 23107407 -> Patch 33311587
Missing Bugfix: 19571821 -> Patch 33311587
Missing Bugfix: 26929226 -> Patch 33311587
Missing Bugfix: 25191174 -> Patch 33311587
Missing Bugfix: 26101975 -> Patch 33311587
Missing Bugfix: 21520649 -> Patch 33311587
Missing Bugfix: 23266217 -> Patch 32287205
Missing Bugfix: 23115139 -> Patch 32287205
Missing Bugfix: 26318200 -> Patch 32287205
Missing Bugfix: 23140259 -> Patch 32287205
Missing Bugfix: 25914276 -> Patch 32287205
Missing Bugfix: 20856766 -> Patch 32287205
Missing Bugfix: 26434300 -> Patch 32287205
Missing Bugfix: 25879984 -> Patch 32287205
Missing Bugfix: 19891090 -> Patch 32287205
Missing Bugfix: 18604692 -> Patch 32287205
Missing Bugfix: 29389063 -> Patch 32287205
Missing Bugfix: 20273319 -> Patch 32287205
Missing Bugfix: 25775213 -> Patch 32287205
Missing Bugfix: 26245237 -> Patch 32287205
Missing Bugfix: 18166013 -> Patch 32287205
Missing Bugfix: 19718981 -> Patch 32287205
Missing Bugfix: 21656630 -> Patch 32287205
Missing Bugfix: 19697993 -> Patch 32287205
Missing Bugfix: 23055182 -> Patch 32287205
Missing Bugfix: 25760218 -> Patch 32287205
Missing Bugfix: 20725343 -> Patch 32287205
Missing Bugfix: 16354467 -> Patch 32287205
Missing Bugfix: 22750215 -> Patch 32287205
Missing Bugfix: 25635149 -> Patch 32287205
Missing Bugfix: 25555252 -> Patch 32287205
Missing Bugfix: 17983206 -> Patch 32287205
Missing Bugfix: 21063322 -> Patch 32287205
Missing Bugfix: 26243698 -> Patch 32287205
Missing Bugfix: 23716938 -> Patch 23716938
Missing Bugfix: 23716938 -> Patch 23716938
Missing Bugfix: 24681614 -> Patch 33311587
Missing Bugfix: 30146419 -> Patch 33311587
Missing Bugfix: 20580842 -> Patch 33311587
Missing Bugfix: 27577851 -> Patch 33311587
Missing Bugfix: 25288078 -> Patch 32287205
Missing Bugfix: 30887923 -> Patch 33311587
Missing Bugfix: 26752325 -> Patch 33311587
Missing Bugfix: 30876572 -> Patch 33311587
Missing Bugfix: 31285797 -> Patch 32287205
Missing Bugfix: 31909295 -> Patch 32287205
Missing Bugfix: 31748000 -> Patch 32287205
Missing Bugfix: 31696577 -> Patch 32287205
Missing Bugfix: 27072923 -> Patch 32287205
Missing Bugfix: 31169366 -> Patch 32287205
Missing Bugfix: 17428816 -> Patch 32287205
Missing Bugfix: 31658943 -> Patch 32287205
Missing Bugfix: 32294066 -> Patch 33311587
Missing Bugfix: 32593782 -> Patch 33311587
Missing Bugfix: 31586302 -> Patch 33311587
Missing Bugfix: 29857440 -> Patch 33311587
Missing Bugfix: 32928416 -> Patch 32928416
Missing Bugfix: 32949290 -> Patch 33144848
The above list shows missing bugfixes for FMW - Web Tier.
These results have been stored in the database.
Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
Missing Bugfix: 20004021 -> Patch 22290164
Missing Bugfix: 20004087 -> Patch 22290164
Missing Bugfix: 16872333 -> Patch 22290164
Missing Bugfix: 19699191 -> Patch 22290164
Missing Bugfix: 20558005 -> Patch 22290164
Missing Bugfix: 20331945 -> Patch 22290164
The above list shows missing bugfixes for RSF within FMW Web tier.
These results have been stored in the database.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/app/PROD/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
Missing Bugfix: 9905685 -> Patch 9905685
Missing Bugfix: 17428617 -> Patch 17428617
Missing Bugfix: 21366277 -> Patch 21366277
Missing Bugfix: 21628307 -> Patch 21628307
Missing Bugfix: 24606362 -> Patch 24606362
Missing Bugfix: 24843064 -> Patch 24843064
Missing Bugfix: 13544814 -> Patch 13544814
Missing Bugfix: 16089637 -> Patch 16089637
Missing Bugfix: 20141119 -> Patch 20141119
Missing Bugfix: 24335626 -> Patch 30368663
Missing Bugfix: 22998551 -> Patch 30368663
Missing Bugfix: 22660018 -> Patch 30368663
Missing Bugfix: 24913281 -> Patch 30368663
Missing Bugfix: 20055551 -> Patch 30368663
Missing Bugfix: 27212806 -> Patch 27212806
Missing Bugfix: 28371189 -> Patch 28708563
Missing Bugfix: 26957170 -> Patch 30368663
Missing Bugfix: 28368196 -> Patch 30368663
Missing Bugfix: 30153175 -> Patch 30368663
Missing Bugfix: 29702340 -> Patch 30368663
Missing Bugfix: 29997425 -> Patch 30368663
Missing Bugfix: 26933408 -> Patch 26933408
The above list shows missing bugfixes for FMW - oracle common.
These results have been stored in the database.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home = /u01/app/PROD/fs1/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7
Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.
Missing Patch ID: 31641257 -> Patch 32728622
The above list shows missing patches for Oracle WebLogic Server.
If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed.
Contact Oracle Support if you require assistance in determining whether this is the case.
These results have been stored in the database.
===============================================================================
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================
One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:
-------------------------------------------------------------------------------
Oracle Forms and Reports 10.1.2.3.0
-------------------------------------------------------------------------------
Patch 32922089
- Filename: p32922089_101232_LINUX.zip
Patch 25342269
- Filename: p25342269_101232_Generic.zip
Patch 27491934
- Filename: p27491934_101232_LINUX.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 22288381
- Filename: p22288381_111190_Generic.zip
Patch 33311587
- Filename: p33311587_111190_Linux-x86-64.zip
Patch 32287205 [IMPORTANT: Follow Note 2555355.1 before applying.]
- Filename: p32287205_111190_Linux-x86-64.zip
Patch 23716938
- Filename: p23716938_111190_Generic.zip
Patch 32928416
- Filename: p32928416_111190_Linux-x86-64.zip
Patch 33144848
- Filename: p33144848_111190_Linux-x86-64.zip
-------------------------------------------------------------------------------
RSF within FMW Web tier 11.1.0.7.0
-------------------------------------------------------------------------------
Patch 22290164
- Filename: p22290164_111070_Linux-x86-64.zip
-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
Patch 9905685
- Filename: p9905685_111190_Generic.zip
Patch 17428617
- Filename: p17428617_111190_Generic.zip
Patch 21366277
- Filename: p21366277_111190_Generic.zip
Patch 21628307
- Filename: p21628307_111190_Generic.zip
Patch 24606362
- Filename: p24606362_111190_Generic.zip
Patch 24843064
- Filename: p24843064_111190_Generic.zip
Patch 13544814
- Filename: p13544814_111190_Generic.zip
Patch 16089637
- Filename: p16089637_111190_Generic.zip
Patch 20141119
- Filename: p20141119_111190_Generic.zip
Patch 30368663
- Filename: p30368663_111190_Generic.zip
Patch 27212806
- Filename: p27212806_111190_Generic.zip
Patch 28708563
- Filename: p28708563_111190_Generic.zip
Patch 26933408
- Filename: p26933408_111190_Generic.zip
-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
Patch 32728622 [SU Patch [NA7A]: WLS PSU 10.3.6.0.201020]
- Filename: p32728622_R12_GENERIC.zip
Apply the required patches and rerun this script.
+-----------------------------------------------------------------------------+
A consolidated zip file with the required application tier patches is
available on My Oracle Support via:
Patch 33570839
- EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JAN 2022
+-----------------------------------------------------------------------------+
[WARNING] Patch 32728622 [SU Patch [NA7A]: WLS PSU 10.3.6.0.201020] is missing.
This is the current recommended minimum WLS patch set.
As patch sets are not included in the consolidated zip file, you must obtain it
(or a later one, if available) from My Oracle Support and install it by
following its Readme.
After successful installation, rerun this script to check for any further
available fixes.
+-----------------------------------------------------------------------------+
See Doc ID 1594274.1 for any special instructions regarding these patches.
Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.
Finished checking prerequisite patches for File Edition: run.
Sun Oct 22 13:17:55 CST 2023
Log file for this session: /home/applmgr/17537119/log/checkMTpatch_60879.log
===============================================================================
提示需要下载聚合补丁 33570839：
[root@ebst2 ~]# mkdir -p /u01/stage/patch/33570839
[root@ebst2 ~]# unzip /mnt/hgfs/ebs/12.2.10/stage/patch/p33570839_R12_LINUX.zip -d /u01/stage/patch/33570839/
[root@ebst2 ~]# chown -R applmgr:dba /u01/stage/patch/33570839
[root@ebst2 ~]# su - applmgr
[applmgr@ebst2 ~]$ cd /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/forms/10.1.2.3.0/
[applmgr@ebst2 10.1.2.3.0]$ unzip p32922089_101232_LINUX.zip
[applmgr@ebst2 10.1.2.3.0]$ unzip p25342269_101232_Generic.zip
[applmgr@ebst2 10.1.2.3.0]$ unzip p27491934_101232_LINUX.zip
[applmgr@ebst2 10.1.2.3.0]$ source /u01/app/PROD/fs1/EBSapps/appl/APPSPROD_ebst2.env
[applmgr@ebst2 10.1.2.3.0]$ export ORACLE_HOME=/u01/app/PROD/fs1/EBSapps/10.1.2
[applmgr@ebst2 10.1.2.3.0]$ /u01/app/PROD/fs1/EBSapps/10.1.2/OPatch/opatch apply 32922089
[applmgr@ebst2 10.1.2.3.0]$ /u01/app/PROD/fs1/EBSapps/10.1.2/OPatch/opatch apply 25342269
[applmgr@ebst2 10.1.2.3.0]$ /u01/app/PROD/fs1/EBSapps/10.1.2/OPatch/opatch apply 27491934
安装 Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0 补丁：
[applmgr@ebst2 10.1.2.3.0]$ cd /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/webtier/11.1.1.9.0/
[applmgr@ebst2 11.1.1.9.0]$ unzip \*.zip
[applmgr@ebst2 11.1.1.9.0]$ export ORACLE_HOME=$IAS_ORACLE_HOME
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch napply /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/webtier/11.1.1.9.0 -id 22288381,23716938,32287205,32928416,33144848,33311587
安装 RSF within FMW Web tier 11.1.0.7.0 补丁：
[applmgr@ebst2 11.1.1.9.0]$ cd /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/webtier/11.1.0.7.0/
[applmgr@ebst2 11.1.0.7.0]$ unzip p22290164_111070_Linux-x86-64.zip
[applmgr@ebst2 11.1.0.7.0]$ export ORACLE_HOME=$IAS_ORACLE_HOME
[applmgr@ebst2 11.1.0.7.0]$ $ORACLE_HOME/OPatch/opatch apply 22290164
安装 Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0 补丁：
[applmgr@ebst2 11.1.0.7.0]$ cd /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/
[applmgr@ebst2 11.1.1.9.0]$ unzip \*.zip
[applmgr@ebst2 11.1.1.9.0]$ export ORACLE_HOME=$FMW_HOME/oracle_common
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 13544814
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 16089637
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 17428617
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 20141119
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 21366277
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 21628307
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 24606362
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 28708563
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 26933408
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply 27212806
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/9905685/oui/ -id 9905685
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/24843064/oui/ -id 24843064
[applmgr@ebst2 11.1.1.9.0]$ $ORACLE_HOME/OPatch/opatch apply /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/30368663/oui/ -id 30368663
安装 Oracle WebLogic Server (WLS) 10.3.6.0.7 补丁：
[applmgr@ebst2 11.1.1.9.0]$ cd /u01/stage/patch/33570839/etcc-bundle/LINUX_X86-64/wls/10.3.6.0.220118/
[applmgr@ebst2 10.3.6.0.220118]$ unzip \*.zip
[applmgr@ebst2 10.3.6.0.220118]$ cp *.jar *.xml /u01/app/PROD/fs1/FMW_Home/utils/bsu/cache_dir/
[applmgr@ebst2 10.3.6.0.220118]$ cd /u01/app/PROD/fs1/FMW_Home/utils/bsu/
[applmgr@ebst2 bsu]$ vim bsu.sh
#!/bin/sh
JAVA_HOME="/u01/app/PROD/fs1/EBSapps/comn/util/jdk64"
MEM_ARGS="-Xms4096m -Xmx4096m -XX:-UseGCOverheadLimit"
"$JAVA_HOME/bin/java" ${MEM_ARGS} -jar patch-client.jar $*
[applmgr@ebst2 bsu]$ ./bsu.sh -prod_dir=/u01/app/PROD/fs1/FMW_Home/wlserver_10.3 -patch_download_dir=/u01/app/PROD/fs1/FMW_Home/utils/bsu/cache_dir/ -status=downloaded -view -verbose
[applmgr@ebst2 bsu]$ cp -a /mnt/hgfs/ebs/12.2.10/stage/patch/bsupatch/bsu_update* /u01/app/PROD/fs1/FMW_Home/utils/bsu/
[applmgr@ebst2 bsu]$ sh bsu_update.sh install
Installing Smart Update V4...
Updating bsu modules
Update was successful.
[applmgr@ebst2 bsu]$ cd /mnt/hgfs/ebs/12.2.10/stage/patch/33528262/
[applmgr@ebst2 33528262]$ cp *.jar *.xml /u01/app/PROD/fs1/FMW_Home/utils/bsu/cache_dir/
[applmgr@ebst2 33528262]$ cd /u01/app/PROD/fs1/FMW_Home/utils/bsu/
[applmgr@ebst2 bsu]$ ./bsu.sh -prod_dir=/u01/app/PROD/fs1/FMW_Home/wlserver_10.3 -patchlist=1LRI,2GYW,CW9T,VKXF,BLTG -verbose -remove
[applmgr@ebst2 bsu]$ ./bsu.sh -prod_dir=/u01/app/PROD/fs1/FMW_Home/wlserver_10.3 -patchlist=YVDZ,YHJK,FCX7,Y5AP -verbose -remove
[applmgr@ebst2 bsu]$ ./bsu.sh -prod_dir=/u01/app/PROD/fs1/FMW_Home/wlserver_10.3 -patchlist=HYG5 -verbose -install
[applmgr@ebst2 bsu]$ ./bsu.sh -prod_dir=/u01/app/PROD/fs1/FMW_Home/wlserver_10.3 -patchlist=CIH8 -verbose -remove
[applmgr@ebst2 bsu]$ ./bsu.sh -prod_dir=/u01/app/PROD/fs1/FMW_Home/wlserver_10.3 -patchlist=32I2,7FC9,7GCA,CW7X,DI8E,DN1F,HYG5,IJC1,S8H6,S9MN,TTEM -verbose -install
安装成功后再次检查：
[applmgr@ebst2 bsu]$ cd /home/applmgr/17537119/
[applmgr@ebst2 17537119]$ ./checkMTpatch.sh
+===============================================================+
| Copyright (c) 2005, 2022 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Application Tier Technology Codelevel Checker |
+===============================================================+
Using context file from currently set applications environment:
/u01/app/PROD/fs1/inst/apps/PROD_ebst2/appl/admin/PROD_ebst2.xml
Starting Application Tier Technology Codelevel Checker
Version: 120.0.12020000.53.
Sun Oct 22 18:52:46 CST 2023
Log file for this session: /home/applmgr/17537119/log/checkMTpatch_105004.log
Bugfix XML file version: 120.0.12020000.54
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.40
This file will be used for mapping bugfixes to patches.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Connecting to database.
Database connection successful.
The installed AD.C.13 codelevel supports storing the results in the database.
Checking for ETCC results table.
Table to store results already exists in database.
===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/app/PROD/fs1/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
All required bugfixes are present for Oracle Forms and Reports.
These results have been stored in the database.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.
These results have been stored in the database.
===============================================================================
Oracle Fusion Middleware (FMW) - Web Tier
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/app/PROD/fs1/FMW_Home/webtier.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.
All required bugfixes are present for FMW - Web Tier.
These results have been stored in the database.
Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web tier.
These results have been stored in the database.
===============================================================================
Oracle Fusion Middleware (FMW) - oracle_common
===============================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/app/PROD/fs1/FMW_Home/oracle_common.
Product Version = 11.1.1.9.0
Checking required bugfixes for FMW - oracle common 11.1.1.9.0.
All required bugfixes are present for FMW - oracle common.
These results have been stored in the database.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining product Oracle WebLogic Server (WLS).
Oracle Home = /u01/app/PROD/fs1/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.220118
Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.220118.
All required patches are present for Oracle WebLogic Server (WLS).
These results have been stored in the database.
===============================================================================
All required one-offs are confirmed as present.
Finished checking prerequisite patches for File Edition: run.
Sun Oct 22 18:53:01 CST 2023
Log file for this session: /home/applmgr/17537119/log/checkMTpatch_105004.log
===============================================================================
可以看到所有的补丁都已打好了。
安装种子表补丁
停止所有应用层服务：
[root@ebst2 ~]# su - applmgr
[applmgr@ebst2 ~]$ $ADMIN_SCRIPTS_HOME/adstpall.sh apps/Abcd1234
只启动 Oracle Weblogic Admin Server：
[applmgr@ebst2 ~]$ $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
安装补丁 26787701：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/12210/
[root@ebst2 12210]# unzip p26787701_12.2.0_R12_GENERIC.zip -d /u01/app/PROD/fs_ne/EBSapps/patch/
[root@ebst2 12210]# cd /u01/app/PROD/fs_ne/EBSapps/patch/
[root@ebst2 patch]# chown -R applmgr:dba 26787701/
[root@ebst2 patch]# su - applmgr
[applmgr@ebst2 ~]$ adop phase=apply patches=26787701 hotpatch=yes
安装 AD 和 TXK 补丁
解压补丁：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/12.2_ad_txk/
[root@ebst2 12.2_ad_txk]# unzip \*.zip
创建 EBS_SYSTEM Schema：
[root@ebst2 12.2_ad_txk]# su - oracle
[oracle@ebst2 ~]$ mkdir /u01/db/PROD/12.1.0/appsutil/admin
[oracle@ebst2 ~]$ cp /mnt/hgfs/ebs/12.2.10/stage/patch/12.2_ad_txk/33441060/admin/adgrants.sql /u01/db/PROD/12.1.0/appsutil/admin/
[oracle@ebst2 ~]$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql apps
[oracle@ebst2 ~]$ sqlplus / as sysdba
SQL> ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
SQL> ALTER USER EBS_SYSTEM IDENTIFIED BY "Abcd1234";
AP 节点验证密码：
[root@ebst2 ~]# su - applmgr
[applmgr@ebst2 ~]$ perl /mnt/hgfs/ebs/12.2.10/stage/patch/12.2_ad_txk/32394134/ad/bin/adValidateEbssystemSchema.pl
Enter the APPS password:
Enter the SYSTEM password:
Validating APPS credentials...validated successfully
Validating SYSTEM credentials...validated successfully
Validating EBS_SYSTEM user
ebssys entity is not registered
All required validations completed successfully
安装补丁：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/12.2_ad_txk/
[root@ebst2 12.2_ad_txk]# cp -a 32394134/ 33441060/ 32392507/ 33550674/ 34207577/ 33535778/ /u01/app/PROD/fs_ne/EBSapps/patch/
[root@ebst2 12.2_ad_txk]# chown -R applmgr:dba /u01/app/PROD/fs_ne/EBSapps/patch/*
[root@ebst2 12.2_ad_txk]# su - applmgr
[applmgr@ebst2 ~]$ adop phase=apply patches=32394134,33441060 hotpatch=yes merge=yes
[applmgr@ebst2 ~]$ adop phase=apply patches=32392507,33550674,34207577,33535778 hotpatch=yes merge=yes
[applmgr@ebst2 ~]$ vi .bash_profile
#source /u01/app/PROD/fs1/EBSapps/appl/APPSPROD_ebst2.env
[applmgr@ebst2 ~]$ logout
[root@ebst2 patch]# su - applmgr
[applmgr@ebst2 ~]$ source /u01/app/PROD/EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/app/PROD/fs1/EBSapps/appl
PATCH File System : /u01/app/PROD/fs2/EBSapps/appl
Non-Editioned File System : /u01/app/PROD/fs_ne
DB Host: ebst2.stonecoding.net Service/SID: PROD
Sourcing the RUN File System ...
[applmgr@ebst2 ~]$ cd /home/applmgr/17537119/
[applmgr@ebst2 17537119]$ ./checkMTpatch.sh
[applmgr@ebst2 17537119]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
[applmgr@ebst2 17537119]$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
[applmgr@ebst2 17537119]$ perl $AD_TOP/bin/admkappsutil.pl
[root@ebst2 ~]# su - oracle
[oracle@ebst2 ~]$ cp /u01/app/PROD/fs1/inst/apps/PROD_ebst2/admin/out/appsutil.zip /u01/db/PROD/12.1.0/
[oracle@ebst2 ~]$ cd /u01/db/PROD/12.1.0/
[oracle@ebst2 12.1.0]$ unzip -o appsutil.zip
[oracle@ebst2 12.1.0]$ source /u01/db/PROD/12.1.0/PROD_ebst2.env
[oracle@ebst2 12.1.0]$ sh /u01/db/PROD/12.1.0/appsutil/scripts/PROD_ebst2/adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/db/PROD/12.1.0/appsutil/log/PROD_ebst2/10221913/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/db/PROD/12.1.0
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Classpath : :/u01/db/PROD/12.1.0/jdbc/lib/ojdbc6.jar:/u01/db/PROD/12.1.0/appsutil/java/xmlparserv2.jar:/u01/db/PROD/12.1.0/appsutil/java:/u01/db/PROD/12.1.0/jlib/netcfg.jar:/u01/db/PROD/12.1.0/jlib/ldapjclnt12.jar:/u01/db/PROD/12.1.0/jlib/orai18n.jar
Using Context file : /u01/db/PROD/12.1.0/appsutil/PROD_ebst2.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
在 Run File System 运行自动配置：
[applmgr@ebst2 ~]$ sh $INST_TOP/admin/scripts/adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/PROD/fs1/inst/apps/PROD_ebst2/admin/log/10221915/adconfig.log
wlsDomainName: EBS_domain_PROD
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/app/PROD/fs1/inst/apps/PROD_ebst2
Classpath : /u01/app/PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/app/PROD/fs1/EBSapps/comn/java/classes
Using Context file : /u01/app/PROD/fs1/inst/apps/PROD_ebst2/appl/admin/PROD_ebst2.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
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 CZ_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 IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
安装升级补丁
解压并安装补丁：
[root@ebst2 ~]# cd /mnt/hgfs/ebs/12.2.10/stage/patch/12210/
[root@ebst2 12210]# unzip \*11.zip -d /u01/app/PROD/fs_ne/EBSapps/patch/
[root@ebst2 12210]# unzip p33678475_12.2.0_R12_GENERIC.zip -d /u01/app/PROD/fs_ne/EBSapps/patch/
[root@ebst2 12210]# chown -R applmgr:dba /u01/app/PROD/fs_ne/EBSapps/patch/30399999
[root@ebst2 12210]# chown -R applmgr:dba /u01/app/PROD/fs_ne/EBSapps/patch/33678475
[root@ebst2 12210]# su - applmgr
[applmgr@ebst2 ~]$ source /u01/app/PROD/EBSapps.env run
[applmgr@ebst2 ~]$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
[applmgr@ebst2 ~]$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
[applmgr@ebst2 ~]$ adop phase=apply apply_mode=downtime patches=30399999,33678475 merge=yes
安装完成后启动应用：
[applmgr@ebst2 ~]$ sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
Perform adop cleanup action：
[applmgr@ebst2 ~]$ adop phase=cleanup
Synchronize file systems：
[applmgr@ebst2 ~]$ adop phase=fs_clone