I have heard and received this question several times. And I always pointed people to the status logs in AutoUpgrade’s logging directory. But I wasn’t aware how simple the monitoring can be. Kudos to my colleague Meir Burmanov from Oracle Israel for explaining me today how you can simply monitor AutoUpgrade: Refresh Status Information automatically. And as things progress quickly, and we have smart developers in the upgrade team, I had to refresh this blog post soon after. See below …
Like it – and it’s very simple
This won’t be a long blog post. And maybe there are even more fancier ways to do the monitoring. But for me it does the job. And it is super simple. Plus, I learned something new 🙂
AutoUpgrade writes not only log information for each job but also information which applies to the entire run. And one of these files is the state.html which gets updated over and over again during an upgrade run. Now you can monitor this file.
And at first stage, my colleague Meir Burmanov told me about the state.html file and recommended to start a simple web server such as python -m SimpleHTTPServer 8000 .
It is even more simple
Once my team mates saw this, they quickly implemented a tiny change – and since then you don’t need a webserver to be started anymore. You simply pass this into your browser’s address line:
And it refreshes automatically.
Not the most fancy output but it does what it’s supposed to do.
But this way you don’t have to type “lsj” a hundred times.
Further Information and Links
- AutoUpgrade – Where are all the logfiles?
- Oracle Database 19c Upgrade Guide – Logfile Structure
- Python for Beginners – How to use SimpleHTTPServer