Oracle RAC 11203 在线升级至RAC 11204

目录

1、环境准备

2、环境检查

3、GRID升级

4、Oracle database software 升级

5、FAQ问题

6、DataBase 升级


1、环境准备

root@RAC1 oracle]# mkdir -p /u02/app/grid/
[root@RAC1 oracle]# mkdir -p /u02/app/11.2.0/grid
[root@RAC1 oracle]# mkdir -p /u02/app/oracle/product/11.2.0/dbhome_1
[root@RAC1 oracle]# chown -R grid:oinstall /u02
[root@RAC1 oracle]# chown -R oracle:oinstall /u02/app/oracle/
[root@RAC1 oracle]# chmod -R 775 /u02


grid$.bash_profile

#PATH=$PATH:$HOME/bin
#export ORACLE_SID=+ASM1
#export ORACLE_BASE=/u01/app/grid
#export ORACLE_HOME=/u01/app/11.2.0/grid
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
#export PATH=$ORACLE_HOME/bin:$PATH


export ORACLE_SID=+ASM1
export ORACLE_BASE=/u02/app/grid
export ORACLE_HOME=/u02/app/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export PATH=$ORACLE_HOME/bin:$PATH


2、环境检查

./runcluvfy.sh stage -pre crsinst -upgrade -n RAC1,RAC2 -rolling -src_crshome /u01/app/11.2.0/grid  -dest_crshome /u02/app/11.2.0/grid -dest_version 11.2.0.4.0 -fixup -fixupdir /soft2/grid_install -verbose >/home/grid/grid_check.log
grid@RAC1 ~]$ cat grid_check.log 

Performing pre-checks for cluster services setup 

Checking node reachability...

Check: Node reachability from node "RAC1"
  Destination Node                      Reachable?              
  ------------------------------------  ------------------------
  RAC2                                  yes                     
  RAC1                                  yes                     
Result: Node reachability check passed from node "RAC1"


Checking user equivalence...

Check: User equivalence for user "grid"
  Node Name                             Status                  
  ------------------------------------  ------------------------
  RAC2                                  passed                  
  RAC1                                  passed                  
Result: User equivalence check passed for user "grid"

Checking CRS user consistency
Result: CRS user consistency check successful

Checking node connectivity...

Checking hosts config file...
  Node Name                             Status                  
  ------------------------------------  ------------------------
  RAC2                                  passed                  
  RAC1                                  passed                  

Verification of the hosts config file successful


Interface information for node "RAC2"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 bond0  192.168.168.153 192.168.168.0   0.0.0.0         192.168.168.1   08:94:EF:6D:E1:FC 1500  
 bond0  192.168.168.9   192.168.168.0   0.0.0.0         192.168.168.1   08:94:EF:6D:E1:FC 1500  
 bond1  19.21.68.153    19.21.68.0      0.0.0.0         192.168.168.1   08:94:EF:6D:E1:FE 1500  
 bond1  169.254.133.227 169.254.0.0     0.0.0.0         192.168.168.1   08:94:EF:6D:E1:FE 1500  


Interface information for node "RAC1"
 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU   
 ------ --------------- --------------- --------------- --------------- ----------------- ------
 bond0  192.168.168.151 192.168.168.0   0.0.0.0         192.168.168.1   08:94:EF:6D:E1:48 1500  
 bond0  192.168.168.8   192.168.168.0   0.0.0.0         192.168.168.1   08:94:EF:6D:E1:48 1500  
 bond1  19.21.68.151    19.21.68.0      0.0.0.0         192.168.168.1   08:94:EF:6D:E1:4A 1500  
 bond1  169.254.96.0    169.254.0.0     0.0.0.0         192.168.168.1   08:94:EF:6D:E1:4A 1500  


Check: Node connectivity for interface "bond0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  RAC2[192.168.168.153]           RAC2[192.168.168.9]             yes             
  RAC2[192.168.168.153]           RAC1[192.168.168.151]           yes             
  RAC2[192.168.168.153]           RAC1[192.168.168.8]             yes             
  RAC2[192.168.168.9]             RAC1[192.168.168.151]           yes             
  RAC2[192.168.168.9]             RAC1[192.168.168.8]             yes             
  RAC1[192.168.168.151]           RAC1[192.168.168.8]             yes             
