探索Oracle之数据库升级四11.2.0.4.0PSU11.2.0.4.3 - 数据库编程

------------------------------------------------------- Installed Top-level Products(1): Oracle Database 11g 11.2.0.4.0 There are 1 product(s)installed in this Oracle Home. Interim patches (1) : Patch 18522509 : applied on Sat Oct 04 05:37:21 CST 2014 Unique Patch ID: 17604597 Patch description: "Database Patch Set Update : 11.2.0.4.3(18522509)" Created on 30 Jun 2014, 08:14:42 hrs PST8PDT 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: 17752995, 17288409, 16392068, 17205719,17811429, 17767676, 17614227 17040764, 17381384, 17754782, 17726838,13364795, 17311728, 17389192 17006570, 17612828, 17284817, 17441661,13853126, 17721717, 13645875 18203837, 17390431, 16542886, 16992075,16043574, 17446237, 16863422 14565184, 17071721, 17610798, 17468141,17786518, 17375354, 17397545 18203838, 16956380, 17478145, 16360112,17235750, 17394950, 13866822 17478514, 17027426, 12905058, 14338435,16268425, 13944971, 18247991 14458214, 16929165, 17265217, 13498382,17786278, 17227277, 17546973 14054676, 17088068, 16314254, 17016369,14602788, 17443671, 16228604 16837842, 17332800, 17393683, 13951456,16315398, 18744139, 17186905 16850630, 17437634, 19049453, 17883081,15861775, 17296856, 18277454 16399083, 16855292, 18018515, 10136473,16472716, 17050888, 17865671 17325413, 14010183, 18554871, 17080436,16613964, 17761775, 16721594 17588480, 17551709, 17344412, 18681862,15979965, 13609098, 18139690 17501491, 17239687, 17752121, 17602269,18203835, 17297939, 17313525 16731148, 17811456, 14133975, 17600719,17385178, 17571306, 16450169 17655634, 18094246, 17892268, 17165204,17011832, 17648596, 16785708 17477958, 16180763, 16220077, 17465741,17174582, 18522509, 16069901 16285691, 17323222, 18180390, 17393915,16875449, 18096714, 17238511 17596908, 17811438, 17811447, 18031668,16912439, 18061914, 17622427 17545847, 16943711, 17082359, 17346671,18996843, 14852021, 17783588 16618694, 17672719, 17614134, 17341326,17546761, 17716305 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@db01 18522509]$/home/oracle/OPatch/opatch lspatches 18522509;Database Patch SetUpdate : 11.2.0.4.3 (18522509)

八、更新dba_registry_history视图最新PSU信息

SQL> startup

ORACLE instance started.

 

Total System Global Area2872786944 bytes

Fixed Size                  2256712 bytes

Variable Size            2634023096 bytes

Database Buffers          218103808 bytes

Redo Buffers               18403328 bytes

Database mounted.

Database opened.

SQL> !lsnrctl start

 

LSNRCTL for Linux: Version11.2.0.4.0 - Production on 04-OCT-2014 06:34:29

 

Copyright (c) 1991, 2013,Oracle.  All rights reserved.

 

Starting/DBSoft/Product/11.2.4/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version11.2.0.4.0 - Production

System parameter file is/DBSoft/Product/11.2.4/db_1/network/admin/listener.ora

Log messages written to/DBSoft/diag/tnslsnr/db01/listener/alert/log.xml

Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))

 

Connecting to(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

探索Oracle之数据库升级四11.2.0.4.0PSU11.2.0.4.3(五)