Re: Problem: Oracle 8.1 on NT no listener

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/04/04
Message-ID: <8cbc5l$4m4$1@perki.connect.com.au>#1/1

Rich,
let me see if I have undertood you.
You have configured the SQL/NET on the server and it works just fine. from client side you want to get connected to the database eg using sqlplus.
now if this is the case you have to configuer the sqlnet on the clinet side as well.
to do this use oracle net8 easy config.
Tom

<rarardin_at_my-deja.com> wrote in message news:8cb4l0$13l$1_at_nnrp1.deja.com...
> I am running Oracle 8.1 on NT 4 sp 5.
>
> I have setup one database.
>
> On the server I have set up a tnsnames entry
> using TCP/IP, host name = machine_name, port =
> 1521, sid = ORA8. I can test the connection just
> fine on the server.
>
> From any other machine when I use the same tns
> information I get a 12224 no listener error
> message.
>
> Both the OracleOraHome81TNSListener and
> OracleServiceORA8 services are started at startup
> and are currently running.
>
> Anyone ever see this before?
>
> Thanks,
> Rich
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 04 2000 - 00:00:00 CDT