Re: Oracle Client and Listener

in that case it may be in the way that you are trying to resolve the ipaddress
or indeed cman is trying to resolve it... (is cman and the lsnr on the same box?)
(do you use hostnames or ipaddr in the listener.ora, cman.ora and tnsnames.ora?)

look at the ipaddr the lsnr is using
then check if cman and you client pc are getting to it correctly

try a trace level 16 on the client and post the errors

--
Regards,

Daniel.


"Adam Gent" <adam_at_arcweb.org.uk> wrote in message
news:56bn8.6893$km3.1153964_at_news2-win.server.ntlworld.com...


> 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

> > > > > >

> > > > > >

> > > > >

> > > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>