On Thu, 24 Jun 1999 23:03:15 +0800, Joe <joetin_at_netvigator.com> wrote:
The oracle 8 uses NET8 and the oracle 7 uses sqlnet as the connection
and transport protocol.
That means that there are two directory in the oracle home of the
client. network/admin and net8/admin.
In the network/admin there is a file called tnsnames.ora, where the
connect string is defined. Try to copy it to the network/admin
directory or change the sample tnsnames.ora with the setting in the
oracle8 tnsnames.ora
Paul
>Recently, I upgrade from Oracle 7.3.4 to Oracle 8i 8.1.5 on Solaris 2.6,
>both
>database and client. I can connect from local machine through SQL*Net to
>local
>database. However, I can't connect to remote Oracle7 DB (7.3.3 on HP-UX
>10.20),
>which I could connect before, through firewall.
>
>I can tnsping from 8i to the remote DB and I can use old sqlplus from
>Oracle7
>connect to the remote DB. But when I use 8i sqlplus and enter password,
>the sqlplus program hangs. I observe the listener.log in remote DB and
>the file indicates it accepts both tnsping and connect-request of 8i and
>7 sqlplus.
>But the 8i sqlplus hangs.
>
>Can someone help me?
>Thanks in advance.
>
>Joe
>joetin_at_netvigator.com
>
Received on Thu Jul 15 1999 - 14:47:02 CDT
