upgrading from 10g to 11g [message #320325] |
Wed, 14 May 2008 12:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
seyiisq
Messages: 125 Registered: September 2005
|
Senior Member |
|
|
i have been trying to upgrade from 10g to 11g but i keep having an error
ora--04063:view "sys.ku$_xmlschema_view" has error
I queried my dba_registry and go the following
SQL> select comp_id,comp_name,status,version from dba_registry;
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
EM
Oracle Enterprise Manager
VALID 10.1.0.2.0
XDB
Oracle XML Database
UPGRADING 10.1.0.2.0
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
AMD
OLAP Catalog
VALID 10.1.0.2.0
CONTEXT
Oracle Text
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
VALID 10.1.0.2.0
SDO
Spatial
VALID 10.1.0.2.0
ORDIM
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle interMedia
VALID 10.1.0.2.0
EXF
Oracle Expression Filter
VALID 10.1.0.2.0
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
OWM
Oracle Workspace Manager
VALID 10.1.0.2.0
ODM
Oracle Data Mining
VALID 10.1.0.2.0
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
CATALOG
Oracle Database Catalog Views
INVALID 10.1.0.2.0
CATPROC
Oracle Database Packages and Types
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
INVALID 10.1.0.2.0
JAVAVM
JServer JAVA Virtual Machine
VALID 10.1.0.2.0
XML
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
Oracle XDK
VALID 10.1.0.2.0
CATJAVA
Oracle Database Java Packages
VALID 10.1.0.2.0
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
APS
OLAP Analytic Workspace
VALID 10.1.0.2.0
XOQ
Oracle OLAP API
VALID 10.1.0.2.0
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
STATUS VERSION
----------- ------------------------------
16 rows selected.
pls can someone help
|
|
|
|
|
|