Result: Node connectivity passed for interface "bond0"


Check: TCP connectivity of subnet "192.168.168.0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  RAC1:192.168.168.151            RAC2:192.168.168.153            passed          
  RAC1:192.168.168.151            RAC2:192.168.168.9              passed          
  RAC1:192.168.168.151            RAC1:192.168.168.8              passed          
Result: TCP connectivity check passed for subnet "192.168.168.0"


Check: Node connectivity for interface "bond1"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  RAC2[19.21.68.153]              RAC1[19.21.68.151]              yes             
Result: Node connectivity passed for interface "bond1"


Check: TCP connectivity of subnet "19.21.68.0"
  Source                          Destination                     Connected?      
  ------------------------------  ------------------------------  ----------------
  RAC1:19.21.68.151               RAC2:19.21.68.153               passed          
Result: TCP connectivity check passed for subnet "19.21.68.0"

Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.168.0".
Subnet mask consistency check passed for subnet "19.21.68.0".
Subnet mask consistency check passed.

Result: Node connectivity check passed

Checking multicast communication...

Checking subnet "192.168.168.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.168.0" for multicast communication with multicast group "230.0.1.0" passed.

Checking subnet "19.21.68.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "19.21.68.0" for multicast communication with multicast group "230.0.1.0" passed.

Check of multicast communication passed.

Checking OCR integrity...

OCR integrity check passed

Checking ASMLib configuration.
  Node Name                             Status                  
  ------------------------------------  ------------------------
  RAC2                                  passed                  
  RAC1                                  passed                  
Result: Check for ASMLib configuration passed.

Check: Total memory 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          125.8086GB (1.31919872E8KB)  1.5GB (1572864.0KB)       passed    
  RAC1          125.8085GB (1.31919812E8KB)  1.5GB (1572864.0KB)       passed    
Result: Total memory check passed

Check: Available memory 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          122.0735GB (1.28003392E8KB)  50MB (51200.0KB)          passed    
  RAC1          121.2454GB (1.2713506E8KB)  50MB (51200.0KB)          passed    
Result: Available memory check passed

Check: Swap space 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          31.25GB (3.2767996E7KB)   16GB (1.6777216E7KB)      passed    
  RAC1          31.25GB (3.2767996E7KB)   16GB (1.6777216E7KB)      passed    
Result: Swap space check passed

Check: Free disk space for "RAC2:/u02/app/11.2.0/grid,RAC2:/tmp" 
  Path              Node Name     Mount point   Available     Required      Status      
  ----------------  ------------  ------------  ------------  ------------  ------------
  /u02/app/11.2.0/grid  RAC2          /             137.8184GB    7.5GB         passed      
  /tmp              RAC2          /             137.8184GB    7.5GB         passed      
Result: Free disk space check passed for "RAC2:/u02/app/11.2.0/grid,RAC2:/tmp"

Check: Free disk space for "RAC1:/u02/app/11.2.0/grid,RAC1:/tmp" 
  Path              Node Name     Mount point   Available     Required      Status      
  ----------------  ------------  ------------  ------------  ------------  ------------
  /u02/app/11.2.0/grid  RAC1          /             124.0203GB    7.5GB         passed      
  /tmp              RAC1          /             124.0203GB    7.5GB         passed      
Result: Free disk space check passed for "RAC1:/u02/app/11.2.0/grid,RAC1:/tmp"

Check: User existence for "grid" 
  Node Name     Status                    Comment                 
  ------------  ------------------------  ------------------------
  RAC2          passed                    exists(501)             
  RAC1          passed                    exists(501)             

Checking for multiple users with UID value 501
Result: Check for multiple users with UID value 501 passed 
Result: User existence check passed for "grid"

Check: Group existence for "oinstall" 
  Node Name     Status                    Comment                 
  ------------  ------------------------  ------------------------
  RAC2          passed                    exists                  
  RAC1          passed                    exists                  
Result: Group existence check passed for "oinstall"

