本帖最后由 liu_qingwei2008 于 2011-12-9 14:27 编辑
11.2.0.1升级到11.2.0.3后感觉不正常,请高手帮看看。谢谢!
[oracle@localhost ~]$ sqlplus / as sysdba
s
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 9 14:18:17 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
SQL> select distinct object_name FROM dba_invalid_objects;
OBJECT_NAME
--------------------------------------------------------------------------------
/3ed986d2_SegmentationDataType
/51fce785_SubLayerInfoScalingF
/918fe946_SubLayerInfoStatisti
/30559e24_SdoGeorPKG
/42c667ae_GeoRasterSRSAdapter
/9d27ee71_SpatialReferenceInfo
/fc7881f7_SpatialReferenceInfo
/843a9d92_SubLayerInfoColormap
/1ee27fc7_SubLayerInfoGrayscal
/578c2b04_SubLayerInfoRasterGr
/f7c0e173_SubLayerInfoRasterPs
OBJECT_NAME
--------------------------------------------------------------------------------
/9d4abdc7_BlobDecodeParam
/a3e12f8a_JP2Compressor
/b7328870_GeoTIFFWriter
/d94f0d7c_BLOBWriter
/976f73d9_PNGWriter
/74fcd842_BandReferenceInfoBan
/378df9a3_RasterInfoDimensionS
/b5956ed3_ResolutionType
/6b8ab103_Compressor
/39b18dc9_BlobCodec
/a8d27e67_GeoRasterImageProces
OBJECT_NAME
--------------------------------------------------------------------------------
/7c917f61_TIFFWriter
/a7845786_SpatialReferenceInfo
/fd247f09_SubLayerInfoCellGray
/bec63728_GeoRasterImage
/3e7fa114_SdoGeoRaster
/83d15702_ExtentType
/9899cade_JGeoRaster
/13578568_JRaster
/84ac9a2b_LayerInfo
/621866a9_RasterInfoBlockingDe
/cdf836cc_RasterInfo
OBJECT_NAME
--------------------------------------------------------------------------------
/1e16d7bd_RasterInfoPyramidDes
/70178183_SubLayerInfoCellCoun
/b71dcac6_SubLayerInfo
/4d6360de_SubLayerInfoHistogra
/d12b8de1_SubLayerInfoNODATATy
/d6d3e921_SubLayerInfoRasterCo
/60887f2d_SubLayerInfoRectangu
/ec9f33aa_TemporalReferenceInf
/ac0f7327_BlobImage
/e240445a_BMPWriter
/6a4fffa1_JGeoRasterAdapter
OBJECT_NAME
--------------------------------------------------------------------------------
/b56145_CellCoordinateType
/9a7a58f9_JGeoRasterMeta
/2b830f06_SpatialReferenceInfo
/b33419d9_GeoRasterGeoTIFFInte
/dbf8243f_ObjectInfo
/c8aeb20d_RasterInfoCompressio
/f6a0dbab_SpatialReferenceInfo
/2155856b_SubLayerInfoBinFunct
/906a57a7_GeorGtfParser
/78fcde4a_GeoRasterImageNodata
/fc14e333_GeoRasterAdapter
OBJECT_NAME
--------------------------------------------------------------------------------
/928b6b32_JRasterAdapter
/93d2287f_BandReferenceInfo
/4e42d840_SubLayerInfoCellPseu
/ee8e1dfc_BlobImageDecoder
/ce3f022d_SISToIISAdapter
/8500ba6b_JPEGWriter
61 rows selected.
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
OWB 11.2.0.1.0 VALID
Oracle Application Express 3.2.1.00.10 VALID
Oracle Enterprise Manager 11.2.0.3.0 VALID
OLAP Catalog 11.2.0.3.0 VALID
Spatial 11.2.0.3.0 INVALID
Oracle Multimedia 11.2.0.3.0 VALID
Oracle XML Database 11.2.0.3.0 VALID
Oracle Text 11.2.0.3.0 VALID
Oracle Expression Filter 11.2.0.3.0 VALID
Oracle Rules Manager 11.2.0.3.0 VALID
Oracle Workspace Manager 11.2.0.3.0 VALID
COMP_NAME VERSION STATUS
---------------------------------------- ------------------------------ ----------------------
Oracle Database Catalog Views 11.2.0.3.0 VALID
Oracle Database Packages and Types 11.2.0.3.0 VALID
JServer JAVA Virtual Machine 11.2.0.3.0 VALID
Oracle XDK 11.2.0.3.0 VALID
Oracle Database Java Packages 11.2.0.3.0 VALID
OLAP Analytic Workspace 11.2.0.3.0 VALID
Oracle OLAP API 11.2.0.3.0 VALID
18 rows selected.
数据库启动着哪,下面是这样
[grid@localhost ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE localhost
ora....ER.lsnr ora....er.type ONLINE ONLINE localhost
ora.asm ora.asm.type ONLINE ONLINE localhost
ora.cssd ora.cssd.type ONLINE ONLINE localhost
ora.diskmon ora....on.type OFFLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE localhost
ora.ons ora.ons.type OFFLINE OFFLINE
ora.racdb1.db ora....se.type ONLINE OFFLINE