19c rac部署-部署同时应用补丁

bestsun999

已于 2023-08-03 20:36:14 修改

阅读量794

点赞数

分类专栏： Oracle_19c 文章标签：服务器 oracle

于 2023-06-01 15:11:48 首次发布

本文链接：https://blog.csdn.net/kevinyu998/article/details/130988724

版权

Oracle_19c 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

#sha256sum LINUX.X64_193000_grid_home.zip
d668002664d9399cf61eb03c0d1e3687121fc890b1ddd50b35dcbe13c5307d2e LINUX.X64_193000_grid_home.zip

#sha256sum LINUX.X64_193000_db_home.zip
ba8329c757133da313ed3b6d7f86c5ac42cd9970a28bf2e6233f3235233aa8d8 LINUX.X64_193000_db_home.zip

#p35058172_190000_Linux-x86-64.zip 2.8 GB (2996662068 bytes)
SHA-256 AEF2DE67B8C7933793A17182C9FB7523D0F4971C2F9364F55CD6449F6E962A69

#p6880880_190000_Linux-x86-64-37.zip
SHA-256 221E49B87245EE4A2E172742101ECF2C714357088BA1C2BE8141FDE652541106

将GI和DB放到/opt下面，补丁和opatch放到/opt/update

GI安装+补丁--节点一上操作
chown grid:oinstall /opt/LINUX.X64_193000_grid_home.zip
chmod 775 /opt/LINUX.X64_193000_grid_home.zip
chown -R grid:oinstall /opt/update
chmod -R 775 /opt/update
su - grid
unzip -q -o /opt/LINUX.X64_193000_grid_home.zip -d $ORACLE_HOME
unzip -q -o /opt/update/p6880880_190000_Linux-x86-64-37.zip -d $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch version
unzip -q -o /opt/update/p35058172_190000_Linux-x86-64.zip -d /opt/update

export DISPLAY=:1.0 ---vnc图形下，根据情况修改
$ORACLE_HOME/gridSetup.sh -applyPSU /opt/update/35058172/35037840

2个节点依次执行

/u01/app/oraInventory/orainstRoot.sh

/u01/app/19.0.0/grid_1/root.sh

DB安装+补丁--节点一上操作
chown oracle:oinstall /opt/LINUX.X64_193000_db_home.zip
chmod 775 /opt/LINUX.X64_193000_db_home.zip
chown -R oracle:oinstall /opt/update
chmod -R 775 /opt/update
su - oracle
unzip -q -o /opt/LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
unzip -q -o /opt/update/p6880880_190000_Linux-x86-64-37.zip -d $ORACLE_HOME
unzip -q -o /opt/update/p35058172_190000_Linux-x86-64.zip -d /opt/update/
$ORACLE_HOME/OPatch/opatch version
export DISPLAY=:1.0
$ORACLE_HOME/runInstaller -applyPSU /opt/update/35058172/35037840

2个节点依次执行
/u01/app/oraInventory/orainstRoot.sh

OJVM补丁-两个主机都需要应用

su - oracle
cd /opt/update/35058172/35050341
opatch apply

[root@db1 ~]# /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@db1 ~]# /u01/app/19.0.0/grid_1/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.0.0/grid_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.0.0/grid_1/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/db1/crsconfig/rootcrs_db1_2023-05-31_04-33-29PM.log
2023/05/31 16:33:34 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2023/05/31 16:33:34 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2023/05/31 16:33:36 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2023/05/31 16:33:36 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2023/05/31 16:33:36 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2023/05/31 16:33:36 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2023/05/31 16:33:45 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2023/05/31 16:33:48 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2023/05/31 16:34:00 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2023/05/31 16:34:00 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2023/05/31 16:34:04 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2023/05/31 16:34:04 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2023/05/31 16:34:22 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2023/05/31 16:34:22 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2023/05/31 16:34:22 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2023/05/31 16:34:42 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2023/05/31 16:34:45 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

ASM has been created and started successfully.

[DBT-30001] Disk groups created successfully. Check /u01/app/grid/cfgtoollogs/asmca/asmca-230531PM043514.log for details.

