Re: patches applied to RDBMS

2003-08-23 Thread Lon White
Yep.  Should have read the original question a little closer.  Thanks for
covering.

Lon
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 8:44 AM


> Database & technology stack patches aren't recorded in AD_ tables in Apps.
> Only patches going to APPL_TOP are.
> And OP probably has just DB anyway.
>
> Tanel.
>
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, August 21, 2003 9:44 AM
>
>
> > select * from ad_bugs usually works unless the patch uses the
Runinstaller
> > to install.  Is this for a straight database or an Apps installation?
> >
> > Lon
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 20, 2003 11:49 AM
> >
> >
> > > Hi All,
> > >
> > >  OS: Solaris 2.8
> > >  DB: 8i/9i
> > >
> > >  Is there a way to know whether a patch has been
> > >  applied to the Oracle RDBMS (except lsinventory).
> > >
> > > I guess there shouldbe some log/history file that will
> > > have this info. but can't re-call now.
> > >
> > > can somebody through some light.
> > >
> > >  Thanks and Regards,
> > >  Srinivas
> > >
> > >
> > >
> > > __
> > > Do you Yahoo!?
> > > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > > http://sitebuilder.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: kommareddy sreenivasa
> > >   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.net
> > --
> > Author: Lon White
> >   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.net
> --
> Author: Tanel Poder
>   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.net
-- 
Author: Lon White
  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: patches applied to RDBMS

2003-08-21 Thread Tanel Poder
Database & technology stack patches aren't recorded in AD_ tables in Apps.
Only patches going to APPL_TOP are.
And OP probably has just DB anyway.

Tanel.


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 9:44 AM


> select * from ad_bugs usually works unless the patch uses the Runinstaller
> to install.  Is this for a straight database or an Apps installation?
>
> Lon
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 20, 2003 11:49 AM
>
>
> > Hi All,
> >
> >  OS: Solaris 2.8
> >  DB: 8i/9i
> >
> >  Is there a way to know whether a patch has been
> >  applied to the Oracle RDBMS (except lsinventory).
> >
> > I guess there shouldbe some log/history file that will
> > have this info. but can't re-call now.
> >
> > can somebody through some light.
> >
> >  Thanks and Regards,
> >  Srinivas
> >
> >
> >
> > __
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: kommareddy sreenivasa
> >   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.net
> -- 
> Author: Lon White
>   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.net
-- 
Author: Tanel Poder
  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: patches applied to RDBMS

2003-08-20 Thread Lon White
select * from ad_bugs usually works unless the patch uses the Runinstaller
to install.  Is this for a straight database or an Apps installation?

Lon

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 11:49 AM


> Hi All,
>
>  OS: Solaris 2.8
>  DB: 8i/9i
>
>  Is there a way to know whether a patch has been
>  applied to the Oracle RDBMS (except lsinventory).
>
> I guess there shouldbe some log/history file that will
> have this info. but can't re-call now.
>
> can somebody through some light.
>
>  Thanks and Regards,
>  Srinivas
>
>
>
> __
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: kommareddy sreenivasa
>   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.net
-- 
Author: Lon White
  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: patches

2002-12-02 Thread DENNIS WILLIAMS
John - Excellent points.
Patrice - One factor to consider is that patches tend to be tested very
little by the software vendor. Full releases get tested extensively, but
even then there are gaps, because well, we wouldn't be having patches
otherwise. 
   If you've ever been a developer at a software vendor, what happens is one
customer reports an error. You verify the error and create a patch to fix
that specific error. But no comprehensive system testing is done. You ship
that patch to fix that problem. 
   Sometimes a vendor will bundle a group of patches together into a patch
bundle. Here the testing is much more extensive than for the single patch,
but still far short of the extensive full release testing.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Monday, December 02, 2002 7:44 AM
To: Multiple recipients of list ORACLE-L