Check: Membership of user "grid" in group "oinstall" [as Primary]
  Node Name         User Exists   Group Exists  User in Group  Primary       Status      
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              yes           yes           yes           yes           passed      
  RAC1              yes           yes           yes           yes           passed      
Result: Membership check for user "grid" in group "oinstall" [as Primary] passed

Check: Run level 
  Node Name     run level                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          5                         3,5                       passed    
  RAC1          5                         3,5                       passed    
Result: Run level check passed

Check: Hard limits for "maximum open file descriptors" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  RAC2              hard          65536         65536         passed          
  RAC1              hard          65536         65536         passed          
Result: Hard limits check passed for "maximum open file descriptors"

Check: Soft limits for "maximum open file descriptors" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  RAC2              soft          1024          1024          passed          
  RAC1              soft          1024          1024          passed          
Result: Soft limits check passed for "maximum open file descriptors"

Check: Hard limits for "maximum user processes" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  RAC2              hard          16384         16384         passed          
  RAC1              hard          16384         16384         passed          
Result: Hard limits check passed for "maximum user processes"

Check: Soft limits for "maximum user processes" 
  Node Name         Type          Available     Required      Status          
  ----------------  ------------  ------------  ------------  ----------------
  RAC2              soft          2047          2047          passed          
  RAC1              soft          2047          2047          passed          
Result: Soft limits check passed for "maximum user processes"

There are no oracle patches required for home "/u01/app/11.2.0/grid".

There are no oracle patches required for home "/u02/app/11.2.0/grid".

Check: System architecture 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          x86_64                    x86_64                    passed    
  RAC1          x86_64                    x86_64                    passed    
Result: System architecture check passed

Check: Kernel version 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          2.6.32-696.el6.x86_64     2.6.9                     passed    
  RAC1          2.6.32-696.el6.x86_64     2.6.9                     passed    
Result: Kernel version check passed

Check: Kernel parameter for "semmsl" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              250           250           250           passed          
  RAC1              250           250           250           passed          
Result: Kernel parameter check passed for "semmsl"

Check: Kernel parameter for "semmns" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              32000         32000         32000         passed          
  RAC1              32000         32000         32000         passed          
Result: Kernel parameter check passed for "semmns"

Check: Kernel parameter for "semopm" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              100           100           100           passed          
  RAC1              100           100           100           passed          
Result: Kernel parameter check passed for "semopm"

Check: Kernel parameter for "semmni" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              128           128           128           passed          
  RAC1              128           128           128           passed          
Result: Kernel parameter check passed for "semmni"

Check: Kernel parameter for "shmmax" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              68719476736   68719476736   4294967295    passed          
  RAC1              68719476736   68719476736   4294967295    passed          
Result: Kernel parameter check passed for "shmmax"

Check: Kernel parameter for "shmmni" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              4096          4096          4096          passed          
  RAC1              4096          4096          4096          passed          
Result: Kernel parameter check passed for "shmmni"

Check: Kernel parameter for "shmall" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              2147483648    2147483648    2097152       passed          
  RAC1              2147483648    2147483648    2097152       passed          
Result: Kernel parameter check passed for "shmall"

Check: Kernel parameter for "file-max" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              6815744       6815744       6815744       passed          
  RAC1              6815744       6815744       6815744       passed          
Result: Kernel parameter check passed for "file-max"

Check: Kernel parameter for "ip_local_port_range" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed          
  RAC1              between 9000.0 & 65500.0  between 9000.0 & 65500.0  between 9000.0 & 65500.0  passed          
Result: Kernel parameter check passed for "ip_local_port_range"

Check: Kernel parameter for "rmem_default" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              262144        262144        262144        passed          
  RAC1              262144        262144        262144        passed          
Result: Kernel parameter check passed for "rmem_default"

Check: Kernel parameter for "rmem_max" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              4194304       4194304       4194304       passed          
  RAC1              4194304       4194304       4194304       passed          
Result: Kernel parameter check passed for "rmem_max"

Check: Kernel parameter for "wmem_default" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              262144        262144        262144        passed          
  RAC1              262144        262144        262144        passed          
