Can't Install Oracle XML db component [message #566245] |
Wed, 12 September 2012 00:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e40f5c60680c1e6ffa3b085ebf8f092b?s=64&d=mm&r=g) |
sikakaito
Messages: 6 Registered: July 2012 Location: Manila
|
Junior Member |
|
|
Hi all,
I am trying to install the oracle xml database component and i'm encountering errors.
i followed the documentation but it wasn't a success.
here is the error.
create or replace type XDB.XDB$RESOURCE_T OID
ERROR at line 1:
ORA-21700: object does not exist or is marked for delete
grant execute on xdb.xdb$resource_t to public with grant option
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
create table XDB.XDB$RESOURCE of sys.xmltype
ERROR at line 1:
ORA-00902: invalid datatype
alter table XDB.XDB$RESOURCE add (ref(xmldata.XMLREF) with rowid)
ERROR at line 1:
ORA-00942: table or view does not exist
i am a newbie in this matter. please help me.
By the way i am still using oracle9i.(i know its old but its our company's database)
Thank You for your future replies.
|
|
|
|
|
|
Re: Can't Install Oracle XML db component [message #566261 is a reply to message #566245] |
Wed, 12 September 2012 01:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8932 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hi - you do need to sort this out: I remember that you can't upgrade to 10g without XDB. If it isn't already installed, the upgrade process attempts (and, presumably, will fail) to install it. So unless you use export/import, you will never be able to upgrade.
I guess you do not have a support contract, so you are on tour own?
Perhaps some XDB objects already exist. You can remove XDV with the catnoqm.sql script, I would try that and then install again.
|
|
|
|
|
|
|
|
|
|