LINUX5.10 - 64, ORACLE11203, RAC双节点。
在这环境上打了几个 one-off patch,发觉结果和文档的说法有差距,
刚才在LINUX 11023 RAC 环境上打了3个小补丁,10110625 ,12385172, 13527323。其中,
10110625 要求打补丁前,必须关掉 $ORACLE_HOME 下的所有服务,并且要求在每个节点都执行该补丁命令,
Ensure that you shut down all the services running from the Oracle home.
12385172, 13527323。则要求关系该节点的所有服务 (database, ASM, listeners, nodeapps, and CRS daemons),并且要求在每个节点都执行该补丁命令,
For a RAC environment, shut down all the services (database, ASM, listeners, nodeapps, and CRS daemons) running from the Oracle home of the node you want to patch.
After you patch this node, start the services on this node.Repeat this process for each of the other nodes of the Oracle RAC system. OPatch is used on only one node at a time.
但实际上,我在节点1,执行crsctl stop crs 后,陆续打上该补丁,完成后查看节点,发现这些补丁都已经打到节点2上,而此时节点2上各个服务还在运行着,如下:
[root@rac42 db_1]# su - oracle
[oracle@rac42 ~]$ opatch lspatches
12385172;
13914613;
[oracle@rac42 ~]$ opatch lspatches
13527323;
12385172;
13914613;
[oracle@rac42 ~]$ opatch lspatches
10110625;
13527323;
12385172;
13914613;
[oracle@rac42 ~]$
[oracle@rac42 ~]$ exit
logout
[root@rac42 db_1]# su - grid
[grid@rac42 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
ONLINE ONLINE rac42
ora.DBDATA.dg
ONLINE ONLINE rac42
ora.FLASHDG.dg
ONLINE ONLINE rac42
ora.LISTENER.lsnr
ONLINE ONLINE rac42
ora.asm
ONLINE ONLINE rac42 Started
ora.gsd
OFFLINE OFFLINE rac42
ora.net1.network
ONLINE ONLINE rac42
ora.ons
ONLINE ONLINE rac42
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac42
ora.cvu
1 ONLINE ONLINE rac42
ora.oc4j
1 ONLINE ONLINE rac42
ora.rac41.vip
1 ONLINE INTERMEDIATE rac42 FAILED OVER
ora.rac42.vip
1 ONLINE ONLINE rac42
ora.scan1.vip
1 ONLINE ONLINE rac42
ora.wldb.db
1 ONLINE OFFLINE
2 ONLINE ONLINE rac42 Open
[grid@rac42 ~]$
据此推测,打这3个补丁,都不需要停库;并且,并不需要在每个节点都执行一遍打补丁操作。
希望这只是早期的作法,后续不再出现这种随意的README。