6年没碰Oracle了，今天有个项目需要远程安装一套DataGuard的备库，记录安装过程。
安装步骤
- Step 1 Add Required RPMs.
- Step 2 Configure the Kernel.
- Step 3 Create directories, Add groups.
- Step 4 Create Grid & Oracle Users and give permissions.
- Step 5 Make the primary partition for added disk to use for ASM.
- Step 6 Install RPM for ASM, Configure ASM, Create ASM disks.
- Step 7 Copy grid binary on server , Unzip & Create responce file for grid. (With Grid user).
- Step 8 install grid in silent mode
- Step 9 Copy oraclebinary on server , Unzip & Create responce file for oracle. (With Oracle user)
- Step 10 install oracle in silent mode
- Step 11 Create Listener in silent mode
- Step 12 Create database
- Step 13 打补丁(grid和oracle用户)
Step 1 – Add Required RPMs.
Oracle 11.2.0.4.0 requires extra RPMs from the install media.
The following command should load all needed RPMs for 11.2.0.4.0 Grid and Database.
rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64*
rpm -Uvh glibc-2*i686*
rpm -Uvh nss-softokn-freebl-3*x86_64*
rpm -Uvh nss-softokn-freebl-3*i686*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libcap*
rpm -Uvh binutils-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh sysstat-9.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh glibc-headers-2.*
rpm -Uvh ksh-2*
rpm -Uvh make-3.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh libstdc++-4.*.i686*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh libcap-2.16-5.2.el6.i686.rpm
rpm -Uvh libattr-2.4.44-4.el6.i686.rpm
rpm -Uvh libtool-ltdl*i686*
rpm -Uvh ncurses*i686*
rpm -Uvh readline*i686*
rpm -Uvh unixODBC*
Step 2 – Configure the Kernel.
The following steps modify key settings to allow Oracle to execute. We will also disable the NTP time synchronization configuration file which will confuse the Oracle installer.
(i) If you are not using DNS, the “/etc/hosts” file must contain the following information.
192.168.36.10 cqdbsvr-c1
(ii) Add or amend the following lines to the “/etc/sysctl.conf” file.
fs.aio-max-nr = 4194304
fs.file-max = 6815744
kernel.shmmax = 128849018880
kernel.shmmni = 4096
kernel.shmall = 31457280
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
net.ipv4.conf.eth1.rp_filter = 2
net.ipv4.conf.eth0.rp_filter = 2
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_tw_reuse = 0
net.ipv4.tcp_tw_recycle = 0
net.core.somaxconn = 8192
net.core.netdev_max_backlog = 16384
net.ipv4.tcp_max_syn_backlog = 16384
net.ipv4.tcp_retries2 = 5
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_keepalive_time = 1800
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_keepalive_intvl = 30
vm.min_free_kbytes = 2097152
vm.nr_hugepages = 20500
(iii) Run the following command to change the current kernel parameters.
/sbin/sysctl -p
(iv) Add the following lines to the “/etc/security/limits.conf” file.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
grid soft nproc 10240
grid hard nproc 16384
grid soft nofile 10240
grid hard nofile 65536
grid soft stack 10240
(v) Add the following lines to the “/etc/pam.d/login” file, if it does not already exist.
session required pam_limits.so
(vi) Make the following changes to the default shell startupfile, add the following lines to the “/etc/profile” file:
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
(vii) Amend the “/etc/security/limits.d/90-nproc.conf” file as described below. See MOS Remark [ID 1487773.1]
# Change this
* soft nproc 1024
# To this
* - nproc 16384
(viii) Change the setting of SELinux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.
SELINUX=disabled
(ix) If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here. The following is an example of disabling the firewall.
# service iptables stop
# chkconfig iptables off
(x) Disable the NTP configuration file
# service ntpd stop
Shutting down ntpd: [ OK ]
# chkconfig ntpd off
# mv /etc/ntp.conf /etc/ntp.conf.orig
# rm /var/run/ntpd.pid
Step 3 - Create directories, Add groups
- For oracle user
mkdir -p /oracle/app/oracle/product/11.2.0/db_home
mkdir -p /oracle/app/oracle/oraInventory
- For grid user
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/grid/product/11.2.0/grid_home
mkdir -p /oracle/app/oraInventory
Step 4 - Create Grid & Oracle Users and give permissions.
groupadd -g 200 oinstall
groupadd -g 201 dba
groupadd -g 202 oper
groupadd -g 203 asmdba
groupadd -g 204 asmoper
groupadd -g 205 asmadmin
useradd -u 201 -g oinstall -G asmadmin,asmdba,asmoper,dba -d /home/grid grid
useradd -u 200 -g oinstall -G dba,oper,asmdba -d /home/oracle oracle
[root@DBA01 Packages]# passwd oracle
[root@DBA01 Packages]# passwd grid
chown -R oracle:oinstall /oracle/
chown -R oracle:oinstall /oracle/app/oracle/oraInventory
chown -R grid:oinstall /oracle/app/grid/
chown -R grid:oinstall /oracle/app/oraInventory/
chown -R grid:oinstall /oracle/app/grid/product/11.2.0/grid_home
chown -R oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle
- Setting for .bash_profile for grid and oracle user
修改SID
.bash_profile for Grid:
[root@host11g1 ~]# vi /home/grid/.bash_profile
ORACLE_BASE=/oracle/app/grid; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/grid_home; export ORACLE_HOME
ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
.bash_profile for oracle:
[root@host11g1 ~]# vi /home/oracle/.bash_profile
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_home; export ORACLE_HOME
ORACLE_SID=cqnevastandby; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
Step 5 - Make the primary partition for added disk to use for ASM
(i) List of partition disk in my machine.
[root@cqdbsvr-c1 xx]# fdisk -l
Disk /dev/sda: 899.0 GB, 898999779328 bytes
255 heads, 63 sectors/track, 109297 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000a7325
Device Boot Start End Blocks Id System
/dev/sda1 * 1 39 307200 83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sda2 39 109298 877621248 8e Linux LVM
Disk /dev/mapper/vg_cqdbsvrc1-LogVol03_swap: 68.7 GB, 68719476736 bytes
255 heads, 63 sectors/track, 8354 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_cqdbsvrc1-LogVol00_root: 42.9 GB, 42949672960 bytes
255 heads, 63 sectors/track, 5221 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_cqdbsvrc1-LogVol01_home: 53.7 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_cqdbsvrc1-LogVol02_oracle: 85.9 GB, 85899345920 bytes
255 heads, 63 sectors/track, 10443 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
Disk /dev/sdb: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdc: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdd: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sde: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdf: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdg: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdh: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdi: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdj: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdk: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdl: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdm: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdo: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdn: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdp: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/sdq: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Disk /dev/mapper/mpathb: 2199.0 GB, 2199023255552 bytes
255 heads, 63 sectors/track, 267349 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 32768 bytes / 32768 bytes
Disk identifier: 0x14f9054c
Device Boot Start End Blocks Id System
Step 6 - Install RPM for ASM, Configure ASM, Create ASM disks
- create a udev rules file for raw devices
[root@cqdbsvr-1 ~]# less /etc/udev/rules.d/99-oracleasm.rules
ENV{DM_NAME}=="mpath[b]", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@cqdbsvr-c1 ~]# start_udev
正在启动 udev： [确定]
Step 7 - Copy grid binary on server , Unzip & Create response file for grid. (With Grid user)
grid_install.rsp:
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0
ORACLE_HOSTNAME=cqdbsvr-c1
INVENTORY_LOCATION=/oracle/app/oraInventory
SELECTED_LANGUAGES=en
oracle.install.option=HA_CONFIG
ORACLE_BASE=/oracle/app/grid
ORACLE_HOME=/oracle/app/grid/product/11.2.0/grid_home
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=asmadmin
oracle.install.crs.config.gpnp.scanName=
oracle.install.crs.config.gpnp.scanPort=
oracle.install.crs.config.clusterName=
oracle.install.crs.config.gpnp.configureGNS=false
oracle.install.crs.config.gpnp.gnsSubDomain=
oracle.install.crs.config.gpnp.gnsVIPAddress=
oracle.install.crs.config.autoConfigureClusterNodeVIP=
oracle.install.crs.config.clusterNodes=
oracle.install.crs.config.storageOption=
oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
oracle.install.crs.config.useIPMI=false
oracle.install.crs.config.ipmi.bmcUsername=
oracle.install.crs.config.ipmi.bmcPassword=
oracle.install.asm.SYSASMPassword=asm
oracle.install.asm.diskGroup.name=DATADG
oracle.install.asm.diskGroup.redundancy=EXTERNAL
oracle.install.asm.diskGroup.disks=/dev/mapper/mpathb
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/mapper/mpath*
oracle.install.asm.monitorPassword=asm
oracle.install.crs.upgrade.clusterNodes=
oracle.install.asm.upgradeASM=false
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
PROXY_HOST=
PROXY_PORT=0
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
Step 9 -We are ready to install grid in silent mode
(i) Hit the command to install grid.
[grid@cqdbsvr-c1 software]$ ./runInstaller -silent -showProgress -ignoreSysPrereqs -ignorePrereq -responseFile /home/grid/grid_install.rsp
正在启动 Oracle Universal Installer...
检查临时空间: 必须大于 120 MB。 实际为 31322 MB 通过
检查交换空间: 必须大于 150 MB。 实际为 65535 MB 通过
准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2019-08-12_04-51-56AM. 请稍候...[grid@cqdbsvr-c1 software]$
[grid@cqdbsvr-c1 software]$ [WARNING] [INS-30011] 输入的 SYS 口令不符合 Oracle 建议的标准。
原因: Oracle 建议输入的口令应该至少长为 8 个字符, 至少包含 1 个大写字符, 1 个小写字符和 1 个数字 [0-9]。
操作: 提供符合 Oracle 建议标准的口令。
[WARNING] [INS-30011] 输入的 ASMSNMP 口令不符合 Oracle 建议的标准。
原因: Oracle 建议输入的口令应该至少长为 8 个字符, 至少包含 1 个大写字符, 1 个小写字符和 1 个数字 [0-9]。
操作: 提供符合 Oracle 建议标准的口令。
可以在以下位置找到本次安装会话的日志:
/oracle/app/oraInventory/logs/installActions2019-08-12_04-51-56AM.log
准备 正在进行中。
.................................................. 9% 完成。
准备成功。
复制文件 正在进行中。
.................................................. 14% 完成。
.................................................. 21% 完成。
.................................................. 26% 完成。
.................................................. 31% 完成。
.................................................. 36% 完成。
.................................................. 42% 完成。
.................................................. 50% 完成。
.................................................. 56% 完成。
.................................................. 61% 完成。
.................................................. 66% 完成。
.................................................. 71% 完成。
........................................
复制文件成功。
链接二进制文件 正在进行中。
..........
链接二进制文件成功。
..........
安装程序文件 正在进行中。
.................................................. 76% 完成。
.................................................. 89% 完成。
安装程序文件成功。
[grid@cqdbsvr-c1 software]$ Oracle Grid Infrastructure 11g 的 安装 已成功。
请查看 '/oracle/app/oraInventory/logs/silentInstall2019-08-12_04-51-56AM.log' 以获取详细资料。
.................................................. 94% 完成。
执行 Root 脚本 正在进行中。
以 root 用户的身份执行以下脚本:
1. /oracle/app/oraInventory/orainstRoot.sh
2. /oracle/app/grid/product/11.2.0/grid_home/root.sh
.................................................. 100% 完成。
执行 Root 脚本成功。
以安装用户的身份执行以下脚本来完成配置。
1. /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/configToolAllCommands RESPONSE_FILE=<response_file>
注:
1. 此脚本必须在已运行安装程序的同一主机上运行。
2. 对于需要口令的 Configuration Assistant, 此脚本需要一个较小的口令属性文件 (请参阅安装指南文档)。
Successfully Setup Software.
(ii) Run the orainstRoot.sh & root.sh script with root user
[root@cqdbsvr-c1 /]# /oracle/app/oraInventory/orainstRoot.sh
更改权限/oracle/app/oraInventory.
添加组的读取和写入权限。
删除全局的读取, 写入和执行权限。
更改组名/oracle/app/oraInventory 到 oinstall.
脚本的执行已完成。
[root@cqdbsvr-c1 ~]# /oracle/app/grid/product/11.2.0/grid_home/root.sh
Check /oracle/app/grid/product/11.2.0/grid_home/install/root_cqdbsvr-c1_2019-08-12_05-32-30.log for the output of root script
[root@cqdbsvr-c1 ~]# cat /oracle/app/grid/product/11.2.0/grid_home/install/root_cqdbsvr-c1_2019-08-12_05-32-30.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /oracle/app/grid/product/11.2.0/grid_home
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
Creating trace directory
/oracle/app/grid/product/11.2.0/grid_home/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory
Failed to create keys in the OLR, rc = 127, Message:
Failed to create keys in the OLR at /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_lib.pm line 7660.
/oracle/app/grid/product/11.2.0/grid_home/perl/bin/perl -I/oracle/app/grid/product/11.2.0/grid_home/perl/lib -I/oracle/app/grid/product/11.2.0/grid_home/crs/install /oracle/app/grid/product/11.2.0/grid_home/crs/install/roothas.pl execution failed
解决：
yum install -y libcap
cd /lib64
ln -s libcap.so.2.16 libcap.so.1
使用-force
[root@cqdbsvr-c1 lib64]# cat /oracle/app/grid/product/11.2.0/grid_home/install/root_cqdbsvr-c1_2019-08-12_05-54-35.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /oracle/app/grid/product/11.2.0/grid_home
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node cqdbsvr-c1 successfully pinned.
Adding Clusterware entries to upstart
cqdbsvr-c1 2019/08/12 05:56:39 /oracle/app/grid/product/11.2.0/grid_home/cdata/cqdbsvr-c1/backup_20190812_055639.olr
Successfully configured Oracle Grid Infrastructure for a Standalone Server
(iii) grid用户执行脚本
Create a file that contain all the asm password cfgrsp.properties
[grid@host11g1 ~]$ vi /home/grid/software/cfgrsp.properties
oracle.assistants.asm|S_ASMPASSWORD=asm
oracle.assistants.asm|S_ASMMONITORPASSWORD=asm
[grid@cqdbsvr-c1 ~]$ /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/opt/software/cfgrsp.properties
Setting the invPtrLoc to /oracle/app/grid/product/11.2.0/grid_home/oraInst.loc
perform - 操作的模式正在启动: configure
^C[grid@cqdbsvr-c1 ~]$ /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/configToolAllCommands RESPONSE_FILE=/home/grid/software/cfgrsp.properties
Setting the invPtrLoc to /oracle/app/grid/product/11.2.0/grid_home/oraInst.loc
perform - 操作的模式正在启动: configure
2019-8-12 6:01:54 oracle.install.driver.oui.config.GenericInternalPlugIn invoke
信息: Executing ASMCA
2019-8-12 6:01:54 oracle.install.driver.oui.config.GenericInternalPlugIn invoke
信息: Command /oracle/app/grid/product/11.2.0/grid_home/bin/asmca -silent -oui_internal -configureASM -diskString '/dev/mapper/mpath*' -diskGroupName DATADG -diskList /dev/mapper/mpathb -redundancy EXTERNAL -au_size 1
2019-8-12 6:01:54 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: ... GenericInternalPlugIn.handleProcess() entered.
2019-8-12 6:01:54 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: ... GenericInternalPlugIn: getting configAssistantParmas.
2019-8-12 6:01:54 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: ... GenericInternalPlugIn: checking secretArguments.
2019-8-12 6:01:54 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: ... GenericInternalPlugIn: starting read loop.
2019-8-12 6:01:57 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read: SYS_PASSWORD_PROMPT
2019-8-12 6:01:57 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Processing: SYS_PASSWORD_PROMPT for argument tag -sysAsmPassword
2019-8-12 6:01:57 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read: ASMSNMP_PASSWORD_PROMPT
2019-8-12 6:01:57 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Processing: ASMSNMP_PASSWORD_PROMPT for argument tag -asmMonitorPassword
2019-8-12 6:01:57 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: End of argument passing to stdin
2019-8-12 6:03:10 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read:
2019-8-12 6:03:10 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read: 已成功创建并启动 ASM。
2019-8-12 6:03:10 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read:
2019-8-12 6:03:10 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read: 已成功创建磁盘组DATADG。
2019-8-12 6:03:10 oracle.install.driver.oui.config.GenericInternalPlugIn handleProcess
信息: Read:
perform - 操作的模式已完成: configure
您可以查看日志文件: /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/oui/configActions2019-08-12_06-01-21-AM.log
[grid@cqdbsvr-c1 ~]$
[grid@cqdbsvr-c1 ~]$ cat /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/oui/configActions2019-08-12_06-01-21-AM.log
###################################################
The action configuration is performing
------------------------------------------------------
The plug-in Update Inventory is running
/oracle/app/grid/product/11.2.0/grid_home/oui/bin/runInstaller -nowait -noconsole -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent CRS=true "CLUSTER_NODES={}" ORACLE_HOME=/oracle/app/grid/product/11.2.0/grid_home
正在启动 Oracle Universal Installer...
检查交换空间: 必须大于 500 MB。 实际为 65535 MB 通过
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /oracle/app/oraInventory
The plug-in Update Inventory has successfully been performed
------------------------------------------------------
------------------------------------------------------
The plug-in Oracle Net Configuration Assistant is running
正在对命令行参数进行语法分析:
参数"orahome" = /oracle/app/grid/product/11.2.0/grid_home
参数"orahnam" = Ora11g_gridinfrahome1
参数"instype" = typical
参数"inscomp" = client,oraclenet,javavm,server,ano
参数"insprtcl" = tcp
参数"cfg" = local
参数"authadp" = NO_VALUE
参数"responsefile" = /oracle/app/grid/product/11.2.0/grid_home/network/install/netca_typ.rsp
参数"silent" = true
参数"silent" = true
完成对命令行参数进行语法分析。
Oracle Net Services 配置:
完成概要文件配置。
Oracle Net 监听程序启动:
监听程序已成功启动。
监听程序配置完成。
成功完成 Oracle Net Services 配置。退出代码是0
The plug-in Oracle Net Configuration Assistant has successfully been performed
------------------------------------------------------
------------------------------------------------------
The plug-in Automatic Storage Management Configuration Assistant is running
The plug-in Automatic Storage Management Configuration Assistant has successfully been performed
------------------------------------------------------
------------------------------------------------------
The plug-in Oracle Cluster Verification Utility is running
执行 Oracle Restart 配置 的后期检查
正在检查 Oracle Restart 完整性...
Oracle Restart 完整性检查已通过
正在检查 OLR 完整性...
正在检查 OLR 配置文件...
OLR 配置文件检查成功
正在检查 OLR 文件属性...
OLR 文件检查成功
WARNING:
此检查不验证 OLR 内容的完整性。请以授权用户的身份执行 'ocrcheck -local' 以验证 OLR 的内容。
OLR 完整性检查通过
Oracle Restart 配置 的后期检查成功。
The plug-in Oracle Cluster Verification Utility has successfully been performed
------------------------------------------------------
The action configuration has successfully completed
###################################################
[grid@cqdbsvr-c1 ~]$ crsctl status res
NAME=ora.DATADG.dg
TYPE=ora.diskgroup.type
TARGET=ONLINE
STATE=ONLINE on cqdbsvr-c1
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on cqdbsvr-c1
NAME=ora.asm
TYPE=ora.asm.type
TARGET=ONLINE
STATE=ONLINE on cqdbsvr-c1
NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on cqdbsvr-c1
NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=OFFLINE
STATE=OFFLINE
NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on cqdbsvr-c1
NAME=ora.ons
TYPE=ora.ons.type
TARGET=OFFLINE
STATE=OFFLINE
Step 9 - Copy oraclebinary on server , Unzip & Create responce file for oracle. (With Oracle user)
db_install.rsp:
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=cqdbsvr-c1
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_home
ORACLE_BASE=/oracle/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=
oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
Step 10 install oracle in silent mode
(i) Hit the command to install oracle in silent mode
[oracle@cqdbsvr-c1 software]$ ./runInstaller -silent -showProgress -ignoreSysPrereqs -ignorePrereq -responseFile /home/oracle/db_install.rsp
正在启动 Oracle Universal Installer...
检查临时空间: 必须大于 120 MB。 实际为 31272 MB 通过
检查交换空间: 必须大于 150 MB。 实际为 65535 MB 通过
准备从以下地址启动 Oracle Universal Installer /tmp/OraInstall2019-08-12_06-58-36AM. 请稍候...[oracle@cqdbsvr-c1 software]$
[oracle@cqdbsvr-c1 software]$ 可以在以下位置找到本次安装会话的日志:
/oracle/app/oraInventory/logs/installActions2019-08-12_06-58-36AM.log
准备 正在进行中。
.................................................. 9% 完成。
准备成功。
复制文件 正在进行中。
.................................................. 14% 完成。
.................................................. 20% 完成。
.................................................. 26% 完成。
.................................................. 31% 完成。
.................................................. 36% 完成。
.................................................. 41% 完成。
.................................................. 46% 完成。
.................................................. 51% 完成。
.................................................. 56% 完成。
.................................................. 63% 完成。
.................................................. 68% 完成。
.................................................. 73% 完成。
.................................................. 78% 完成。
.................................................. 83% 完成。
..............................
复制文件成功。
链接二进制文件 正在进行中。
..........
链接二进制文件成功。
安装程序文件 正在进行中。
.................................................. 88% 完成。
.................................................. 94% 完成。
安装程序文件成功。
Oracle Database 11g 的 安装 已成功。
请查看 '/oracle/app/oraInventory/logs/silentInstall2019-08-12_06-58-36AM.log' 以获取详细资料。
执行 Root 脚本 正在进行中。
以 root 用户的身份执行以下脚本:
1. /oracle/app/oracle/product/11.2.0/db_home/root.sh
.................................................. 100% 完成。
执行 Root 脚本成功。
Successfully Setup Software.
(ii) Run root.sh script
[root@cqdbsvr-c1 software]# /oracle/app/oracle/product/11.2.0/db_home/root.sh
Check /oracle/app/oracle/product/11.2.0/db_home/install/root_cqdbsvr-c1_2019-08-12_07-06-34.log for the output of root script
[root@cqdbsvr-c1 software]# cat /oracle/app/oracle/product/11.2.0/db_home/install/root_cqdbsvr-c1_2019-08-12_07-06-34.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/oracle/product/11.2.0/db_home
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Finished product-specific root actions.
[root@cqdbsvr-c1 software]#
Step 11 -Create Listener in silent mode
(i) Create Listener via grid user
[grid@cqdbsvr-c1 grid_home]$ /oracle/app/grid/product/11.2.0/grid_home/bin/netca -silent -responsefile /oracle/app/grid/product/11.2.0/grid_home/assistants/netca/netca.rsp
正在对命令行参数进行语法分析:
参数"silent" = true
参数"responsefile" = /oracle/app/grid/product/11.2.0/grid_home/assistants/netca/netca.rsp
完成对命令行参数进行语法分析。
Oracle Net Services 配置:
完成概要文件配置。
监听程序 "LISTENER" 已存在。
成功完成 Oracle Net Services 配置。退出代码是0
(ii) Check Listner status
[grid@cqdbsvr-c1 grid_home]$ /oracle/app/grid/product/11.2.0/grid_home/bin/lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 12-AUG-2019 07:11:04
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 12-AUG-2019 06:01:52
Uptime 0 days 1 hr. 9 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/grid/product/11.2.0/grid_home/network/admin/listener.ora
Listener Log File /oracle/app/grid/diag/tnslsnr/cqdbsvr-c1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cqdbsvr-c1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully
Step 12 - Create database
dbca -silent -deleteDatabase -SOURCEDB cqneva -sysPassword sys -systemPassword sys
[oracle@cqdbsvr-c1 ~]$ dbca -silent \
-createDatabase \
-asmsnmpPassword asm \
-characterSet AL32UTF8 \
-continueOnNonFatalErrors false \
-disableSecurityConfiguration ALL \
-diskGroupName DATADG \
-emConfiguration NONE \
-gdbName cqneva \
-listeners LISTENER \
-memoryPercentage 40 \
-recoveryAreaDestination DATADG \
-sid cqnevastandy\
-sysPassword sys \
-systemPassword sys \
-storageType ASM \
-sampleSchema true \
-templateName General_Purpose.dbc
复制数据库文件
1% 已完成
2% 已完成
4% 已完成
35% 已完成
正在创建并启动 Oracle 实例
38% 已完成
43% 已完成
44% 已完成
45% 已完成
46% 已完成
47% 已完成
48% 已完成
52% 已完成
53% 已完成
57% 已完成
58% 已完成
59% 已完成
62% 已完成
将数据库注册到 Oracle Restart
68% 已完成
正在进行数据库创建
72% 已完成
75% 已完成
79% 已完成
90% 已完成
91% 已完成
100% 已完成
有关详细信息, 请参阅日志文件 "/oracle/app/oracle/cfgtoollogs/dbca/cqneva/cqneva.log"。
打补丁
- GI PSU : p28813878_112040_Linux-x86-64.zip
- OPatch : p6880880_112000_Linux-x86-64.zip
grid用户
- 更新OPatch版本
[root@cqdbsvr-c1 grid_home]# cd /oracle/app/grid/product/11.2.0/grid_home/
[root@cqdbsvr-c1 grid_home]# mv OPatch/ OPatch.bak
[root@cqdbsvr-c1 grid_home]# unzip p6880880_112000_Linux-x86-64.zip
[root@cqdbsvr-c1 grid_home]# mv /home/grid/OPatch/ ./
[root@cqdbsvr-c1 grid_home]# chown -R grid:oinstall OPatch
- 检查需要打的补丁与现有补丁是否冲突
[root@cqdbsvr-c1 ~]$unzip p28813878_112040_Linux-x86-64.zip
[root@cqdbsvr-c1 ~]$ chown -R grid:oinstall 28813878
[root@cqdbsvr-c1 ~]]su - grid
[grid@cqdbsvr-c1 grid]cd 28813878/
[grid@cqdbsvr-c1 28813878]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ -oh /oracle/app/grid/product/11.2.0/grid_h
Oracle 中间补丁程序安装程序版本 11.2.0.3.19
版权所有 (c) 2019, Oracle Corporation。保留所有权利。
PREREQ session
Oracle Home : /oracle/app/grid/product/11.2.0/grid_home
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/grid/product/11.2.0/grid_home/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatch/opatch2019-08-12_09-34-12上午_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
- 验证Inventory一致性
[grid@cqdbsvr-c1 28813878]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle 中间补丁程序安装程序版本 11.2.0.3.19
版权所有 (c) 2019, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/grid/product/11.2.0/grid_home
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/grid/product/11.2.0/grid_home/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatch/opatch2019-08-12_09-35-07上午_1.log
Lsinventory Output file location : /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatch/lsinv/lsinventory2019-08-12_09-35-07上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: cqdbsvr-c1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
已安装的产品 (89):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Automatic Storage Management Assistant 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Ready Services Files 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Cluster Verification Utility Files 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Grid Infrastructure 11g 11.2.0.4.0
Oracle Help For Java 4.2.9.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle Quality of Service Management (Server) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
Required Support Files 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
Universal Storage Manager Files 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
此 Oracle 主目录中已安装 89 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
--------------------------------------------------------------------------------
OPatch succeeded.
- 配置ocm响应文件
[grid@cqdbsvr-c1 bin]$ cd $ORACLE_HOME/OPatch/ocm/bin
[grid@cqdbsvr-c1 bin]$ ./emocmrsp -no_banner -output $ORACLE_HOME/OPatch/ocm/bin/ocm.rsp
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: 307185292@qq.com
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):
Unable to establish connection to Oracle Configuration Manager server.
Hostname (https://ccr.oracle.com) is unknown.
Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL:
Invalid Oracle Support Hub address specified ().
Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL: none
Invalid Oracle Support Hub address specified (none).
Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL: NONE
Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification:
An invalid proxy specification was given. Please re-enter the proxy information.
Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification:
An invalid proxy specification was given. Please re-enter the proxy information.
Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification: NONE
The OCM configuration response file (/oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp) was successfully created.
[root@cqdbsvr-c1 ~]# /oracle/app/grid/product/11.2.0/grid_home/OPatch/opatch auto /home/grid/GIPSU/28813878/ -ocmrf /oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp
Executing /oracle/app/grid/product/11.2.0/grid_home/perl/bin/perl /oracle/app/grid/product/11.2.0/grid_home/OPatch/crs/patch11203.pl -patchdir /home/grid/GIPSU -patchn 28813878 -ocmrf /oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp -paramfile /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
This is the main log file: /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-12_10-06-08.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-12_10-06-08.report.log
2019-08-12 10:06:08: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
unable to get oracle owner for
这个错误的主要原因是LANG环境变量为中文导致opatch不能准确的获取ORACLE_HOME导致，这应该算是opatch的一个BUG了，但Oracle认为这只是个PROBLEM。
OPATCH AUTO Fails with “unable to get oracle owner for” in Multi-Byte Language Environment [ID 1325256.1]
[root@cqdbsvr-c1 db_home]# echo $LANG
zh_CN.UTF-8
[root@cqdbsvr-c1 db_home]#
[root@cqdbsvr-c1 db_home]# export LANG=C
再次执行，报下面的错误：
ERROR: Unable to run lspatches on /oracle/app/oracle/product/11.2.0/db_home
解决： db 软件的 opatch 和grid不一致，不小心copy一个p6880880_121000_Linux.zip到db的$ORACLE_HOME引起。
- OPatch apply
[root@cqdbsvr-c1 db_home]# /oracle/app/grid/product/11.2.0/grid_home/OPatch/opatch auto /home/grid/GIPSU/28813878/ -ocmrf /oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp
Executing /oracle/app/grid/product/11.2.0/grid_home/perl/bin/perl /oracle/app/grid/product/11.2.0/grid_home/OPatch/crs/patch11203.pl -patchdir /home/grid/GIPSU -patchn 28813878 -ocmrf /oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp -paramfile /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
This is the main log file: /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-12_10-45-15.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-12_10-45-15.report.log
2019-08-12 10:45:15: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
The opatch minimum version check for patch /home/grid/GIPSU/28813878/28729234/custom/server/28729234 failed for /oracle/app/oracle/product/11.2.0/db_home
The opatch minimum version check for patch /home/grid/GIPSU/28813878/28729262 failed for /oracle/app/oracle/product/11.2.0/db_home
Opatch version check failed for oracle home /oracle/app/oracle/product/11.2.0/db_home
Opatch version check failed
ERROR: update the opatch version for the failed homes and retry
[root@cqdbsvr-c1 11.2.0]# less /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-12_10-47-25.report.log
*********** Configuration Data ***********
* It shows only those targets that will be patched in this session *
crs_home=/oracle/app/grid/product/11.2.0/grid_home owner=grid opatch_ver=11.2.0.3.19
rac_home=/oracle/app/oracle/product/11.2.0/db_home owner=oracle opatch_ver=11.2.0.3.19
*********** Steps to be executed as owner unless specified as root ***********
drwxr-x--- 70 root oinstall 4096 Aug 12 10:12 grid_home
[root@cqdbsvr-c1 11.2.0]# chown grid:oinstall grid_home/
[root@cqdbsvr-c1 db_home]# cd /oracle/app/oracle/product/11.2.0
[root@cqdbsvr-c1 db_home]# ll ./
drwxrwxr-x 76 grid oinstall 4096 Aug 12 10:55 db_home
[root@cqdbsvr-c1 11.2.0]# chown oracle:oinstall db_home/
加上-oh参数，指定grid_home.
[root@cqdbsvr-c1 db_home]# /oracle/app/grid/product/11.2.0/grid_home/OPatch/opatch auto /home/grid/GIPSU/28813878/ -ocmrf /oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp -oh /oracle/app/grid/product/11.2.0/grid_home
Executing /oracle/app/grid/product/11.2.0/grid_home/perl/bin/perl /oracle/app/grid/product/11.2.0/grid_home/OPatch/crs/patch11203.pl -patchdir /home/grid/GIPSU -patchn 28813878 -ocmrf /oracle/app/grid/product/11.2.0/grid_home/OPatch/ocm/bin/ocm.rsp -oh /oracle/app/grid/product/11.2.0/grid_home -paramfile /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
This is the main log file: /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-13_01-20-31.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatchauto2019-08-13_01-20-31.report.log
2019-08-13 01:20:31: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
Stopping CRS...
Stopped CRS successfully
patch /home/grid/GIPSU/28813878/28729234 apply successful for home /oracle/app/grid/product/11.2.0/grid_home
patch /home/grid/GIPSU/28813878/28729262 apply successful for home /oracle/app/grid/product/11.2.0/grid_home
patch /home/grid/GIPSU/28813878/28729245 apply successful for home /oracle/app/grid/product/11.2.0/grid_home
Starting CRS...
CRS-4123: Oracle High Availability Services has been started.
opatch auto succeeded.
- 验证
[root@cqdbsvr-c1 ~]# su - grid
[grid@cqdbsvr-c1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle 中间补丁程序安装程序版本 11.2.0.3.19
版权所有 (c) 2019, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/grid/product/11.2.0/grid_home
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/grid/product/11.2.0/grid_home/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatch/opatch2019-08-13_01-34-02上午_1.log
Lsinventory Output file location : /oracle/app/grid/product/11.2.0/grid_home/cfgtoollogs/opatch/lsinv/lsinventory2019-08-13_01-34-02上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: cqdbsvr-c1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
中间补丁程序 (3) :
Patch 28729245 : applied on Tue Aug 13 01:27:27 CST 2019
Unique Patch ID: 22546711
Patch description: "ACFS Patch Set Update : 11.2.0.4.190115 (28729245)"
Created on 2 Nov 2018, 04:47:07 hrs PST8PDT
Bugs fixed:
28069955, 26247490, 21369858, 16318126, 19690653, 17503605, 17203009
17359415, 20140148, 17611362, 25098392, 17270418, 17164243, 19053182
17696547, 17488768, 25078431, 18168684, 21519796, 18143006, 21208140
23321114, 17428148, 17070158, 20438706, 17510275, 17172303, 28142134
18610307, 17376318, 17721778, 22198405, 17699423, 22810422, 18915417
21233961, 18155334, 25381434, 19919907, 18321597, 18185024, 17363999
17636008, 27593263, 20681968, 17475946, 27463879
Patch 28729262 : applied on Tue Aug 13 01:26:25 CST 2019
Unique Patch ID: 22664181
Patch description: "Database Patch Set Update : 11.2.0.4.190115 (28729262)"
Created on 19 Dec 2018, 22:33:21 hrs PST8PDT
Sub-patch 28204707; "Database Patch Set Update : 11.2.0.4.181016 (28204707)"
Sub-patch 27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"
Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"
Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17184721, 21174504, 21538558, 16091637, 18092127, 17381384, 15979965
20671094, 16731148, 16314254, 13837378, 18441944, 23105538, 17291347
17835048, 28254374, 13558557, 21842740, 21656630, 17008068, 17201159
25427662, 17853498, 20717359, 17246576, 18356166, 18681862, 18440047
20569094, 20031873, 16875449, 20387265, 19788842, 17296856, 21330264
14010183, 17648596, 17025461, 17551063, 24719736, 17267114, 21063322
22507210, 17912217, 17889583, 18202441, 17040764, 17478145, 16524926
25655390, 19358317, 22730454, 22148226, 18747196, 26544823, 18641419
17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 17359610
16618694, 8322815, 16832076, 18247991, 16692232, 22507234, 17570240
13871092, 24624166, 26631046, 19429927, 24348685, 17848897, 17441661
14034426, 17465741, 20273319, 19207156, 16596890, 17437634, 21343897
20506706, 18339044, 21453153, 17951233, 21795111, 22321741, 18430495
21787056, 22380919, 19469538, 19692824, 20506715, 17811429, 17903598
19721304, 18230522, 19554106, 19458377, 21281607, 17612828, 6599380
22092979, 17040527, 22321756, 17811438, 18641461, 18682983, 14657740
25635149, 13364795, 19490948, 21387964, 17346671, 17588480, 22351572
18235390, 18849970, 26474853, 17889549, 19309466, 16472716, 25775213
20596234, 18331850, 18641451, 17019356, 17344412, 19461270, 21179898
17546761, 24842886, 17231779, 14521849, 18203835, 18203838, 18964939
18203837, 17313525, 22195457, 18139690, 16837842, 14106803, 22296366
17842825, 22657942, 21352646, 16360112, 22594718, 20657441, 22195441
17389192, 26198926, 14565184, 17019345, 17205719, 18740837, 18440095
14764829, 22195448, 14354737, 17019086, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 27374796, 19972569
19972568, 20144308, 19972566, 17282229, 19972564, 16870214, 16410570
21629064, 19615136, 26039623, 21354456, 17390431, 18762750, 23007241
16613964, 17957017, 18098207, 17484762, 18471685, 19730508, 18264060
21538485, 17323222, 17754782, 17600719, 18317531, 17852463, 17596908
17655634, 18166013, 16228604, 20074391, 27053456, 24790914, 19972570
20856766, 19891090, 18090142, 18996843, 16042673, 19854503, 22901797
17835627, 20334344, 17393683, 20861693, 18000422, 17551709, 26575788
23315889, 20506699, 19006849, 18277454, 18456514, 19174430, 17258090
17174582, 25654936, 17242746, 27097854, 16399083, 17824637, 21132297
22465352, 17762296, 22168163, 18604692, 17397545, 16450169, 12364061
20067212, 18856999, 19211724, 19463893, 19463897, 21343775, 17853456
18673304, 20004021, 26030218, 21668627, 16194160, 17477958, 23140259
16538760, 12982566, 24570598, 20828947, 18259031, 20296213, 28855981
18293054, 17610798, 19699191, 23065323, 17311728, 18135678, 18774543
23294548, 16785708, 10136473, 24560906, 19777862, 22551446, 17786518
25879984, 18315328, 18334586, 12747740, 18096714, 19032867, 21641760
17390160, 18899974, 17232014, 20598042, 26245237, 26679352, 16354467
17484731, 18673325, 16422541, 18155762, 19827973, 14015842, 22683225
17726838, 18554871, 23177648, 18051556, 20803583, 21972320, 15990359
17922254, 18282562, 16855292, 16668584, 21343838, 20299015, 17446237
18043064, 18093615, 23713236, 17694209, 17288409, 20475845, 18308268
17274537, 13955826, 16934803, 17634921, 17501491, 16315398, 23725036
22683212, 17006183, 13829543, 18191164, 26746894, 22809871, 17655240
28819280, 18384391, 19393542, 21538567, 16198143, 21847223, 25823754
17892268, 20142975, 19584068, 17165204, 25165496, 18604493, 21756699
18508861, 18554763, 16901385, 21532755, 18189036, 17443671, 17385178
14829250, 17936109, 20925795, 20509482, 17478514, 27441326, 16850630
13951456, 16595641, 14054676, 15861775, 21142837, 16912439, 17299889
17297939, 23003979, 16833527, 18619917, 17798953, 19697993, 17816865
25914276, 18607546, 17571306, 21286665, 17341326, 26910644, 17851160
17586955, 20558005, 19049453, 21051840, 17587063, 16956380, 18328509
25423453, 29033139, 14133975, 19718981, 18061914, 18522509, 17518652
21051833, 20294666, 18765602, 20860659, 18272672, 20324049, 18199537
17332800, 13609098, 22502493, 18384537, 14338435, 17945983, 16392068
21067387, 17752995, 21051862, 16863422, 17237521, 25505382, 18244962
19544839, 24433711, 24717859, 17156148, 18973907, 23026585, 17449815
17877323, 18180390, 17088068, 17037130, 20004087, 21422580, 19466309
11733603, 25505371, 18610915, 21051858, 18084625, 18674024, 26243698
21051852, 18091059, 18306996, 25369547, 16306373, 17787259, 18193833
19915271, 20513399, 20631274, 16344544, 25879656, 14692762, 18614015
17346091, 18228645, 17721717, 13960236, 18685892, 18436307, 19888853
21756677, 11883252, 17891943, 19475971, 22353199, 16384983, 19121551
25634317, 27825893, 12816846, 17982555, 17761775, 22243719, 17265217
25505394, 17071721, 16721594, 18262334, 21756661, 17891946, 15913355
17672719, 17602269, 17239687, 17042658, 25555252, 17238511, 17811456
17284817, 17752121, 20879889, 28806384, 21380789, 17394950, 17011832
16579084, 22195465, 14602788, 28790634, 18325460, 27567477, 24476265
26569225, 24476274, 12611721, 18674465, 16903536, 17006570, 19689979
28076295, 16043574, 18783224, 24662775, 16494615, 21526048, 17392698
19197175, 16069901, 17811447, 27870645, 28876684, 17308789, 24835538
22195477, 17865671, 17343514, 19013183, 17325413, 18316692, 16180763
17348614, 14368995, 21983325, 17393915, 16285691, 19211433, 20331945
17883081, 17705023, 24316947, 17614227, 19578350, 22195485, 14084247
24975421, 26078387, 23115139, 13645875, 16777840, 19727057, 14852021
18744139, 18674047, 17716305, 19285025, 18482502, 17622427, 19289642
27534509, 25947799, 22195492, 14458214, 20869721, 21172913, 17767676
18723434, 25505407, 17786278, 19258504, 17082983, 17365043, 21351877
13498382, 18331812, 16065166, 25489607, 16685417, 18031668, 22893153
17551674, 16943711, 19272701, 21517440, 25897615, 17649265, 13866822
18094246, 24528741, 17783588, 14245531, 17082359, 18280813, 20448824
23330119, 16268425, 19487147, 25600421, 18018515, 17302277, 17215560
24411921, 19271443, 14176370, 25764020, 17016369, 20777150, 16756406
23330124, 20441797, 19769489, 28100487, 17545847, 25093656, 18260550
13853126, 17227277, 17551699, 23536835, 25957038, 24652769, 20725343
19207117, 9756271, 18868646, 17614134, 26667023, 17546973, 18704244
19680952, 26667015, 17050888, 18273830, 18828868, 17360606, 16992075
24563422, 17375354, 12905058, 18362222, 21429602, 26667032, 28364007
27086138, 17571039, 17468141, 18436647, 17570606, 17235750, 21168487
17279227, 16220077, 16929165
Patch 28729234 : applied on Tue Aug 13 01:24:52 CST 2019
Unique Patch ID: 22546711
Patch description: "OCW Patch Set Update : 11.2.0.4.190115 (28729234)"
Created on 8 Nov 2018, 23:01:45 hrs PST8PDT
Bugs fixed:
18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
20365005, 21232394, 17336871, 17387214, 17750548, 17617807, 14497275
20219458, 17733927, 18180541, 23757020, 18962892, 17292250, 17378618
16759171, 20110156, 17843489, 17065496, 13991403, 21694632, 17273020
22762046, 17336884, 17155238, 17336889, 18261183, 18053580, 20012766
21245437, 20218012, 17013634, 17886392, 20995001, 24422155, 17039197
16317771, 17947785, 10052729, 20340620, 22353346, 16237657, 20317221
18199185, 15917869, 18399991, 20186278, 18024089, 17374271, 16849642
20246071, 20746251, 14270845, 23621494, 20552947, 18414137, 18882642
17001914, 17927970, 14378120, 16346413, 15986647, 17336898, 18068871
21222147, 16206997, 18143836, 21982225, 25490238, 19168690, 18343490
20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
17500165, 18875012, 14769643, 25656952, 19558324, 18464784, 18848125
19241857, 17955615, 14851828, 14693336, 20315294, 16284825, 17352230
20014326, 17238586, 17089344, 17405605, 17531342, 21327402, 26546632
19398098, 17159489, 17640316, 13823394, 16543190, 22024217, 17983675
20795241, 17481314, 18346135, 17598201, 16281493, 15986311, 17208793
19601468, 18999857, 18700935, 14076173, 18428146, 16709532, 17435488
18352845, 18352846, 20408163, 17592037, 19616601, 17387779, 17391726
14777968, 15851860, 16206882, 20141091, 15832129, 17305100, 20175174
21113068, 19885321, 16901346, 17985714, 25591658, 18536826, 17780903
18752378, 18946768, 16876500, 16875342, 17769597, 19955755, 16429265
18336452, 17273003, 17209968, 25484507, 16988311, 19319357, 20094984
17046460, 17059927, 18053631, 16867761, 18774591, 21442094, 20235486
19359787, 15869775, 17447588, 19642566, 21152052, 16798862, 15920201
--------------------------------------------------------------------------------
OPatch succeeded.
Oracle用户
- 备份并拷贝OPatch
[root@cqdbsvr-c1 software]# cp -R /home/grid/GIPSU/ /home/oracle/
[root@cqdbsvr-c1 ~]# chown -R oracle:oinstall /home/oracle/GIPSU/
[root@cqdbsvr-c1 ~]# chmod -R 775 /home/oracle/GIPSU/
[root@cqdbsvr-c1 software]# mv /oracle/app/oracle/product/11.2.0/db_home/OPatch/ /oracle/app/oracle/product/11.2.0/db_home/OPatch.bak
[root@cqdbsvr-c1 software]# cp p6880880_112000_Linux-x86-64.zip /oracle/app/oracle/product/11.2.0/db_home/
[root@cqdbsvr-c1 db_home]# chown -R oracle:oinstall OPatch
- 检查需要打的补丁与现有补丁是否冲突
[oracle@cqdbsvr-c1 ~]$ su - oracle
[oracle@cqdbsvr-c1 ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/GIPSU/28813878 -oh $ORACLE_HOME
Oracle 中间补丁程序安装程序版本 11.2.0.3.19
版权所有 (c) 2019, Oracle Corporation。保留所有权利。
PREREQ session
Oracle Home : /oracle/app/oracle/product/11.2.0/db_home
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0/db_home/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/opatch2019-08-13_02-09-17上午_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
- 检查Inventory一致性
[oracle@cqdbsvr-c1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle 中间补丁程序安装程序版本 11.2.0.3.19
版权所有 (c) 2019, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/app/oracle/product/11.2.0/db_home
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0/db_home/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/opatch2019-08-13_02-10-01上午_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatch/lsinv/lsinventory2019-08-13_02-10-01上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: cqdbsvr-c1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Database 11g 11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
已安装的产品 (136):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Database Configuration and Upgrade Assistants 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Database Workspace Manager 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Edition Options 11.2.0.4.0
Enterprise Manager Agent 10.2.0.4.5
Enterprise Manager Agent Core Files 10.2.0.4.5
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support 11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support 11.2.0.4.0
Enterprise Manager Grid Control Core Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Enterprise Manager Repository Core Files 10.2.0.4.5
Exadata Storage Server 11.2.0.1.0
Expat libraries 2.0.1.0.1
Generic Connectivity Common Files 11.2.0.4.0
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
JAccelerator (COMPANION) 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle 11g Warehouse Builder Required Files 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Application Express 11.2.0.4.0
Oracle Call Interface (OCI) 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Code Editor 1.2.1.0.0I
Oracle Configuration Manager 10.3.8.1.0
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Data Mining RDBMS Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database Gateway for ODBC 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle Database Vault J2EE Application 11.2.0.4.0
Oracle Database Vault option 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Display Fonts 9.0.2.0.0
Oracle Enterprise Manager Console DB 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Help For Java 4.2.9.0.0
Oracle Help for the Web 2.0.14.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC Server Support Package 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle Label Security 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Message Gateway Common Files 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Annotator 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Net Services 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle ODBC Driver 11.2.0.4.0
Oracle ODBC Driverfor Instant Client 11.2.0.4.0
Oracle OLAP 11.2.0.4.0
Oracle OLAP API 11.2.0.4.0
Oracle OLAP RDBMS Files 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Partitioning 11.2.0.4.0
Oracle Programmer 11.2.0.4.0
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Real Application Testing 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Spatial 11.2.0.4.0
Oracle SQL Developer 11.2.0.4.0
Oracle Starter Database 11.2.0.4.0
Oracle Text 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle UIX 2.2.24.6.0
Oracle Universal Connection Pool 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Oracle XML Development Kit 11.2.0.4.0
Oracle XML Query 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Common Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
Provisioning Advisor Framework 10.2.0.4.3
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
regexp 2.1.9.0.0
Required Support Files 11.2.0.4.0
Sample Schema Data 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SQLJ Runtime 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
XML Parser for Oracle JVM 11.2.0.4.0
此 Oracle 主目录中已安装 136 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
--------------------------------------------------------------------------------
OPatch succeeded.
- 配置ocm
[oracle@cqdbsvr-c1 ~]$ cd $ORACLE_HOME/OPatch/ocm/bin
[oracle@cqdbsvr-c1 bin]$ ./emocmrsp -no_banner -output $ORACLE_HOME/OPatch/ocm/bin/ocm.rsp
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: 307185292@qq.com
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):
Unable to establish connection to Oracle Configuration Manager server.
Hostname (https://ccr.oracle.com) is unknown.
Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL: NONE
Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
[<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification: NONE
The OCM configuration response file (/oracle/app/oracle/product/11.2.0/db_home/OPatch/ocm/bin/ocm.rsp) was successfully created.
- OPatch apply
su - root
[root@cqdbsvr-c1 ~]# /oracle/app/oracle/product/11.2.0/db_home/OPatch/opatch auto /home/oracle/GIPSU/28813878/ -local -silent -ocmrf /oracle/app/oracle/product/11.2.0/db_home/OPatch/ocm/bin/ocm.rsp -oh /oracle/app/oracle/product/11.2.0/db_home
Executing /oracle/app/grid/product/11.2.0/grid_home/perl/bin/perl /oracle/app/oracle/product/11.2.0/db_home/OPatch/crs/patch11203.pl -patchdir /home/oracle/GIPSU -patchn 28813878 -ocmrf /oracle/app/oracle/product/11.2.0/db_home/OPatch/ocm/bin/ocm.rsp -oh /oracle/app/oracle/product/11.2.0/db_home -paramfile /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
This is the main log file: /oracle/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatchauto2019-08-13_02-13-54.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/app/oracle/product/11.2.0/db_home/cfgtoollogs/opatchauto2019-08-13_02-13-54.report.log
2019-08-13 02:13:54: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/app/grid/product/11.2.0/grid_home/crs/install/crsconfig_params
Stopping RAC /oracle/app/oracle/product/11.2.0/db_home ...
Stopped RAC /oracle/app/oracle/product/11.2.0/db_home successfully
patch /home/oracle/GIPSU/28813878/28729234/custom/server/28729234 apply successful for home /oracle/app/oracle/product/11.2.0/db_home
patch /home/oracle/GIPSU/28813878/28729262 apply successful for home /oracle/app/oracle/product/11.2.0/db_home
Starting RAC /oracle/app/oracle/product/11.2.0/db_home ...
Started RAC /oracle/app/oracle/product/11.2.0/db_home successfully
opatch auto succeeded.
- 升级数据字典
su - oracle
cd $ORACLE_HOME/rdbms/admin
[oracle@cqdbsvr-c1 admin# sqlplus / as sysdba
SQL> @catbundle.sql psu apply
SQL> set line 150
SQL> col action_time for a30
SQL> col action for a8
SQL> col namespace for a8
SQL> col version for a10
SQL> col bundle_series for a5
SQL> col comments for a40
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- ----------------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
24-OCT-16 04.57.07.916237 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
24-OCT-16 10.49.21.585728 AM APPLY SERVER 11.2.0.4 161018 PSU PSU 11.2.0.4.161018
3 rows selected.
参考
http://oraerrors.blogspot.com/2016/10/silent-installationconfiguration-of.html
http://hemendraoracleblogs.blogspot.com/2014/01/install-oracle-11gr2-grid-for.html
5463
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
