Oracle 12c 单机安装PSU(12.1.0.2.161018)-低调大师

Oracle 12c 单机安装PSU(12.1.0.2.161018)

2016-12-13 1012

一、准备工作

1，数据库环境

操作系统版本 : Redhat 7.1 x64
数据库版本 : Oracle 12.1.0.2 x64
Oracle database: 12.1.0.2

2，准备内容

OPatch : p6880880_122010_Linux-x86-64.zip
DB PSU : p24006101_121020_Linux-x86-64.zip 仅oracle12c单机使用。

二、更新OPatch

说明：更新database OPatch版本。

1. 更新OPatch版本，OPatch直接压缩替换就可以了。

(1) 上传p6880880_122010_Linux-x86-64.zip到/u01/software目录下, /u01/software给777权限。
(2) root用户下将原OPatch目录改名。

mv /u01/app/oracle/product/12.1.0/db_1/OPatch /u01/app/oracle/product/12.1.0/db_1/OPatchBK

2. oracle目录OPatch替换

(1) root用户

cd /u01/software/;chown oracle:oinstall p6880880_122010_Linux-x86-64.zip

(2) oracle用户

su - oracle
cd /u01/software/ ; unzip p6880880_122010_Linux-x86-64.zip

(3) root用户

cd /u01/software/; mv OPatch /u01/app/oracle/product/12.1.0/db_1/

(4) oracle用户测试

su - oracle
/u01/app/oracle/product/12.1.0/db_1/OPatch/opatch version

OPatch Version: 12.2.0.1.8
OPatch succeeded.

三、开始升级PSU

说明:
(1) 升级过程会自动关闭和启动集群。
(2) 先升级节点1 grid，再升级节点2 grid。

1. oracle用户下解压PSU补丁包

(1) root用户操作

cd /u01/software/;chown oracle:oinstall p24006101_121020_Linux-x86-64.zip

(2) oracle用户操作

# su - oracle
$ cd /u01/software/;unzip p24006101_121020_Linux-x86-64.zip

2. 测试兼容性, 之前没有打过,这步也可以忽略。

su - oracle

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/24006101 -oh $ORACLE_HOME

----------------------------------------------------
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2016, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-12-14_00-49-41AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
----------------------------------------------------

四、打database PSU补丁

1. 关闭数据库

[oracle@test ~]$ sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 14 00:54:26 2016

SQL> conn / as sysdba;
Connected.
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY NO
         3 PDB1                           READ WRITE NO
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit

2. oracle database打补丁

$ /u01/app/oracle/product/12.1.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/24006101

--------------------------------------------------------------
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-12-14_00-57-47AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 19769480 20299023 20831110 21359755 21948354 22291127 23054246 24006101

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

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

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/crs/install/tfa_setup" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/crs/install/tfa_setup"

Patching component oracle.rdbms.util, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/rdbms/mesg/diaus.msb" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/rdbms/mesg/diaus.msb"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/rdbms/mesg/diaus.msg" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/rdbms/mesg/diaus.msg"

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libzt12.a" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libzt12.a"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libccme_asym.so" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libccme_asym.so"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libccme_ecc.so" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libccme_ecc.so"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libccme_ecc_accel_fips.so" because it is the same as
the file in incoming patch "/u01/software/24006101/19769480/files/lib/libccme_ecc_accel_fips.so"

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20299023' to OH '/u01/app/oracle/product/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.tfa, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/crs/install/tfa_setup" because it is the same as
the file in incoming patch "/u01/software/24006101/20299023/files/crs/install/tfa_setup"

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf.ic, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Applying sub-patch '20831110' to OH '/u01/app/oracle/product/12.1.0/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libccme_ecc_accel_non_fips.so" because it is the same as
the file in incoming patch "/u01/software/24006101/20831110/files/lib/libccme_ecc_accel_non_fips.so"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libccme_ecc_non_fips.so" because it is the same as
the file in incoming patch "/u01/software/24006101/20831110/files/lib/libccme_ecc_non_fips.so"

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...
Applying sub-patch '21359755' to OH '/u01/app/oracle/product/12.1.0/db_1'

