Ask the Expert

RAC startup error with Veritas Advanced Cluster Server

I am unable to determine what the issue is on database startup Oracle9i RAC with Veritas Advanced Cluster Server:

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: