ah i think i may know, your tnsnames.ora entry on the client does not know
that the first address descriptor is a cman box but thinks its a listener?
and cos there is no lsnr process on the port its failing with 12541, try
making sure that the client side tnsnames entry has the following;
(SOURCE_ROUTE = OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = cmanhost)(PORT = 1610))
(ADDRESS = (PROTOCOL = TCP)(HOST = lsnrhost)(PORT = 1521))
where the first param says we're using cman, and the first address
descriptor points us towards the cman process and the second points us
towards the lsnr process
--
Regards,
Daniel.
"Adam Gent" <adam_at_arcweb.org.uk> wrote in message
news:he9n8.6356$km3.1048880_at_news2-win.server.ntlworld.com...
> Hi,
>
> Yes I am getting a 12541 TNS:no listener error.
>
> I am connecting to a server, through the oracle connection manager, so
> connecting to one machine, then going on to the next from there.
>
> As far as I know that is all set-up correct, as it was set-up the the
> network admin\DBA.
>
> What I do not know, is how to set-up the listener.ora file.
>
> I will look at the log as soon as I can transfer it over, it is fairly
> large.
>
> Adam
>
>
>
> "daniel" <test_at_test.com> wrote in message
> news:a7j5p8$3ou$1_at_newsg3.svr.pol.co.uk...
> > are you getting a 12541 at the client end? if so whats the server end
> > getting? have a look in the listener.log file. although i bet its more
> > likely to be the way you are resolving the ip address of the lsnr or
some
> > wacky firewall/nat problem... bung me some more detail and i'll look at
it
> > further. or bung me the ip address of the server in question?
> >
> > --
> > Regards,
> >
> > Daniel.
> >
> >
> > "Adam Gent" <adam_at_arcweb.org.uk> wrote in message
> > news:xO8n8.6188$km3.1018858_at_news2-win.server.ntlworld.com...
> > > Hi,
> > >
> > > I am trying to get the oracle client utils to talk to a remote oracle
> > server
> > > (8i) over the internet.
> > >
> > > I have installed the client untilities and am trying to connect to the
> > > oracle server through SQL Plus.
> > >
> > > I have set-up the tnsnames.ora file, with the correct settings, but I
> get
> > an
> > > error with no listener found, and I do not know what I need to put in
to
> > > this file.
> > >
> > > Could you please tell me what needs to go into this file.
> > >
> > > Thanks,
> > >
> > > Adam Gent
> > >
> > >
> >
> >
>
>
Received on Sat Mar 23 2002 - 19:21:23 CST
