当前位置: 首页 > UPDATE > 正文

(Gi Standalone) 11.2.0.3升级到11.2.0.3.7

下面测试的是gi standalone 11.2.0.3手动升级到11.2.0.3.7

测试环境:os:rhel 5.8    db:11.2.03    sf:5.1

1,数据库软件
2,停数据库HOME
3,Save database home configuration
4,停gi与unlock gi home
5,更新opatch工具
6,grid目录打补丁
7,给rdbms打补丁
8,Restore database home configuration:
9,lock gi home与startup gi
10,Start database home on the node
11,更新数据字典
12,查看升级后的版本

1,安装数据库

   本测试采用的一个全新的系统,采用silent的方式来安装的。

1.1 配置主机参数
[root@asm11g ~]# echo "fs.aio-max-nr = 1048576
> fs.file-max = 6815744
> kernel.shmall = 2097152
> kernel.shmmax = 11036870912
> kernel.shmmni = 4096
> 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">>/etc/sysctl.conf
1.2 配置资源限制
[root@asm11g ~]# echo "oracle soft nproc 2047
> oracle hard nproc 16384
> oracle soft nofile 1024
> oracle hard nofile 65536
> grid   soft nproc 2047
> grid   hard nproc 16384
> grid   soft nofile 1024
> grid   hard nofile 65536">>/etc/security/limits.conf
[root@asm11g ~]# tail -8 /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
grid   soft nproc 2047
grid   hard nproc 16384
grid   soft nofile 1024
grid   hard nofile 65536
1.3 创建用户
[root@asm11g ~]# echo "session required pam_limits.so">>/etc/pam.d/login
[root@asm11g ~]# tail -1 /etc/pam.d/login
session required pam_limits.so
[root@asm11g ~]# /usr/sbin/groupadd -g 501 oinstall
[root@asm11g ~]# /usr/sbin/groupadd -g 502 dba
[root@asm11g ~]# /usr/sbin/groupadd -g 504 asmadmin
[root@asm11g ~]# /usr/sbin/groupadd -g 506 asmdba
[root@asm11g ~]# /usr/sbin/groupadd -g 507 asmoper
[root@asm11g ~]# /usr/sbin/useradd -u 501 -g oinstall -G dba,asmadmin,asmdba,asmoper grid
/usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle
[root@asm11g ~]# /usr/sbin/useradd -u 502 -g oinstall -G dba,asmdba oracle
echo "oracle"|passwd grid --stdin
[root@asm11g ~]# echo "oracle"|passwd oracle --stdin
Changing password for user oracle.
passwd: all authentication tokens updated successfully.
[root@asm11g ~]# echo "oracle"|passwd grid --stdin
Changing password for user grid.
passwd: all authentication tokens updated successfully.
[root@asm11g ~]#
1.4 配置yum资源库
[root@asm11g ~]# echo "
> [RHEL5.6]
> name = Enterprise Linux 5.5 DVD
> baseurl=file:///media/Server/
> gpgcheck=0
> enabled=1">/etc/yum.repos.d/public-yum-el5.repo
[root@asm11g ~]# tail -5 /etc/yum.repos.d/public-yum-el5.repo
[RHEL5.6]
name = Enterprise Linux 5.5 DVD
baseurl=file:///media/Server/
gpgcheck=0
enabled=1
[root@asm11g ~]# 
[root@asm11g ~]# /bin/mount /dev/cdrom /media
mount: block device /dev/cdrom is write-protected, mounting read-only
1.5 安装软件
[root@asm11g ~]# yum install sysstat unixODBC unixODBC-devel libaio-devel
1.6 创建asm磁盘的lv
[root@asm11g ~]# vxprint -u|grep ^v
v  asmlv1       fsgen        ENABLED  2g       -        ACTIVE   -       -
v  asmlv2       fsgen        ENABLED  2g       -        ACTIVE   -       -
v  asmlv3       fsgen        ENABLED  2g       -        ACTIVE   -       -
v  asmlv4       fsgen        ENABLED  2g       -        ACTIVE   -       -
v  asmlv5       fsgen        ENABLED  2g       -        ACTIVE   -       -
[root@asm11g ~]# vxedit -g datadg set user=grid group=asmadmin asmlv{1,2,3,4,5}
[root@asm11g ~]# ls -l /dev/vx/rdsk/datadg/*
crw------- 1 grid asmadmin 199, 7000 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv1
crw------- 1 grid asmadmin 199, 7001 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv2
crw------- 1 grid asmadmin 199, 7002 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv3
crw------- 1 grid asmadmin 199, 7003 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv4
crw------- 1 grid asmadmin 199, 7004 Sep 18 08:09 /dev/vx/rdsk/datadg/asmlv5
1.7 配置.bash_profile
[grid@asm11g ~]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_SID=+ASM
export DISPLAY=192.168.111.1:0.0
stty erase ^h
set -o vi
1.8 安装cvuqdisk软件
[root@asm11g rpm]# rpm -vih cvuqdisk-1.0.9-1.rpm 
Preparing...                ########################################### [100%]
Using default group oinstall to install package
   1:cvuqdisk               ########################################### [100%]
