Patching databases - time estimates

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:
2. 9i patch to 9.2.0.8?
3. 8i patch to 10.2. Would it be better to export/import?

2)

1. Will 10g be OK on NT4?
2. If so, will Oracle support it?
3. 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 31 2007 - 08:43:04 CST