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.
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.
Click Here to Expand Forum to Full Width