Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unanswered: Moving data base Oracle

    Hi,
    we add a new fs in HP-UX where i do it to move entire databse, and then remove old fs.

    1-software oracle
    2-datafiles
    3-config files

    Everyone already do it this?
    The Oracle Metalink note 28433.1 , if you have access..it's right? or they are better?

    Thank!

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: Moving data base Oracle

    If you build a new fs and move your Oracle Home to the new fs, I think you need to run root.sh before Oracle will work. Root.sh is created when you first installed Oracle. If you don't have that file, you might have to reinstall Oracle.

    Here is my guess, as I do not use HP-UX. File permissions are set by the user's ID as assigned by the fs, and not the user's name. When you rebuilt the fs, the fs assigned new ID numbers to all users. Therefore, the files are not owned by the new users. It might say the owner is "oracle" with ID 7, or some value, but the hidden number (like keycode) is different.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •