RE: how to find out the patch applied on different env.
Title: 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- From: sesuraj m [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Subject: how to find out the patch applied on different env. 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. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sesuraj m INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: how to find out the patch applied on different env.
Have you tried ftp://oracle-ftp.oracle.com/apps/patchsets/PATCHSET_COMPARE_TOOL/ ? I think it is not using applptch.txt. inka -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. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sesuraj m INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).