Oracle 11.2.0.4打补丁的方法_oracle_

 [oracle@localhost OPatch]$ ./opatch version OPatch Version: 11.2.0.3.16 OPatch succeeded.

 12:40:47 SYS@std> set linesize 500 pagesize 600 12:40:49 SYS@std> col COMP_NAME for a30 12:41:06 SYS@std> select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY; COMP_ID COMP_NAME VERSION STATUS ------------------------------ ------------------------------ ------------------------------ -------------------------------------------- OWB OWB 11.2.0.4.0 VALID APEX Oracle Application Express 3.2.1.00.12 VALID EM Oracle Enterprise Manager 11.2.0.4.0 VALID AMD OLAP Catalog 11.2.0.4.0 VALID SDO Spatial 11.2.0.4.0 VALID ORDIM Oracle Multimedia 11.2.0.4.0 VALID XDB Oracle XML Database 11.2.0.4.0 VALID CONTEXT Oracle Text 11.2.0.4.0 VALID EXF Oracle Expression Filter 11.2.0.4.0 VALID RUL Oracle Rules Manager 11.2.0.4.0 VALID OWM Oracle Workspace Manager 11.2.0.4.0 VALID CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID CATPROC Oracle Database Packages and T 11.2.0.4.0 VALID ypes JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID XML Oracle XDK 11.2.0.4.0 VALID CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID APS OLAP Analytic Workspace 11.2.0.4.0 VALID XOQ Oracle OLAP API 11.2.0.4.0 VALID 18 rows selected. Elapsed: 00:00:00.04

 12:41:11 SYS@std> col ACTION_TIME for a30 12:46:03 SYS@std> col COMMENTS for a30 12:46:07 SYS@std> select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY; ACTION_TIME ACTION VERSION COMMENTS ------------------------------ ------------------------------ ------------------------------ ------------------------------ 24-AUG-13 12.03.45.119862 PM APPLY 11.2.0.4 Patchset 11.2.0.2.0 22-MAR-19 12.02.16.970055 PM APPLY 11.2.0.4 Patchset 11.2.0.2.0 Elapsed: 00:00:00.01

 12:46:11 SYS@std> select count(*) from dba_objects where status<>'VALID'; COUNT(*) ---------- 0

 [oracle@localhost OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/28689165/ -oh $ORACLE_HOME Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2019, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-22_13-02-45PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

 ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9

 13:11:12 SYS@std> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 13:11:28 SYS@std>

 [oracle@localhost OPatch]$ lsnrctl stop LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2019 13:12:51 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully [oracle@localhost OPatch]$

 [oracle@localhost OPatch]$ ps -ef |grep ora_|grep -v grep [oracle@localhost OPatch]$ netstat -an |grep 1158 [oracle@localhost OPatch]$ netstat -an|grep 1521 [oracle@localhost OPatch]$

 [oracle@localhost OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-44-35AM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_08-44-35AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: localhost ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. [oracle@localhost OPatch]$ ./opatch napply -oh $ORACLE_HOME -local /home/oracle/28689165 many more lines compressed.. + make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _FULL_LIBNAME=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfhc.so _LIBNAME=libnmcfhc _LIBDIR=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_LIBNAME_LIBS=$(libnmcfhcLIBS)' '_LIBNAME_EXTRALIBS=$(libnmcfhcEXTRALIBS)' + PATH=/bin:/usr/bin:/usr/ccs/bin + export PATH + lib=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so + makefile=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk + so_ext=so + target=new_ld_shlib + var= ++ basename /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so .so + libname=libnmcfsga ++ dirname /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so + dir=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib + '[' var = new_ld_shlib ']' + '[' -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.a ']' + dir2=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ + '[' '' '!=' '' ']' + make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _FULL_LIBNAME=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so _LIBNAME=libnmcfsga _LIBDIR=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_LIBNAME_LIBS=$(libnmcfsgaLIBS)' '_LIBNAME_EXTRALIBS=$(libnmcfsgaEXTRALIBS)' /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. /bin/ld: warning: -z lazyload ignored. /bin/ld: warning: -z nolazyload ignored. Composite patch 28204707 successfully applied. Patch 28440700 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-50-02AM_1.log OPatch completed with warnings. [oracle@localhost OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_09-02-42AM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_09-02-42AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: localhost ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 28440700 : applied on Mon Mar 25 08:54:00 CST 2019 Unique Patch ID: 22461927 Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.181016" Created on 15 Oct 2018, 08:12:17 hrs PST8PDT Bugs fixed: 18933818, 19176885, 17201047, 25649873, 25067795, 28502128, 27952577 14774730, 27461842, 19153980, 21911849, 23727132, 18166577, 27000663 24448240, 17056813, 21811517, 19909862, 25494379, 22675136, 24534298 19895326, 22253904, 17804361, 19231857, 27642235, 26023002, 17528315 19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988 23265914, 19699946, 19006757, 19374518, 19223010, 25076732, 22118835 26637592, 19852360, 20408829, 21047766, 21566944 Patch 28204707 : applied on Mon Mar 25 08:53:49 CST 2019 Unique Patch ID: 22491169 Patch description: "Database Patch Set Update : 11.2.0.4.181016 (28204707)" Created on 19 Sep 2018, 03:24:06 hrs PST8PDT Sub-patch 27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)" Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)" Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)" Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)" Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)" Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)" Sub-patch 24732075; "Databa
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：Oracle创建设置查询权限用户的方法_oracle_
                                                                
下一篇：详解Oracle游标的简易用法_oracle_