In lot of cases we turn around the execution concept and grant oracle the
sudo privileges to run the commands.
Then automation controlled by the DBA instead of the sysadmin is used to
deploy Oracle without human intervention.
I have worked at some clients where Oracle Cloud Control with Oracle
Configuration management is deployed and everything is automated through it.
In other places DBAs have written the puppet/chef deployment scripts and a
central deployment repository is used.
In other clients the DBA team actually owned their own puppet/chef
deployment services.
I had one client which had puppet for OS level deployments and Chef for
application level deployments for complete separation of duties. The choice
of one or the other was based on the two teams. In that particular client
the DBAs fell on the application side of the house where in a lot of
companies they are seen as part of infrastructure but it really depends on
the company.
I have had a variety of clients use custom automation scripts put into other
scheduling or administrative platforms or even a custom driven APEX app for
determining deployments.
There is a gamut of deployment mechanisms/reasons a team or company chooses
one or the other. In a lot of cases it seems to really be driven by power
and control instead of by what is best.
IMHO, Sysadmins would prefer puppet, chef or Docker unless the company is
driven by windows admins. The DBAs would prefer OEM or their own automation.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew
Parker's profile on LinkedIn
www.dimensionaldba.com <http://www.dimensionaldba.com/>
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John Mchugh
Sent: Monday, June 13, 2016 5:16 PM
To: william.muriithi@xxxxxxxxx
Cc: pete.sharman@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Question regarding sudo equivalents
Interesting thread....along the lines of automated provisioning where the
database and grid infrastructure require root execution for root.sh and
orainstRoot.sh what do most of you use? Or is it acceptable to run the
provisioning scripts as root and 'su' to the specific oracle user to run
the installation? By automation I mean no human intervention at all for
provisioning purposes.
thanks,
jpm
On Jun 13, 2016, at 5:04 PM, William Muriithi <william.muriithi@xxxxxxxxx>
wrote:
Evening Pete,
you using to get that access? The reason I'm asking is because I was on a
If you need secured access to root (i.e. sudo-like functionality) what are
That's interesting. First time I have heard that the industry is moving away