OraFAQ Forum: Server Administration » Can't Install Oracle XML db component

Home » RDBMS Server » Server Administration » Can't Install Oracle XML db component (windows 2003, oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't Install Oracle XML db component [message #566245]

Wed, 12 September 2012 00:27

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.

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566246 is a reply to message #566245]

Wed, 12 September 2012 00:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>(windows 2003, oracle 9i)
How is it that you can upgrade OS to this Century, but unable to upgrade the DB?
Why running in totally uncertified combination?

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566252 is a reply to message #566246]

Wed, 12 September 2012 01:05

sikakaito
Messages: 6
Registered: July 2012
Location: Manila

Junior Member

Considering the price of DB versus the OS.. we're just a small company. The budget is not that big.

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566254 is a reply to message #566252]

Wed, 12 September 2012 01:17

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can use XE edition which is free.

Regards
Michel

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566261 is a reply to message #566245]

Wed, 12 September 2012 01:41

John Watson
Messages: 8976
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.

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566275 is a reply to message #566261]

Wed, 12 September 2012 03:50

sikakaito
Messages: 6
Registered: July 2012
Location: Manila

Junior Member

our support just expired this january.. we haven't renewed..

i have tried to uninstall and reinstall using catnoqm and catqm , but still having error in installation.
We are on the process of upgrade that's why i am testing on a test machine and trying to install xml component.

Thank you for all your replies. Please help me with this.

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566279 is a reply to message #566275]

Wed, 12 September 2012 04:04

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

My advice: do not upgrade the current database, export your application schemas, create a new database, import.

Regards
Michel

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566281 is a reply to message #566279]

Wed, 12 September 2012 04:15

sikakaito
Messages: 6
Registered: July 2012
Location: Manila

Junior Member

i have tested the import. now they want me to test the upgrade, what will i say to them if i can't upgrade. is there a documentation on this?

Thanks Again

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566282 is a reply to message #566281]

Wed, 12 September 2012 04:18

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

If you do not have a support contract, I think it is illegal to upgrade. So you most definitely have to tell your client that you can't do it. And I certainly can't assist.

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566283 is a reply to message #566282]

Wed, 12 September 2012 04:23

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I concur.

Regards
Michel

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566284 is a reply to message #566282]

Wed, 12 September 2012 04:28

sikakaito
Messages: 6
Registered: July 2012
Location: Manila

Junior Member

its for our own company..its inhouse database.
we are NOT upgrading without having purchasing it. we are on testing.
we are still testing the possibilities(options to take for the upgrade).

If there is a documentation on xml that can't be installed on 9i, can you give me a link
because i have googled it and having a hard time.

Thank you all again

Report message to a moderator

Re: Can't Install Oracle XML db component [message #566285 is a reply to message #566284]

Wed, 12 September 2012 04:37

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no documentation for your error, you simply can't do it, so proceed wiht exp/imp.

Regards
Michel

Report message to a moderator

Previous Topic:	client libraries are inaccessible
Next Topic:	not Ping linux intstall on vmware from host os win 7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 04:48:38 CDT 2025