Oracle 11.2.0.4打补丁的方法

2024-07-28 18:59:54

所需补丁及高版本opatch

image上传后将p6880880_112000_Linux-x86-64.zip解压覆盖$ORACLE_HOME/OPatch目录即可

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

OPatch succeeded.

检查环境是否需要打补丁，opatch版本安装环境可以看mos和readme 查看组件信息

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; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
 Bugs fixed:
  21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965
  20671094, 16731148, 16314254, 13837378, 18441944, 17291347, 17835048
  28254374, 21656630, 21842740, 13558557, 17008068, 17201159, 25427662
  17853498, 20717359, 17246576, 18356166, 18681862, 18440047, 20569094
  20031873, 16875449, 20387265, 19788842, 17296856, 21330264, 14010183
  17648596, 17551063, 17025461, 24719736, 21063322, 17267114, 22507210
  17912217, 17889583, 18202441, 17040764, 17478145, 16524926, 25655390
  19358317, 22730454, 22148226, 18747196, 26544823, 18641419, 17036973
  18948177, 17811789, 16542886, 14285317, 18009564, 17359610, 16618694
  8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092
  24624166, 26631046, 19429927, 24348685, 17848897, 17441661, 14034426
  17465741, 20273319, 19207156, 16596890, 17437634, 21343897, 20506706
  21453153, 18339044, 17951233, 22321741, 21795111, 18430495, 21787056
  22380919, 19692824, 19469538, 20506715, 17811429, 19721304, 17903598
  18230522, 19554106, 19458377, 21281607, 17612828, 6599380, 22092979
  17040527, 22321756, 17811438, 18641461, 18682983, 25635149, 14657740
  13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390
  26474853, 18849970, 17889549, 19309466, 16472716, 25775213, 20596234
  18331850, 18641451, 17019356, 17344412, 19461270, 21179898, 17546761
  24842886, 17231779, 14521849, 18203835, 18203838, 18964939, 18203837
  17313525, 22195457, 18139690, 16837842, 22296366, 14106803, 17842825
  21352646, 22657942, 22594718, 16360112, 20657441, 22195441, 17389192
  26198926, 14565184, 17019345, 17205719, 18740837, 18440095, 14764829
  22195448, 14354737, 17019086, 13944971, 16571443, 21868720, 17186905
  17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568
  20144308, 19972566, 17282229, 19972564, 16870214, 16410570, 21629064
  19615136, 26039623, 21354456, 17390431, 18762750, 23007241, 16613964
  17957017, 18098207, 17484762, 18471685, 19730508, 21538485, 18264060
  17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 18166013
  17655634, 16228604, 27053456, 20074391, 24790914, 19972570, 20856766
  19891090, 18090142, 18996843, 19854503, 16042673, 22901797, 17835627
  20334344, 17393683, 20861693, 18000422, 17551709, 26575788, 23315889
  20506699, 19006849, 18277454, 18456514, 19174430, 17258090, 17174582
  25654936, 17242746, 16399083, 17824637, 21132297, 22465352, 17762296
  22168163, 18604692, 17397545, 16450169, 12364061, 20067212, 18856999
  19211724, 19463893, 19463897, 21343775, 17853456, 18673304, 20004021
  26030218, 21668627, 16194160, 17477958, 23140259, 16538760, 12982566
  24570598, 20828947, 18259031, 20296213, 18293054, 17610798, 19699191
  23065323, 17311728, 18135678, 18774543, 23294548, 16785708, 10136473
  24560906, 22551446, 19777862, 17786518, 25879984, 18315328, 18334586
  12747740, 18096714, 19032867, 21641760, 17390160, 18899974, 17232014
  16354467, 26245237, 26679352, 20598042, 17484731, 18673325, 16422541
  18155762, 14015842, 19827973, 22683225, 17726838, 18554871, 23177648
  18051556, 20803583, 21972320, 15990359, 17922254, 18282562, 16855292
  16668584, 21343838, 20299015, 17446237, 18093615, 18043064, 23713236
  17694209, 17288409, 18308268, 20475845, 17274537, 13955826, 16934803
  17634921, 17501491, 16315398, 22683212, 23725036, 17006183, 13829543
  18191164, 17655240, 22809871, 26746894, 18384391, 19393542, 21538567
  16198143, 21847223, 25823754, 17892268, 20142975, 19584068, 17165204
  25165496, 18604493, 21756699, 18508861, 16901385, 18554763, 21532755
  18189036, 17443671, 17385178, 14829250, 17936109, 20925795, 20509482
  17478514, 27441326, 16850630, 13951456, 16595641, 14054676, 15861775
  21142837, 16912439, 17299889, 17297939, 23003979, 18619917, 16833527
  17798953, 17816865, 25914276, 18607546, 17571306, 21286665, 17341326
  26910644, 17851160, 20558005, 17586955, 19049453, 21051840, 17587063
  16956380, 18328509, 25423453, 14133975, 19718981, 18061914, 17518652
  18522509, 21051833, 20294666, 18765602, 20860659, 18272672, 20324049
  18199537, 17332800, 13609098, 22502493, 18384537, 14338435, 17945983
  16392068, 21067387, 17752995, 21051862, 16863422, 17237521, 25505382
  18244962, 19544839, 24433711, 24717859, 17156148, 18973907, 23026585
  17877323, 17449815, 18180390, 17088068, 17037130, 20004087, 21422580
  19466309, 11733603, 25505371, 18610915, 21051858, 18084625, 26243698
  18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259
  18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762
  18614015, 17346091, 18228645, 17721717, 13960236, 18685892, 18436307
  21756677, 19888853, 11883252, 17891943, 19475971, 22353199, 16384983
  19121551, 25634317, 27825893, 12816846, 17982555, 17761775, 22243719
  17265217, 25505394, 17071721, 16721594, 18262334, 21756661, 17891946
  15913355, 17672719, 17602269, 25555252, 17239687, 17042658, 17238511
  17811456, 17284817, 17752121, 20879889, 21380789, 17394950, 17011832
  16579084, 22195465, 14602788, 18325460, 24476265, 26569225, 24476274
  12611721, 18674465, 16903536, 17006570, 19689979, 16043574, 18783224
  24662775, 16494615, 21526048, 17392698, 19197175, 16069901, 17811447
  27870645, 17308789, 22195477, 24835538, 17865671, 17343514, 19013183
  17325413, 18316692, 16180763, 17348614, 14368995, 21983325, 17393915
  16285691, 19211433, 20331945, 17883081, 17705023, 24316947, 17614227
  19578350, 22195485, 24975421, 14084247, 26078387, 23115139, 13645875
  16777840, 19727057, 14852021, 18744139, 18674047, 17716305, 19285025
  18482502, 17622427, 19289642, 27534509, 22195492, 25947799, 14458214
  20869721, 21172913, 17767676, 18723434, 25505407, 17786278, 19258504
  17082983, 21351877, 17365043, 13498382, 18331812, 16065166, 25489607
  16685417, 18031668, 22893153, 17551674, 16943711, 19272701, 21517440
  25897615, 17649265, 13866822, 18094246, 24528741, 17783588, 14245531
  17082359, 18280813, 20448824, 23330119, 16268425, 19487147, 25600421
  18018515, 17302277, 17215560, 24411921, 19271443, 14176370, 25764020
  17016369, 20777150, 23330124, 16756406, 20441797, 19769489, 28100487
  17545847, 25093656, 18260550, 13853126, 17551699, 17227277, 23536835
  25957038, 24652769, 20725343, 19207117, 9756271, 18868646, 17614134
  26667023, 17546973, 18704244, 19680952, 26667015, 17050888, 18828868
  18273830, 17360606, 16992075, 24563422, 17375354, 12905058, 18362222
  21429602, 28364007, 26667032, 27086138, 17571039, 17468141, 18436647
  17570606, 17235750, 21168487, 17279227, 16220077, 16929165