Result: Kernel parameter check passed for "wmem_default"

Check: Kernel parameter for "wmem_max" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              1048586       1048586       1048576       passed          
  RAC1              1048586       1048586       1048576       passed          
Result: Kernel parameter check passed for "wmem_max"

Check: Kernel parameter for "aio-max-nr" 
  Node Name         Current       Configured    Required      Status        Comment     
  ----------------  ------------  ------------  ------------  ------------  ------------
  RAC2              1048576       1048576       1048576       passed          
  RAC1              1048576       1048576       1048576       passed          
Result: Kernel parameter check passed for "aio-max-nr"

Check: Package existence for "make" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          make-3.81-23.el6          make-3.80                 passed    
  RAC1          make-3.81-23.el6          make-3.80                 passed    
Result: Package existence check passed for "make"

Check: Package existence for "binutils" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          binutils-2.20.51.0.2-5.46.el6  binutils-2.15.92.0.2      passed    
  RAC1          binutils-2.20.51.0.2-5.46.el6  binutils-2.15.92.0.2      passed    
Result: Package existence check passed for "binutils"

Check: Package existence for "gcc(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          gcc(x86_64)-4.4.7-18.el6  gcc(x86_64)-3.4.6         passed    
  RAC1          gcc(x86_64)-4.4.7-18.el6  gcc(x86_64)-3.4.6         passed    
Result: Package existence check passed for "gcc(x86_64)"

Check: Package existence for "libaio(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          libaio(x86_64)-0.3.107-10.el6  libaio(x86_64)-0.3.105    passed    
  RAC1          libaio(x86_64)-0.3.107-10.el6  libaio(x86_64)-0.3.105    passed    
Result: Package existence check passed for "libaio(x86_64)"

Check: Package existence for "glibc(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          glibc(x86_64)-2.12-1.209.el6  glibc(x86_64)-2.3.4-2.41  passed    
  RAC1          glibc(x86_64)-2.12-1.209.el6  glibc(x86_64)-2.3.4-2.41  passed    
Result: Package existence check passed for "glibc(x86_64)"

Check: Package existence for "compat-libstdc++-33(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          compat-libstdc++-33(x86_64)-3.2.3-69.el6  compat-libstdc++-33(x86_64)-3.2.3  passed    
  RAC1          compat-libstdc++-33(x86_64)-3.2.3-69.el6  compat-libstdc++-33(x86_64)-3.2.3  passed    
Result: Package existence check passed for "compat-libstdc++-33(x86_64)"

Check: Package existence for "elfutils-libelf(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          elfutils-libelf(x86_64)-0.164-2.el6  elfutils-libelf(x86_64)-0.97  passed    
  RAC1          elfutils-libelf(x86_64)-0.164-2.el6  elfutils-libelf(x86_64)-0.97  passed    
Result: Package existence check passed for "elfutils-libelf(x86_64)"

Check: Package existence for "elfutils-libelf-devel" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          elfutils-libelf-devel-0.164-2.el6  elfutils-libelf-devel-0.97  passed    
  RAC1          elfutils-libelf-devel-0.164-2.el6  elfutils-libelf-devel-0.97  passed    
Result: Package existence check passed for "elfutils-libelf-devel"

Check: Package existence for "glibc-common" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          glibc-common-2.12-1.209.el6  glibc-common-2.3.4        passed    
  RAC1          glibc-common-2.12-1.209.el6  glibc-common-2.3.4        passed    
Result: Package existence check passed for "glibc-common"

Check: Package existence for "glibc-devel(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          glibc-devel(x86_64)-2.12-1.209.el6  glibc-devel(x86_64)-2.3.4  passed    
  RAC1          glibc-devel(x86_64)-2.12-1.209.el6  glibc-devel(x86_64)-2.3.4  passed    
Result: Package existence check passed for "glibc-devel(x86_64)"

Check: Package existence for "glibc-headers" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          glibc-headers-2.12-1.209.el6  glibc-headers-2.3.4       passed    
  RAC1          glibc-headers-2.12-1.209.el6  glibc-headers-2.3.4       passed    