2023/05/31 16:35:53 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2023/05/31 16:35:53 CLSRSC-482: Running command: '/u01/app/19.0.0/grid_1/bin/ocrconfig -upgrade grid oinstall'
CRS-4256: Updating the profile
Successful addition of voting disk 414f5250e01f4fe7bf63b02824cb3fed.
Successful addition of voting disk d2bcfdadd4764f56bfbbbe11d5c715ba.
Successful addition of voting disk fc50fcd15a2d4f5ebfa61d67e3774c73.
Successful addition of voting disk 1d3aab8dfc314f42bf2552ad80d70597.
Successful addition of voting disk 17368ee804d54ffcbf7ce086e2ae84bf.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE    File Universal Id                File Name Disk group
-- -----    -----------------                --------- ---------
1. ONLINE   414f5250e01f4fe7bf63b02824cb3fed (/dev/mapper/asm-crs1) [CRS]
2. ONLINE   d2bcfdadd4764f56bfbbbe11d5c715ba (/dev/mapper/asm-crs2) [CRS]
3. ONLINE   fc50fcd15a2d4f5ebfa61d67e3774c73 (/dev/mapper/asm-crs3) [CRS]
4. ONLINE   1d3aab8dfc314f42bf2552ad80d70597 (/dev/mapper/asm-crs4) [CRS]
5. ONLINE   17368ee804d54ffcbf7ce086e2ae84bf (/dev/mapper/asm-crs5) [CRS]
Located 5 voting disk(s).
2023/05/31 16:36:45 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2023/05/31 16:37:47 CLSRSC-343: Successfully started Oracle Clusterware stack
2023/05/31 16:37:47 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2023/05/31 16:38:39 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2023/05/31 16:38:53 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@db1 ~]#

########################################################
[root@db2 network-scripts]# /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@db2 network-scripts]# /u01/app/19.0.0/grid_1/root.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.0.0/grid_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.0.0/grid_1/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/db2/crsconfig/rootcrs_db2_2023-05-31_04-59-55PM.log
2023/05/31 16:59:58 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2023/05/31 16:59:58 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2023/05/31 16:59:59 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2023/05/31 16:59:59 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2023/05/31 16:59:59 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2023/05/31 17:00:00 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2023/05/31 17:00:00 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2023/05/31 17:00:01 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2023/05/31 17:00:10 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2023/05/31 17:00:10 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2023/05/31 17:00:11 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2023/05/31 17:00:11 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2023/05/31 17:00:27 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2023/05/31 17:00:27 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2023/05/31 17:00:28 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2023/05/31 17:00:44 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2023/05/31 17:00:45 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2023/05/31 17:00:52 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2023/05/31 17:01:39 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2023/05/31 17:01:47 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2023/05/31 17:01:51 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@db2 network-scripts]# 2023/05/31 17:02:00 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

-------------------------

orcl1:/home/oracle@db1> opatch lspatches
35050331;OCW RELEASE UPDATE 19.19.0.0.0 (35050331)
35042068;Database Release Update : 19.19.0.0.230418 (35042068)

OPatch succeeded.
orcl1:/home/oracle@db1>cd /opt/update/35058172/35050341
orcl1:/opt/update/35058172/35050341@db1>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.

Oracle Home       : /u01/app/oracle/product/19.0.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/19.0.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.37
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-05-31_17-52-37PM_1.log

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

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/19.0.0/db_1')

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

Patching component oracle.javavm.server, 19.0.0.0.0...

Patching component oracle.javavm.server.core, 19.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...

Patching component oracle.javavm.client, 19.0.0.0.0...
Patch 35050341 successfully applied.
Log file location: /u01/app/oracle/product/19.0.0/db_1/cfgtoollogs/opatch/opatch2023-05-31_17-52-37PM_1.log

OPatch succeeded.
orcl1:/opt/update/35058172/35050341@db1>
kfptdb2:/opt/update@db2>unzip -q -o p35058172_190000_Linux-x86-64.zip -d /opt/update/
kfptdb2:/opt/update@db2>cd /opt/update/35058172/35050341
kfptdb2:/opt/update/35058172/35050341@db2>opatch apply
Oracle Interim Patch Installer version 12.2.0.1.37
Copyright (c) 2023, Oracle Corporation. All rights reserved.