Solved

best automation tool for installing oracle

Posted on 2013-10-23
6
409 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
6 Comments
 
LVL 76

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 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39594892
Sorry but I've never set up Windows MSI type packages or *NIX install packages.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to recover a database from a user managed backup

911 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now