libzb访问oracle库,Oracle 12c 单机安装PSU(12.1.0.2.161018)

电玩女神 2023-01-18 09:06 72阅读 0赞

一、准备工作

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

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

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\]

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\]

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 Interim Patch Installer version 12.2.0.1.8

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>

如查没有配置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

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>

或关注我们的官方微博微信，还有更多惊喜哦~

![bc002a757435a6c617cb4e1a1fdb4edb.png][]

[bc002a757435a6c617cb4e1a1fdb4edb.png]: /images/20221021/b881db3961994e3f91e348b9a9b62391.png

libzb访问oracle库,Oracle 12c 单机安装PSU(12.1.0.2.161018)

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 oracle12.2 psu,Oracle 12.2 家族的补丁 RU 和 RUR 说明

相关 libzb访问oracle库,Oracle 12c 单机安装PSU(12.1.0.2.161018)

相关 Docker 安装Oracle12c

相关 Oracle 12c Study之-- Oracle 12.2安装

相关 C#通过ODAC访问Oracle12c

相关 CentOS安装Oracle12C

相关 Oracle12c 安装问题

相关 centos 安装oracle12c

相关 oracle12C安装说明

相关 oracle12C安装说明