探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤 - 数据库编程

re being createdand run correctly: DOC> DOC> 1. Query showing jobs created by UTL_RECOMP DOC> SELECT job_name FROM dba_scheduler_jobs DOC> WHERE job_name like'UTL_RECOMP_SLAVE_%'; DOC> DOC> 2. Query showing UTL_RECOMP jobs that arerunning DOC> SELECT job_name FROMdba_scheduler_running_jobs DOC> WHERE job_name like'UTL_RECOMP_SLAVE_%'; DOC># PL/SQL proceduresuccessfully completed. TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMPUTLRP_END 2014-10-04 04:15:34 DOC> The following queryreports the number of objects that have compiled DOC> with errors. DOC> DOC> If the number ishigher than expected, please examine the error DOC> messages reportedwith each object (using SHOW ERRORS) to see if they DOC> point to systemmisconfiguration or resource constraints that must be DOC> fixed beforeattempting to recompile these objects. DOC># OBJECTS WITH ERRORS ------------------- 0 DOC> The following queryreports the number of errors caught during DOC> recompilation. Ifthis number is non-zero, please query the error DOC> messages in thetable UTL_RECOMP_ERRORS to see if any of these errors DOC> are due tomisconfiguration or resource constraints that must be DOC> fixed before objectscan compile successfully. DOC># ERRORS DURING RECOMPILATION --------------------------- 0 Function created. PL/SQL proceduresuccessfully completed. Function dropped. PL/SQL proceduresuccessfully completed. SQL>

该脚本耗时约为3分钟左右。

13、至此数据库已经升级完成，查看各组件版本号：

SQL> select comp_name,status,version fromdba_server_registry

 
COMP_NAME                                STATUS         VERSION
------------------------------------------------------ ------------------------------

OWB                                      VALID          11.2.0.3.0
Oracle ApplicationExpress                VALID          3.2.1.00.12
Oracle EnterpriseManager                 VALID          11.2.0.4.0
OLAP Catalog                             VALID          11.2.0.4.0
Spatial                                  VALID          11.2.0.4.0
Oracle Multimedia                        VALID          11.2.0.4.0
Oracle XML Database                      VALID          11.2.0.4.0
Oracle Text                              VALID          11.2.0.4.0
Oracle ExpressionFilter                  VALID          11.2.0.4.0
Oracle Rules Manager                     VALID          11.2.0.4.0
Oracle WorkspaceManager                  VALID          11.2.0.4.0
Oracle Database CatalogViews             VALID          11.2.0.4.0
Oracle Database Packages andTypes        VALID          11.2.0.4.0
JServer JAVA VirtualMachine              VALID          11.2.0.4.0
Oracle XDK                               VALID          11.2.0.4.0
Oracle Database JavaPackages             VALID          11.2.0.4.0
OLAP Analytic Workspace                  VALID          11.2.0.4.0
Oracle OLAP API                          VALID          11.2.0.4.0
 

18 rows selected.

14、检查无效对象：

SQL> select * fromdba_objects where status !='VALID';

 
no rows selected

15、升级成功后删除原来的目录，通过DBCA重建EM

[oracle@db01 /]$ rm -rf/DBSoft/Product/11.2.3/

手工创建EM资料库:
####emca -repos drop

 
[oracle@db01 /]$ emca -reposdrop

STARTED EMCA at Oct 4, 20146:11:41 AM
EM Configuration Assistant,Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011,Oracle.  All rights reserved.

 
Enter the followinginformation:
Database SID: woo
Listener port number: 1521
Password for SYS user:  
Password for SYSMANuser:  

 
----------------------------------------------------------------------
WARNING : While repositoryis dropped the database will be put in quiesce mode.
----------------------------------------------------------------------

Do you wish to continue?[yes(Y)/no(N)]: y
Oct 4, 2014 6:11:53 AMoracle.sysman.emcp.EMConfig perform
INFO: This operation isbeing logged at /DBSoft/cfgtoollogs/

探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤(十)