Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I installed the Oracle 11g2 'standard' edition using the following zip-files:

linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip

I used the installation guide by Oracle which I found quite tedious, e.g. you need to install/configure an X-Server because the default installer is a GUI which you have to 'babysit' for some time.

Is there a way to automate a default Oracle installation?

I mean something like a script where I can specify: tell me what yum/apt-packages are missing, here are my oracle-zip-install-files, install it under $MY_BASEDIR and for everything else use some sane defaults!

And no GUI.

I know that there is an express-edition which comes as an rpm - this looks convenient on the first glance, but it seems to exclude some stuff the 'standard' edition includes, e.g. Pro*C.

share|improve this question
1  
Did you search for "oracle silent install", that's what this type of thing is usually called. –  Mat May 23 '13 at 16:39
add comment

1 Answer

up vote 3 down vote accepted

Two solutions:

Install oracle manually the first time. Then zip all ORACLE_HOME and for future installation simply do:

  1. Unzip oracle_home into the new home
  2. Run $ORACLE_HOME/bin/relink all
  3. Run ./runInstaller -silent -attachHome ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME="<Oracle_Home_Name>"

Other solution (not my preferred but probably the preferred for mass deployment) is to create a response file. The sample is available in the installation dir: <11g Disk>/database/response/enterprise.rsp . Copy this file, edit it and replace default values with your ones (mainly the path, install type, etc). Then run:

./runInstaller -silent -responseFile myresponsefile.rsp

You can also install the DB manually the first time and record the response file witht he command:

./runInstaller -record -destinationFile myresponsefile.rsp

The first one is my preferred because you can easily install and patch the database with the last PSU available, then you have a consolidated installation can be moved around. Of course all systems must be already prepared with needed packages.

share|improve this answer
    
How to change the SID for the future installation for the 1st method. –  Debajyoti Das Jul 24 '13 at 7:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.