One adjustment to Matt's comments below. The Configuration Management Pack is
no longer available for purchase. It has been subsumed into the relevant
lifecycle management pack (in the example use case here, the Database Lifecycle
Management Pack).
Pete
Pete Sharman
Database Architect, DBaaS / DBLM
Enterprise Manager Product Suite
33 Benson Crescent CALWELL ACT 2905 AUSTRALIA
Phone: +61262924095 | | Mobile: +61414443449
Email: pete.sharman@xxxxxxxxxx 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: Dimensional DBA [mailto:dimensional.dba@xxxxxxxxxxx] ;
Sent: Friday, August 19, 2016 03:32 PM
To: keyantech@xxxxxxxxx; vijaysehgal21@xxxxxxxxx
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: RE: Tools for automating database build and deployment
You should ask yourself what is your current organization using for SW
deployments and see if that would work for you too, instead of introducing a
new tool chain into the environment.
Tools I have used in the past to deploy Oracle SW, Oracle Patches, Oracle
Databases, Oracle PDBs, Monitoring implementation/changes, DBA scripts, DDL
changes, etc include Open Source:
Puppet, Chef, Ansible, OpenCrowbar, SaltStack, Docker, CFEngine, Jenkins
Pay to Play:
Enterprise Puppet, OEM Configuration Management Pack, Microsoft Team Foundation
Server.
There are a lot more than these. It depends on what you really need/want to do.
Some are easier to use than others for certain tasks.
Extreme caution is advised here as most with most deployment SW you are turning
over access to your database to a tool that is controlled by someone else who
is not within infrastructure or databases. This has been the real rub as most
of the automation SW is controlled by DEV teams. In a lot of organizarions we
divide up deployments into different tools so that databases align with
infrastructure deployments instead of SW deployments.
Things as simple as DDL deployments that a dev simply pushed code into the
deployment that basically from the designer tool performed a drop table/create
table on the production tables and we had to restore from backup. Yes it was
tested all the way up the stack but in DEV/QA it generated all of it's data for
the testing scenarios with the data generation simply not being apart of the
Prod deploy.
You just need to think carefully about what you are allowing to happen on your
systems. It doesn't matter how much the DevOPS guys try to tell you about the
approval processes in the tool there is always an override or structural
modification that an admin on that side or developer because the admins are
really apart of the DEV team and gives everyone access that the controls
doesn't stop badness from happening.
Some links
https://blog.profitbricks.com/48-best-cloud-tools-for-infrastructure-automat
ion/
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx
View Matthew Parker's profile on LinkedIn
www.dimensionaldba.com
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Karth Panchan
Sent: Thursday, August 18, 2016 5:41 PM
To: vijaysehgal21@xxxxxxxxx
Cc: ORACLE-L
Subject: Re: Tools for automating database build and deployment
Check Liquibase. Nice open source tool. It allows release management.
Nice integration with Maven and Jenkins.
Karth
Sent from my IPhone
On Aug 18, 2016, at 8:07 PM, vijayrsehgal <vijaysehgal21@xxxxxxxxx> wrote:working towards automating release process of database scripts and
Dear Experts,
This was not my area of work, but in my present organization the team is
could shed some light on which tools are used.
I have never worked in this area before, so I thought if experts here
--
Thanking you for your time and help.
Regards,
Vijay Sehgal