免费网站注册永久,具备网站维护与建设能力,在网站中搜索关键字,wordpress的标题字怎么变目录 1.当前DB环境2.下载补丁包和opatch的升级包3.检查OPatch的版本4.检查补丁是否冲突5.关闭数据库实例#xff0c;关闭监听6.应用patch7.加载变化的SQL到数据库8.ORACLE升级补丁查询 oracle19.3升级补丁到19.18 1.当前DB环境
[oraclelocalhost ~]$ cat /etc/redhat-releas… 目录 1.当前DB环境2.下载补丁包和opatch的升级包3.检查OPatch的版本4.检查补丁是否冲突5.关闭数据库实例关闭监听6.应用patch7.加载变化的SQL到数据库8.ORACLE升级补丁查询 oracle19.3升级补丁到19.18 1.当前DB环境
[oraclelocalhost ~]$ cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)
[oraclelocalhost ~]$ uname -r
3.10.0-1160.el7.x86_64
[oraclelocalhost ~]$ lsnrctl statusLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-AUG-2023 05:39:02Copyright (c) 1991, 2019, Oracle. All rights reserved.Connecting to (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOSTlocalhost)(PORT1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 12-JAN-2023 00:13:37
Uptime 208 days 4 hr. 25 min. 25 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/19c/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...(DESCRIPTION(ADDRESS(PROTOCOLtcp)(HOSTlocalhost)(PORT1521)))(DESCRIPTION(ADDRESS(PROTOCOLipc)(KEYEXTPROC1521)))
Services Summary...
Service orcl has 1 instance(s).Instance orcl, status READY, has 1 handler(s) for this service...
Service orclXDB has 1 instance(s).Instance orcl, status READY, has 1 handler(s) for this service...
The command completed successfully
[oraclelocalhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 8 05:40:12 2023
Version 19.3.0.0.0Copyright (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.02.下载补丁包和opatch的升级包
要具有开源精神 opatch升级包 链接https://pan.baidu.com/s/1I2Kt44kMM2Y2rNMdjvintw 提取码y09u –来自百度网盘超级会员V1的分享 19.18的补丁包 链接https://pan.baidu.com/s/1V-L6BJykTKqUSri1BqzFwg 提取码narc –来自百度网盘超级会员V1的分享
3.检查OPatch的版本
更新opatch根据README要求opatch工具版本至少12.2.0.1.34 或更高版本
[oraclelocalhost ~]$ cd $ORACLE_HOME
[oraclelocalhost db_1]$ cd OPatch/
[oraclelocalhost OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17OPatch succeeded.升级opatch版本
#备份OPatch
[oraclelocalhost ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.bak#解压到$ORACLE_HOME目录下
[oraclelocalhost ~]$ unzip p6880880_190000_Linux-x86-64.zip -d $ORACLE_HOME#查看升级后的opatch的版本
[oraclelocalhost ~]$ cd $ORACLE_HOME
[oraclelocalhost db_1]$ cd OPatch/
[oraclelocalhost OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.36OPatch succeeded.4.检查补丁是否冲突
[oraclelocalhost ~]$ unzip p34762026_190000_Linux-x86-64.zip
[oraclelocalhost ~]$ chown -R oracle:oinstall 34762026/
[oraclelocalhost ~]$ chmod 775 -R 34762026/
#检测冲突,依次检测
[oraclelocalhost ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/34762026/33575402/
[oraclelocalhost ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/34762026/34765931/
[oraclelocalhost ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/34762026/34768559/
[oraclelocalhost ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/34762026/34768569/
[oraclelocalhost ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/34762026/34863894/
#出现以下字样检测成功
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.PREREQ sessionOracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/oraInventoryfrom : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-08-08_06-47-50AM_1.logInvoking prereq checkconflictagainstohwithdetailPrereq checkConflictAgainstOHWithDetail passed.OPatch succeeded.5.关闭数据库实例关闭监听
[oraclelocalhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Aug 8 06:53:08 2023
Version 19.3.0.0.0Copyright (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.0SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oraclelocalhost ~]$ lsnrctl stopLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-AUG-2023 07:13:07Copyright (c) 1991, 2019, Oracle. All rights reserved.Connecting to (DESCRIPTION(ADDRESS(PROTOCOLTCP)(HOSTlocalhost)(PORT1521)))
The command completed successfully6.应用patch
[oraclelocalhost 34765931]$ pwd
/home/oracle/34762026/34765931
[oraclelocalhost 34765931]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/oracle/product/19c/db_1
Central Inventory : /u01/oraInventoryfrom : /u01/app/oracle/product/19c/db_1/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.7.0
Log file location : /u01/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2023-08-08_07-19-09AM_1.logVerifying environment and performing prerequisite checks...
......7.加载变化的SQL到数据库
安装补丁之后还需要将有变化的SQL加载到数据库中这里可以直接运行Datapatch工具将这些修改的SQL重新加载到数据库中如果是RAC环境只需要在一个节点执行就可以了。
根据readme的说明操作步骤如下
sqlplus /nolog
SQL Connect / as sysdba
SQL startup
SQL alter pluggable database all open;
SQL quit
cd $ORACLE_HOME/OPatch./datapatch -verbose8.ORACLE升级补丁查询
1.查询dba_server_registry视图
SQL select comp_name,version from dba_server_registry;2.查询dba_registry_history
SQL select * from dba_registry_history;3.查询product_component_version视图
SQL select product,version from product_component_version;4.查询v$version视图
SQL select * from v$version;
