探索Oracle之数据库升级五PSU11.2.0.4.3rollback11.2.0.4.0 - 数据库编程

)) Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521))) Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUSof the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version11.2.0.4.0 - Production StartDate 04-OCT-2014 07:04:31 Uptime 0 days 0 hr. 0 min. 0 sec TraceLevel off Security ON: Local OS Authentication SNMP OFF ListenerParameter File /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora ListenerLog File /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml ListeningEndpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521))) Thelistener supports no services Thecommand completed successfully SQL>startup ORACLEinstance started. TotalSystem Global Area 2872786944 bytes FixedSize 2256712 bytes VariableSize 2634023096 bytes DatabaseBuffers 218103808 bytes RedoBuffers 18403328 bytes Databasemounted. Databaseopened. SQL> SQL>alter system register; Systemaltered. SQL>@?/rdbms/admin/catbundle_PSU_WOO_ROLLBACK.sql SQL>alter system register; Systemaltered. SQL>alter system register; Systemaltered.

三、检查回滚后的版本：

[oracle@db0118522509]$ /home/oracle/OPatch/opatch lsinventory

OracleInterim Patch Installer version 11.2.0.3.6

Copyright(c) 2013, Oracle Corporation.  All rightsreserved.

 

 

OracleHome       : /DBSoft/Product/11.2.4/db_1

CentralInventory : /DBSoft/oraInventory

   from           :/DBSoft/Product/11.2.4/db_1/oraInst.loc

OPatchversion    : 11.2.0.3.6

OUIversion       : 11.2.0.4.0

Log filelocation : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-04_07-10-34AM_1.log

 

LsinventoryOutput file location :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-04_07-10-34AM.txt

 

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

InstalledTop-level Products (1): 

 

OracleDatabase 11g                                                 11.2.0.4.0

Thereare 1 product(s) installed in this Oracle Home.

 

 

Thereare no Interim patches installed in this Oracle Home.

 

 

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

 

OPatchsucceeded.

[oracle@db0118522509]$

 

SQL>




col comp_name format a40

SQL>col comp_id format a10

SQL>col version format a20

SQL>col status format a30

SQL>col status format a6

SQL>set line 300

SQL>set pagesize 200

SQL>r

  1* select comp_id,comp_name,version,statusfrom dba_registry

 

COMP_ID    COMP_NAME                                VERSION              STATUS

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

EM         Oracle Enterprise Manager                11.2.0.4.0           VALID

OWB        OWB                                     11.2.0.3.0           VALID

APEX       Oracle Application Express               3.2.1.00.12          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 Types       11.2.0.4.0           VALID

JAVAVM     JServer JAVA Virtual Machine             11.2.0.4.0           VALID

XML        Or

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