Home » RDBMS Server » Server Administration » upgrading from 10g to 11g (oracle 10.1.0.2, window xp)
upgrading from 10g to 11g [message #320325] Wed, 14 May 2008 12:57 Go to next message
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
Re: upgrading from 10g to 11g [message #320326 is a reply to message #320325] Wed, 14 May 2008 13:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ORA-7445 core dump in "kgghstfel" or ORA-3113 Creating View "sys.ku$_xmlschema_view"
Doc ID: Note:452577.1 Type: PROBLEM
Last Revision Date: 28-APR-2008

Cause

This issue is caused by Bug 5161782
Re: upgrading from 10g to 11g [message #320378 is a reply to message #320325] Wed, 14 May 2008 21:54 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
am i suppose to do a patch, can u explain pls
Re: upgrading from 10g to 11g [message #320386 is a reply to message #320378] Wed, 14 May 2008 23:27 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You are suppose to read the note all is explained in there.

Regards
Michel
Previous Topic: 10g Recyclebin
Next Topic: Uncommitted Trasactions
Goto Forum:
  


Current Time: Fri Nov 29 22:49:42 CST 2024