Patching component oracle.assistants.server, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...
Applying sub-patch '21948354' to OH '/u01/app/oracle/product/12.1.0/db_1'

Patching component oracle.rdbms.deconfig, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.xdk.parser.java, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.xdk.rsf, 12.1.0.2.0...
Applying sub-patch '22291127' to OH '/u01/app/oracle/product/12.1.0/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 12.1.0.2.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 12.1.0.2.0...

Patching component oracle.ldap.client, 12.1.0.2.0...

Patching component oracle.tfa, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/rdbms/admin/prvtbkrs.plb" because it is the same as
the file in incoming patch "/u01/software/24006101/22291127/files/rdbms/admin/prvtbkrs.plb"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/rdbms/admin/dbmsbkrs.sql" because it is the same as
the file in incoming patch "/u01/software/24006101/22291127/files/rdbms/admin/dbmsbkrs.sql"

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.oraolap, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.oraolap.dbscripts, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/rdbms/admin/dbmsaw.sql" because it is the same as
the file in incoming patch "/u01/software/24006101/22291127/files/rdbms/admin/dbmsaw.sql"
Applying sub-patch '23054246' to OH '/u01/app/oracle/product/12.1.0/db_1'

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.ldap.rsf, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libzt12.a" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/lib/libzt12.a"

Patching component oracle.install.deinstalltool, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libldapjclnt12.so" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/lib/libldapjclnt12.so"

Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...

Patching component oracle.oracore.rsf, 12.1.0.2.0...

Patching component oracle.ctx, 12.1.0.2.0...

Patching component oracle.xdk, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/xmldiff" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xmldiff"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/xvm" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xvm"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/xmlpatch" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xmlpatch"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/xsl" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xsl"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/xmlcg" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xmlcg"

Patching component oracle.nlsrtl.rsf, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/lxegen" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/lxegen"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/lcsscan" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/lcsscan"
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/lxchknlb" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/lxchknlb"

Patching component oracle.xdk.parser.java, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/bin/xml" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/bin/xml"

Patching component oracle.ctx.atg, 12.1.0.2.0...
Skip copying to "/u01/app/oracle/product/12.1.0/db_1/lib/libanllexer12.so" because it is the same as
the file in incoming patch "/u01/software/24006101/23054246/files/lib/libanllexer12.so"
Applying sub-patch '24006101' to OH '/u01/app/oracle/product/12.1.0/db_1'

Patching component oracle.sqlplus, 12.1.0.2.0...

Patching component oracle.rdbms, 12.1.0.2.0...

Patching component oracle.network.listener, 12.1.0.2.0...

Patching component oracle.network.rsf, 12.1.0.2.0...

Patching component oracle.rdbms.dv, 12.1.0.2.0...

Patching component oracle.rdbms.rman, 12.1.0.2.0...

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patching component oracle.sqlplus.ic, 12.1.0.2.0...

Patching component oracle.rdbms.rsf, 12.1.0.2.0...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
/bin/ld: warning: libstdc++.so.5, needed by /u01/app/oracle/product/12.1.0/db_1/ctx/lib//libsc_ca.so, not found (try using -rpath or -rpath-link)

Composite patch 24006101 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-12-14_00-57-47AM_1.log

OPatch completed with warnings.
--------------------------------------------------------------

注：上面/bin/ld: warning: libstdc++.so.报错，缺少compat-libstdc++-33包，并且RHEL7.1安装光盘中没有，需要采用yum方式安装。

3. 检查打补丁情况

[root@test ~]# su - oracle
[oracle@test ~]$ $ORACLE_HOME/OPatch/opatch lsinv

Oracle Home       : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-12-14_01-13-15AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-12-14_01-13-15AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 24006101     : applied on Wed Dec 14 00:58:42 CST 2016
Unique Patch ID: 20683584
Patch description: "Database Patch Set Update : 12.1.0.2.161018 (24006101)"
   Created on 1 Oct 2016, 12:33:50 hrs PST8PDT
