I am running an Oracle 18.104.22.168 database. Almost at midnight I get an error message "The instance Oracle VTDBS has been Terminated" on the server, and when I restart the system, the database runs fine. Could you please tell me how I can overcome this problem?
Something is bringing down your database. If it is occurring at the same time every day, then it sounds like this is being scheduled for automation. The first thing I'd do is to see what is being scheduled to run. If you are on Windows, then check 'at' or the scheduler. If you are on Unix, then check cron. See if you can find out what is being started.
Another thing to look at is your logs. Check the Alert Log (located in BACKGROUND_DUMP_DEST). Also check for any process logs in the same directory. See if there are error messages which would give you any indication.
There are simply too many possibilties why a database would be brought down. You'll have to do some digging to figure out why.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.