In Oracle : Oracle Apps Patching in NON interactive mode

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Oracle Apps Patching in NON interactive mode

 

 Oracle Apps Patching in NON interactive mode

 

 

1. Why Patching in NON-interactive mode ?

2. How could I create the response file (the defaultsfile file) ?

3. Applying the patch in NON-interactive Mode

4. Restarting a NON-interactive AutoPatch session

5. Abandoning a NON-interactive AutoPatch session

 

 

1. Why Patching in NON-interactive mode ?

 

Instead of responding to the adpatch prompts, you can create a file which keeps the adpatch responses. In this case you don't have to asnswer to the adpatch prompt and because of this the down time is smaller. 

 

 

2. How could I create the response file (the defaultsfile file) ?

This could be done by running the AutoPatch in interactive mode using the defaultsfile = <file name> argument. When AutoPatch ask you for the location of the patch type abort and <ENTER>.

 

Example:

 

$ adpatch defaultsfile=$APPL_TOP/admin/VIS/mydefaults.txt

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications AutoPatch
 


Version 11.5.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.

Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.

Your default directory is '/APPS/visappl'.
Is this the correct APPL_TOP [Yes] ?

AutoPatch records your AutoPatch session in a text file
you specify. Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.
 


Filename [adpatch.log] :

Defaults Feature Enabled = YES.

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [VIS] : VIS *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *

Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *

Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [apps] : apps *

You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database 'VIS'
using ORACLE executables in '/APPS/visora/8.0.6'.

Is this the correct database [Yes] ?

AutoPatch needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.

Enter the password for your 'SYSTEM' ORACLE schema: manager

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS

Enter the ORACLE password of Application Object Library [APPS] :

AutoPatch is verifying your username/password.
The status of various features in this run of AutoPatch is:

<-Feature version in->
Feature Active? APPLTOP Data model Flags
------------------------------ ------- -------- ----------- -----------
CHECKFILE Yes 1 1 Y N N Y N Y
PREREQ Yes 6 6 Y N N Y N Y
CONCURRENT_SESSIONS No 2 2 Y Y N Y Y N
PATCH_TIMING Yes 2 2 Y N N Y N Y
PATCH_HIST_IN_DB Yes 6 6 Y N N Y N Y
SCHEMA_SWAP Yes 1 1 Y N N Y Y Y

Identifier for the current session is 26930

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...

Reading database to see what industry is currently installed.

Reading FND_LANGUAGES to see what is currently installed.
Currently, the following language is installed:

Code Language Status
---- --------------------------------------- ---------
US American English Base

Your base language will be AMERICAN.

Setting up module information.
Reading database for information about the modules.
Saving module information.
Reading database for information about the products.
Reading database for information about how products depend on each other.
Reading topfile.txt ...

Saving product information.

AD code level : [11i.AD.I.2]

Trying to obtain a lock...

Attempting to instantiate the current-view snapshot...

Instantiated bug-fix info from baseline info.


**************** S T A R T O F U P L O A D ****************

Start date: Thu Mar 27 2008 00:13:42

0 "left over" javaupdates.txt files uploaded to DB: Thu Mar 27 2008 00:13:42

0 patches uploaded from the ADPSV format patch history files: Thu Mar 27 2008 00:13:42

Uploading information about files copied during the previous runs ...

0 "left over" filescopied_<session_id>.txt files uploaded to DB: Thu Mar 27 2008 00:13:42

****************** E N D O F U P L O A D ******************

End date: Thu Mar 27 2008 00:13:42

Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/home/oracle/Desktop/PATCH_TOP/6012471] : abort    + ENTER     !!!!!

 

Verify that the defaults file exists in APPL_TOP/admin/<SID> directory:

 

[oracle@APPS VIS]$ cd /APPS/visappl/admin/VIS
[oracle@APPS VIS]$ ls
\adalldefaults.txt log mydefaults.txt out restart

 

Here is the content of the mydefaults.txt file:

 

#
# AD Default Values File
#
#
# Updated by AutoPatch on Thu Mar 27 2008 00:10:51
#

## Start of Defaults Record
%%START_OF_TOKEN%%
APPL_TOP
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
/APPS/visappl
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
DBNAME
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
VIS
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
MATCH_APPL_TOP
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
Yes
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
LOG_FNAME
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
adpatch.log
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
DEF_ACTIVATE_EMAIL
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
No
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
DEF_BATCH_SIZE
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
1000
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
O2
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
/APPS/visora/8.0.6
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
CORRECT_DBENV
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
Yes
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
DEF_SYSTEM_PWD
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
manager
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
ORACLE_username_Application_Object_Library
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
APPLSYS
%%END_OF_VALUE%%
## End of Defaults Record

## Start of Defaults Record
%%START_OF_TOKEN%%
ORACLE_password_Application_Object_Library
%%END_OF_TOKEN%%

%%START_OF_VALUE%%
APPS
%%END_OF_VALUE%%
## End of Defaults Record

 

 

3. Applying the patch in NON-interactive Mode

 

Run the following command:

 

$adpatch defaultsfile=$APPL_TOP/admin/<SID>/<defaults file name>  \

                patchtop=<loaction of the patch driver> \

                logfile= <logfile short name> \

                driver= <driver name>  \

                workers = <number of workers>  \

                interactive=no

 

Note: if driver parameter is not specified, all the drivers will be applied. 

 

Example:

 

$ adpatch defaultsfile=$APPL_TOP/admin/VIS/mydefaults.txt \
      patchtop=/home/oracle/Desktop/PATCH_TOP/6012471 \
      logfile=6012471.log \
      driver=u6012471.drv \
      workers=4 \
      interactive=no

 

 

4. Restarting a NON-interactive AutoPatch session

 

This must be done when a NON-interactive patching session fails. 

When the error is fixed the session must be restarted. this must be done using the same command and another new argument restart=yes:

 

$ adpatch defaultsfile=$APPL_TOP/admin/VIS/mydefaults.txt \
      patchtop=/home/oracle/Desktop/PATCH_TOP/6012471 \
      logfile=6012471.log \
      driver=u6012471.drv \
      workers=4 \
      interactive=no \

      restart=yes

 

 

5. Abandoning a NON-interactive AutoPatch session

 

If you have an error with a NON-interactive patch and you want to abandon that session (you will never be able to restart that session in this case) in order to apply another patch NON-interactively you have to add abandon=yes to the new adpatch command: 

 

Example:

 

$ adpatch defaultsfile=$APPL_TOP/admin/VIS/mydefaults.txt \
      patchtop=/home/oracle/Desktop/PATCH_TOP/6132763 \
      logfile=6132763.log \
      driver=u6132763.drv \
      workers=4 \
      interactive=no \

      abandon=yes

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Oracle Apps Patching in NON interactive mode

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.