Errors in file
/opt/oracle/sol64-9.2.0.4/rdbms/log/ansset2_ora_22251.trc:
Requires Free Membership to View
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.
This was first published in November 2003

Join the conversationComment
Share
Comments
Results
Contribute to the conversation