--------------------------------------------------------------------------------
OPatch succeeded.

更新数据库，将修改过的SQL文件应用到数据库中，很多DBA在执行完上述安装命令以后就不再进行这一步，那么实际上PSU是没有完整安装的

[oracle@localhost 28689165]$ cd $ORACLE_HOME/rdbms/admin
[oracle@localhost admin]$ sql
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 25 11:10:53 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
11:10:53 SYS@std> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
Function created.
Elapsed: 00:00:00.14
Function created.
many more lines compressed

总结

以上所述是小编给大家介绍的Oracle 11.2.0.4打补丁的方法，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对我们网站的支持！
如果你觉得本文对你有帮助，欢迎转载，烦请注明出处，谢谢！

Oracle数据库opatch补丁操作流程

一. 升级前准备工作 1. 确认数据库版本使用dba登陆查询当前数据库的版本 SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE
[Oracle] Data Guard CPU/PSU补丁安装详细教程

非Data Guard的补丁安装教程可参考<[Oracle] CPU/PSU补丁安装详细教程>,Data Guard需要Primary和Standby同时打上补丁,所以步骤更复杂一些,其主要步骤如下:1.在Primary停止日志传输服务:2.关闭Standby数据库,在Standby的软件上打补丁(注意:不需要为Standby数据库打补丁),启动standby为mount状态,不启用managed recovery:3.关闭Primary,在Primary的软件和数据库本身都打上补丁:4.启动
VMware中linux环境下oracle安装图文教程（二）ORACLE 10.2.05版本的升级补丁安装

