My experience is only up through 11, not 11i, but I would resist the
"only test what Oracle says is touched" approach. If a patch has
nothing but a form .inp, you can get away with it, but the second
you touch a lib or object file...I've seen too many problems appear
in areas they shouldn't not to want at least a module test. On big
patches, I always asked for (not always got, but at least argued for)
a full system test. This becomes even more important if you have
much in the way of customization.
Just my $.02,
John P Weatherman
Database Administrator
Replacements Ltd.
-----Original Message-----
Sent: Friday, August 16, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L
Catherine,
We are not running HR. We have Financial Apps (GL, AP, PO, etc.). We
have test procedures that the users run through. They test basic
functionality (bring up various forms, query data, etc). The procedures
amount to around 16-20 man-hours of testing.
If a patch only affects a form or two, then that is what we test. Lately
we have been applying large groups of patches because we are bringing up
another module. This requires us to run through our testing procedures.
Jay
>>> [EMAIL PROTECTED] 08/15/02 09:38PM >>>
Hi Jay,
Our Oracle HR consultant said that we are to test only the patch readme.txt
"Enhanced features" as Oracle HR is way too big and it's not possible to
test every form and report. Are you on 11I Oracle HR ? If yes, do you mean
that you test every single form and report ? If yes, how long does it take ?
Regds,
Catherine
-----Original Message-----
From: Jay Hostetter
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Arm Twisting?
Catherine,
We all feel your pain.
My only suggestion is to test heavily. For every hour of
patching that we have, we have several hours of pre-req research and testing
on another server. You simply can't run this software without a whole
separate environment for testing patches.
Is there a support group for 11i dbas?
Jay
>>> [EMAIL PROTECTED] 08/14/02 11:08PM >>>
I guess you are not using Oracle Human Resources
Applications. For most of
the patches that we've applied, there are new bugs. It's a
never-ending
applying patches-after-patches ... We've lost count of the
number of TARs
opened. The worst part is after applying a patch to solve a
bug, the new
problem which was not documented in the readme file always
emerge itself
after sometime. By then, it's too late to revert back to the
old version.
Are we the only company having the problem ? sigh..
Regds,
Catherine
-----Original Message-----
From: Conboy, Jim
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 5:54 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Oracle Arm Twisting?
"I've called Oracle for a TAR once in the
past 18 months."
Ah, my friend, but you're not using Portal
9.0.2, are you?
I've opened more TARs in the last few months than the rest
of my Oracle
career. Bleeding edge, I guess, so maybe its our own fault.
But
third-party support for this would have stopped the project
before it got
started.
I agree that its not accurate to generalize
all tech support
as nimrods. There are some very good ones out there, and
even the rest at
least have acccess to all the internal notes we can't get to
(Grrrrr...why
the hell do they show in metalink searches if we can't see
them?). And the
developers, if you can ever get to them, know their stuff
and are a pretty
decent bunch.
**DISCLAIMER
This e-mail message and any files transmitted with it are
intended for the use of the individual or entity to which they are addressed
and may contain information that is privileged, proprietary and
confidential. If you are not the intended recipient, you may not use, copy
or disclose to anyone the message or any information contained in the
message. If you have received this communication in error, please notify the
sender and delete this e-mail message. The contents do not represent the
opinion of D&E except to the extent that it relates to their official
business.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
INET: [EMAIL PROTECTED]
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: [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: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
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: [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).
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the
use of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the
message or any information contained in the message. If you have received
this communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the
extent that it relates to their official business.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
INET: [EMAIL PROTECTED]
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: [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: John Weatherman
INET: [EMAIL PROTECTED]
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: [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).
