Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: About SQL*Net

Re: About SQL*Net

From: Vincent Ventrone <vav_at_mitre.org>
Date: Mon, 27 Dec 1999 13:27:44 -0500
Message-ID: <3867AFA0.FC9C5EBA@mitre.org>

half-wit wrote:
>
> Hello, merry christmas.
> Can you help me?
>
> I want connect Oracle server A (version 7.2.3 on HP 10.20 ) from Oracle
> server B ( version 8.0.3 on Solaris 5.6)
> use SQL*Net,
> but when I type sqlplus scott/tiger_at_serb from Solaris, it display the
> fellow line and no respones no longer.

I assume both databases are on the same machine? If so you need to make sure you have a SQLNet ver. 2.x listener listening for the Oracle7 databases & a Net8 listener listening for the Oracle8 databases & the two listeners must have different names (can't both be using the default name of "LISTENER") & must be listening on two *different* ports -- once you have that working correctly make sure all TNSNAMES.ORA entries point to the correct port for the right listener for the target database.

good luck

--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730
Received on Mon Dec 27 1999 - 12:27:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US