Result: Package existence check passed for "glibc-headers"

Check: Package existence for "gcc-c++(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          gcc-c++(x86_64)-4.4.7-18.el6  gcc-c++(x86_64)-3.4.6     passed    
  RAC1          gcc-c++(x86_64)-4.4.7-18.el6  gcc-c++(x86_64)-3.4.6     passed    
Result: Package existence check passed for "gcc-c++(x86_64)"

Check: Package existence for "libaio-devel(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          libaio-devel(x86_64)-0.3.107-10.el6  libaio-devel(x86_64)-0.3.105  passed    
  RAC1          libaio-devel(x86_64)-0.3.107-10.el6  libaio-devel(x86_64)-0.3.105  passed    
Result: Package existence check passed for "libaio-devel(x86_64)"

Check: Package existence for "libgcc(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          libgcc(x86_64)-4.4.7-18.el6  libgcc(x86_64)-3.4.6      passed    
  RAC1          libgcc(x86_64)-4.4.7-18.el6  libgcc(x86_64)-3.4.6      passed    
Result: Package existence check passed for "libgcc(x86_64)"

Check: Package existence for "libstdc++(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          libstdc++(x86_64)-4.4.7-18.el6  libstdc++(x86_64)-3.4.6   passed    
  RAC1          libstdc++(x86_64)-4.4.7-18.el6  libstdc++(x86_64)-3.4.6   passed    
Result: Package existence check passed for "libstdc++(x86_64)"

Check: Package existence for "libstdc++-devel(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          libstdc++-devel(x86_64)-4.4.7-18.el6  libstdc++-devel(x86_64)-3.4.6  passed    
  RAC1          libstdc++-devel(x86_64)-4.4.7-18.el6  libstdc++-devel(x86_64)-3.4.6  passed    
Result: Package existence check passed for "libstdc++-devel(x86_64)"

Check: Package existence for "sysstat" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          sysstat-9.0.4-33.el6      sysstat-5.0.5             passed    
  RAC1          sysstat-9.0.4-33.el6      sysstat-5.0.5             passed    
Result: Package existence check passed for "sysstat"

Check: Package existence for "pdksh" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          missing                   pdksh-5.2.14              failed    
  RAC1          missing                   pdksh-5.2.14              failed    
Result: Package existence check failed for "pdksh"

Check: Package existence for "expat(x86_64)" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          expat(x86_64)-2.0.1-13.el6_8  expat(x86_64)-1.95.7      passed    
  RAC1          expat(x86_64)-2.0.1-13.el6_8  expat(x86_64)-1.95.7      passed    
Result: Package existence check passed for "expat(x86_64)"

Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed 

Check: Current group ID 
Result: Current group ID check passed

Starting check for consistency of primary group of root user
  Node Name                             Status                  
  ------------------------------------  ------------------------
  RAC2                                  passed                  
  RAC1                                  passed                  

Check for consistency of root user's primary group passed

Check: Package existence for "cvuqdisk" 
  Node Name     Available                 Required                  Status    
  ------------  ------------------------  ------------------------  ----------
  RAC2          cvuqdisk-1.0.9-1          cvuqdisk-1.0.9-1          passed    
  RAC1          cvuqdisk-1.0.9-1          cvuqdisk-1.0.9-1          passed    
Result: Package existence check passed for "cvuqdisk"

Starting Clock synchronization checks using Network Time Protocol(NTP)...

NTP Configuration file check started...
Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes
No NTP Daemons or Services were found to be running

Result: Clock synchronization check using Network Time Protocol(NTP) passed

Checking Core file name pattern consistency...
Core file name pattern consistency check passed.

Checking to make sure user "grid" is not in "root" group
  Node Name     Status                    Comment                 
  ------------  ------------------------  ------------------------
  RAC2          passed                    does not exist          
  RAC1          passed                    does not exist          
Result: User "grid" is not part of "root" group. Check passed

Check default user file creation mask
  Node Name     Available                 Required                  Comment   
  ------------  ------------------------  ------------------------  ----------
  RAC2          0022                      0022                      passed    
  RAC1          0022                      0022                      passed    
