Installing Oracle XML DB ro Oracle 9.2 on HP

[Diana]

Hi All,

I am suddenly in a position where I need to learn to be my own Oralce
DBA. I have limited experience with Oracle and haven't ever performed
an install on my own.

Recently someone installed Oracle 9.2 on an HP for me to use. He
choose the "Software Only" option on the 9i Database Configuration
Screen during install. So that it only installed the software and did
not create a database.

I am now trying to do somethings with Oracle XML DB but don't think it
was installed . . . I tried several things to see if it was installed,
such as:

"select XDBUriType('/xdbconfig.xml').getXML() from dual /"

AND

"select object_name from dba_objects where owner = 'XDB'"

each of which returned "no rows selected"

So I am assuming that the XML DB stuff didn't get installed . . .

I have been looking through the Oracle 9i Installation Guide and the
OTN website but can't find any clues about how to install it . . .

Does anyone have advice for me?????

Thanks!
Diana

[Diana]

Well I figured this out so thought I would put the info out here in
case anyone else has the same problem.

There is info on how to install XML DB without DBCA and how to
re-install XML DB at:
http://www.cise.ufl.edu/help/databas...man.htm#640595.

Very complete detailed info there.

dl*******@yahoo.com (Diana) wrote in message news:<f4**************************@posting.google. com>...

Hi All,

I am suddenly in a position where I need to learn to be my own Oralce
DBA. I have limited experience with Oracle and haven't ever performed
an install on my own.

Recently someone installed Oracle 9.2 on an HP for me to use. He
choose the "Software Only" option on the 9i Database Configuration
Screen during install. So that it only installed the software and did
not create a database.

I am now trying to do somethings with Oracle XML DB but don't think it
was installed . . . I tried several things to see if it was installed,
such as:

"select XDBUriType('/xdbconfig.xml').getXML() from dual /"

AND

"select object_name from dba_objects where owner = 'XDB'"

each of which returned "no rows selected"

So I am assuming that the XML DB stuff didn't get installed . . .

I have been looking through the Oracle 9i Installation Guide and the
OTN website but can't find any clues about how to install it . . .

Does anyone have advice for me?????

Thanks!
Diana