We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Free tier database keeps stopping

Accepted answer
20
Views
4
Comments
edited Apr 20, 2020 7:44PM in Oracle Cloud Infrastructure - General 4 comments

Summary

Half the time I log in to find the free tier ATP instance in a stopped state

Content

Database shuts down while in use, and must be manually restarted. 

Here is what it looks like from my datalogger:

2020-03-19 09:45:01,484 DEBUG __main__ Values committed
2020-03-19 09:50:04,445 DEBUG __main__ Values committed
2020-03-19 09:55:06,349 DEBUG __main__ Values committed
2020-03-19 10:00:07,256 ERROR __main__ ORA-03113: end-of-file on communication channel

In addition to the persistent connection from the data logger, I also have a couple of new connections every minute that retrieve the latest updates to my data. 

The activity graphs agree that the database was in fact shut down on March 19th around 10:00, a few minutes after the last commit. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!