首先我们解压 $ unzip p8202632_10205_LINUX.zip 解压后我们会发现多出了个文件夹,他是:Disk1,进入Disk1.然后执行安装: $ ./runInstaller 执行脚本 # /u01/app/oracle/10.2.0/db_1/root.shRunning Oracle 10g root.sh script...The following environment variables are set as: ORACLE_OWNER= oracle
[Oracle] CPU/PSU补丁安装详细教程

什么是CPU/PSU Oracle CPU的全称是Critical Patch Update, Oracle对于其产品每个季度发行一次安全补丁包,通常是为了修复产品中的安全隐患. Oracle PSU的全称是Patch Set Update,Oracle对于其产品每个季度发行一次的补丁包,包含了bug的修复.Oracle选取被用户下载数量多,且被验证过具有较低风险的补丁放入到每个季度的PSU中.在每个PSU中不但包含Bug的修复而且还包含了最新的CPU.PSU通常随CPU一起发布. CPU是累积
Oracle 11.2.0.4打补丁的方法

所需补丁及高版本opatch image上传后将p6880880_112000_Linux-x86-64.zip解压覆盖$ORACLE_HOME/OPatch目录即可 [oracle@localhost OPatch]$ ./opatch version OPatch Version: 11.2.0.3.16 OPatch succeeded. 检查环境是否需要打补丁,opatch版本安装环境可以看mos和readme 查看组件信息 12:40:47 SYS@std> set linesize
Linux 7.4上安装配置Oracle 11.2.0.4图文教程

1. 配置Yum源及关闭SeLinux [root@localhost ~]# mkdir /media/rhel [root@localhost ~]# mount /dev/cdrom /media/rhel mount: /dev/sr0 is write-protected, mounting read-only [root@localhost ~]# vi /etc/yum.repos.d/iso.repo [iso] name=iso baseurl=file:///media/rh
CentOS 7.4下安装Oracle 11.2.0.4数据库的方法

在Linux下安装Oracle数据库是一件较为麻烦的事情. 由于Linux的安装过程中可能会选择不同的安装包,会导致Oracle安装过程中缺失或多一些软件包,很难一次性的安装成功.所以,本文详细记录了Oracle在Linux上的安装过程,以供参考. 本环境仅供软件开发和测试环境使用,并不适合用于生产环境. Oracle官方支持的Linux发行版本有RedHat和Oracle Linux,所以,我们在CentOS(7.4)下安装Oracle(11gR2)时,还需要做一些特别的准备工作. 本文的Ce
Oracle11.2.0.1如何升级到11.2.0.3 Oracle同版本升级

