Friday, May 9, 2008

How to apply a Patch in Apps

Patching is the most basic thing that an Oracle Apps Dba is expected to know.A patch is applied either to fix a bug or to add some new functionality.
Here are the steps for patching in Apps 11i
1 First check that the patch is already not applied.
select * from ad_bugs where bug_number='patchnumber';
Now if the patch is not applied then go through the read me of the patch on Metalink. Check for pre-reqs and download the patch.
1 Stop the apps services
./adstpall.sh apps/password
2 Bounce the database(This is not mandatory but it kills any hanging process)
./addbctl.sh stop immediate
./addlnctl.sh stop listnername
./addlnctl.sh start listnername
./addbctl.sh start
3 Put the system in Maintenance mode
Run adadmin--Goto step 5-Change Maintenance mode-step 1 Enable Maintenance mode
4 Goto the patch directory where you downloaded the patch.Unzip the patch as applmgr user(application owner).It will create a directory with the patch number.
5 Goto the directory with the patch number and run
adpatch
It will ask for patch log file,apps,system password,driver name(c,d,g,u),number of workers.
6 go through the patch log file and check that there is no error
7 Disable maintenance mode
Run adadmin--Goto step 5-Change Maintenance mode-step 2 Dis-able Maintenance mode
8 Bounce the database again
9 Start the apps services
./adstartal.sh apps/password

3 comments:

Devesh Mishra said...

Nice one!!

Regards
Devesh

Saurabh said...

Good job... keep it up..

its helps me a lot...

thanks for all ur effort and support..

thanks once again..

SANDY'S ART GALLERY said...

Good job anmol..you should have done it longgg back !!!!!!!!

C:\>ping anmol.gupta.com

Pinging anmol.com [69.46.228.181] with 32 bytes of data:

Reply from 69.46.228.181: bytes=32 time=365ms TTL=236
Reply from 69.46.228.181: bytes=32 time=378ms TTL=236
Reply from 69.46.228.181: bytes=32 time=251ms TTL=236
Reply from 69.46.228.181: bytes=32 time=340ms TTL=236

Ping statistics for 69.46.228.181:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),


HAPPY PATCHING !!!!