Oracle RAC 11203 在线升级至RAC 11204

最新推荐文章于 2023-06-23 08:45:27 发布
最新推荐文章于 2023-06-23 08:45:27 发布
阅读量785 收藏 2
点赞数
分类专栏： oracle 文章标签： 11203 11204 rac
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jisen_huang/article/details/117886519
版权

目录

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

 

 

黄继生 jisen
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Oracle rac 两节点升级.docx
06-17
实测oracle两节点rac11.2.0.1.0升级到11.2.0.4.0，能力有限，欢迎执指正
oracle rac10205升级到11204
11-25
redhat5.7下oracle rac 10.2.0.5.0升级到11.2.0.4.0
11203RAC升级到11204RAC
Baldwin的博客
04-02 558
11203RAC升级到11204RAC0.步骤总结1.升级前检查2.升级准备3.升级前校验4.升级集群软件，完成之后所有节点`grid`用户修改环境变量(路径有变化 `ORACLE_BASE`和`ORACLE_HOME` )5.升级oracle软件，更新数据字典 ，完成之后所有节点oracle用户修改环境变量(路径有变化 ORACLE_BASE和ORACLE_HOME,PATH) rac 2节点 11.2.0.3升级到11.2.0.4完整步骤 0.步骤总结 1.升级前检查 数据库状态（都是open)： S
oracle 11.2.0.3RAC升级到11.2.0.4
zongzizz的博客
07-26 624
oracle 11.2.0.3RAC升级到11.2.0.4
oracle11.2.03,Oracle11.2.0.3升级至11.2.0.4
weixin_42394785的博客
04-09 277
一、安装图形界面yum search tiger #搜索安装vnc服务器yum grouplist #显示可用group列表yum -y groupinstall desktop二、升级grid图形界面升级grid，在启动安装软件后第二步installation option选择“Upgrade Oracle Grid Infrastructure or Oracle Automatic ...
都2021了，还愁Oracle升级步骤麻烦吗？学会本文，升级如喝水
Vic的博客
06-04 594
转载至https://blog.csdn.net/m0_50546016/article/details/117261236?spm=1001.2014.3001.5501
oracle rac 不停机调整时间.txt
04-12
oracle rac 不停机调整时间.txt
Oracle 12CR2 RAC 升级
04-11
Oracle 12CR2 RAC，包括grid,rdbms,数据库实例三部分的升级操作，一步步地操作，就可以升级数据库，注意权限，要一步步操作，不要跳过任何一步
Oracle 11gR2迁移升级至12cR2 RAC
03-26
异机迁移oracle 11.2.0.4单机至12cR2 RAC, DBUA直接升级
oracle升级110201-110204
07-17
server2008下oracle11g升级
oracle upgrade 版本升级 解决办法
01-09
oracle 冷备到更高级的实例中 upgrade 方法
upgradeOracleRAC11201to11204
01-07
upgrade oracle 11.2.0.1 rac to 11.2.0.4
oracle 10201升级10205带图详细文档（linux）转
05-17
转：oracle 10201升级10205带图详细文档（for linux），挺详细的。
Oracle 11203 AIX PSU5
07-25
Oracle 11203 AIX PSU5 ，供下载
oracle 升级到11204,Oracle11.2.0.3升级至11.2.0.4
weixin_29932857的博客
04-02 552
一、安装图形界面yum search tiger #搜索安装vnc服务器yum grouplist #显示可用group列表yum -y groupinstall desktop二、升级grid图形界面升级grid，在启动安装软件后第二步installation option选择“Upgrade Oracle Grid Infrastructure or Oracle Automatic ...
Oracle单机版升级（11.2.0.3升级到11.2.0.4）
最新发布
IT邦德
06-23 2403
本文祥细阐述了Oracle单机版11.2.0.3升级到11.2.0.4的祥细过程
oracle 升级到11204,案例客服数据库RAC升级11201升级11204.docx
weixin_34558565的博客
04-02 725
案例客服数据库RAC升级11201升级11204一．准备工作1.?所需补丁可以到ORACLE官网上下载11204 for Redhat Linux的补丁，补丁号为8202632，文件名为112040_Linux-x86-64_1of7.zip、112040_Linux-x86-64_2of7.zip和112040_Linux-x86-64_3of7.zip?(包含clusterware和softw...
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (四)
热门推荐
Zhong Weicheng Study Notes
12-29 1万+
使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (一) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (二) 使用UDEV在Oracle Linux 6上安装Oracle 11g RAC(11.2.0.3) (三) 将安装介质上传到node1,解压准备安装grid infrast
oracle 单机升级oracle rac
05-31
将 Oracle 单机升级为 Oracle RAC 是一项复杂的任务，需要考虑多个方面，包括硬件、网络、存储和软件等方面。以下是一些大致的步骤： 1. 确定硬件和网络要求，确保集群节点之间的网络通信畅通。 2. 安装必需的软件...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值