Re: Updating Oracle with latest patches

Niall, thanks for this most interesting information. I would really appreciate a URL or Google search terms to pull out this autoupdate information for 10g. Interestingly we are already running two 10g databases. For our default everything installations, there is also not an option showing in the menu (on the Windows systems anyway) to "scan for" necessary updates. All I see are Oracle/Oracle - DevSuiteHome, Application Server - DevSuiteHome, and Developer Suite - DevSuiteHome. Are you referring to an optional component, third party, ....

As for the automatic updates for SQL Server, perhaps I was a little careless in what I wrote. What I should have written is that there are automatic updates for SQL Server 2000 desktop edition. To autoupdate this it is just a matter of windowsupdate.microsoft.com, detect, and downloading any patches. We don't do it like this though, we use SMS. Perhaps this is the same for SQL Server but I do not know.

Regards
Barry

Niall Litchfield wrote:
> "barry" <bbulsara23_at_hotmail.com> wrote in message
> news:747f1dec.0502130547.ca9f478_at_posting.google.com...
> > Hi, I administer SuSE linux 9, SQL Server 2000, Windows 2K,
Microsoft
> > Office, Sophos anti-virus, and Adobe Acrobat reader on a number of
> > networked machines. All of these have a facility to
"Download/update
> > any outstanding updates or patches" automatically or on-demand. Is
> > there something similar out there for Oracle databases, even a 3rd
> > party product. I can't find anything. Rather than installing the
> > patches, I just want to a) backup the company database prior to b)
> > running a program to detect and update the database with all the
> > latest patches.
>
> Oracle 10g allows you to do this at extra cost - prior to that it is
up to
> you.
>
> Incidentally I'm not aware of any such facility for sqlserver, where
can it
> be found?
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
Received on Sun Feb 13 2005 - 08:48:09 CST