Oracle Response File

Scenario:

As a release engineer, you have to manage the database and apply patches if applicable. As you know, a lazy engineer is a good engineer and you want to automated the application. Before you can automate that you have to know how to apply a db patch in silent mode – in other word, silent installation.

A silent installation is an installation performed without displaying the Universal Installer screens and could run in noninteractive mode.

Solution:

You can create an Oracle Response File and it will help you apply db patches in silent mode.

What is a response file? A resonpse file contains answers to installation questions that otherwise would be provided by the users in an interactive installation session.

How to create an Oracle response file? Run as below (Ensure that $ORACLE_HOME has been set properly)

-bash-3.2$ $ORACLE_HOME/ccr/bin/emocmrsp
OCM Installation Response Generator 10.3.4.0.0 – Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
The OCM configuration response file (ocm.rsp) was successfully created.
-bash-3.2$ ls
ocm.rsp
-bash-3.2$

Here ocm.rsp is your response file. You can use it to apply patches automatically.

For example, you want to apply patch#123456 into your DB home, you can issue,

opatch apply -silent -ocmrf ocm.rsp 123456

Pls. note, ocm.rsp is platforms independent and you can use the same ocm.rsp file for Windows, Unix, Solaris, etc.