Automic Workload Automation

Expand all | Collapse all

Upgrading Automic DB from Oracle 11g to 12c

  • 1.  Upgrading Automic DB from Oracle 11g to 12c

    Posted 07-10-2018 09:56 AM

    Good Morning,

    We have to upgrade our Automic Oracle DB to 12c and are just wondering if anyone has gone through this process before.  We're currently on 11.2.6HF1.

    From a procedural perspective, this is what I'm thinking we will need to do during the backend upgrade:

    1 - Bring down the agents and application using the same procedure as during an upgrade (clear activities, shutdown agents, stop clients, bring down CPs/WPs, and stop Windows Service)

    2 - Allow the DB team to complete the upgrade.

    3 - Bring up main services, and once stable start the clients.

    4 - Start all Agents.

    5 - Advise teams that they can start their queues.

    For this type of backend update, is there anything that we might be missing?  Has anyone done any backend DB upgrades and run in to any issues?

    Thanks!

    Tina



  • 2.  Re: Upgrading Automic DB from Oracle 11g to 12c

    Posted 07-10-2018 10:25 AM

    Hi Tina,

     

    we are also on AE 11.2.6 and we upgraded our Oracle database from 11.2 to 12.1. One thing you should remember is to upgrade the Oracle Client on the AE Server side as well. Your DB Team may not be aware of this..but the Oracle Client should have same level as the Database version in use.

    Oracle Client ver 11 should work woith an Oracle database 12c but still...

     

    /Keld.



  • 3.  Re: Upgrading Automic DB from Oracle 11g to 12c

    Posted 07-10-2018 10:32 AM

    Thanks Keld!

    Good point for updating the local Oracle Client.  Will add that to our Notes.



  • 4.  Re: Upgrading Automic DB from Oracle 11g to 12c

    Posted 07-10-2018 10:33 AM

    Hi,

     

    this is also recommended by Oracle company to install the same version of the Oracle Client on the application server as the version of the Database Engine is.

    And, I recommend to install the full client and not the instant client.

     

    /Andi



  • 5.  Re: Upgrading Automic DB from Oracle 11g to 12c

    Posted 07-10-2018 10:37 AM

    Also, one thing I forgot to mention.  We have some regular transport from our DEV to PROD instance.  If the backend DBs are on different versions, will that cause any major issues?  We're going to have a gap of 2-3 weeks between updating both environments.