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

STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version11.2.0.4.0 - Production Start Date 04-OCT-2014 06:34:29 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora Listener Log File /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml Listening EndpointsSummary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521))) The listener supports noservices The command completedsuccessfully SQL> alter systemregister; System altered. SQL> @?/rdbms/admin/catbundle.sqlpsu apply

九、确认更新后的dba_registry_history视图信息

SQL> col action_time format a35

SQL> col action format a15

SQL> col namespace format a10

SQL> col version format a10

SQL> select action_time,action,namespace,version,idfrom dba_registry_history

 

ACTION_TIME                         ACTION          NAMESPACE  VERSION            ID

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

17-SEP-11 10.21.11.595816 AM        APPLY           SERVER     11.2.0.3            0

04-OCT-14 12.16.44.664335 AM        APPLY           SERVER     11.2.0.3            0

04-OCT-14 04.01.36.022121 AM        VIEW INVALIDATE                          8289601

04-OCT-14 04.01.36.121141 AM        UPGRADE         SERVER     11.2.0.4.0

04-OCT-14 06.35.32.745430 AM        APPLY           SERVER     11.2.0.4            3

 

SQL> selectaction,comments from registry$history

 

ACTION          COMMENTS

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

APPLY           Patchset 11.2.0.2.0

APPLY           Patchset 11.2.0.2.0

VIEW INVALIDATE viewinvalidation

UPGRADE         Upgraded from 11.2.0.3.0

APPLY           PSU 11.2.0.4.3

ROLLBACK        PSU 11.2.0.4.3

APPLY           Patchset 11.2.0.2.0

APPLY           PSU 11.2.0.4.3

APPLY           PSU 11.2.0.4.3

 

SQL> SELECT * FROMPRODUCT_COMPONENT_VERSION

 

PRODUCT                                  VERSION    STATUS

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

NLSRTL                                   11.2.0.4.0Production

Oracle Database 11gEnterprise Edition   11.2.0.4.0 64bitProduction

PL/SQL                                   11.2.0.4.0Production

TNS for Linux:                           11.2.0.4.0Production

至此，PSU已经完成

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