oracle doesn't read/write the database files on Solaris 2.7
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle doesn't read/write the database files on Solaris 2.7

  1. #1
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93

    Unhappy oracle doesn't read/write the database files on Solaris 2.7

    Hi friends, we have a big problem with our production database.
    Please help me to solve this big problem.

    We have a production Oracle database 8.1.6 on Solaris 2.7 and it was working fine until the operative system disk crashed. After reinstalling the same version of the OS we cannot mount the database. We restablished all the kernel parameters and configuration settings, of course.

    There arenīt errors after apply the open nomount command, but when we try to mount the database we have this error message:

    ORA-00205: error in identifying controlfile, check alert log for more info.

    After that, we have trying to recreate the control files, but we have another oracle error:

    ORA-01503: CREATE CONTROL FILE failed
    ORA-00227: corrupt block detected in controlfile: (block 1, #blocks)
    ORA-00202: controlfile: '/oracle/control01.ctl'


    At this point we have scanned the filesystems for errors but the operative system says that everything is working fine. We can copy, move, delete files in the oracle's filesystems directly from the Operative system but the RDBMS cannot work fine. Even we have trying to create a new database in a new filesystem without success.

    I really need help!
    Thanks in advance.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm, just guessing here...
    1. make sure the "oracle" user can write to /oracle
    2. make sure the uid of the "oracle" user matches before the install and after install of the OS.
    3. check ownership of database files to verify you own them and can do what you need to do with them.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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


Click Here to Expand Forum to Full Width