Solved

best automation tool for installing oracle

Posted on 2013-10-23
6
410 Views
Last Modified: 2013-10-29
What would be the best method, scripting language/programming language/tool etc to install Oracle database. I'd like to ideally have one method which picks the required oracle install files, including ODAC and some other components I need for a .net application.

I'd like to use this same script to run the install on Windows and Linux, I assume Bash would have been the way to go if I was only doing this for Linux.

Once i have this i'd like to make it available for multiple machines so they can simply run the tool and it fetches and installs the software as per the script. I know there will be a lot to learn whatever way but i'm just looking on advice on what tool/technology i need to look into.
0
Comment
Question by:deepi19
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 167 total points
ID: 39594574
The Oracle installer comes with the ability to do a Silent Install:
http://docs.oracle.com/cd/E11882_01/install.112/e24187/advance.htm#CHDICDJA

The response file should port across OS types but you will need to tweak the install locations.
0
 

Author Comment

by:deepi19
ID: 39594589
thanks for that, i'll look into that. Sorry i should have mentioned that i'd need to install some other software, .net, msxml and some other tools, ideally i'd like one script which handles that and the oracle installation. Any ideas on the best method of doing that? Even if it's another tool which calls the silent install from Oracle. I assume a scripting language would be best for this but i'm not sure which one.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39594892
Sorry but I've never set up Windows MSI type packages or *NIX install packages.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 23

Assisted Solution

by:David
David earned 166 total points
ID: 39595826
Slight's "tweak" can be putting it mildly, all the more so when you are throwing in different OS platforms, versions, patches, naming conventions, physical storage, and RAM.  My counsel is to keep things simple and sustainable until you become much more familiar with what things can go wrong :)
0
 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 167 total points
ID: 39598534
there is no 1 solution for multiple os types
you'll need to make a solution for each os type
just check the downloads on oracle ... first select your os, then your version of the client
even oracle doesn't have 1 installer.

however you could still bundle them all into 1 deployment package with a tool like LANdesk
http://www.landesk.com/products/management-suite/
0
 

Author Closing Comment

by:deepi19
ID: 39609663
Thanks guys, I'm going to look into the silent installers, i think from a scripting point of view something like python may be worthwhile.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question