The reason why he probably was unable to get it to work is that if you
listen out for TCP/IP connections on anything other than the default port of
1521, you must specify the LOCAL_LISTENER init.ora parameter. That needs to
be set to the tnsnames alias of the Instance to which you wish to connect
via the non-default port.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Murali" <oraclems_at_hotmail.com> wrote in message
news:22e6597b.0203010838.4cd4cce_at_posting.google.com...
> >> In the listener.ora, tell the listener to listen on two ports for
> TCP
> >> connections.
> >>
> >> LISTENER =
> >> (DESCRIPTION =
> >> (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1521))
> >> (ADDRESS = (PROTOCOL = TCP)(HOST = test_server)(PORT = 1526))
> >> )
> >> .
> >> .
> >> .
> >> .
> >>
> > Have you EVER tried this?
>
> I may not know everything, but I try not to post false information. I
> tried this on my 9.0.1 database and just copied/pasted to the news
> group from my files after confirming that this works. I tried it again
> on an 8.1.7 database after reading your post (not that I doubted
> myself, just to see if it was a 9i only thing), and guess what ? It
> worked again.
>
> > I did. Guess what? It doesn't work.
>
> You mean you cant GET it to work.
>
> > Please don't try to make a fool out of me when you don't know what you
> > are talking about.
> >
> I am not getting paid to put you down or anything. Please dont take it
> personally. I just tried what you said doesnt work, and it worked. But
> just to show that I do know what I'm talking about, here's my listener
> status:
>
> LSNRCTL> start
> Starting /u01/app/oracle/product/8.1.7/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 8.1.7.0.0 - Production
> System parameter file is
> /u01/app/oracle/product/8.1.7/network/admin/listener.ora
> Log messages written to
> /u01/app/oracle/product/8.1.7/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1526)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
> Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=2481))(PROTOCOL_STACK=(
PRESENTATION=GIOP)(SESSION=RAW)))
>
> I did not make this up... You can see the listener listening on both
> 1521 and 1526 for TCP connections. Here's my netstat output:
>
> tcp 0 0 *:2481 *:*
> LISTEN
> tcp 0 0 *:1526 *:*
> LISTEN
> tcp 0 0 *:1521 *:*
> LISTEN
>
> Again both ports show up. Hey, I dont know what you tried, and unless
> you give me the OS and version information, or prove it doesnt work, I
> will just take it that the listener can listen on more than 1 port for
> TCP connections at the same time.
>
> Murali
> http://www.dbaquest.com/
Received on Fri Mar 01 2002 - 13:49:31 CST
