Re: SQL*NET V1 V2 Migration

Ah, why not just convert them all, regardless, we only had about 1,000 or so machines, but we just went WHUMP and migrated everyone to SQL*NET V2, Oracle Names, and MTS. Just upgrade regardless! If they are at the current release, bueno. The script idea is fine, except for the case where you have people running both (ecch).

Is this a standard, TNSNAMES and SQLNET.ORA type deal on each desktop, and two $ORACLE_HOMEs, one for 16 bit and one for 32 bit? Have the users been allowed to edit TNSNAMES and hosts etc to create their own pointers to databases? And build ODBC data sources upon that? Are you using DNS to resolve hostnames?

The more they've been doing on their own, the less clean this will be.

Well a key is have they only one $ORACLE_HOME? Or one for each wordsize?

What sort of user community are you serving? The ah less tricky and astute they are, chances are the easier all this will be.

RSH. "Scott Mills" <scott.mills_at_uk2.net> wrote in message news:eaai8.8013$nt.1221522_at_news11-gui.server.ntli.net...
> Hi
>
> For some time we have been running SQL*NET V1 & V2 on our servers and
we're
> planning on turning off the V1 listener pretty soon. We have around 8000
NT
> client machines on site and they are running either SQL*NET V1, V2 or
both.
> We need to know what machine is doing what so we can upgrade where
> necessary.
>
> I intend to write a small DOS script that writes out the machine name, IP
> Address, username and what version of sqlnet that the NT box is running.
I
> will then place this script into the NT logon scripts, hence I shall be
able
> to get all the data I need to grab very quickly so we can upgrade the V1
> clients.
>
> However, I am having some problems grabbing what SQL*NET versions are
> running on the client.
>
> Can I assume that if the client has a ORAWIN/BIN/PRO16 directory it is
> running SQL*NET V1 and if a ORANT/BIN/PRO18 directory structure exists
then
> it's running SLQ*NET V2???
>
> If not, can anyone tell me of any files, default locations of files or
> registry entries to distinguish which version of sqlnet is running?
>
> Thanks
>
> Scott
>
>
>
>
>
Received on Fri Mar 08 2002 - 16:24:56 CST