Re: 8.0 to 8.1 Connection

Did you notice the differences between SID (e.g. DB1), Net8 Service Name (used in SQL*PLUS connect, e.g. DB1Host1), and Service Name (=global DB-Name 8.1.5, e.g. DB1.Host1 [with '.'])?
Did you install the Oracle ODBC Driver with 8.1.5 and thus replace the old one from 8.0.5 on your server?

When testing 8.1.5 we had problems concerning "Oracle ODBC Driver 8.01.05.00 SQORA32.DLL". As a workaround we deinstalled the 8.1.5 ODBC driver and reinstalled the 8.0.5 ODBC driver (using the Oracle installers). To overcome the connection problems we doubly defined the net. Our 8.0.5 Installation on that test server contains nothing more than the net definition and the required support files (e.g.):
1. -- D:\orant80\net80\admin\tnsnames.ora DB1Host1.world =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (PORT = 1521) (HOST = Host1) ) )

    (CONNECT_DATA = (SID = DB1) )
  )
2. -- D:\orant81\network\admin\tnsnames.ora (notice the '.' in service_name): DB1Host1 =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = Host1) ) )     (CONNECT_DATA = (SERVICE_NAME = DB1.Host1) )   )
The 8.0 clients know about D1Host only. Check your tnsnames.ora first and try doubly defining, not just copying. As a 2nd step try the old ODBC driver.
We don't know whether it's really needed, but it works. And please do not cross-post too much newsgroups.
Karl H. Maas

Arthur Levin schrieb:

> try to copy SQLNET.ora and tnsnames.ora from server to client account.
> and check in linstener if you have correct SID_NAME
> Have fun,
> Arthur
> JACK LUNDIN <jack_lundin_at_swipnet.se> wrote in message
> news:bGNG4.322$uJ1.1620_at_nntpserver.swip.net...
> > Hello.
> > I have a problem in Win NT to connect between a oracle 8.1.5 database from
> a
> > developer 8.0.5 version (fetched from technet)
> > I have installed all the software (in different oraclehomes) without
> > problems, I've created a database in oracle 8.1 and it works with all
> > clienttools eg sqlplus, svrmgrl etc. from oraclehome 8.1, but, it doesn't
> > work at all when I use 8.0.5 tolls like plus80 etc.
> > I have copied tnsnames.ora from 8.1/network to 8.0/net80 admin directory.
> > tnsping work for 8.1 but not for 8.0.
> > Is there some restrictions in connecting on WinNT between two versions of
> > oracle?
> > I don't know what to do in this situation, please help.... anyone...
> > thanks in advance
> > Jack
Received on Thu Apr 06 2000 - 05:10:53 CDT