Result: Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across nodes

Checking the file "/etc/resolv.conf" to make sure only one of domain and search entries is defined
File "/etc/resolv.conf" does not have both domain and search entries defined
Checking if domain entry in file "/etc/resolv.conf" is consistent across the nodes...
domain entry in file "/etc/resolv.conf" is consistent across nodes
Checking if search entry in file "/etc/resolv.conf" is consistent across the nodes...
search entry in file "/etc/resolv.conf" is consistent across nodes
Checking DNS response time for an unreachable node
  Node Name                             Status                  
  ------------------------------------  ------------------------
  RAC2                                  failed                  
  RAC1                                  failed                  
PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: RAC2,RAC1

File "/etc/resolv.conf" is not consistent across nodes


UDev attributes check for OCR locations started...
Result: UDev attributes check passed for OCR locations 


UDev attributes check for Voting Disk locations started...
Result: UDev attributes check passed for Voting Disk locations 

Check: Time zone consistency 
Result: Time zone consistency check passed
Checking VIP configuration.
Checking VIP Subnet configuration.
Check for VIP Subnet configuration passed.
Checking VIP reachability
Check for VIP reachability passed.

Checking Oracle Cluster Voting Disk configuration...

ASM Running check passed. ASM is running on all specified nodes

Oracle Cluster Voting Disk configuration check passed

Clusterware version consistency passed

Pre-check for cluster services setup was unsuccessful on all the nodes.

3、GRID升级

执行脚本

[root@RAC1 grid]# /u02/app/11.2.0/grid/rootupgrade.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u02/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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: /u02/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer

ASM upgrade has started on first node.


CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'RAC1'
CRS-2673: Attempting to stop 'ora.crsd' on 'RAC1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'RAC1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'RAC1'
CRS-2673: Attempting to stop 'ora.DATA01.dg' on 'RAC1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'RAC1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.RAC1.vip' on 'RAC1'
CRS-2677: Stop of 'ora.RAC1.vip' on 'RAC1' succeeded
CRS-2672: Attempting to start 'ora.RAC1.vip' on 'RAC2'
CRS-2677: Stop of 'ora.DATA01.dg' on 'RAC1' succeeded
CRS-2676: Start of 'ora.RAC1.vip' on 'RAC2' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'RAC1'
CRS-2677: Stop of 'ora.asm' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'RAC1'
CRS-2677: Stop of 'ora.ons' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'RAC1'
CRS-2677: Stop of 'ora.net1.network' on 'RAC1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'RAC1' has completed
CRS-2677: Stop of 'ora.crsd' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'RAC1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'RAC1'
CRS-2673: Attempting to stop 'ora.evmd' on 'RAC1'
CRS-2673: Attempting to stop 'ora.asm' on 'RAC1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'RAC1'
CRS-2677: Stop of 'ora.evmd' on 'RAC1' succeeded
CRS-2677: Stop of 'ora.crf' on 'RAC1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'RAC1' succeeded
CRS-2677: Stop of 'ora.asm' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'RAC1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'RAC1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'RAC1'
CRS-2677: Stop of 'ora.cssd' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'RAC1'
CRS-2677: Stop of 'ora.gipcd' on 'RAC1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'RAC1'
CRS-2677: Stop of 'ora.gpnpd' on 'RAC1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'RAC1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in upstart
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@RAC2 ~]# /u02/app/11.2.0/grid/rootupgrade.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u02/app/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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: /u02/app/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
Installing Trace File Analyzer
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'RAC2'
CRS-2673: Attempting to stop 'ora.crsd' on 'RAC2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'RAC2'
CRS-2673: Attempting to stop 'ora.cvu' on 'RAC2'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'RAC2'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'RAC2'
CRS-2673: Attempting to stop 'ora.DATA01.dg' on 'RAC2'
CRS-2677: Stop of 'ora.cvu' on 'RAC2' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'RAC1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.RAC2.vip' on 'RAC2'
CRS-2677: Stop of 'ora.RAC2.vip' on 'RAC2' succeeded
CRS-2672: Attempting to start 'ora.RAC2.vip' on 'RAC1'
CRS-2676: Start of 'ora.cvu' on 'RAC1' succeeded
CRS-2677: Stop of 'ora.DATA01.dg' on 'RAC2' succeeded
CRS-2676: Start of 'ora.RAC2.vip' on 'RAC1' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'RAC2'
CRS-2677: Stop of 'ora.asm' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'RAC2'
CRS-2677: Stop of 'ora.ons' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'RAC2'
CRS-2677: Stop of 'ora.net1.network' on 'RAC2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'RAC2' has completed
CRS-2677: Stop of 'ora.crsd' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'RAC2'
CRS-2673: Attempting to stop 'ora.crf' on 'RAC2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'RAC2'
CRS-2673: Attempting to stop 'ora.evmd' on 'RAC2'
CRS-2673: Attempting to stop 'ora.asm' on 'RAC2'
CRS-2677: Stop of 'ora.mdnsd' on 'RAC2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'RAC2' succeeded
CRS-2677: Stop of 'ora.crf' on 'RAC2' succeeded
CRS-2677: Stop of 'ora.asm' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'RAC2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'RAC2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'RAC2'
CRS-2677: Stop of 'ora.cssd' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'RAC2'
CRS-2677: Stop of 'ora.gipcd' on 'RAC2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'RAC2'
CRS-2677: Stop of 'ora.gpnpd' on 'RAC2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'RAC2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
OLR initialization - successful
Replacing Clusterware entries in upstart
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 11g Release 2.
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Started to upgrade the Oracle Clusterware. TRAC operation may take a few minutes.
Started to upgrade the CSS.
Started to upgrade the CRS.
The CRS was successfully upgraded.
Successfully upgraded the Oracle Clusterware.
Oracle Clusterware operating version was successfully set to 11.2.0.4.0

