Re: Patching databases - time estimates

Tony,

The problem with asking multiple questions is that one may be overlooked ;-)

Patch times vary a lot depending on hardware and the such. The best policy is to apply them to a test server and that will let you get your procedure down. You'll still find that your production server may vary significantly in the amount of time it takes.

8i to 10g. Hard to make a blanket statement. This could be a good time to change the layout of your database to benefit most from 10g. For example, are you using LMT everywhere? On the other hand, how much data, how long a downtime window can you get? Imp/exp may not complete in the available downtime window.
Here is a link to a document that may offer some ideas: http://www.tcoug.org/, scroll down to Best Practices for Upgrading to Oracle database 10g, and open the link to the presentation.

Dennis Williams

On 1/31/07, Paul Drake <bdbafh_at_gmail.com> wrote:
>
> On 1/31/07, S. Anthony Sequeira <tony_at_sequeira.org.uk> wrote:
> >
> > Hi,
> >
> > More than one question here. I have been asked to estimate the time
> > required to patch several databases.
> >
> > The majority are 9i (currently 9.2.0.1/9.2.0.4), to be patched up to
> > 9.2.0.8, all are single instance databases, all are running on
> > Win2K/Win 2003 servers. Most are 24/7, some 8/5
> >
> > Unfortunately, there are a couple of these still running on NT4.
> >
> > There are also a few 8.1.7 databases to be migrated to 10g on NT4 :(
> >
> > Questions:
> >
> > 1) A rough idea of time required for:
> > a) 9i patch to 9.2.0.8?
> > b) 8i patch to 10.2. Would it be better to export/import?
> >
> > 2)
> > a) Will 10g be OK on NT4?
> > b) If so, will Oracle support it?
> > c) Is it possible to patch 8.1 to 10.2? (see 1b)
> >
> > I'm pessimistic about 2, I'll be digging around on Metalink as soon as
> > I finish paperwork, but I have a meeting and I have to have a rough
> > idea on the above.
> >
> > Cheers.
> > --
> > Tony
> >
>
> Tony,
>
> MS Windows NT4 is a desupported OS.
> Metalink >> Certify >> by platform >> product >> check versions and
> submit.
>
> I wonder how MS WinNT4 will handle the daylight savings time change?
>
> Paul
>
>
>

--
http://www.freelists.org/webpage/oracle-l