Ask the Expert

Why does database keep crashing?

I have Oracle9.1 running under Win2K. We are experiencing database crashes where the Oracle service suddenly crashes out. The only message is in the system event log for Service Manager that the service has crashed. No other peculier messages are present in any Oracle logs either. We have not been able to determine any events or activities that consistently preceed the crash. We have moved to another server with a fresh OS installation and the problem persists.

The crash frequency is also not consistent. It works for a month and then crashes a few times and then works. The system is not overloaded and we have monitored the system parameters preceeding the crash and no peculiar patterns were evident.

We have VB applications accessing the database and have observed that once when the application was restarted the DB service crashed but this is not consistent.

I am now all out of options.

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

I've never seen the Oracle database crash suddenly like you mention without issuing some sort of trace or error information. Make sure you fully examine your Alert log for clues to the crash. Also check the USER_DUMP_DEST, BINARY_DUMP_DEST, and CORE_DUMP_DEST directories for any trace files. Also check %ORACLE_HOME%database directory for any information. You might also want to consider patching to Oracle 9.2.0.4 as this may fix known bugs.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary

This was first published in December 2003

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Data Management
Business Analytics
SAP
SQL Server
Java
Data Center
Content Management
Financial Applications

Data Management
- From 4GLs to HTML5 desktop apps: Bringing data to the masses
  
  Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.
- Enterprise data quality efforts in good company with MDM, governance
  
  Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.
- Better data quality process begins with business processes, not tools
  
  Efforts to improve data quality should start with procedural changes to help avoid data errors, then the possible addition of data quality software.
Business Analytics
- Member Exclusive Downloads
  
  Member Exclusive Downloads from SearchBusinessAnalytics
- In-memory applications take on big data analytics challenge
  
  In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.
- Texas utility deploys operational intelligence, improves 'on-boarding'
  
  TXU Energy applied Vitria operational intelligence software to gain a better customer view. Careful processes selection ensured quick performance.
SAP
- Food bank network delivers with SAP mobility
  
  The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.
- SAP adds hybris to its SAP CRM tool set: More choices, or confusion?
  
  One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.
- Limit returns, SAP procurement expenses with a stability study
  
  Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.
SQL Server
- SQL Server 2014 'keeps up with the Joneses,' says analyst
  
  Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- SQL Server high availability: Natural enemy of virtualization?
  
  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
- SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
  
  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.
Java
- Will the Red Hat model work for IaaS cloud computing with OpenStack?
  
  The Red Hat transition is to move their successful model to IaaS through OpenStack and cloud computing. But will this new move from the JBoss company work as well as RHEL did a decade ago?
- How Red Hat's Linux and OpenStack IaaS drives Intel's bottom line
  
  While a major protectorate of intellectual property, Red Hat Linux and OpenStack IaaS offerings provide the bonus of driving innovation, which leads to more chips being purchased, driving revenue at Intel's bottom line.
- Embracing OpenStack: How Red Hat commoditized open source cloud computing
  
  By leveraging OpenStack, Red Hat plans to commoditized cloud computing, just like they commoditized open source Linux ten years ago.
Data Center
- Red Hat Open Hybrid Cloud aids private, public cloud management
  
  Hardware, virtualization, public and private cloud are all converging and need to be managed as one environment. Enter Red Hat's Open Hybrid Cloud.
- Mainframe modernization takes on urgency
  
  A Red Hat Summit talk on database and mainframe modernization highlights urgency, need for agility in enterprise development teams.
- AMD microprocessors regroup to fight another day
  
  Intel may win the server war, but AMD microprocessors could find more acceptance in another niche market.
Content Management
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
- Quiz: Implementing digital asset management systems
  
  Take this quiz to test your knowledge of digital asset management (DAM) technologies and processes.
Financial Applications
- CFOs reap the benefits of BPM tools in efficiency, compliance
  
  BPM tools can help CFOs reduce errors and enhance the accuracy of reporting and forecasting, experts say.
- CFOs can seize opportunity to lead good governance over IT
  
  Get tips from experts on how to enact good IT governance by getting the right people to do the right processes.
- CFO survey finds interest in analytics and cloud on the rise
  
  According to a recent survey, CFOs expect to invest more in cloud, mobile and big data technology in coming years and spend less on IT infrastructure.

All Rights Reserved,Copyright 2003 - 2013, TechTarget