ASM upgrade has finished on last node.


Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 

 

4、Oracle database software 升级

#PATH=$PATH:$HOME/bin
#export ORACLE_SID=orcl1
#export ORACLE_BASE=/u01/app/oracle
#export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
#export TMP=/tmp
#export TMPDIR=$TMP
#export PATH=$PATH:$ORACLE_HOME/bin
#export PATH
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
#export ORACLE_UNQNAME=orcl


export ORACLE_SID=orcl1
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$PATH:$ORACLE_HOME/bin
export PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_UNQNAME=orcl
#PATH=$PATH:$HOME/bin
#export ORACLE_SID=orcl2
#export ORACLE_BASE=/u01/app/oracle
#export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
#export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
#export TMP=/tmp
#export TMPDIR=$TMP
#export PATH=$PATH:$ORACLE_HOME/bin


export ORACLE_SID=orcl2
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$PATH:$ORACLE_HOME/bin

执行脚本

[root@RAC1 ~]# /u02/app/oracle/product/11.2.0/dbhome_1/root.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u02/app/oracle/product/11.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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
[root@RAC2 ~]# /u02/app/oracle/product/11.2.0/dbhome_1/root.sh
Performing root user operation for Oracle 11g 

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u02/app/oracle/product/11.2.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]: 
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

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.

5、FAQ问题

问题处理:

[grid@RAC1 ~]$ srvctl enable database -d orcl
PRCD-1027 : Failed to retrieve database orcl
PRCD-1229 : An attempt to access configuration of database orcl was rejected because its version 11.2.0.3.0 differs from the program version 11.2.0.4.0. Instead run the program from /u01/app/oracle/product/11.2.0/dbhome_1.
[oracle@RAC1 ~]$ /u02/app/11.2.0/grid/bin/srvctl upgrade database -d orcl -o /u02/app/oracle/product/11.2.0/dbhome_1
[oracle@RAC1 ~]$ 
[root@RAC1 bin]# ./srvctl enable database -d orcl

6、DataBase 升级

 @$ORACLE_HOME/rdbms/admin/catupgrd.sql;
 @$ORACLE_HOME/rdbms/admin/utlu112s.sql
 @$ORACLE_HOME/rdbms/admin/catuppst.sql
 @$ORACLE_HOME/rdbms/admin/utlrp.sql
SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值