Re: Oracle Client and Listener

Got that, any other ideas?

Thanks,

Adam
"daniel" <test_at_test.com> wrote in message news:a7jcf0$bh8$1_at_newsg4.svr.pol.co.uk...
> sorry im tired should have read
>
> (SOURCE_ROUTE = ON)
>
> think you can use TRUE aswell
>
> --
> Regards,
>
> Daniel.
>
>
> "daniel" <test_at_test.com> wrote in message
> news:a7j9ip$rpb$1_at_newsg1.svr.pol.co.uk...
> > 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 - 20:46:26 CST