
	Home > Ask the Oracle Experts > Questions & Answers > System timing out writing to control file

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

System timing out writing to control file

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

QUESTION POSED ON: 17 December 2003
We have run into a number of ORA-00600 errors that have brought our system down. The message says that it's timing out on writing to the control file. We upped a parameter from 900 to 1800 to give the system more time to update but no one seems to be able to zero in on the real problem.

It's Oracle81 8.1.7.4 and it's a large data warehouse application. Any ideas on where we should be looking?

EXPERT RESPONSE
The ORA-600 errors are untrapped errors issued by the Oracle instance. In other words, the ORA-600 errors are a generic way of letting you know that there is a problem, but the database does not know what the problem is. On the same line as ORA-600, there will be additional information in brackets. The first code in brackets is the most important as it indicates what section of the Oracle kernel code tripped the ORA-600 error. Without this first parameter, it is hard to determine what the exact problem is. If you have access to MetaLink, type in "ORA 600 xxxx" where "xxxx" is that first parameter in brackets. It should help you figure out what the exact problem and resolution is. Barring that, you can try a Google search to see if others have posted this same error somewhere before. Finally, ORA-600 errors can really only be diagnosed by Oracle Support. So if the above does not solve your problem, open a TAR with Oracle Support.

Digg This!

StumbleUpon

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
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Oracle White Papers: Fusion Middleware

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy