Sunday, February 16, 2020

Free Oracle Cloud: 19. Oracle APEX upgrades (19.1 to 19.2)

This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

Many people wonder how you can upgrade your Oracle APEX version to the latest version in your cloud account. The short answer is: you can't...

Oracle is doing this for you, whenever they believe it is the right time to do. The idea is that at some point you can tell Oracle when it would be a good time to upgrade your APEX environment in a specified window, but today, that is not there yet.

I read that a few days ago Oracle upgraded the APEX release to 19.2 on the free cloud.

I didn't use my Always FREE Oracle Cloud account for a few weeks, so it was stopped.
I went in the Oracle Cloud console to start it again and up we go.

Through the Tools menu, I open APEX and logged in into my CLOUD workspace. But, to my surprise my APEX version was still 19.1.

I was doing a few things when suddenly I got "Application Express is being upgraded to a newer version":

When trying to open APEX from the console, I couldn't anymore.

I waited a couple of minutes and there it was ... APEX came back and was upgraded to 19.2:

So it looks like Oracle is checking your APEX release when you start your database and when it sees it's an older version, it will just upgrade. I thought that probably because my account was stopped, Oracle will try again in the maintenance window, but my experience learns it's not waiting on that window.

I'm glad Oracle upgraded APEX for me automatically, but it would be nice to have a log somewhere or some info that it will do this. Hopefully, this blog post will help people who only fire up their instance occasionally when doing a demo. It's best to do it a bit before so the upgrade takes place before you need your APEX instance.


LCapriles said...

Hi! Guided by your blogs, I have been using ATP as my new development environment, but remote debugging is missing (using jwp). I am unable to grant Debug Any Procedure: is there a way to overcome this?
Thank you for your time!

Anonymous said...

Hi Dimitri,
Many thanks for your useful posts. My client runs an On-Prem version of Apex (5.1) and we want to upgrade them to the Cloud. They have bought a new Oracle ERP system that comes with 2x free Autonomous Databases. We want to leverage one of these to migrate Apex to. I'm not really familiar with Oracle or Apex. Few questions below:
1. Is everything you need for a "standard" deployment essentially "built in"? Having read through some online documentation, do we need to add things like an Apex Listener, Web/HTTP Server, or any other server for that matter?
2. Confirming we'll need to upgrade to the latest version of Apex? What is this process like?
3. Can we integrate with Azure AD for authentication easily enough?
4. Are there any unforeseen costs associated with this?
Many thanks,

Anonymous said...

How can someone upgrade to Apex 20.1 on ATP

Dimitri Gielis said...

Oracle will automatically do this, you can not do this yourself.

Eslam said...

Sorry, I don't get it. If my app is always active, will oracle upgrade apex too? Or is it only for stopped databases?