SQL> select comp_id, comp_name, version, status from dba_registry;
COMP_ID
------------------------------
COMP_NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
www.msqkp.cn
www.trwjp.cn
www.gwdyr.cn
www.wlysk.cn
www.pqhsw.cn
www.mknzz.cn
www.smknq.cn
www.prpyq.cn
www.mtrwp.cn
------------------------------ --------------------------------------------
OWB
OWB
11.2.0.1.0 VALID
APEX
Oracle Application Express
3.2.1.00.10 VALID
EM
Oracle Enterprise Manager
11.2.0.4.0 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
www.kknhg.cn
www.xgtzh.cn
www.rkmnx.cn
www.krrlb.cn
www.gqkzd.cn
www.rkffb.cn
www.jplxm.cn
www.bnjcx.cn
www.lzmdg.cn
www.bmfnr.cn
www.hsfpp.cn
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
www.jfclt.cn
www.jgwnn.cn
www.wtjmg.cn
www.frydt.cn
www.wjqbs.cn
www.mxfgl.cn
www.slqrs.cn
www.rgglg.cn
www.qbgtr.cn
www.wqsjl.cn
www.vmtrck.cn
www.zfzozh.cn
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
www.oygtll.cn
www.mqoqzb.cn
www.buwpxf.cn
www.bqfgdl.cn
www.uqlbnw.cn
www.panujt.cn
www.zirivk.cn
www.suztkw.cn
www.ptbdys.cn
www.vudvam.cn
www.zlshtr.cn
www.lpjzii.cn
11.2.0.4.0 VALID
CATJAVA
Oracle Database Java Packages
11.2.0.4.0 VALID
APS
OLAP Analytic Workspace
11.2.0.4.0 VALID
XOQ
Oracle OLAP API
11.2.0.4.0 VALID
18 rows selected.
SQL> select * from dba_objects where status='INVALID';
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ------------------- --------- ---------
www.wqstj.cn
www.htqwb.info
www.lgpby.info
www.wtbzz.info
www.prhxj.info
www.qqyfq.info
www.wfqft.cn
------------------- ------- - - - ---------- ------------------------------
SYS KUPW$WORKER 11635 PACKAGE BODY 31-OCT-16 10-NOV-17
2017-11-10:03:08:52 INVALID N N N 2
SQL> @?/rdbms/admin/utlu112i.sql;
Oracle Database 11.2 Pre-Upgrade Information Tool 11-10-2017 03:12:09
Script Version: 11.2.0.4.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: SZQMDM
--> version: 11.2.0.4.0
--> compatible: 11.2.0.0.0
--> blocksize: 8192
--> timezone file: V11
.
Database already upgraded; to rerun upgrade use rdbms/admin/catupgrd.sql.