I think I veer towards Yechiel's view here Patrice. I am not sure I have
ever heard anyone suggest applying all outstanding relevant patches to a
database however much you test first. (To be honest you are not advocating
that, just raising the question).
Normal policy wherever I have worked is not to patch unless absolutely
necessary.
 
Another point is that 1 patch can provide a new code piece of binary and
patches are not cumulative. Therefore applying patch a then patch b could
well mean that patch a is overwritten and yet your documentation indicates
that it has been installed.
 
HTH
 
John

-Original Message-
Sent: 02 December 2002 12:54
To: Multiple recipients of list ORACLE-L


Yechiel,
 
If that's your philosophy, and there are known unpatched bugs in the server
software, how can you be 100 percent sure it will stay up?
 
Granted, many of these bugs are esoteric, but not all.
 
I am curious what Oracle Support consultants do when they have a 24x7
contract, with all these patches.  Surely they have a list.
 
Regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 

[Boivin, Patrice J]  -Original Message-
Sent: Friday, November 29, 2002 3:49 AM
To: Multiple recipients of list ORACLE-L



We only apply patches as needed and where needed.
For example: I had a problem with export taking a long time on one system.
I installed a patch for this problem (after testing in test environment of
course) only on that database.
 
My motto is: If it ain't broken do not fix it.
 
I have seen too many follow up fixes to install something I do not need.
 
Yechiel Adar
Mehish

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Wednesday, November 27, 2002 9:05 PM

I am wondering how your sites handle patching production servers.
 
I just did a search in MetaLink, since 8174 was released there have been 48
patches (if I just select RDBMS).
 
If I select other items in my search, I get upwards of 70 additional bug
fixes.
 
How do high reliability sites handle patching?  I assume they would rather
fix potential problems (testing the patches on a testbed of course) rather
than just apply bug fixes as problems are encountered on production servers.
 
regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: <[EMAIL PROTECTED]
  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: DENNIS WILLIAMS
  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: patches

2002-12-02 Thread John.Hallas
I think I veer towards Yechiel's view here Patrice. I am not sure I have
ever heard anyone suggest applying all outstanding relevant patches to a
database however much you test first. (To be honest you are not advocating
that, just raising the question).
Normal policy wherever I have worked is not to patch unless absolutely
necessary.
 
Another point is that 1 patch can provide a new code piece of binary and
patches are not cumulative. Therefore applying patch a then patch b could
well mean that patch a is overwritten and yet your documentation indicates
that it has been installed.
 
HTH
 
John

-Original Message-
Sent: 02 December 2002 12:54
To: Multiple recipients of list ORACLE-L


Yechiel,
 
If that's your philosophy, and there are known unpatched bugs in the server
software, how can you be 100 percent sure it will stay up?
 
Granted, many of these bugs are esoteric, but not all.
 
I am curious what Oracle Support consultants do when they have a 24x7
contract, with all these patches.  Surely they have a list.
 
Regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 

[Boivin, Patrice J]  -Original Message-
Sent: Friday, November 29, 2002 3:49 AM
To: Multiple recipients of list ORACLE-L



We only apply patches as needed and where needed.
For example: I had a problem with export taking a long time on one system.
I installed a patch for this problem (after testing in test environment of
course) only on that database.
 
My motto is: If it ain't broken do not fix it.
 
I have seen too many follow up fixes to install something I do not need.
 
Yechiel Adar
Mehish

- Original Message - 
To: Multiple   recipients of list ORACLE-L 
Sent: Wednesday, November 27, 2002 9:05 PM

I am wondering how your sites handle patching production servers.
 
I just did a search in MetaLink, since 8174 was released there have been 48
patches (if I just select RDBMS).
 
If I select other items in my search, I get upwards of 70 additional bug
fixes.
 
How do high reliability sites handle patching?  I assume they would rather
fix potential problems (testing the patches on a testbed of course) rather
than just apply bug fixes as problems are encountered on production servers.
 
