Q
Problem solve Get help with specific problems with your technologies, process and projects.

Database stopped, showing multiple error messages

We have had a database running successfully for two months now. However, since returning from our vacation, the database has stopped. From the client, it displays ORA-01033 error. When logged in locally and trying to start the database, I get the following error messages: ORA-01115, ORA-01110 and ORA-27072.
Make sure you download yourself a copy of the Error Messages guide for future reference (technet.oracle.com). For now, I've provided you with the information you should need to decipher your problem from the Error Messages guide.

ORA-01033 ORACLE initialization or shutdown in progress
Cause: An attempt was made to log on while Oracle is being started or shutdown.
Action: Wait a few minutes. Then retry the operation.

ORA-01115 IO error reading block from file string (block # string)
Cause: The device on which the file resides is probably off line.
Action: Restore access to the device, then retry the operation.

ORA-01110 data file string: 'string'
Cause: This message reports the file name involved with other messages.
Action: See the associated messages for a description of the problem.

ORA-27072 skgfdisp: I/O error
Cause: READ/WRITE/READV/WRITEV system call returned error, additional information indicates starting block number of I/O.
Action: Check errno.

From this series of error messages, it appears that one of your datafiles is missing or off-line or has been corrupted somehow. Given the text of the error messages, you should be able to discover the file it's pointing to and then try to determine what the specific problem is with that file.

Dig Deeper on Oracle error messages

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close