Re: Installing Oracle XML DB ro Oracle 9.2 on HP

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/database/oracle-docs/appdev.920/a96620/appaman.htm#640595.

Very complete detailed info there.

dlzapalac_at_yahoo.com (Diana) wrote in message news:<f48d36c1.0407061611.7abb6c12_at_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
Received on Fri Jul 09 2004 - 18:01:55 CEST