Re: why listener listen on port 9090?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 5 Jan 2004 22:53:14 -0800
Message-ID: <1a75df45.0401052253.40512459@posting.google.com>

"lc" <liucheng_ok_at_etang.com> wrote i

> > so, the dispatcher(s) will be using different ports, e.g.
> > (ADDRESS=(PROTOCOL=tcp)(HOST=foo)(PORT=61686))
>
> I am not sure.IF so, how can i prevent it.

By explicitly configuring the port(s) for the dispatcher(s) in the SPFILE or PFILE for that instance.

> > Finally, how do you know that the Oracle listener is indeed using TCP
> > port 9090. How do you determine that? What proof do you have?
>
> #lsof -P -n -i tcp:9090

Are you interpreting the results correctly? Can you please post the stdout of your listener's startup and the lsof command. E.g.

oracle:~> lsnrctl start

LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 06-JAN-2004 08:38:29

Starting /app/oracle/products/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.1.0 - Production System parameter file is
/app/oracle/products/9.2.0/network/admin/listener.ora Log messages written to
/app/oracle/products/9.2.0/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.1.0 -
Production
Start Date                06-JAN-2004 08:38:30
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/app/oracle/products/9.2.0/network/admin/listener.ora Listener Log File
/app/oracle/products/9.2.0/network/log/listener.log Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521))) Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "xxx" has 1 instance(s).
  Instance "xxx", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
oracle:~>
oracle:~> lsof -P -n -i
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME tnslsnr 30170 oracle 10u IPv4 68412 TCP *:1521 (LISTEN) oracle:~>

> I find the TNSLSNR( the name i am not sure) listening on port 9090, which
> also listen on port 8080,1521,2481,2482

What database services are you running? Are you use XMLDB? Do you have 9iAS installed too? Are you using Oracle's Apache httpd? Are you using Oracle Intelligent Agent? Are you running an OEM server? Are you running MTS dispatchers?

Are you also maybe confusing socket numbers as port numbers?

COMMAND     PID   USER   FD   TYPE DEVICE SIZE NODE NAME
telnet     2150 billyv    3u  IPv4   3287       TCP

165.148.52.160:32816->155.239.47.17:23

32816 in the above output is the socket handle on my machine that was connected to port 23 on another machine.

I stand by what I said - the listener will *NOT* use a port that *you* (or an Oracle default) did not configure.

Somewhere there is a config saying that port 9090 must be used. Period.

Either that or you are mistaken about the port number.

--
Billy

Received on Tue Jan 06 2004 - 00:53:14 CST