Re: Client side upgrade

> So, as part of my upgrade I must move all my client machines (approx
> 400) from a mixture of 9i and 10i to all of them being on 11g.
Do you have any of your clients still using Windows 2000? If so, 11.1.0.6 is the absolute latest release of 11g client that will install on 2000. Ask me how I know! :-(

> Anyone have a best practice or best method of doing a mass upgrade?
Not with the numbers you are looking at - sorry.

> Can you even upgrade a client? Or do you have to uninstall and
> reinstall?

You need to install. There's no need to uninstall but you will end up with both clients on PATH at the same time which *can* lead to problems.

Also, if you use Microsoft MDAC components in your applications' 'talking to Oracle' interface (ADO, ODBC using Microsoft drivers etc) then the registry settings at HKLM/software/microsoft/msdtc/MTxOCI will need changing to make sure that they pick up the latest client. There are three:

OracleOciLib = oci.dll
OracleSqlLib = orasql11.dll
OracleXaLib = oraclient11.dll

(The latter two have the digits one one before the dot!)

If you miss this and have multiple versions of client on PATH then you can end up with some dlls loaded from one version and others from another. Again, ask me how I know!

Good luck.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l