regards,
Patrice Boivin 
Systems Analyst (Oracle Certified DBA) 
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: <[EMAIL PROTECTED]
  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: patches

2002-12-02 Thread Boivin, Patrice J
Title: Pro*C for Oracle 817 on Win2000?



Yechiel,
 
If 
that's your philosophy, and there are known unpatched bugs in the server 
software, how can you be 100 percent sure it will stay up?
 
Granted, many of these bugs are esoteric, but not 
all.
 
I am 
curious what Oracle Support consultants do when they have a 24x7 contract, with 
all these patches.  Surely they have a list.
 
Regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA) 
[Boivin, Patrice 
J]  -Original Message-From: Yechiel 
Adar [mailto:[EMAIL PROTECTED]]Sent: Friday, November 29, 2002 3:49 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
patches

  We only apply patches as needed and where 
  needed.
  For example: I had a problem with export taking a long 
  time on one system.
  I installed a patch for this problem (after testing in 
  test environment of course) only on that database.
   
  My motto is: If it ain't broken do not fix 
  it.
   
  I have seen too many follow up fixes to install 
  something I do not need.
   
  Yechiel AdarMehish
  
- Original Message - 
From: 
Boivin, Patrice J 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, November 27, 2002 9:05 
PM
Subject: patches

I 
am wondering how your sites handle patching production 
servers.
 
I 
just did a search in MetaLink, since 8174 was released there have been 48 
patches (if I just select RDBMS).
 
If 
I select other items in my search, I get upwards of 70 additional bug 
fixes.
 
How do high reliability sites handle patching?  I assume they 
would rather fix potential problems (testing the patches on a testbed of 
course) rather than just apply bug fixes as problems are encountered on 
production servers.
 
regards,
Patrice 
Boivin Systems Analyst (Oracle 
Certified DBA) 
 


Re: patches

2002-11-29 Thread Yechiel Adar
Title: Pro*C for Oracle 817 on Win2000?



We only apply patches as needed and where 
needed.
For example: I had a problem with export taking a long 
time on one system.
I installed a patch for this problem (after testing in 
test environment of course) only on that database.
 
My motto is: If it ain't broken do not fix 
it.
 
I have seen too many follow up fixes to install something 
I do not need.
 
Yechiel AdarMehish

  - Original Message - 
  From: 
  Boivin, Patrice J 
  To: Multiple recipients of list ORACLE-L 
  Sent: Wednesday, November 27, 2002 9:05 
  PM
  Subject: patches
  
  I am 
  wondering how your sites handle patching production 
  servers.
   
  I 
  just did a search in MetaLink, since 8174 was released there have been 48 
  patches (if I just select RDBMS).
   
  If I 
  select other items in my search, I get upwards of 70 additional bug 
  fixes.
   
  How 
  do high reliability sites handle patching?  I assume they would rather 
  fix potential problems (testing the patches on a testbed of course) rather 
  than just apply bug fixes as problems are encountered on production 
  servers.
   
  regards,
  Patrice Boivin 
  Systems Analyst (Oracle Certified 
  DBA) 
   


RE: patches

2002-11-27 Thread Stephen Lee

-Original Message-
I am wondering how your sites handle patching production servers.


We make a copy of the existing product directory structure using tar
(everyone else) or cpio (me) before installing the patch.

For example:
cd /path/path/product/8.1.7
find . -print | cpio -pvmud /some/backup/directory
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  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: patches for 8.1.7

2002-02-14 Thread Connor McDonald

8.1.7.3 is the latest patch.

hth
connor

 --- sarath kumar <[EMAIL PROTECTED]> wrote: >
Hai,
> 
> i have to move my 7.3.4 database to 8.1.7. what are
> the patches i need to apply once i move to 8.1.7.
> The
> OS is  SUN SPARC 2.6
> 
> TIA
> Srinivas
> 
> __
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: sarath kumar
>   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). 

=
Connor McDonald
http://www.oracledba.co.uk (mirrored at 
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  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).