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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Client and Listener

Re: Oracle Client and Listener

From: daniel <test_at_test.com>
Date: Sun, 24 Mar 2002 02:10:35 -0000
Message-ID: <a7jcf0$bh8$1@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:10:35 CST

Original text of this message

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