2 minutes readSteps

When we applying patches in Interactive Mode by using ADPATCH utility, this utility ask basic question like Default APPL_TOP, Log File Name, ORACLE_HOME, apps password, system Password and some patches Compiling database and JSP at the end of patches

When we apply patch in Interactive mode, each time we repeated task like Default APPL_TOP, Log File Name, ORACLE_HOME, apps password…… We can reduce repeated tasks if we applying patches in Non Interactive Mode.

Steps for applying patches in Non Interactive Mode

• First we create Default file:( You have to do bellow steps only once in an environment to create defaults file)

adpatch defaultsfile =$APPL_TOP/admin/$SID/defaults.txt

Note: abort adpatch section at point where it asks for patch directory.

• Second Apply patches by using following commands:

adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt logfile=.log patchtop= driver=.drv interactive=no

• Now any future patches you apply by using Second Steps.

Note: In Non Interactive Mode, adpatch utility apply patch by using defaults file. Adpatch will pick APP_TOP, ORACLE_HOME information, system password and apps password from defaults file. This will save lot of time & you can reduce your patch timing using defaults file .

Now, we will discuss for applying lot of patches if we are applying 20 patches & out of those 10 patches execute compile database and JSP then adpatch will compile database 10 times which is waste of time. Better we apply patches with not to compile of Database and JSP.

adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt options=nocompilejsp,nocompiledb logfile=.log patchtop= driver=.drv interactive=no

after all patches applying successfully we can compile JSP and Database.

Step: How to compile database objetcs ?
Use adadmin compile database option or Use utlrp.sql script on database tier at $ORACLE_HOME/rdbms/admin

Step: How to compile JSP in Apps ?
Use perl script ojspCompile.pl under $JTF_TOP/admin/scripts like
perl ojspCompile.pl –compile

Another option (Merge Patches – admrgpch) to applying lot of patches to reduce patch timing
if we want to applying 20 patches we can merge 20 patches and create single patches and apply that single.

Steps for Merging Patches:

• Create directory Source Directory and put all patches.
• Create another Destination Directory where single patch will come
• After user following command:

admrgpch source_directory destination_directory