Sub-patch 23054246; "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
   Bugs fixed:
     21099555, 22175564, 19141838, 22083366, 20842388, 20117253, 19865345
     19791273, 19243521, 20951038, 19908836, 21281532, 19238590, 24577566
     21184223, 19134173, 20387265, 19149990, 21263635, 18886413, 17551063
     22160989, 22507210, 19703301, 19366375, 19001390, 18202441, 20267166
     19358317, 19706965, 18549238, 19068970, 18797519, 22148226, 20825533
     19649152, 19670108, 18940497, 18948177, 18964978, 19035573, 19176326
     20413820, 19176223, 20904530, 20134339, 19074147, 20868862, 18411216
     21322887, 22507234, 20425790, 18966843, 21329301, 19333670, 19468991
     20124446, 19883092, 19658708, 19591608, 19402853, 20618595, 21787056
     22380919, 21266085, 17835294, 19721304, 19791377, 19068610, 22178855
     22173980, 20746251, 20048359, 20898391, 19185876, 20281121, 20907061
     6599380, 19577410, 22092979, 20603378, 19001359, 19490948, 21387964
     20832516, 17532734, 19309466, 19081128, 20627866, 20844426, 21188532
     18791688, 21442094, 20890311, 20596234, 18973548, 21296029, 19303936
     19461270, 21479753, 20936905, 20235511, 21220620, 18964939, 19430401
     22296366, 21153266, 19409212, 22657942, 20657441, 19879746, 19684504
     20528052, 19024808, 20977794, 18799993, 20466322, 18740837, 19662635
     20228093, 19065556, 20212067, 19524384, 17722075, 20446883, 18952989
     16870214, 19928926, 19835133, 21629064, 20466628, 24386767, 19931709
     19730508, 18819908, 23124895, 19188927, 20074391, 20356733, 14643995
     19547370, 19065677, 21960504, 21225209, 20397490, 18967382, 19174430
     21241829, 19536415, 19171086, 22465352, 22168163, 19335438, 20447445
     18856999, 20471920, 19869255, 21620471, 18990693, 17890099, 18990023
     20101006, 21300341, 20848335, 21744290, 20897759, 21668627, 19304354
     19052488, 20794034, 23260854, 18681056, 20952966, 19896336, 18618122
     20328248, 20440930, 18456643, 19699191, 19201867, 22865673, 18743542
     20798891, 20347562, 22551446, 19777862, 19687159, 21373076, 19174942
     20424899, 21899588, 18899974, 20598042, 19032777, 19058490, 22815955
     19399918, 19434529, 21273804, 19018447, 22757364, 18851894, 19284031
     19022470, 18043064, 20173897, 22062026, 20475845, 17274537, 19440586
     16887946, 22374754, 17319928, 20708701, 17655240, 16439813, 19805359
     19155797, 20859910, 19393542, 22024071, 17210525, 21847223, 19189525
     21649497, 19075256, 22762046, 22075064, 19280225, 18845653, 20560611
     19248799, 21756699, 18988834, 20245930, 18921743, 18799063, 20373598
     20476175, 19571367, 20925795, 19018206, 20509482, 20711718, 20588502
     18849537, 19183343, 21917884, 19189317, 19644859, 19390567, 19279273
     20669434, 16863642, 22528741, 19619732, 18607546, 20348653, 19315691
     19676905, 20165574, 17867700, 20558005, 20734332, 19532017, 20922010
     19450314, 22353346, 20361671, 20009833, 22366558, 20294666, 18191823
     19307662, 19371175, 19195895, 20043616, 19154375, 18914624, 20139391
     21291274, 19174521, 19520602, 19382851, 21875360, 19676012, 19326908
     20217801, 20093776, 21097043, 21246723, 21665897, 19143550, 20428621
     19627012, 14283239, 19518079, 18610915, 18674024, 18306996, 19524158
     19915271, 20122715, 20284155, 20017509, 19363645, 19597439, 21239530
     19888853, 20880215, 21756677, 19534363, 19354335, 19044962, 19639483
     22353199, 22243719, 22916353, 20378086, 21756661, 21260431, 22923409
     20877664, 19028800, 20879889, 19723336, 19077215, 21421886, 19604659
     19308965, 19048007, 18288842, 19689979, 21526048, 19180770, 19197175
     19902195, 20318889, 19013183, 19012119, 20464614, 19067244, 21632821
     19512341, 19841800, 20331945, 19587324, 24316947, 19578350, 19637186
     18674047, 19054077, 20898997, 19708632, 21091431, 19289642, 20869721
     19258504, 17365043, 19468347, 21373473, 16359751, 19439759, 19769480
     19272708, 19978542, 20402832, 19329654, 19873610, 23229229, 21517440
     13542050, 19291380, 21915719, 19076343, 19561643, 19990037, 19487147
     18909599, 20831538, 18250893, 19016730, 16619249, 18354830, 21188584
     19989009, 17414008, 20688221, 20704450, 20441797, 19157754, 18885870
     21785691, 21450666, 18893947, 18705806, 22223463, 16923858, 18417036
     20919320, 20474192, 22046677, 19385656, 19501299, 20920911, 20899461
     21387128, 21315084, 18122373, 20581111, 19606174, 18436647, 19023822
     19178851, 19124589, 19597583, 18499088, 19050649

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

