Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am facing issues with Oracle log files. My application inserts data from xml file into Oracle. I started my application last day and went home. It stopped unexpectedly at 8PM. There is no log in application why the insertion stopped.

I want to check Oracle log file to check what exactly the error was and why the Oracle stopped inserting data.

I have log.xml file and multiple *.trc and *.trm file. I don`t know how to start with this.

I just have to check the error that why the Oracle has stopped.

share|improve this question

migrated from Dec 24 '12 at 11:51

This question came from our site for professional and enthusiast programmers.

Aside from what maialithar said, you can also check the alert_yourSID.log or the listener.log

share|improve this answer

You have to open and read your log.xml file. Find the date when the error occured and read the messages. Eventually, when you find an error, it can point you to additional .trc file. Read it and see what happens.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.