Re: Listener on different host than database server

From: Lars Bo Vanting <lars.vanting_at_ex.sni.ch>
Date: Thu, 14 Jan 1999 14:15:01 +0100
Message-ID: <77kqj8$juv$1@news.mch.sbs.de>

It is not possible to configure a listener an a different host than the one where the database/SID resides.
As far as I remember you must define your INTERCHANGE as a server with both NIC's in order to go across networks with SQL*Net, at least in Oracle 7.3. Please see the SQL*Net doc, in 7.3 it was under "Multi-Protocol Interchange" (possible using the, BTW great, tool NETMAN) and in Oracle8 it is "Multi-Protocol Support" / Connection Manager.

Regards

Lars Bo Vanting
COREBIIT TPI AG Micanet wrote in message <369DADC6.C7AC46E5_at_hotmail.com>...
>Hello all,
>
>I have a little problem with sqlnet. How can I to configure Listener on
>a different host than Database Server so that I can make a Gateway to
>another network ?
>I have configured the Listener on second host ( with HOST=<database
>server>
> and PORT=<tcp/ip port of database server listener>). This listener
>startup but I receive some
>errors when I try to use a service (TNSNAMES.ORA).
>This errors are:
>TNS-12541: TNS:no listener
>
>Can You help me ?
>Thanks.
>
>
>
>
Received on Thu Jan 14 1999 - 07:15:01 CST