OPatch succeeded.

[oracle@test ~]$ $ORACLE_HOME/OPatch/opatch lspatches
24006101;Database Patch Set Update : 12.1.0.2.161018 (24006101)

OPatch succeeded.

五、注册PSU信息到数据库

1. 启动oracle数据库

SQL> conn / as sysdba;
Connected to an idle instance.
SQL> startup;
ORACLE instance started.

Total System Global Area 2499805184 bytes
Fixed Size                  2927480 bytes
Variable Size             738198664 bytes
Database Buffers         1744830464 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.
SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY NO
         3 PDB1                           READ WRITE NO
SQL>
SQL>

如查没有配置pdb数据库开机自启动，可以执行如下命令启动pdb数据库。

SQL> alter pluggable database all open;
Pluggable database altered.
SQL>

2. 注册PSU到数据库

[root@db1 ~]# su - oracle
[oracle@test ~]$ cd /u01/app/oracle/product/12.1.0/db_1/OPatch
[oracle@test OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Wed Dec 14 01:30:22 2016
Copyright (c) 2016, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_9041_2016_12_14_01_30_22/sqlpatch_invocation.log

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
ID 161018 in the binary registry and not installed in any PDB

Adding patches to installation queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED PDB1
    Nothing to roll back
    The following patches will be applied:
      24006101 (Database Patch Set Update : 12.1.0.2.161018 (24006101))

Installing patches...
Patch installation complete. Total patches installed: 3

Validating logfiles...
Patch 24006101 apply (pdb CDB$ROOT): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24006101/20683584/24006101_apply_ORCL_CDBROOT_2016Dec14_01_31_03.log (no errors)
Patch 24006101 apply (pdb PDB$SEED): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24006101/20683584/24006101_apply_ORCL_PDBSEED_2016Dec14_01_31_28.log (no errors)
Patch 24006101 apply (pdb PDB1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24006101/20683584/24006101_apply_ORCL_PDB1_2016Dec14_01_31_28.log (no errors)
SQL Patching tool complete on Wed Dec 14 01:31:53 2016
[oracle@test OPatch]$

3. 查看数据库补丁记录

oracle12c(12.1.0.2起采用dba_registry_sqlpatch如下方式查看数据库补丁记录)
$ sqlplus / as sysdba;
SQL> set linesize 300
SQL> col DESCRIPTION for a30
SQL> col ACTION_TIME for a30
SQL> select PATCH_ID, PATCH_UID,VERSION,ACTION, STATUS,ACTION_TIME,DESCRIPTION from dba_registry_sqlpatch;

PATCH_ID PATCH_UID VERSION ACTION STATUS ACTION_TIME DESCRIPTION
---------- ---------- -------------------- --------------- --------------- ------------------------------ ------------------------------
24006101 20683584 12.1.0.2 APPLY SUCCESS 14-DEC-16 01.31.51.376483 AM Database Patch Set Update : 12.1.0.2.161018 (24006101)
SQL>

微信关注我们

原文链接：https://blog.51cto.com/koumm/1882365

转载内容版权归作者及来源网站所有！

低调大师中文资讯倾力打造互联网数据资讯、行业资源、电子商务、移动互联网、网络营销平台。持续更新报道IT业界、互联网、市场资讯、驱动更新,是最及时权威的产业资讯及硬件资讯报道平台。

Hyper-v 2016 VHD Set

Hyper-v 2016 VHD Set 微软在Windows Server 2016 Hyper-v中新增了一种磁盘类型--“VHD集”，和以前版本的共享VHD类似，这种类型的磁盘能够在多个服务器之间共享来实现来宾群集。看到这里相信有很多熟悉Hyper-v的朋友会问：这和以前的 Share VHDX有什么区别？下面我们就来看一下： Share VHDX可以使多个虚拟机之间共用一个虚拟硬盘，这对于实施需要使用磁盘共享的来宾操作系统群集是十分有用的，例如我们常见的SQL Server AlwaysON等等。但是使用Share VHDX会有如下限制： 1、Share VHDX不支持做备份或者副本 2、Share VHDX不支持调整大小或迁移 VHD集则没有上述的限制，但是VHD集仅适用于Windows Server 2016来宾操作系统。闲言少叙，下面我们来看一下如何配置VHD集创建VHD集：打开“故障转移群集管理器”—“虚拟机”—“新建硬盘”：在向导页点击“下一步”：磁盘格式选择“VHD集”：根据实际情况选择磁盘类型：指定虚拟磁盘名称和存储位置：指定磁盘大小：摘要页确...

2016-12-13

1115

一、简述这几天在看了ansible官网，收获蛮多。截取一个lineinfile模块作一个总结。如果批量修改配置文件某一行时，在写playbook时lineinfile避免不了的。根据官网说法：lineinfile - Ensure a particular line is in a file, or replace an existing line using a back-referenced regular expression.大意是说，针对文件特殊行，使用后端引用的正则表达式来替换二、实践 playbook，我先定义前面common部分。 --- -hosts:"`host`" remote_user:"`user`" gather_facts:false tasks: 由于我已经定义标签tags，执行playbook中某个特定任务时，只需执行到对应TAGNAME便可 ansible-playbook line1.yml --extra-vars "host=gitlab user=root" --tags "TAGNAME" -v 1、正则匹配，更改某个...

2016-12-13

744

资源下载

更多资源

Mario

马里奥是站在游戏界顶峰的超人气多面角色。马里奥靠吃蘑菇成长，特征是大鼻子、头戴帽子、身穿背带裤，还留着胡子。与他的双胞胎兄弟路易基一起，长年担任任天堂的招牌角色。

Nacos

Nacos /nɑ:kəʊs/ 是 Dynamic Naming and Configuration Service 的首字母简称，一个易于构建 AI Agent 应用的动态服务发现、配置管理和AI智能体管理平台。Nacos 致力于帮助您发现、配置和管理微服务及AI智能体应用。Nacos 提供了一组简单易用的特性集，帮助您快速实现动态服务发现、服务配置、服务元数据、流量管理。Nacos 帮助您更敏捷和容易地构建、交付和管理微服务平台。

Rocky Linux

Rocky Linux（中文名：洛基）是由Gregory Kurtzer于2020年12月发起的企业级Linux发行版，作为CentOS稳定版停止维护后与RHEL（Red Hat Enterprise Linux）完全兼容的开源替代方案，由社区拥有并管理，支持x86_64、aarch64等架构。其通过重新编译RHEL源代码提供长期稳定性，采用模块化包装和SELinux安全架构，默认包含GNOME桌面环境及XFS文件系统，支持十年生命周期更新。

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能，例如代码缩略图，Python的插件，代码段等。还可自定义键绑定，菜单和工具栏。Sublime Text 的主要功能包括：拼写检查，书签，完整的 Python API ， Goto 功能，即时项目切换，多选择，多窗口等等。Sublime Text 是一个跨平台的编辑器，同时支持Windows、Linux、Mac OS X等操作系统。