Oracle数据库升级也并非简单的事,这篇文章对Oracle那点事做了较详细的介绍:Oracle数据库升级或数据迁移方法研究我还属于Oracle的菜鸟,就不献丑介绍了. 下面我就简单总结下,Oracle同版本升级的经历: 升级数据库: 1. 先检查数据库当前版本:SELECT * FROM v$version; 2. 使用RMAN或exp 进行全库备份 [这一步非常非常重要,因升级到数据部分时,虚拟机没空间了,导致VM崩溃,升级失败.orcl库也挂了,不得不从另一台Oracle上创建了一个O
ORACLE 11g从 11.2.0.1升级到11.2.0.4 详细实战教程

1.准备安装查看当前oracle版本,确定是比较旧的11.2.0.1 [oracle@hch_test_121_90 ~]$ rlwrap sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 17 15:20:45 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g E
oracle11g 最终版本11.2.0.4安装详细过程介绍

--安装背景上次碰到问题,cursor:mutex S导致的load过高, 有说可以升级到11.2.0.4就能避免这种问题,所以准备重新搭建新版本11.2.0.4. 安装环境是:azure云 linux centos6.5. 1,修改内核 1.1 修改sysctl.conf文件 [root@orcltest Downloads]# vim/etc/sysctl.conf # add by tim.man kernel.shmmax = 277495689510912 kernel.shmmni
Java开发Oracle数据库连接JDBC Thin Driver 的三种方法

Oracle的jdbc驱动三种主要分类: 1.JDBC OCI: oci是oracle call interface的缩写,此驱动类似于传统的ODBC 驱动.因为它需要Oracle Call Interface and Net8,所以它需要在运行使用此驱动的JAVA程序的机器上安装客户端软件,其实主要是用到orcale客户端里以dll方式提供的oci和服务器配置. 2.JDBC Thin: thin是for thin client的意思,这种驱动一般用在运行在WEB浏览器中的JAVA程序.它不是
Oracle 10g利用amdu抽取数据文件的方法教程

前言本文主要给大家介绍的是关于Oracle 10g利用amdu抽取数据文件的相关内容,下面话不多说了,来一起看看详细的介绍吧环境:OEL 5.7 + Oracle 10.2.0.5 RAC 需求:实验在Oracle 10g环境使用amdu抽取数据库文件本文主要目的是介绍3个知识点: 1.使amdu可以在oracle 10g环境中使用 2.使kfed可以在oracle 10g环境中使用 3.amdu如何抽取损坏的ASM磁盘组数据 1.使amdu可以在oracle 10g环境中使用在Orac
Oracle数据加载和卸载的实现方法

在日常工作中:经常会遇到这样的需求: Oracle 数据表跟文本或者文件格式进行交互:即将指定文件内容导入对应的 Oracle 数据表中:或者从 Oracle 数据表导出. 其他数据库中的表跟Oracle数据库进行交互. 若是少量数据:可选择的解决方案有很多.常用的用 Pl/SQL developer工具,或者手动转换为 INSERT 语句,或者通过API.但数据量大:用上面的方法效率太烂了.本文来说说 Oracle 数据的加载和卸载. Oracle中的DBLINK Oracle加载数据-外部表
Oracle出现超出打开游标最大数的解决方法

本文实例讲述了Oracle出现超出打开游标最大数的解决方法.分享给大家供大家参考,具体如下: Java代码在执行conn.createStatement()和conn.prepareStatement()的时候,实际上都是相当与在数据库中打开了一个cursor.尤其是,假如你的createStatement和prepareStatement是在一个循环里面的话,就会非常轻易出现这个问题.因为游标一直在不停的打开,而且没有关闭. 一般来说,我们在写Java代码的时候,createStatement

Oracle 11.2.0.4打补丁的方法

相关推荐

随机推荐