Apply patch on EBS 11i

How to apply patch on EBS 11i

This document is well explained regarding how to apply patch on EBS 11i. The following are the step by step document
1- Stop the application using applmgr user
2- run the environment file.
3- run the adadmin using applmgr
4- Change to maintanance mode.
5- run the adpatch from downloaded patch. like
$adpatch
Follow the instruction and go-ahead.
6- After complete come out of the maintenance mode
7- Start the application

========================================

With details

First off all stop the application using applmgr user

#cd/u01/oracle/viscomn/admin/scripts/VIS_prodapps
#./adstpall.sh apps/apps
Then proceed with instruction as below
script returned:
****************************************************
1- run the adadmin using applgmr .
Some time to run adadmin is not working properly for that you has to run the below

$cd /u01/oracle/visappl/
now to run put the $ . . /APPSVIS_appserver.env (There is space between two dots.
Now you will be able to run adadmin
applmgr$ adadmin
[applmgr@appserver visappl]$ adadmin

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications AD Administration
Version 11.5.0
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AD Administration 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 ‘/u01/oracle/visappl’.
Is this the correct APPL_TOP [Yes] ?

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

Filename [adadmin.log] :

************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Thu Apr 01 2010 10:09:22

APPL_TOP is set to /u01/oracle/visappl

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

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 [appserver] : appserver *

You are about to use or modify Oracle Applications product tables
in your ORACLE database ‘VIS
using ORACLE executables in ‘/u01/oracle/visora/8.0.6’.

Is this the correct database [Yes] ?

AD Administration 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] : apps

AD Administration is verifying your username/password.
The status of various features in this run of AD Administration 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 24934

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]

AD Administration Main Menu
————————————————–

1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration

Enter your choice [6] : 5  

Change Maintenance Mode
—————————————-

Maintenance Mode is currently: [Disabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:

1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu

Enter your choice [3] : 1
sqlplus -s &un_apps/***** @/u01/oracle/visappl/ad/11.5.0/patch/115/sql/adsetmmd.sql ENABLE
Spawned Process 24370

Successfully enabled Maintenance Mode.

Review the messages above, then press [Return] to continue.

Backing up restart files, if any……Done.

Change Maintenance Mode
—————————————-

Maintenance Mode is currently: [Enabled].

Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.

Please select an option:

1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu

Enter your choice [3] :

AD Administration Main Menu
————————————————–

1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration

Enter your choice [6] :

Backing up restart files, if any……Done.

There is no timing information available for the current session.

AD Administration is complete.

Errors and warnings are listed in the log file
/u01/oracle/visappl/admin/VIS/log/adadmin.log

and in other log files in the same directory.

[applmgr@appserver visappl]$

Now you are in maintainance mode
2- run adpatch to apply patch

[applmgr@appserver 4003579]$ pwd
/home/appsoftware/apps/11i_patches/first given/11i Patches/Patches/4003579
[applmgr@appserver 4003579]$ ls
b4003579.ldt f4003579.ldt fnd marker1.txt pa README.html README.txt u4003579.drv
[applmgr@appserver 4003579]$ adapatch
-bash: adapatch: command not found
[applmgr@appserver 4003579]$ adpatch

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 ‘/u01/oracle/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] :

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 [appserver] : appserver *

You are about to apply a patch to the installation of Oracle Applications
in your ORACLE database ‘VIS
using ORACLE executables in ‘/u01/oracle/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] : 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 24935

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…

Was already instantiated. So no instantiation done this time.
**************** S T A R T O F U P L O A D ****************

Start date: Thu Apr 01 2010 10:16:23

0 “left over” javaupdates.txt files uploaded to DB: Thu Apr 01 2010 10:16:23

0 patches uploaded from the ADPSV format patch history files: Thu Apr 01 2010 10:16:23
Uploading information about files copied during the previous runs …

0 “left over” filescopied_<session_id>.txt files uploaded to DB: Thu Apr 01 2010 10:16:23

****************** E N D O F U P L O A D ******************
End date: Thu Apr 01 2010 10:16:23
Enter the directory where your Oracle Applications patch has been unloaded

The default directory is [/home/appsoftware/apps/11i_patches/first given/11i Patches/Patches/4003579] :

Please enter the name of your AutoPatch driver file : u4003579.drv
#note open another terminal and go to the patch which you are going to apply . there will be driver file put that one there.

#/home/appsoftware/apps/11i_patches/first given/11i Patches/Patches/4003579
#[root@appserver 4003579]# ls
#b4003579.ldt fnd pa README.txt
#f4003579.ldt marker1.txt README.html u4003579.drv
#[root@appserver 4003579]#

patch is applied
Purging timing information for prior sessions.

sqlplus -s APPS/***** @/u01/oracle/visappl/ad/11.5.0/admin/sql/adtpurge.sql 10 1000
Spawned Process 29703

Done purging timing information for prior sessions.

AutoPatch is complete.

AutoPatch may have written informational messages to the file
/u01/oracle/visappl/admin/VIS/log/adpatch.lgi

Errors and warnings are listed in the log file
/u01/oracle/visappl/admin/VIS/log/adpatch.log

and in other log files in the same directory.

[applmgr@appserver 4003579]$

After apply patch, change the maintenance mode to disable

[applmgr@appserver 4003579]$ adadmin

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

Oracle Applications AD Administration

Version 11.5.0

NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Attention: AD Administration 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 ‘/u01/oracle/visappl’.
Is this the correct APPL_TOP [Yes] ?

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

Filename [adadmin.log] :

************* Start of AD Administration session *************
AD Administration version: 11.5.0
AD Administration started at: Thu Apr 01 2010 10:24:59

APPL_TOP is set to /u01/oracle/visappl

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 [appserver] : appserver *

You are about to use or modify Oracle Applications product tables
in your ORACLE database ‘VIS’
using ORACLE executables in ‘/u01/oracle/visora/8.0.6’.

Is this the correct database [Yes] ?

AD Administration 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] : apps

AD Administration is verifying your username/password.
The status of various features in this run of AD Administration 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 24936

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]

AD Administration Main Menu
————————————————–

1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration

Enter your choice [6] : 5

Change Maintenance Mode
—————————————-

Maintenance Mode is currently: [Enabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.
Please select an option:

1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu

Enter your choice [3] : 2

sqlplus -s &un_apps/*****
@/u01/oracle/visappl/ad/11.5.0/patch/115/sql/adsetmmd.sql DISABLE
Spawned Process 29747

Successfully disabled Maintenance Mode.

Review the messages above, then press [Return] to continue.

Backing up restart files, if any……Done.

Change Maintenance Mode
—————————————-

Maintenance Mode is currently: [Disabled].
Maintenance mode should normally be enabled when patching
Oracle Applications and disabled when users are logged on
to the system. See the Oracle Applications Maintenance
Utilities manual for more information about maintenance mode.

Please select an option:

1. Enable Maintenance Mode
2. Disable Maintenance Mode
3. Return to Main Menu

Enter your choice [3] :

AD Administration Main Menu
————————————————–

1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration

Enter your choice [6] :

Backing up restart files, if any……Done.

There is no timing information available for the current session.

AD Administration is complete.

Errors and warnings are listed in the log file
/u01/oracle/visappl/admin/VIS/log/adadmin.log

and in other log files in the same directory.

[applmgr@appserver 4003579]$

Now start the application using script.

/u01/oracle/viscomn/admin/scripts/VIS_appserver/adalnctl.sh start
script returned:
****************************************************

 

Completed

 

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in EBS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s