Updating Oracle with latest patches

External Since: Aug 02, 2003 Posts: 1

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.

Thanks
Barry

External Since: Feb 13, 2005 Posts: 1

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.TakeThisOut@hotmail.com> wrote in message
> news:747f1dec.0502130547.ca9f478@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
<font color=purple> > <a style='text-decoration: underline;' href="http://www.niall.litchfield.dial.pipex.com</font" target="_blank">http://www.niall.litchfield.dial.pipex.com</font</a>>