| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Applying Application Patches - Help needed
This is a multi-part message in MIME format.
--------------DBD9957C29188E55FCC22379 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
John,
The adpatch utility is used to apply patches for the Oracle Applications. You will need to know the passwords to the SYSTEM, APPS, and APPLSYS schemas. I would advise you to read the readme.txt file supplied for the patch as it usually contains information regarding the order in which to apply the patch drivers, and other prerequisite patches (this is very important!!). It sounds like you are applying a mega patch, so make sure you test in development first as there is no backout ability. Make sure users are not using the system, and that the concurrent managers have been shut down. If you are NCA, I'd also recommend shutting down the web listeners and forms listener as well.
Generally, patches consist of several patch drivers: c<patch#>.drv, d<patch#>.drv, and g<patch#>.drv where the 'c' driver copies files from the patch directory to the APPL_TOP, the 'd' driver runs database scripts, and the 'g' driver generates forms and reports files.
I'd recommend checking for and compiling any invalid DB objects after applying a patch set. Run compile APPS schema from the Maintain Database Objects Menu in adadmin.
Searching MetaLink for 'adpatch' will probably return too many hits. The documentation on adpatch and the other applications utilities can be found in the system administrator manual for the applications.
HTH,
Michael Siebert
Solutions Consulting, LLC.
John Dailey wrote:
> Hi all, I have searched Metalink for about an hour now and have been
> unsuccessful in finding any instructions on applying application patches. I
> have not done this before, but am anxious to learn. The DBA job here kind
> of got dumped in my lap; most of my experience comes on DB2. Could anybody
> point me to a good step-by-step or other how-to on applying application
> patches? I'm trying to apply Patch Set G for Oracle Fixed Assets 10.7. We
> are on 7.3.4.2 / HP-UX 11.
>
> Thanks to any and all for your help. The tips I have picked up here have
> saved me more than once. Also, please don't hold my M$ certification
> against me; I'm really not that bad of a guy! =) (The devil made me take
> the tests)
>
> Thanks again for any help.
>
> John Dailey, MCSE/MCP+I
> Consultant
> Concept Solutions, LLC
> Phone: 703-975-7039
>
> Concept Solutions, LLC
> *Your Business Intelligence Partner*
> www.concept-solutions.com
>
> --
> Author: John Dailey
> INET: John.Dailey_at_concept-solutions.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--------------DBD9957C29188E55FCC22379
Content-Type: text/x-vcard; charset=us-ascii;
name="michael_siebert.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Michael S. Siebert Content-Disposition: attachment;
begin:vcard
n:Siebert;Michael
tel;pager:5136089903_at_mobile.att.net tel;cell:(513) 608-9903 tel;work:(513) 891-3423 ext. 7010
 |
 |