DB OPEN in MIGRATE status!
来源:互联网 发布:南斯拉夫大使馆知乎 编辑:程序博客网 时间:2024/06/06 02:26
C:/>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 10月 8 22:21:09 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup open update;
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
ORA-02231: missing or invalid option to ALTER DATABASE
【Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT,
OPEN, or CLOSE is specified in the statement.
Action: Specify only legal options.】
SQL> select status from v$instance;
STATUS
------------------------
STARTED
SQL> select open_mode from v$database;
select open_mode from v$database
*
第 1 行出现错误:
ORA-01507: database not mounted
【Cause: A command was attempted that requires the database to be mounted.
Action: If you are using the ALTER DATABASE statement via the SQLDBA startup command,
specify the MOUNT option to startup; else if you are directly doing an ALTER DATABASE
DISMOUNT, do nothing; else specify the MOUNT option to ALTER DATABASE. If you are doing a
backup or copy, you must first mount the desired database. If you are doing a FLASHBACK
DATABASE, you must first mount the desired database.】
SQL> alter database mount;
数据库已更改。
SQL> alter database open for update;
alter database open for update
*
第 1 行出现错误:
ORA-02288: invalid OPEN mode
【Cause: A token other than RESETLOGS appears following ALTER DATABASE <name> OPEN.
Action: Either nothing or RESETLOGS should be placed following OPEN.】
SQL> alter database open update;
alter database open update
*
第 1 行出现错误:
ORA-02288: invalid OPEN mode
【Cause: A token other than RESETLOGS appears following ALTER DATABASE <name> OPEN.
Action: Either nothing or RESETLOGS should be placed following OPEN.】
SQL> ALTER DATABASE OPEN READ WRITE RESETLOGS update;
ALTER DATABASE OPEN READ WRITE RESETLOGS update
*
第 1 行出现错误:
ORA-02288: invalid OPEN mode
【Cause: A token other than RESETLOGS appears following ALTER DATABASE <name> OPEN.
Action: Either nothing or RESETLOGS should be placed following OPEN.】
SQL> alter database open upgrade;
数据库已更改。
SQL> select instance_name,open_mode from v$instance;
select instance_name,open_mode from v$instance
*
第 1 行出现错误:
ORA-00904: "OPEN_MODE": invalid identifier
【Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less
than or equal to 30 characters, and consist of only alphanumeric characters and the special
characters $, _, and #. If it contains other characters, then it must be enclosed in double
quotation marks. It may not be a reserved word.】
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN MIGRATE
SQL> alter database read write;
alter database read write
*
第 1 行出现错误:
ORA-02231: missing or invalid option to ALTER DATABASE
【Cause: An option other than ADD, DROP, RENAME, ARCHIVELOG, NOARCHIVELOG, MOUNT, DISMOUNT,
OPEN, or CLOSE is specified in the statement.
Action: Specify only legal options.】
SQL> alter system read write;
alter system read write
*
第 1 行出现错误:
ORA-02065: illegal option for ALTER SYSTEM
【Cause: The option specified for ALTER SYSTEM is not supported
Action: refer to the user manual for option supported】
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
数据库装载完毕。
ORA-01092: ORACLE 实例终止。强制断开连接
SQL> startup upgrade
ORA-24324: 未初始化服务句柄
ORA-01041: 内部错误, hostdef 扩展名不存在
SQL> startup nomount;
ORA-24324: 未初始化服务句柄
ORA-01041: 内部错误, hostdef 扩展名不存在
SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:/>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 10月 8 22:35:09 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
已连接到空闲例程。
SQL> startup nomount;
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
SQL> alter database mount;
数据库已更改。
SQL> alter database open upgrade;
数据库已更改。
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN MIGRATE
SQL> alter database open read write;
alter database open read write
*
第 1 行出现错误:
ORA-01531: a database already open by the instance
【Cause: During ALTER DATABASE, an attempt was made to open a database on an instance for
which there is already an open database.
Action: If you wish to open a new database on the instance, first shutdown the instance and
then startup the instance and retry the operation.】
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
数据库装载完毕。
SQL> alter database open read write upgrade;
数据库已更改。
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN MIGRATE
SQL> alter database write;
alter database write
*
第 1 行出现错误:
ORA-02231: ALTER DATABASE 选项缺失或无效
SQL> alter database open write;
alter database open write
*
第 1 行出现错误:
ORA-02288: 无效的 OPEN 模式
SQL> alter database write only;
alter database write only
*
第 1 行出现错误:
ORA-02231: ALTER DATABASE 选项缺失或无效
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
数据库装载完毕。
SQL> alter database open read write resetlogs upgrade;
alter database open read write resetlogs upgrade
*
第 1 行出现错误:
ORA-01139: RESETLOGS 选项仅在不完全数据库恢复后有效
SQL> alter database open read write noresetlogs upgrade;
alter database open read write noresetlogs upgrade
*
第 1 行出现错误:
ORA-01139: RESETLOGS 选项仅在不完全数据库恢复后有效
SQL> alter database open write upgrade;
alter database open write upgrade
*
第 1 行出现错误:
ORA-02288: 无效的 OPEN 模式
SQL> alter database open upgrade;
数据库已更改。
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN MIGRATE
SQL> alter system switch logfile;
系统已更改。
SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
数据库装载完毕。
ORA-01092: ORACLE 实例终止。强制断开连接
SQL>
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 67111448 bytes
Database Buffers 134217728 bytes
Redo Buffers 2895872 bytes
数据库装载完毕。
SQL> alter database open upgrade;
数据库已更改。
SQL>@D:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/catupgrd.sql;
......
......
......
SQL> @D:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlu102s.sql;
.
Oracle Database 10.2 Upgrade Status Utility 10-09-2008 01:10:58
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:22:17
JServer JAVA Virtual Machine VALID 10.2.0.4.0 01:10:50
Oracle XDK VALID 10.2.0.4.0 00:01:11
Oracle Database Java Packages VALID 10.2.0.4.0 00:01:07
Oracle Text VALID 10.2.0.4.0 00:01:22
Oracle XML Database VALID 10.2.0.4.0 00:03:58
Oracle Workspace Manager VALID 10.2.0.4.3 00:02:23
Oracle Data Mining VALID 10.2.0.4.0 00:01:13
OLAP Analytic Workspace VALID 10.2.0.4.0 00:02:36
OLAP Catalog VALID 10.2.0.4.0 00:02:21
Oracle OLAP API VALID 10.2.0.4.0 00:01:27
Oracle interMedia VALID 10.2.0.4.0 00:08:16
Spatial VALID 10.2.0.4.0 00:04:44
Oracle Expression Filter VALID 10.2.0.4.0 00:00:29
Upgrade Incomplete
PL/SQL 过程已成功完成。
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
486
SQL> SELECT distinct object_name FROM dba_objects WHERE status='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
DBA_DDL_LOCKS
AQ$_AQ_SRVNTFN_TABLE_F
AQ$SCHEDULER$_JOBQTAB
XDBURITYPE
DBMS_XMLGEN
DBMS_METADATA
KU$_XMLSCHEMA_VIEW
KU$_IONT_VIEW
KU$_NT_PARENT_VIEW
KU$_10_1_HTABLE_VIEW
KU$_10_1_FHTABLE_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
KU$_PFHTABLE_VIEW
KU$_IOTABLE_VIEW
KU$_M_VIEW_LOG_PFH_VIEW
KUPW$WORKER
KUPP$PROC
DBMS_LOGREP_EXP
DBMS_JVM_EXP_PERMS
EXF$ATTRIBUTE_LIST
EVALUATE
SCORE
CATSEARCH
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XDBZ
SETMODFLG
DEPTH
ALL_PATH
ALL_RLMGR_COMPRCLS_PROPERTIES
ADM_RLMGR_SYSTRIG
SDO_INSIDE
SDO_COVEREDBY
SDO_TUNE
ALL_SDO_THEMES
MULTILINESTRINGFROMWKB
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_EXTERIORRING
OGC_WITHIN
OGC_STARTPOINT
STARTPOINT
OGC_POINTN
POINTN
OGC_ISCLOSED
EQUALS
SYMMETRICDIFFERENCE
/c4cbdb8f_GraphTimer
/a10358eb_ElocationNode
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_TPFNS
/f5bcad1_GeoRasterAdapter
SDO_GEOR_LIZARDTECH
AQ$_MGMT_NOTIFY_QTABLE_F
MGMT$CSA_HOST_OS_COMPONENTS
MGMT$DELTA_OS_KERNEL_PARAMS
MGMT$GROUP_MEMBERS
MGMT$OS_COMPONENTS
MGMT$TARGET_COMPOSITE
ST_INSIDE
DBA_LOCK_INTERNAL
OBJECT_NAME
--------------------------------------------------------------------------------
AQ$_SCHEDULER$_EVENT_QTAB_F
HTTPURITYPE
URITYPE
DBMS_XMLSTORE
KU$_CONSTRAINT1_VIEW
KU$_PIOTABLE_VIEW
KU$_M_VIEW_FH_VIEW
KU$_M_VIEW_LOG_H_VIEW
DBMS_DATAPUMP
DBMS_STREAMS
AQ$_ALERT_QT_F
OBJECT_NAME
--------------------------------------------------------------------------------
AQ$ALERT_QT_R
DRVODM
ABSPATH
RESOURCE_VIEW
PATH_VIEW
DBMS_RLMGR
DBMS_RLMGR_UTL
DBMS_RLMGR_DEPASEXP
SI_POSITIONALCOLOR
SDO_ADDR_ARRAY
SDO_INDEX_METHOD_10I
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_FILTER
SDO_OVERLAPBDYDISJOINT
SDO_UTIL
DBA_SDO_THEMES
OGC_MULTIPOLYGONFROMTEXT
OGC_POINTFROMTEXT
POLYGONFROMWKB
POINTFROMWKB
OGC_ASTEXT
OGC_Y
OGC_OVERLAP
OBJECT_NAME
--------------------------------------------------------------------------------
OVERLAP
OGC_CONVEXHULL
CENTROID
BOUNDARY
OGC_ISEMPTY
NUMPOINTS
ISCLOSED
OGC_BUFFER
BUFFER
OGC_DISTANCE
DISTANCE
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_ISSIMPLE
oracle/spatial/network/KDTree
/dbcf5e9e_ElocationEdge
SDO_TOPO_MAP
SDO_RDF_TRIPLE_S
RDF_APIS
MGMT$CSA_HOST_CUSTOM
MGMT$DELTA_OS_COMPONENTS
MGMT$ECM_CURRENT_SNAPSHOTS
MGMT$OS_PATCHES
MGMT$SOFTWARE_PATCHES_IN_HOMES
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$TARGET
DBMS_WORKLOAD_CAPTURE
DBMS_SQLTCB_INTERNAL
ST_COVERS
ST_COVEREDBY
DBURITYPE
URIFACTORY
UTL_XML
KU$_INDEX_VIEW
KU$_10_1_IOTABLE_VIEW
WRI$_ADV_OBJSPACE_TREND_T
OBJECT_NAME
--------------------------------------------------------------------------------
SQLJUTL
RLM$CREATE_SCHEDULER_JOBS
SI_AVERAGECOLOR
SI_TEXTURE
SDO_GEO_ADDR
SDO_COVERS
SDO_MIGRATE
POINTFROMTEXT
OGC_LINESTRINGFROMWKB
OGC_NUMINTERIORRINGS
OGC_GEOMETRYN
OBJECT_NAME
--------------------------------------------------------------------------------
DISJOINT
OGC_CENTROID
OGC_BOUNDARY
OGC_AREA
AREA
MD_LRS
/5add49ef_GraphLayout
/16e6a92f_nodeCostComparator
SDO_GEOR_METADATA
/986b07df_BLOBWriter
/e4e2d7af_GeoRasterException
OBJECT_NAME
--------------------------------------------------------------------------------
/471dfe8f_GeoRasterProcessUtil
/6b8ab103_Compressor
/eba1cb38_GRImageWriteParam
SDO_GEORX
AQ$MGMT_NOTIFY_QTABLE_R
MGMT_REC
MGMT$BLACKOUT_HISTORY
MGMT$CSA_CLIENTS
MGMT$CSA_HOST_COOKIES
MGMT$DELTA_VENDOR_SW
MGMT$OS_FS_MOUNT
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$SOFTWARE_COMPONENTS
MGMT$SOFTWARE_COMPONENT_ONEOFF
MGMT$SOFTWARE_ONEOFF_PATCHES
MGMT$TARGET_COMPONENTS
MGMT$TARGET_PROPERTIES
DBMS_SQLDIAG
RESET_INPROG_INDEX
ST_INTERSECTS
KU$_CONSTRAINT_VIEW
KU$_HNT_VIEW
KU$_HTABLE_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
KU$_FHTABLE_VIEW
KU$_M_VIEW_PH_VIEW
DBMS_SNAP_INTERNAL
DBMSOBJG_DP
AQ$_AQ$_MEM_MC_F
DBMS_SQLTUNE
CTX_TRACE_VALUES
CTX_CONTAINS
EQUALS_PATH
FUNCSTATS
ORDDOC
OBJECT_NAME
--------------------------------------------------------------------------------
PRVT_IDX
ALL_GEOMETRY_COLUMNS
SDO_CS
SDO_RTREE_ADMIN
LINESTRINGFROMTEXT
MULTIPOLYGONFROMTEXT
OGC_MULTIPOLYGONFROMWKB
OGC_MULTILINESTRINGFROMWKB
OGC_POINTFROMWKB
ASBINARY
INTERIORRINGN
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_NUMGEOMETRIES
NUMGEOMETRIES
TOUCH
OGC_INTERSECTION
INTERSECTION
GEOMETRYTYPE
OGC_ENVELOPE
OGC_POINTONSURFACE
ISSIMPLE
/540dac42_ElocationPartition
/4e9308f3_BMPWriter
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_GEOR_INT
SDO_RDF
EMD_DATABASE
EMD_OSM
MGMT$ALERT_HISTORY
MGMT$CLUSTER_INTERCONNECTS
MGMT$CSA_HOST_SW
MGMT$DELTA_ORACLE_HOME
MGMT$DELTA_OS_COMP_DETAILS
MGMT$GROUP_FLAT_MEMBERSHIPS
MGMT$METRIC_DETAILS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$MISSING_TARGETS
ST_TOUCH
ST_OVERLAPS
AQ$AQ_SRVNTFN_TABLE
AQ$SCHEDULER$_EVENT_QTAB_R
KU$_10_1_PHTABLE_VIEW
KU$_10_1_PIOTABLE_VIEW
KU$_M_VIEW_H_VIEW
KU$_M_VIEW_IOT_VIEW
KU$_M_VIEW_LOG_PH_VIEW
DBMS_METADATA_BUILD
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_STREAMS_DATAPUMP
DBMS_SCHEMA_COPY
DBMS_SQLTUNE_INTERNAL
DBMS_EXPFIL
CTX_USER_INDEX_SUB_LEXER_VALS
CONTAINS
DRISCORE
CONTEXT
CTXRULE
XPCONTAINS
DBMS_XDBUTIL_INT
OBJECT_NAME
--------------------------------------------------------------------------------
ALL_RLMGR_EVENT_STRUCTS
ALL_RLMGR_RULE_CLASSES
DBMS_RLMGR_IR
ORDIMAGE
ORDIMAGESIGNATURE
MDPRVT_IDX
SDO_ON
SDO_OVERLAPS
SDO_PRIDX
POLYGONFROMTEXT
OGC_LINESTRINGFROMTEXT
OBJECT_NAME
--------------------------------------------------------------------------------
MULTIPOLYGONFROMWKB
ASTEXT
OGC_SRID
Y
OGC_DISJOINT
OGC_CONTAINS
OGC_DIFFERENCE
OGC_UNION
OGC_RELATE
/7f9770f0_LinkTypeConstraint
/9899cade_JGeoRaster
OBJECT_NAME
--------------------------------------------------------------------------------
/559e5a4f_JGeoRasterMetaBandIn
/c3c9e350_JPEGWriter
/13578568_JRaster
/e57050d7_TIFFWriter
EMD_RAC
SETEMVIEWUSERCONTEXT
MGMT$CSA_HOST_NICS
MGMT$DELTA_COMPONENTS
MGMT$DELTA_FS_MOUNT
MGMT$DELTA_PATCHSET_DETAILS
MGMT$METRIC_COLLECTION
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$METRIC_CURRENT
MGMT$METRIC_DAILY
MGMT$OS_SUMMARY
MGMT$SOFTWARE_DEPENDENCIES
MGMT$SOFTWARE_OTHERS
MGMT$TARGET_TYPE
RTREE_INDEX_METHOD
AQ$_SCHEDULER$_JOBQTAB_F
KU$_PHTABLE_VIEW
KU$_10_1_PFHTABLE_VIEW
KU$_M_VIEW_PFH_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_FILE_GROUP_EXP
UTL_DBWS
EXF$XPATH_TAGS
MATCH_SCORE
DBMS_XDBZ0
ALL_RLMGR_RULE_CLASS_STATUS
ALL_RLMGR_ACTION_ERRORS
RLM$TIMECENTRAL
RLMGR_TRUNCATE_MAINT
SI_COLORHISTOGRAM
ORDVIDEO
OBJECT_NAME
--------------------------------------------------------------------------------
ALL_SDO_TOPO_INFO
SDO_TOUCH
SDO_JOIN
OGC_DIMENSION
DIMENSION
OGC_ASBINARY
OGC_X
X
EXTERIORRING
GEOMETRYN
OGC_TOUCH
OBJECT_NAME
--------------------------------------------------------------------------------
WITHIN
OGC_GEOMETRYTYPE
OGC_ENDPOINT
OGC_ISRING
OGC_INTERSECTS
SDO_CART_TEXT
AGGRCONCAT
/9a7a58f9_JGeoRasterMeta
SDO_NET
SDO_SAM
MGMT$CSA_HOST_CPUS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$DELTA_HARDWARE
MGMT$DELTA_PATCHSETS
MGMT$DELTA_TABLESPACES
MGMT$METRIC_HOURLY
MGMT$MISSING_TARGETS_IN_GROUPS
MGMT$OS_HW_SUMMARY
MGMT$OS_KERNEL_PARAMS
MGMT$SOFTWARE_COMP_PATCHSET
DBMS_WRR_INTERNAL
ST_EQUAL
ST_OVERLAPBDYINTERSECT
OBJECT_NAME
--------------------------------------------------------------------------------
AQ$SCHEDULER$_JOBQTAB_R
FTPURITYPE
KU$_VIEW_VIEW
KUPD$DATA
DBMS_LOGREP_IMP
DBMS_REDEFINITION
DBMS_XPLAN
EXF$ATTRIBUTE
CTX_USER_INDEX_SUB_LEXERS
MATCHES
CTXXPATH
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RLM4J_DICTMAINT
SI_STILLIMAGE
SI_FEATURELIST
ORDAUDIO
ALL_SDO_TOPO_METADATA
SDO_3GL
SDO_EQUAL
SDO_OVERLAPBDYINTERSECT
OGC_MULTILINESTRINGFROMTEXT
MULTILINESTRINGFROMTEXT
LINESTRINGFROMWKB
OBJECT_NAME
--------------------------------------------------------------------------------
NUMINTERIORRINGS
DIFFERENCE
CONVEXHULL
ENVELOPE
ISEMPTY
OGC_NUMPOINTS
POINTONSURFACE
OGC_SYMMETRICDIFFERENCE
RELATE
OGC_CROSS
SDO_LRS
OBJECT_NAME
--------------------------------------------------------------------------------
/dcaeccf3_PartitionManager
/5ec5f173_JGeoRasterSRS
MGMT$ALERT_CURRENT
MGMT$AVAILABILITY_CURRENT
MGMT$DELTA_VIEW
MGMT$DELTA_VIEW_DETAILS
MGMT$HW_NIC
MGMT$SOFTWARE_HOMES
MGMT$SOFTWARE_PATCHSETS
ST_CONTAINS
KU$_M_VIEW_PIOT_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
KU$_M_VIEW_LOG_FH_VIEW
DBMS_METADATA_INT
DBMS_STREAMS_LCR_INT
DBMS_XQUERYINT
CTXCAT
CTX_XPCONTAINS
PATH
DBMS_RLMGR_DR
SDO_IDX
SDO_CONTAINS
OGC_POLYGONFROMTEXT
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_POLYGONFROMWKB
SRID
OGC_INTERIORRINGN
ENDPOINT
OGC_EQUALS
OGC_LENGTH
ISRING
INTERSECTS
CROSS
VALIDATE_SDO
AGGRUNION
OBJECT_NAME
--------------------------------------------------------------------------------
/9b99493a_DistanceFunction
/c7f46be2_RandomGraph
SDO_GEORASTER
/73b53e9_PNGWriter
MGMT_DBNET
MGMT$AVAILABILITY_HISTORY
MGMT$CSA_HOST_IOCARDS
MGMT$CSA_HOST_OS_FILESYSTEMS
MGMT$CSA_HOST_OS_PROPERTIES
MGMT$DELTA_COMPONENT_DETAILS
MGMT$DELTA_HOST_CONFIG
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$DELTA_ONEOFF_PATCHES
MGMT$ECM_VISIBLE_SNAPSHOTS
MGMT$GROUP_DERIVED_MEMBERSHIPS
MGMT$RACDB_INTERCONNECTS
DBMS_SQLPA
RTREEJOIN_IMP_T
SAMCLUST_IMP_T
ST_OVERLAPBDYDISJOINT
已选择404行。
SQL> @D:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlu102s.sql;
.
Oracle Database 10.2 Upgrade Status Utility 10-09-2008 01:13:42
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:22:17
JServer JAVA Virtual Machine VALID 10.2.0.4.0 01:10:50
Oracle XDK VALID 10.2.0.4.0 00:01:11
Oracle Database Java Packages VALID 10.2.0.4.0 00:01:07
Oracle Text VALID 10.2.0.4.0 00:01:22
Oracle XML Database VALID 10.2.0.4.0 00:03:58
Oracle Workspace Manager VALID 10.2.0.4.3 00:02:23
Oracle Data Mining VALID 10.2.0.4.0 00:01:13
OLAP Analytic Workspace VALID 10.2.0.4.0 00:02:36
OLAP Catalog VALID 10.2.0.4.0 00:02:21
Oracle OLAP API VALID 10.2.0.4.0 00:01:27
Oracle interMedia VALID 10.2.0.4.0 00:08:16
Spatial VALID 10.2.0.4.0 00:04:44
Oracle Expression Filter VALID 10.2.0.4.0 00:00:29
Oracle Enterprise Manager VALID 10.2.0.4.0 00:06:33
Oracle Rule Manager VALID 10.2.0.4.0 00:00:44
.
Total Upgrade Time: 02:11:40
PL/SQL 过程已成功完成。
SQL> @D:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlu102s.sql;
.
Oracle Database 10.2 Upgrade Status Utility 10-09-2008 01:13:48
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:22:17
JServer JAVA Virtual Machine VALID 10.2.0.4.0 01:10:50
Oracle XDK VALID 10.2.0.4.0 00:01:11
Oracle Database Java Packages VALID 10.2.0.4.0 00:01:07
Oracle Text VALID 10.2.0.4.0 00:01:22
Oracle XML Database VALID 10.2.0.4.0 00:03:58
Oracle Workspace Manager VALID 10.2.0.4.3 00:02:23
Oracle Data Mining VALID 10.2.0.4.0 00:01:13
OLAP Analytic Workspace VALID 10.2.0.4.0 00:02:36
OLAP Catalog VALID 10.2.0.4.0 00:02:21
Oracle OLAP API VALID 10.2.0.4.0 00:01:27
Oracle interMedia VALID 10.2.0.4.0 00:08:16
Spatial VALID 10.2.0.4.0 00:04:44
Oracle Expression Filter VALID 10.2.0.4.0 00:00:29
Oracle Enterprise Manager VALID 10.2.0.4.0 00:06:33
Oracle Rule Manager VALID 10.2.0.4.0 00:00:44
.
Total Upgrade Time: 02:11:40
PL/SQL 过程已成功完成。
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
444
SQL> SELECT distinct object_name FROM dba_objects WHERE status='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
DBA_DDL_LOCKS
AQ$_AQ_SRVNTFN_TABLE_F
AQ$SCHEDULER$_JOBQTAB
XDBURITYPE
DBMS_XMLGEN
DBMS_METADATA
KU$_XMLSCHEMA_VIEW
KU$_IONT_VIEW
KU$_NT_PARENT_VIEW
KU$_10_1_HTABLE_VIEW
KU$_10_1_FHTABLE_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
KU$_PFHTABLE_VIEW
KU$_IOTABLE_VIEW
KU$_M_VIEW_LOG_PFH_VIEW
KUPW$WORKER
KUPP$PROC
DBMS_LOGREP_EXP
DBMS_JVM_EXP_PERMS
EXF$ATTRIBUTE_LIST
EVALUATE
SCORE
CATSEARCH
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XDBZ
SETMODFLG
DEPTH
ALL_PATH
SDO_INSIDE
SDO_COVEREDBY
SDO_TUNE
ALL_SDO_THEMES
MULTILINESTRINGFROMWKB
OGC_EXTERIORRING
OGC_WITHIN
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_STARTPOINT
STARTPOINT
OGC_POINTN
POINTN
OGC_ISCLOSED
EQUALS
SYMMETRICDIFFERENCE
/c4cbdb8f_GraphTimer
/a10358eb_ElocationNode
SDO_TPFNS
/f5bcad1_GeoRasterAdapter
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_GEOR_LIZARDTECH
MGMT$CSA_HOST_OS_COMPONENTS
MGMT$DB_FEATUREUSAGE
MGMT$DB_ROLLBACK_SEGS
MGMT$DELTA_OS_KERNEL_PARAMS
MGMT$GROUP_MEMBERS
MGMT$HA_INFO
MGMT$OS_COMPONENTS
MGMT$TARGET_COMPOSITE
ST_INSIDE
DBA_LOCK_INTERNAL
OBJECT_NAME
--------------------------------------------------------------------------------
AQ$_SCHEDULER$_EVENT_QTAB_F
HTTPURITYPE
URITYPE
DBMS_XMLSTORE
KU$_CONSTRAINT1_VIEW
KU$_PIOTABLE_VIEW
KU$_M_VIEW_FH_VIEW
KU$_M_VIEW_LOG_H_VIEW
DBMS_DATAPUMP
DBMS_STREAMS
AQ$_ALERT_QT_F
OBJECT_NAME
--------------------------------------------------------------------------------
AQ$ALERT_QT_R
DRVODM
ABSPATH
RESOURCE_VIEW
PATH_VIEW
DBMS_RLMGR
SI_POSITIONALCOLOR
SDO_ADDR_ARRAY
SDO_INDEX_METHOD_10I
SDO_FILTER
SDO_OVERLAPBDYDISJOINT
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_UTIL
DBA_SDO_THEMES
OGC_MULTIPOLYGONFROMTEXT
OGC_POINTFROMTEXT
POLYGONFROMWKB
POINTFROMWKB
OGC_ASTEXT
OGC_Y
OGC_OVERLAP
OVERLAP
OGC_CONVEXHULL
OBJECT_NAME
--------------------------------------------------------------------------------
CENTROID
BOUNDARY
OGC_ISEMPTY
NUMPOINTS
ISCLOSED
OGC_BUFFER
BUFFER
OGC_DISTANCE
DISTANCE
OGC_ISSIMPLE
oracle/spatial/network/KDTree
OBJECT_NAME
--------------------------------------------------------------------------------
/dbcf5e9e_ElocationEdge
SDO_TOPO_MAP
SDO_RDF_TRIPLE_S
RDF_APIS
MGMT$CSA_HOST_CUSTOM
MGMT$DELTA_OS_COMPONENTS
MGMT$ECM_CURRENT_SNAPSHOTS
MGMT$OS_PATCHES
MGMT$SOFTWARE_PATCHES_IN_HOMES
MGMT$TARGET
DBMS_WORKLOAD_CAPTURE
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SQLTCB_INTERNAL
ST_COVERS
ST_COVEREDBY
DBURITYPE
URIFACTORY
UTL_XML
KU$_INDEX_VIEW
KU$_10_1_IOTABLE_VIEW
WRI$_ADV_OBJSPACE_TREND_T
SQLJUTL
SI_AVERAGECOLOR
OBJECT_NAME
--------------------------------------------------------------------------------
SI_TEXTURE
SDO_GEO_ADDR
SDO_COVERS
SDO_MIGRATE
POINTFROMTEXT
OGC_LINESTRINGFROMWKB
OGC_NUMINTERIORRINGS
OGC_GEOMETRYN
DISJOINT
OGC_CENTROID
OGC_BOUNDARY
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_AREA
AREA
MD_LRS
/5add49ef_GraphLayout
/16e6a92f_nodeCostComparator
SDO_GEOR_METADATA
/986b07df_BLOBWriter
/e4e2d7af_GeoRasterException
/471dfe8f_GeoRasterProcessUtil
/6b8ab103_Compressor
/eba1cb38_GRImageWriteParam
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_GEORX
MGMT$BLACKOUT_HISTORY
MGMT$CSA_CLIENTS
MGMT$CSA_HOST_COOKIES
MGMT$DB_INIT_PARAMS
MGMT$DB_LICENSE
MGMT$DELTA_VENDOR_SW
MGMT$HA_INIT_PARAMS
MGMT$OS_FS_MOUNT
MGMT$SOFTWARE_COMPONENTS
MGMT$SOFTWARE_COMPONENT_ONEOFF
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$SOFTWARE_ONEOFF_PATCHES
MGMT$TARGET_COMPONENTS
MGMT$TARGET_PROPERTIES
DBMS_SQLDIAG
RESET_INPROG_INDEX
ST_INTERSECTS
KU$_CONSTRAINT_VIEW
KU$_HNT_VIEW
KU$_HTABLE_VIEW
KU$_FHTABLE_VIEW
KU$_M_VIEW_PH_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SNAP_INTERNAL
DBMSOBJG_DP
AQ$_AQ$_MEM_MC_F
DBMS_SQLTUNE
CTX_TRACE_VALUES
CTX_CONTAINS
EQUALS_PATH
FUNCSTATS
ORDDOC
PRVT_IDX
ALL_GEOMETRY_COLUMNS
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_CS
SDO_RTREE_ADMIN
LINESTRINGFROMTEXT
MULTIPOLYGONFROMTEXT
OGC_MULTIPOLYGONFROMWKB
OGC_MULTILINESTRINGFROMWKB
OGC_POINTFROMWKB
ASBINARY
INTERIORRINGN
OGC_NUMGEOMETRIES
NUMGEOMETRIES
OBJECT_NAME
--------------------------------------------------------------------------------
TOUCH
OGC_INTERSECTION
INTERSECTION
GEOMETRYTYPE
OGC_ENVELOPE
OGC_POINTONSURFACE
ISSIMPLE
/540dac42_ElocationPartition
/4e9308f3_BMPWriter
SDO_GEOR_INT
SDO_RDF
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$ALERT_HISTORY
MGMT$CLUSTER_INTERCONNECTS
MGMT$CSA_HOST_SW
MGMT$DELTA_ORACLE_HOME
MGMT$DELTA_OS_COMP_DETAILS
MGMT$GROUP_FLAT_MEMBERSHIPS
MGMT$METRIC_DETAILS
MGMT$MISSING_TARGETS
ST_TOUCH
ST_OVERLAPS
AQ$AQ_SRVNTFN_TABLE
OBJECT_NAME
--------------------------------------------------------------------------------
AQ$SCHEDULER$_EVENT_QTAB_R
KU$_10_1_PHTABLE_VIEW
KU$_10_1_PIOTABLE_VIEW
KU$_M_VIEW_H_VIEW
KU$_M_VIEW_IOT_VIEW
KU$_M_VIEW_LOG_PH_VIEW
DBMS_METADATA_BUILD
DBMS_STREAMS_DATAPUMP
DBMS_SCHEMA_COPY
DBMS_SQLTUNE_INTERNAL
DBMS_EXPFIL
OBJECT_NAME
--------------------------------------------------------------------------------
CTX_USER_INDEX_SUB_LEXER_VALS
CONTAINS
DRISCORE
CONTEXT
CTXRULE
XPCONTAINS
DBMS_XDBUTIL_INT
ORDIMAGE
ORDIMAGESIGNATURE
MDPRVT_IDX
SDO_ON
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_OVERLAPS
SDO_PRIDX
POLYGONFROMTEXT
OGC_LINESTRINGFROMTEXT
MULTIPOLYGONFROMWKB
ASTEXT
OGC_SRID
Y
OGC_DISJOINT
OGC_CONTAINS
OGC_DIFFERENCE
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_UNION
OGC_RELATE
/7f9770f0_LinkTypeConstraint
/9899cade_JGeoRaster
/559e5a4f_JGeoRasterMetaBandIn
/c3c9e350_JPEGWriter
/13578568_JRaster
/e57050d7_TIFFWriter
SETEMVIEWUSERCONTEXT
MGMT$CSA_HOST_NICS
MGMT$DB_CONTROLFILES
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$DB_TABLESPACES
MGMT$DELTA_COMPONENTS
MGMT$DELTA_FS_MOUNT
MGMT$DELTA_PATCHSET_DETAILS
MGMT$INTERFACE_STATS
MGMT$METRIC_COLLECTION
MGMT$METRIC_CURRENT
MGMT$METRIC_DAILY
MGMT$OS_SUMMARY
MGMT$SOFTWARE_DEPENDENCIES
MGMT$SOFTWARE_OTHERS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$TARGET_TYPE
RTREE_INDEX_METHOD
AQ$_SCHEDULER$_JOBQTAB_F
KU$_PHTABLE_VIEW
KU$_10_1_PFHTABLE_VIEW
KU$_M_VIEW_PFH_VIEW
DBMS_FILE_GROUP_EXP
UTL_DBWS
EXF$XPATH_TAGS
MATCH_SCORE
DBMS_XDBZ0
OBJECT_NAME
--------------------------------------------------------------------------------
SI_COLORHISTOGRAM
ORDVIDEO
ALL_SDO_TOPO_INFO
SDO_TOUCH
SDO_JOIN
OGC_DIMENSION
DIMENSION
OGC_ASBINARY
OGC_X
X
EXTERIORRING
OBJECT_NAME
--------------------------------------------------------------------------------
GEOMETRYN
OGC_TOUCH
WITHIN
OGC_GEOMETRYTYPE
OGC_ENDPOINT
OGC_ISRING
OGC_INTERSECTS
SDO_CART_TEXT
AGGRCONCAT
/9a7a58f9_JGeoRasterMeta
SDO_NET
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_SAM
MGMT$CSA_HOST_CPUS
MGMT$DB_DBNINSTANCEINFO
MGMT$DB_REDOLOGS
MGMT$DELTA_HARDWARE
MGMT$DELTA_PATCHSETS
MGMT$DELTA_TABLESPACES
MGMT$HA_BACKUP
MGMT$HA_RMAN_CONFIG
MGMT$METRIC_HOURLY
MGMT$MISSING_TARGETS_IN_GROUPS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$OS_HW_SUMMARY
MGMT$OS_KERNEL_PARAMS
MGMT$SOFTWARE_COMP_PATCHSET
DBMS_WRR_INTERNAL
ST_EQUAL
ST_OVERLAPBDYINTERSECT
AQ$SCHEDULER$_JOBQTAB_R
FTPURITYPE
KU$_VIEW_VIEW
KUPD$DATA
DBMS_LOGREP_IMP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REDEFINITION
DBMS_XPLAN
EXF$ATTRIBUTE
CTX_USER_INDEX_SUB_LEXERS
MATCHES
CTXXPATH
SI_STILLIMAGE
SI_FEATURELIST
ORDAUDIO
ALL_SDO_TOPO_METADATA
SDO_3GL
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_EQUAL
SDO_OVERLAPBDYINTERSECT
OGC_MULTILINESTRINGFROMTEXT
MULTILINESTRINGFROMTEXT
LINESTRINGFROMWKB
NUMINTERIORRINGS
DIFFERENCE
CONVEXHULL
ENVELOPE
ISEMPTY
OGC_NUMPOINTS
OBJECT_NAME
--------------------------------------------------------------------------------
POINTONSURFACE
OGC_SYMMETRICDIFFERENCE
RELATE
OGC_CROSS
SDO_LRS
/dcaeccf3_PartitionManager
/5ec5f173_JGeoRasterSRS
MGMT$ALERT_CURRENT
MGMT$AVAILABILITY_CURRENT
MGMT$DELTA_VIEW
MGMT$DELTA_VIEW_DETAILS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$HA_MTTR
MGMT$HW_NIC
MGMT$SOFTWARE_HOMES
MGMT$SOFTWARE_PATCHSETS
ST_CONTAINS
KU$_M_VIEW_PIOT_VIEW
KU$_M_VIEW_LOG_FH_VIEW
DBMS_METADATA_INT
DBMS_STREAMS_LCR_INT
DBMS_XQUERYINT
CTXCAT
OBJECT_NAME
--------------------------------------------------------------------------------
CTX_XPCONTAINS
PATH
SDO_IDX
SDO_CONTAINS
OGC_POLYGONFROMTEXT
OGC_POLYGONFROMWKB
SRID
OGC_INTERIORRINGN
ENDPOINT
OGC_EQUALS
OGC_LENGTH
OBJECT_NAME
--------------------------------------------------------------------------------
ISRING
INTERSECTS
CROSS
VALIDATE_SDO
AGGRUNION
/9b99493a_DistanceFunction
/c7f46be2_RandomGraph
SDO_GEORASTER
/73b53e9_PNGWriter
MGMT$AVAILABILITY_HISTORY
MGMT$CSA_HOST_IOCARDS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$CSA_HOST_OS_FILESYSTEMS
MGMT$CSA_HOST_OS_PROPERTIES
MGMT$DB_DATAFILES
MGMT$DB_SGA
MGMT$DELTA_COMPONENT_DETAILS
MGMT$DELTA_HOST_CONFIG
MGMT$DELTA_INIT
MGMT$DELTA_ONEOFF_PATCHES
MGMT$ECM_VISIBLE_SNAPSHOTS
MGMT$GROUP_DERIVED_MEMBERSHIPS
MGMT$HA_FILES
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$RACDB_INTERCONNECTS
DBMS_SQLPA
RTREEJOIN_IMP_T
SAMCLUST_IMP_T
ST_OVERLAPBDYDISJOINT
已选择401行。
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
380
SQL> SELECT distinct object_name FROM dba_objects WHERE status='INVALID';
OBJECT_NAME
--------------------------------------------------------------------------------
DBA_DDL_LOCKS
DBMS_XMLGEN
KU$_IONT_VIEW
KU$_NT_PARENT_VIEW
KU$_10_1_HTABLE_VIEW
KU$_10_1_FHTABLE_VIEW
KU$_PFHTABLE_VIEW
KU$_IOTABLE_VIEW
KU$_M_VIEW_LOG_PFH_VIEW
DBMS_JVM_EXP_PERMS
EXF$ATTRIBUTE_LIST
OBJECT_NAME
--------------------------------------------------------------------------------
EVALUATE
SCORE
CATSEARCH
DBMS_XDBZ
SETMODFLG
DEPTH
ALL_PATH
SDO_INSIDE
SDO_COVEREDBY
SDO_TUNE
ALL_SDO_THEMES
OBJECT_NAME
--------------------------------------------------------------------------------
MULTILINESTRINGFROMWKB
OGC_EXTERIORRING
OGC_WITHIN
OGC_STARTPOINT
STARTPOINT
OGC_POINTN
POINTN
OGC_ISCLOSED
EQUALS
SYMMETRICDIFFERENCE
SDO_TPFNS
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_GEOR_LIZARDTECH
MGMT$CSA_HOST_OS_COMPONENTS
MGMT$DB_FEATUREUSAGE
MGMT$DB_ROLLBACK_SEGS
MGMT$DELTA_OS_KERNEL_PARAMS
MGMT$GROUP_MEMBERS
MGMT$HA_INFO
MGMT$OS_COMPONENTS
MGMT$TARGET_COMPOSITE
ST_INSIDE
DBA_LOCK_INTERNAL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XMLSTORE
KU$_CONSTRAINT1_VIEW
KU$_PIOTABLE_VIEW
KU$_M_VIEW_FH_VIEW
KU$_M_VIEW_LOG_H_VIEW
DBMS_STREAMS
DRVODM
ABSPATH
RESOURCE_VIEW
PATH_VIEW
DBMS_RLMGR
OBJECT_NAME
--------------------------------------------------------------------------------
SI_POSITIONALCOLOR
SDO_ADDR_ARRAY
SDO_INDEX_METHOD_10I
SDO_FILTER
SDO_OVERLAPBDYDISJOINT
SDO_UTIL
DBA_SDO_THEMES
OGC_MULTIPOLYGONFROMTEXT
OGC_POINTFROMTEXT
POLYGONFROMWKB
POINTFROMWKB
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_ASTEXT
OGC_Y
OGC_OVERLAP
OVERLAP
OGC_CONVEXHULL
CENTROID
BOUNDARY
OGC_ISEMPTY
NUMPOINTS
ISCLOSED
OGC_BUFFER
OBJECT_NAME
--------------------------------------------------------------------------------
BUFFER
OGC_DISTANCE
DISTANCE
OGC_ISSIMPLE
SDO_TOPO_MAP
SDO_RDF_TRIPLE_S
RDF_APIS
MGMT$CSA_HOST_CUSTOM
MGMT$DELTA_OS_COMPONENTS
MGMT$ECM_CURRENT_SNAPSHOTS
MGMT$OS_PATCHES
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$SOFTWARE_PATCHES_IN_HOMES
MGMT$TARGET
DBMS_WORKLOAD_CAPTURE
DBMS_SQLTCB_INTERNAL
ST_COVERS
ST_COVEREDBY
KU$_10_1_IOTABLE_VIEW
WRI$_ADV_OBJSPACE_TREND_T
SQLJUTL
SI_AVERAGECOLOR
SI_TEXTURE
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_GEO_ADDR
SDO_COVERS
SDO_MIGRATE
POINTFROMTEXT
OGC_LINESTRINGFROMWKB
OGC_NUMINTERIORRINGS
OGC_GEOMETRYN
DISJOINT
OGC_CENTROID
OGC_BOUNDARY
OGC_AREA
OBJECT_NAME
--------------------------------------------------------------------------------
AREA
MD_LRS
SDO_GEOR_METADATA
SDO_GEORX
MGMT$BLACKOUT_HISTORY
MGMT$CSA_CLIENTS
MGMT$CSA_HOST_COOKIES
MGMT$DB_INIT_PARAMS
MGMT$DB_LICENSE
MGMT$DELTA_VENDOR_SW
MGMT$HA_INIT_PARAMS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$OS_FS_MOUNT
MGMT$SOFTWARE_COMPONENTS
MGMT$SOFTWARE_COMPONENT_ONEOFF
MGMT$SOFTWARE_ONEOFF_PATCHES
MGMT$TARGET_COMPONENTS
MGMT$TARGET_PROPERTIES
DBMS_SQLDIAG
RESET_INPROG_INDEX
ST_INTERSECTS
KU$_CONSTRAINT_VIEW
KU$_HNT_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
KU$_HTABLE_VIEW
KU$_FHTABLE_VIEW
KU$_M_VIEW_PH_VIEW
DBMS_SQLTUNE
CTX_TRACE_VALUES
CTX_CONTAINS
EQUALS_PATH
FUNCSTATS
ORDDOC
PRVT_IDX
ALL_GEOMETRY_COLUMNS
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_CS
SDO_RTREE_ADMIN
LINESTRINGFROMTEXT
MULTIPOLYGONFROMTEXT
OGC_MULTIPOLYGONFROMWKB
OGC_MULTILINESTRINGFROMWKB
OGC_POINTFROMWKB
ASBINARY
INTERIORRINGN
OGC_NUMGEOMETRIES
NUMGEOMETRIES
OBJECT_NAME
--------------------------------------------------------------------------------
TOUCH
OGC_INTERSECTION
INTERSECTION
GEOMETRYTYPE
OGC_ENVELOPE
OGC_POINTONSURFACE
ISSIMPLE
SDO_GEOR_INT
SDO_RDF
MGMT$ALERT_HISTORY
MGMT$CLUSTER_INTERCONNECTS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$CSA_HOST_SW
MGMT$DELTA_ORACLE_HOME
MGMT$DELTA_OS_COMP_DETAILS
MGMT$GROUP_FLAT_MEMBERSHIPS
MGMT$METRIC_DETAILS
MGMT$MISSING_TARGETS
ST_TOUCH
ST_OVERLAPS
KU$_10_1_PHTABLE_VIEW
KU$_10_1_PIOTABLE_VIEW
KU$_M_VIEW_H_VIEW
OBJECT_NAME
--------------------------------------------------------------------------------
KU$_M_VIEW_IOT_VIEW
KU$_M_VIEW_LOG_PH_VIEW
DBMS_STREAMS_DATAPUMP
DBMS_SQLTUNE_INTERNAL
DBMS_EXPFIL
CTX_USER_INDEX_SUB_LEXER_VALS
CONTAINS
DRISCORE
CONTEXT
CTXRULE
XPCONTAINS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XDBUTIL_INT
ORDIMAGE
ORDIMAGESIGNATURE
MDPRVT_IDX
SDO_ON
SDO_OVERLAPS
SDO_PRIDX
POLYGONFROMTEXT
OGC_LINESTRINGFROMTEXT
MULTIPOLYGONFROMWKB
ASTEXT
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_SRID
Y
OGC_DISJOINT
OGC_CONTAINS
OGC_DIFFERENCE
OGC_UNION
OGC_RELATE
SETEMVIEWUSERCONTEXT
MGMT$CSA_HOST_NICS
MGMT$DB_CONTROLFILES
MGMT$DB_TABLESPACES
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$DELTA_COMPONENTS
MGMT$DELTA_FS_MOUNT
MGMT$DELTA_PATCHSET_DETAILS
MGMT$INTERFACE_STATS
MGMT$METRIC_COLLECTION
MGMT$METRIC_CURRENT
MGMT$METRIC_DAILY
MGMT$OS_SUMMARY
MGMT$SOFTWARE_DEPENDENCIES
MGMT$SOFTWARE_OTHERS
MGMT$TARGET_TYPE
OBJECT_NAME
--------------------------------------------------------------------------------
RTREE_INDEX_METHOD
KU$_PHTABLE_VIEW
KU$_10_1_PFHTABLE_VIEW
KU$_M_VIEW_PFH_VIEW
UTL_DBWS
EXF$XPATH_TAGS
MATCH_SCORE
DBMS_XDBZ0
SI_COLORHISTOGRAM
ORDVIDEO
ALL_SDO_TOPO_INFO
OBJECT_NAME
--------------------------------------------------------------------------------
SDO_TOUCH
SDO_JOIN
OGC_DIMENSION
DIMENSION
OGC_ASBINARY
OGC_X
X
EXTERIORRING
GEOMETRYN
OGC_TOUCH
WITHIN
OBJECT_NAME
--------------------------------------------------------------------------------
OGC_GEOMETRYTYPE
OGC_ENDPOINT
OGC_ISRING
OGC_INTERSECTS
SDO_CART_TEXT
AGGRCONCAT
SDO_NET
SDO_SAM
MGMT$CSA_HOST_CPUS
MGMT$DB_DBNINSTANCEINFO
MGMT$DB_REDOLOGS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$DELTA_HARDWARE
MGMT$DELTA_PATCHSETS
MGMT$DELTA_TABLESPACES
MGMT$HA_BACKUP
MGMT$HA_RMAN_CONFIG
MGMT$METRIC_HOURLY
MGMT$MISSING_TARGETS_IN_GROUPS
MGMT$OS_HW_SUMMARY
MGMT$OS_KERNEL_PARAMS
MGMT$SOFTWARE_COMP_PATCHSET
DBMS_WRR_INTERNAL
OBJECT_NAME
--------------------------------------------------------------------------------
ST_EQUAL
ST_OVERLAPBDYINTERSECT
KU$_VIEW_VIEW
DBMS_LOGREP_IMP
EXF$ATTRIBUTE
CTX_USER_INDEX_SUB_LEXERS
MATCHES
CTXXPATH
SI_STILLIMAGE
SI_FEATURELIST
ORDAUDIO
OBJECT_NAME
--------------------------------------------------------------------------------
ALL_SDO_TOPO_METADATA
SDO_3GL
SDO_EQUAL
SDO_OVERLAPBDYINTERSECT
OGC_MULTILINESTRINGFROMTEXT
MULTILINESTRINGFROMTEXT
LINESTRINGFROMWKB
NUMINTERIORRINGS
DIFFERENCE
CONVEXHULL
ENVELOPE
OBJECT_NAME
--------------------------------------------------------------------------------
ISEMPTY
OGC_NUMPOINTS
POINTONSURFACE
OGC_SYMMETRICDIFFERENCE
RELATE
OGC_CROSS
SDO_LRS
MGMT$ALERT_CURRENT
MGMT$AVAILABILITY_CURRENT
MGMT$DELTA_VIEW
MGMT$DELTA_VIEW_DETAILS
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$HA_MTTR
MGMT$HW_NIC
MGMT$SOFTWARE_HOMES
MGMT$SOFTWARE_PATCHSETS
ST_CONTAINS
KU$_M_VIEW_PIOT_VIEW
KU$_M_VIEW_LOG_FH_VIEW
DBMS_STREAMS_LCR_INT
DBMS_XQUERYINT
CTXCAT
CTX_XPCONTAINS
OBJECT_NAME
--------------------------------------------------------------------------------
PATH
SDO_IDX
SDO_CONTAINS
OGC_POLYGONFROMTEXT
OGC_POLYGONFROMWKB
SRID
OGC_INTERIORRINGN
ENDPOINT
OGC_EQUALS
OGC_LENGTH
ISRING
OBJECT_NAME
--------------------------------------------------------------------------------
INTERSECTS
CROSS
VALIDATE_SDO
AGGRUNION
SDO_GEORASTER
MGMT$AVAILABILITY_HISTORY
MGMT$CSA_HOST_IOCARDS
MGMT$CSA_HOST_OS_FILESYSTEMS
MGMT$CSA_HOST_OS_PROPERTIES
MGMT$DB_DATAFILES
MGMT$DB_SGA
OBJECT_NAME
--------------------------------------------------------------------------------
MGMT$DELTA_COMPONENT_DETAILS
MGMT$DELTA_HOST_CONFIG
MGMT$DELTA_INIT
MGMT$DELTA_ONEOFF_PATCHES
MGMT$ECM_VISIBLE_SNAPSHOTS
MGMT$GROUP_DERIVED_MEMBERSHIPS
MGMT$HA_FILES
MGMT$RACDB_INTERCONNECTS
DBMS_SQLPA
RTREEJOIN_IMP_T
SAMCLUST_IMP_T
OBJECT_NAME
--------------------------------------------------------------------------------
ST_OVERLAPBDYDISJOINT
已选择342行。
SQL> select count(1) from (SELECT distinct object_name FROM dba_objects WHERE
status='INVALID');
COUNT(1)
----------
37
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
24
SQL> select count(1) from (SELECT distinct object_name FROM dba_objects WHERE
status='INVALID');
COUNT(1)
----------
14
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
13
SQL> select count(1) from (SELECT distinct object_name FROM dba_objects WHERE
status='INVALID');
COUNT(1)
----------
7
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
5
SQL> select count(1) from (SELECT distinct object_name FROM dba_objects WHERE
status='INVALID');
COUNT(1)
----------
0
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
0
SQL> @D:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlu102s.sql;
.
Oracle Database 10.2 Upgrade Status Utility 10-09-2008 01:15:02
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.4.0 00:22:17
JServer JAVA Virtual Machine VALID 10.2.0.4.0 01:10:50
Oracle XDK VALID 10.2.0.4.0 00:01:11
Oracle Database Java Packages VALID 10.2.0.4.0 00:01:07
Oracle Text VALID 10.2.0.4.0 00:01:22
Oracle XML Database VALID 10.2.0.4.0 00:03:58
Oracle Workspace Manager VALID 10.2.0.4.3 00:02:23
Oracle Data Mining VALID 10.2.0.4.0 00:01:13
OLAP Analytic Workspace VALID 10.2.0.4.0 00:02:36
OLAP Catalog VALID 10.2.0.4.0 00:02:21
Oracle OLAP API VALID 10.2.0.4.0 00:01:27
Oracle interMedia VALID 10.2.0.4.0 00:08:16
Spatial VALID 10.2.0.4.0 00:04:44
Oracle Expression Filter VALID 10.2.0.4.0 00:00:29
Oracle Enterprise Manager VALID 10.2.0.4.0 00:06:33
Oracle Rule Manager VALID 10.2.0.4.0 00:00:44
.
Total Upgrade Time: 02:11:40
SQL> @D:/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlrp.sql;
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2008-10-09 01:15:23
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and 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 are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2008-10-09 01:17:51
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
COUNT(*)
----------
0
SQL> SELECT distinct object_name FROM dba_objects WHERE status='INVALID';
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 205520896 bytes
Fixed Size 1295848 bytes
Variable Size 171969048 bytes
Database Buffers 29360128 bytes
Redo Buffers 2895872 bytes
数据库装载完毕。
数据库已经打开。
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl OPEN
- DB OPEN in MIGRATE status!
- sqlalchemy db migrate
- nodejs db migrate入门
- rake db:migrate 与 bundle exec rake db:migrate区别
- 解决rails 执行 rake db:migrate时Error in my_thread_global_end(): 1 threads didn't exit错误
- rails db:migrate 出错 bundle exec
- 执行rake db:migrate时的两个错误
- Oracle RMAN Migrate DB Cross-platform - 思路与方法
- rake db:migrate RAILS_ENV=production 发生error
- heroku run rake db:migrate: No such file or directory
- python manage.py migrate 出错 django.db.utils.ProgrammingError
- Migrate to DB2 in Five Easy Steps
- bundle install rake db:rollback 与 db:migrate:redo的区别
- Sequence in Oracle DB
- terms in db
- HTTP status code in Rails
- 执行rake db:migrate时报错rake aborted! Access denied for user 'root'@'localhost'
- Ext3 -- Form 实例。 用来migrate file 数据到DB用的
- 衣服颜色透视你疾病
- AIX iostat 命令
- NSAffineTransform Examples
- 把Jetty安装成Windows NT服务
- download oracle patchs from metalink by ftp
- DB OPEN in MIGRATE status!
- 4G时代来了!!!!
- 生活随笔
- struts2的一些用法(一):struts2的配置
- .java
- redhat as 5 远程安装 FTP安装
- Java的30个基本概念
- 隐去url后面的参数
- 多线程-临界区模式