Q

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:
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
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close