RE: Automation of regular tasks
Date: Wed, 30 Sep 2015 14:24:52 -0700 (PDT)
Message-ID: <87e9e00e-ee15-43de-9521-410e138f13f2_at_default>
Yes, to do WLS provisioning, you must license WLS Management Pack EE. However, that gives you a lot more than WLS provisioning as you can see from the data sheet at http://www.oracle.com/technetwork/oem/soa-mgmt/ds-em12c-wls-mgmt-pack-ee-1552456.pdf.
As for the DB homes, EM can handle that and indeed does out of place upgrades (separate ORACLE_HOMEs in other words) just as you do. And regarding the running of root.sh, you can either use EM to run sudo (or Power Broker) to do that if you want, or you can leave it out and get a warning at the end of the upgrade to run it manually. So up to you which way you like.
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Fax: +61262925183 | | Mobile: +61414443449
Email: pete.sharman_at_oracle.com Twitter: @SharmanPete LinkedIn: au.linkedin.com/in/petesharman
Website: petewhodidnottweet.com
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not, it's much harder than that!"
Bruce Pihlamae, long term Oracle DBA
-----Original Message-----
From: Paul Houghton [mailto:Paul.Houghton_at_uis.cam.ac.uk]
Sent: Thursday, October 1, 2015 2:15 AM
To: Oracle L (oracle-l_at_freelists.org) <oracle-l_at_freelists.org>
Subject: Automation of regular tasks
Hi
I am looking into automating regular tasks, and wondered what others do. I am thinking of database critical patches, and weblogic installs to start with, because they are things we do a lot.
We are going to look into using enterprise manager, but presumably we need to license weblogic server management pack to use OEM to install weblogic. Also I am not sure about how it would cope with the configuration that is typically required after a weblogic install.
We tend to have separate homes at each CPU version of the database so we can upgrade different DBs on the same server at different times, and to minimise downtime. Can OEM take care of this for us?
I did try using ansible, which I liked, except you can only define one user, which means doing everything as root and using sudo to switch to oracle, or doing everything as oracle and using sudo to run root.sh, neither of which I really like.
I note that http://oraclemiddlewareblog.com/2015/02/25/weblogic-domain-running-minutes-using-docker/ looks interesting, but would probably be no use for a database install, so would have to have different technologies for different areas of the stack which would increase complexity.
What do you use?
Thanks
PaulH
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 30 2015 - 23:24:52 CEST