做家纺网站哪家好,找客户的软件,湖南建筑网,镇江网站设计建设价格ORACLE 19c安装DB补丁#xff1a; 1 确定OPatch的可用性#xff1a;这里需要注意的是p6880880_190000_Linux-x86-64.zip是有版本对应区别的#xff0c;需要注意你要打的补丁版本是否支持。
2 将原$ORACLE_HOME目录下的OPatch目录删除或者改名#xff0c;比如说#xff1a…ORACLE 19c安装DB补丁 1 确定OPatch的可用性这里需要注意的是p6880880_190000_Linux-x86-64.zip是有版本对应区别的需要注意你要打的补丁版本是否支持。
2 将原$ORACLE_HOME目录下的OPatch目录删除或者改名比如说 cd $ORACLE_HOME mv OPatch OPatch_1 或rm -rf OPatch
3 将p6880880_190000_Linux-x86-64.zip上传到你的$ORACLE_HOME目录下并解压。 unzip p6880880_190000_Linux-x86-64.zip 解压后你就可以得到一个新的OPatch目录。
4修改环境变量添加 export ORACLE_OPatch$ORACLE_HOME/OPatch 在export PATH.....这行字符最后添加:$ORACLE_OPatch 比如: export PATH$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin:$PATH:$HOME/bin:$ORACLE_OPatch 然后环境变量生成 source ~/.bash_profile
5 执行opatch version [oracleoracle19c ~]$ opatch version OPatch Version: 12.2.0.1.28
OPatch succeeded. 看到这样就可以了。
6 使用ORACLE用户将你的补丁文件压缩包上传到服务器上。并解压准备打补丁。
7 解压补丁 : unzip p33515361_190000_Linux-x86-64.zip
8 关闭监听和关闭数据库 lsnrctl stop
[oracleoracle19c u01]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 23 22:22:57 2022 Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 这里我们可以看到我们数据库版本为19300关闭数据库 shutdown immediate
9 检查补丁信息 cd 33515361/这个33515361是刚才解压出来的你们要根据你们的实际情况而定 opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.28 Copyright (c) 2022, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19c/db_1 Central Inventory : /u01/oraInventory from : /u01/app/oracle/product/19c/db_1/oraInst.loc OPatch version : 12.2.0.1.28 OUI version : 12.2.0.7.0 Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-01-23_22-26-20PM_1.log
Invoking prereq checkconflictagainstohwithdetail
Prereq checkConflictAgainstOHWithDetail passed.
OPatch succeeded.
没有问题证明一切OK.
10 开始打补丁 cd 33515361/ opatch apply 这个需要在解压出来的补丁目录下执行
Do you want to proceed? [y|n] 出这种东西的话 一律 y
看到这些: Patching component oracle.jdk, 1.8.0.201.0... Patch 33515361 successfully applied. Sub-set patch [29517242] has become inactive due to the application of a super-set patch [33515361]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2022-01-23_22-29-14PM_1.log
OPatch succeeded. 代表数据库补丁安装完毕。
11 启动数据库 [oracleoracle19c 33515361]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 23 22:36:38 2022 Version 19.14.0.0.0看这里
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SQL startup ORACLE instance started.
Total System Global Area 733999360 bytes Fixed Size 8900864 bytes Variable Size 201326592 bytes Database Buffers 520093696 bytes Redo Buffers 3678208 bytes Database mounted. Database opened. SQL
这里应景看到了是191400而不是19300了
12 执行datapatch datapatch -verbose 千万别再SQLPLUS下执行要在ORACLE用户的LINUX终端上执行 [oracleoracle19c 33515361]$ datapatch -verbose
SQL Patching tool version 19.14.0.0.0 Production on Sun Jan 23 22:43:26 2022 Copyright (c) 2012, 2021, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_12364_2022_01_23_22_43_26/sqlpatch_invocation.log
Connecting to database...OK Gathering database info...done Bootstrapping registry and package to current versions...done Determining current state...done
Current state of interim SQL patches: No interim patches found
Current state of release update SQL patches: Binary registry: 19.14.0.0.0 Release_Update 211225122123: Installed SQL registry: Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 18-JAN-21 02.54.27.541960 AM
Adding patches to installation queue and performing prereq checks...done Installation queue: No interim patches need to be rolled back Patch 33515361 (Database Release Update : 19.14.0.0.220118 (33515361)): Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.14.0.0.0 Release_Update 211225122123 No interim patches need to be applied
Installing patches...
看到下列信息代表成功了。 Patch installation complete. Total patches installed: 1
Validating logfiles...done Patch 33515361 apply: SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/33515361/24589353/33515361_apply_ORCL_2022Jan23_22_43_55.log (no errors) SQL Patching tool complete on Sun Jan 23 22:51:58 2022
13 进入到sqlplus / as sysdba下: 执行?/rdbms/admin/utlrp.sql
SQL ?/rdbms/admin/utlrp.sql ?/rdbms/admin/utlrp.sql
Session altered. TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_BGN 2022-01-23 22:54:50
DOC The following PL/SQL block invokes UTL_RECOMP to recompile invalid DOC objects in the database. Recompilation time is proportional to the DOC number of invalid objects in the database, so this command may take DOC a long time to execute on a database with a large number of invalid DOC objects.
直到看到 ERRORS DURING RECOMPILATION --------------------------- 0 Function created. PL/SQL procedure successfully completed. Function dropped. PL/SQL procedure successfully completed.
代表成功。
14 检查补丁是否成功 col ACTION for a8 col status for a10 set line 230 col ACTION_TIME for a30 col DESCRIPTION for a60
执行下列SQL语句 select patch_id, action,status,action_time,description from dba_registry_sqlpatch; PATCH_ID ACTION STATUS ACTION_TIME DESCRIPTION ---------- -------- ---------- ------------------------------ ------------------------------------------------------------ 29517242 APPLY SUCCESS 18-JAN-21 02.54.27.541960 AM Database Release Update : 19.3.0.0.190416 (29517242) 33515361 APPLY SUCCESS 23-JAN-22 10.51.58.754167 PM Database Release Update : 19.14.0.0.220118 (33515361)
看到SUCCESS后代表成功我们把数据库从 19.3.0.0.190416 (29517242) 升级到 19.14.0.0.220118 (33515361)
这里的29517242代表19300的补丁编号一旦失败我们需要回滚我们的补丁。
到这里补丁就算成功打完了。
