Re: Oracle 8 connectivity problems with Oracle 7 clients

Manuel Mall wrote:

> We have a small network with 3 Windows NT machines. One machine runs Oracle
> 7.1 and all machines have the Oracle clients (16 bit), eg. SQL*Plus and
> ODBC, installed. We also have a 16-bit VB application which connects to
> Oracle.
> On a second machine we have just installed Oracle 8i but we cannot "talk" to
> it using the 16 bit clients from any of the workstations even its own. I am
> sure it must be a networking installation / configuration problem. One
> question is: What is the correct CONNECT string for Oracle 8i. For our
> Oracle 7 server in our environment it is something like:
> t:<hostname>:<sid>. But this doesn't appear to work for Oracle 8.

The t:<hostname>:<sid> is a SQL*Net v1 alias syntax. SQL*Net v1 was desupported with the introduction of Oracle7, v7.3.

You need to setup SQL*Net v2 and the Oracle TCP/IP (wild guess) adapter on your NT machine in order to be able to connect to a v7.3+ database.

>
> The basic things like Oracle 8 itself and the listener appear to work, ie.
> on the workstation with Oracle 8 installed, we can use the Oracle 8 version
> of SQL*Plus to connect to the Oracle 8 database by leaving the Host String
> empty. But we are not able to use Oracle 8 SQL*Plus to connect to Oracle 7
> using the t:<hostname>:<sid> string.
> Any suggestions on what we might be doing wrong.
>
> Thanks
>
> Manuel

--

+-------------------------------------+----------------------------+
| Fred Petillot                       |     fpetillo_at_fr.oracle.com |
| Oracle France - Support Technique   |            +33 1 4762 8201 |
| 65, rue des Trois Fontanot          |            +33 6 8089 5135 |
| 92732 Nanterre Cedex                |                            |
+-------------------------------------+----------------------------+