Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Database stopped, showing multiple error messages
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Database stopped, showing multiple error messages

Karen Morton EXPERT RESPONSE FROM: Karen Morton

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site
>
QUESTION POSED ON: 02 March 2004
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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts