| 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: how to find out the patch applied on different env.
FILENAME adphrept.sql
DESCRIPTION
SQL script that creates a report file showing the patching history
of all patches
also can be used in conjuction with the following SQL, this tends to be more
granular:
SELECT * FROM AD_PATCH_DRIVERS
WHERE PATCH_DRIVER_ID IN
(SELECT PATCH_DRIVER_ID FROM AD_PATCH_RUNS WHERE PATCH_RUN_ID IN
(SELECT PATCH_RUN_ID FROM AD_PATCH_RUN_BUGS WHERE ORIG_BUG_NUMBER='&1' and
UPPER(APPLIED_FLAG)='Y'))
-----Original Message-----
Sent: Tuesday, October 01, 2002 11:58 PM
To: Multiple recipients of list ORACLE-L
Dear all,
I have a situation where I need to find out the patches applied on
different Oracle Application 11i (11.5.5) env. We have two environment PROD
and TEST. It seems that there are some patches applied to TEST in the past
few months. I would like to know what patches are applied on TEST env:
Database stack
Application stack $APPL_TOP
Technology stack (Forms, reports, Jinitiator).
There is neither manual logging system where I can find the patch details nor locating the files applpatch.txt or applptch.txt on the server.
Is there any other way I can easily find out the difference between those two instances in respect to patches?
Thanks in advance.
Michael Sesuraj
OCP.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sesuraj m INET: msesuraj_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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-LReceived on Wed Oct 02 2002 - 10:08:26 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markham, Richard INET: RMarkham_at_hafeleamericas.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
 |
 |