I am unable to determine what the issue is on database startup Oracle9i RAC with Veritas Advanced Cluster Serv...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Errors in file
ORA-00376: file 10 cannot be read at this time
ORA-01110: data file 10: '/dev/vx/rdsk/aset1Pdg/ASET_501M_11'
Error 376 happened during db open, shutting down database
USER: terminating instance due to error 376
Instance terminated by USER, pid = 22251
ORA-1092 signalled during: ALTER DATABASE OPEN...
This messages alternates between the ASET*11 and ASET*12 raw partitions on the retries. Veritas shows nothing wrong with the partitions as does UNIX shows that the files are accessible. Can you point me in the right direction?
The only thing I can tell you for sure is that before the Oracle database can open, it must make sure that every datafile exists. In this case, datafile number 10 is not available. There could be any number of reasons. Does the file actually exist? Is there a path from the server to the filesystem. You might also want to run DBVERIFY against this file to see if there are any problems. Otherwise, your best bet is to open a TAR with Oracle Support on this issue.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.