1.9 安装grid
[grid@asm11g grid]$ ./runInstaller   -silent -responseFile /home/grid/grid.rsp
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 23231 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 8191 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-18_05-53-03PM. Please wait ...[grid@asm11g grid]$ [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.
   CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
   ACTION: Provide a password that conforms to the Oracle recommended standards.
[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.
   CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
   ACTION: Provide a password that conforms to the Oracle recommended standards.
[WARNING] [INS-32018] The selected Oracle home is outside of Oracle base.
   CAUSE: The Oracle home selected was outside of Oracle base.
   ACTION: Oracle recommends installing Oracle software within the Oracle base directory. Adjust the Oracle home or Oracle base accordingly.
You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2013-09-18_05-53-03PM.log
The installation of Oracle Grid Infrastructure was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2013-09-18_05-53-03PM.log' for more details.

As a root user, execute the following script(s):
        1. /u01/app/oraInventory/orainstRoot.sh
        2. /u01/app/11.2.0/grid/root.sh


As install user, execute the following script to complete the configuration.
        1. /u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands

        Note:
        1. This script must be run on the same system from where installer was run. 
        2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).


Successfully Setup Software.
[root@asm11g ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@asm11g ~]# /u01/app/11.2.0/grid/root.sh
Check /u01/app/11.2.0/grid/install/root_asm11g_2013-09-18_17-56-14.log for the output of root script
[root@asm11g ~]# /u01/app/11.2.0/grid/cfgtoollogs/configToolAllCommands
Setting the invPtrLoc to /u01/app/11.2.0/grid/oraInst.loc

perform - mode is starting for action: configure


perform - mode finished for action: configure

You can see the log file: /u01/app/11.2.0/grid/cfgtoollogs/oui/configActions2013-09-18_05-56-43-PM.log

1.10 配置asm
[grid@asm11g ~]$ asmca -silent  -configureASM -sysAsmPassword oracle -asmsnmpPassword oracle -diskString '/dev/vx/rdsk/datadg/*'  -diskGroupName DATA -disk '/dev/vx/rdsk/datadg/asmlv1' -redundancy EXTERNAL -au_size 1 -compatible.asm 11.2 -compatible.rdbms 11.2 -compatible.advm 11.2

ASM created and started successfully.

Disk Group DATA created successfully.

[grid@asm11g ~]$ crsctl stat resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       asm11g                                       
ora.asm
               ONLINE  ONLINE       asm11g                   Started             
ora.ons
               OFFLINE OFFLINE      asm11g                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       asm11g                                       
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       asm11g
1.11 安装db
[oracle@asm11g database]$ ./runInstaller  -silent -responseFile /home/oracle/db.rsp
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 20213 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 8191 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-09-18_06-43-20PM. Please wait ...[oracle@asm11g database]$ You can find the log of this install session at:
 /u01/app/oraInventory/logs/installActions2013-09-18_06-43-20PM.log
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2013-09-18_06-43-20PM.log' for more details.

As a root user, execute the following script(s):
        1. /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

[root@asm11g OraInstall2013-09-18_05-42-30PM]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh
Check /u01/app/oracle/product/11.2.0/dbhome_1/install/root_asm11g_2013-09-18_18-46-16.log for the output of root script
[root@asm11g OraInstall2013-09-18_05-42-30PM]# 
1.12 配置监听
[grid@asm11g ~]$ srvctl add listener -l listener -o $ORACLE_HOME  -p 1521
[grid@asm11g ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       asm11g                                       
ora.LISTENER.lsnr
               OFFLINE OFFLINE      asm11g                                       
ora.asm
               ONLINE  ONLINE       asm11g                   Started             
ora.ons
               OFFLINE OFFLINE      asm11g                                       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       asm11g                                       
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       asm11g                                       
[grid@asm11g ~]$ crsctl start resource ora.LISTENER.lsnr
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'asm11g'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'asm11g' succeeded
1.13 创建数据库
略

整个数据库安装已经完成,下面开始升级

2.停数据库HOME

[oracle@asm11g ~]$ srvctl stop home -o $ORACLE_HOME -s /tmp/oracle_home_stop.out
[oracle@asm11g ~]$ cat /tmp/oracle_home_stop.out 
db-asm11g

如果有多个ORACLE_HOME需要在每一个目录中运行,这里注意-s后面给的文件名,我们在升级完成后需要用到,不过建议停数据库前,先手动停监听,再切日志,再kill掉用户进程,再切日志后,再停数据库。

srvctl stop listener -l listener
sqlplus / as sysdba
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
!ps -ef|grep LOCAL=NO|grep $ORACLE_SID|grep -v grep|awk '{print $2}'|xargs kill -9
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

3,Save database home configuration

此步骤只有需要应用gi patch到rdbms的时候才需要

[oracle@asm11g ~]$ /tmp/16742216/16619898/custom/server/16619898/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/tmp/16742216/16619898/custom/server/16619898/custom/scripts/prepatch.sh completed successfully.

如果有多个ORACLE_HOME目录的时候,需要在每一个ORACLE_HOME执行些操作。

4,停gi与unlock gi home

[root@asm11g 16619898]# $GRID_HOME/crs/install/roothas.pl -unlock
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Successfully unlock /u01/app/11.2.0/grid

5,更新opatch工具

[grid@asm11g ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/opatch
[grid@asm11g ~]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip  -d $ORACLE_HOME
[grid@asm11g ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4

OPatch succeeded.

6,grid目录打补丁

[grid@asm11g tmp]$ $ORACLE_HOME/OPatch/opatch napply /tmp/16742216/ -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-09-18_22-11-08PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  16619898  

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: 7343696@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




Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/11.2.0/grid')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/11.2.0/grid'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14275605' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14727310' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '16056266' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] , [ oracle.ovm, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '16619892' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.marvel, 11.2.0.3.0 ] , [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.sysman.agent, 10.2.0.4.3 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] , [ oracle.xdk, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...
Applying interim patch '16619898' to OH '/u01/app/11.2.0/grid'

Patching component oracle.crs, 11.2.0.3.0...

Patching component oracle.usm, 11.2.0.3.0...

Verifying the update...
Composite patch 16619892 successfully applied.
Patch 16619898 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2013-09-18_22-11-08PM_1.log

OPatch succeeded.

7,给rdbms打补丁

     如果有多个ORACLE_HOME,需要在每个ORACLE_HOME下面执行命令

[oracle@asm11g ~]$ unzip /tmp/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
[oracle@asm11g ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /tmp/16742216/16619898/custom/server/ -oh $ORACLE_HOME -id 16619898
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-18-58PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   16619898  

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: 7343696@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




Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '16619898' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Verifying the update...
Patch 16619898 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-18-58PM_1.log

OPatch succeeded.
[oracle@asm11g ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch napply /tmp/16742216/16619892 -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-26-30PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '16056266' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.ovm, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '16619892' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.marvel, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sysman.agent, 10.2.0.4.3...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.repository.core, 10.2.0.4.4...

Patching component oracle.xdk, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'



OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'


Composite patch 16619892 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-09-18_22-26-30PM_1.log

OPatch completed with warnings.

8 Restore database home configuration:

[oracle@asm11g ~]$ /tmp/16742216/16619898/custom/server/16619898/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /u01/app/oracle/product/11.2.0/dbhome_1/install/params.ora..
Reading /u01/app/oracle/product/11.2.0/dbhome_1/install/params.ora..
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/gnsd
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/crsdiag.pl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libhasgen11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclsra11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libdbcfg11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libocr11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libocrb11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libocrutl11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libuini11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/librdjni11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libgns11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libgnsjni11.so
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/lib/libagfw11.so

如果有多个ORACLE_HOME的时候,更新每一个ORACLE_HOME

9,lock gi home与startup gi

[root@asm11g ~]# $GRID_HOME/rdbms/install/rootadd_rdbms.sh
[root@asm11g ~]# $GRID_HOME/crs/install/roothas.pl -patch
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-4123: Oracle High Availability Services has been started.

10,Start database home on the node

[oracle@asm11g ~]$ srvctl start home -o $ORACLE_HOME -s /tmp/oracle_home_stop.out 
这里需要注意的是-s后面接的文件名,是第2步生成的文件名,如果有多个ORACLE_HOME的时候,需要启动每一个ORACLE_HOME

11 更新数据字典

[oracle@asm11g ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 18 22:36:26 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> @?/rdbms/admin/catbundle.sql psu apply

PL/SQL procedure successfully completed.


SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '11.2.0.3',
  9     7,
 10     'PSU',
 11     'PSU 11.2.0.3.7');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ASM11G_APPLY_2013Sep18_22_36_45.log

12,查看升级后的版本

SQL> set lines 200
SQL> col comments for a40
SQL> select action,comments from dba_registry_history;

ACTION                         COMMENTS
------------------------------ ----------------------------------------
APPLY                          Patchset 11.2.0.2.0
APPLY                          Patchset 11.2.0.2.0
APPLY                          PSU 11.2.0.3.7

[oracle@asm11g ~]$ $ORACLE_HOME/OPatch/opatch lspatches
16619892;Database Patch Set Update : 11.2.0.3.7 (16619892)
16619898;Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)

本文固定链接: http://www.htz.pw/2013/09/22/gi-standalone-11-2-0-3%e5%8d%87%e7%ba%a7%e5%88%b011-2-0-3-7.html | 认真就输

该日志由 huangtingzhong 于2013年09月22日发表在 UPDATE 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: (Gi Standalone) 11.2.0.3升级到11.2.0.3.7 | 认真就输