Installing Oracle XML DB ro Oracle 9.2 on HP

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Diana

    Installing Oracle XML DB ro Oracle 9.2 on HP

    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

    #2
    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/databas...man.htm#640595.

    Very complete detailed info there.

    dlzapalac@yahoo .com (Diana) wrote in message news:<f48d36c1. 0407061611.7abb 6c12@posting.go ogle.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

    Comment

    Working...