Home » RDBMS Server » Networking and Gateways » listener listening on 2 different ports (ORACLE 10.2; Solaris;)
listener listening on 2 different ports [message #299649] Tue, 12 February 2008 18:33 Go to next message
geeklol
Messages: 59
Registered: March 2005
Member
i created by database instance using dbca.
I want to change run a few instances on this server on the default port 1521 and that works fine. But i want to run 1 instance on this server on a different port 2598.
network wise i know this port is open and is available to accept connections.
How do i do that? i changed the tnsnames entry from 1521 to 2598 but when i do the status for the listener, it only shows the port 1521.

what all and where all do i need to change the port number to make this happen? also, do i need to do anything with the local_listener init parameter to?

it created an automatic entry for the listener and it looks like,
LISTENER.ORA FILE
SID_LIST_LISTENER_STGAS4ODB01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/local/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dashgp)
(ORACLE_HOME = /usr/local/oracle/product/10.2.0)
(SID_NAME = dashgp1)
)
)

LISTENER_STGAS4ODB01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 1521)(IP = FIRST))
)

my tnsnames.ORA files on the server looks like,
LISTENERS_DASHGP =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb02-vip)(PORT = 2598))
)

DASHGP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb02-vip)(PORT = 2598))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)

DASHGP2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb02-vip)(PORT = 2598))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)
(INSTANCE_NAME = dashgp2)
)
)

DASHGP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)
(INSTANCE_NAME = dashgp1)
)
)


LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_STGAS4ODB01
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 12-FEB-2008 16:04:15
Uptime 0 days 0 hr. 26 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /usr/local/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/10.2.0/network/log/listener_stgas4odb01.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.55)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.56)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "LCECGS4" has 2 instance(s).
Instance "LCECGS41", status READY, has 2 handler(s) for this service...
Instance "LCECGS42", status READY, has 1 handler(s) for this service...
Service "LCECGS4XDB" has 2 instance(s).
Instance "LCECGS41", status READY, has 1 handler(s) for this service...
Instance "LCECGS42", status READY, has 1 handler(s) for this service...
Service "LCECGS4_XPT" has 2 instance(s).
Instance "LCECGS41", status READY, has 2 handler(s) for this service...
Instance "LCECGS42", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dashgp" has 2 instance(s).
Instance "dashgp1", status UNKNOWN, has 1 handler(s) for this service...
Instance "dashgp1", status READY, has 2 handler(s) for this service...
Service "dashgpXDB" has 1 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Service "dashgp_XPT" has 1 instance(s).
Instance "dashgp1", status READY, has 2 handler(s) for this service...
Service "rcat" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
Service "rcatXDB" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
Service "rcat_XPT" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
The command completed successfully



Re: listener listening on 2 different ports [message #299684 is a reply to message #299649] Tue, 12 February 2008 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In your listener.ora the listener is listening in 1521.
tnsnames.ora is used by the client not by the listener.

Regards
Michel
Re: listener listening on 2 different ports [message #299741 is a reply to message #299649] Wed, 13 February 2008 01:22 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
and don't forget to restart the listener when changing the port - otherwise the 1521 stays forever.

regards
Uwe
Re: listener listening on 2 different ports [message #299743 is a reply to message #299649] Wed, 13 February 2008 01:39 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
WHy start listener
just reload
lsnrctl reload
Re: listener listening on 2 different ports [message #299749 is a reply to message #299743] Wed, 13 February 2008 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not sure port is not a static parameter.
Did you try reload?

Regards
Michel
Re: listener listening on 2 different ports [message #299753 is a reply to message #299649] Wed, 13 February 2008 02:16 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
yes i unsuccessfully tried.
sorry for wrong posting.
Re: listener listening on 2 different ports [message #299958 is a reply to message #299649] Wed, 13 February 2008 19:02 Go to previous messageGo to next message
geeklol
Messages: 59
Registered: March 2005
Member
Hi all,

Thank you for your reply.
Issue now is, THE INSTANCE THAT I WANT TO LISTEN ON PORT 2598 IS NOW LISTENING ON PORT 2598 BUT IT IS ALSO LISTENING ON THE DEFAULT PORT 1521. I want it to listen on ONLY 2598 and NOT on 1521. What am i doing wrong or missing? BUT HOW DO I UNREGISTER THE INSTANCE dashgp1 FROM THE DEFAULT LISTENER? If you look STATUS of both the listeners towards the end of this message, you will see that dashgp1 is listening on BOTH THE LISTENERS.


I did stop and start the listener a few times.

i added a new listener (LISTENER_PROD) in my listener.ora,
LISTENER_STGAS4ODB01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 1521)(IP = FIRST))
)
)

SID_LIST_LISTENER_STGAS4ODB01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/local/oracle/product/10.2.0)
(PROGRAM = extproc)
)
)
LISTENER_PROD =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01)(PORT = 2598)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598)(IP = FIRST))
)
)

SID_LIST_LISTENER_PROD =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/local/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dashgp)
(ORACLE_HOME = /usr/local/oracle/product/10.2.0)
(SID_NAME = dashgp1)
)
)

I ADDED THE ENTRIES IN MY TNSNAMES.ORA FILE.
LISTENER_PROD =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb02-vip)(PORT = 2598))
)

DASHGP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598))
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb02-vip)(PORT = 2598))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)

DASHGP2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb02-vip)(PORT = 2598))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)
(INSTANCE_NAME = dashgp2)
)
)

DASHGP1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stgas4odb01-vip)(PORT = 2598))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dashgp)
(INSTANCE_NAME = dashgp1)
)
)



LSNRCTL STATUS: If you look at both the status, you will see that dashgp1 is listening on BOTH THE LISTENERS.

LSNRCTL> set current LISTENER_STGAS4ODB01
Current Listener is LISTENER_STGAS4ODB01
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stgas4odb01)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias LISTENER_STGAS4ODB01
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 13-FEB-2008 15:54:34
Uptime 0 days 1 hr. 6 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /usr/local/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/10.2.0/network/log/listener_stgas4odb01.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.55)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.56)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "LCECGS4" has 2 instance(s).
Instance "LCECGS41", status READY, has 2 handler(s) for this service...
Instance "LCECGS42", status READY, has 1 handler(s) for this service...
Service "LCECGS4XDB" has 2 instance(s).
Instance "LCECGS41", status READY, has 1 handler(s) for this service...
Instance "LCECGS42", status READY, has 1 handler(s) for this service...
Service "LCECGS4_XPT" has 2 instance(s).
Instance "LCECGS41", status READY, has 2 handler(s) for this service...
Instance "LCECGS42", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dashgp" has 1 instance(s).
Instance "dashgp1", status READY, has 2 handler(s) for this service...
Service "dashgpXDB" has 1 instance(s).
Instance "dashgp1", status READY, has 1 handler(s) for this service...
Service "dashgp_XPT" has 1 instance(s).
Instance "dashgp1", status READY, has 2 handler(s) for this service...
Service "rcat" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
Service "rcatXDB" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
Service "rcat_XPT" has 1 instance(s).
Instance "rcat", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> set current LISTENER_PROD
Current Listener is LISTENER_PROD
LSNRCTL> STATUS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=stgas4odb01)(PORT=2598)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias LISTENER_PROD
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 13-FEB-2008 15:38:23
Uptime 0 days 1 hr. 22 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /usr/local/oracle/product/10.2.0/network/admin/listener.ora
Listener Log File /usr/local/oracle/product/10.2.0/network/log/listener_prod.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.55)(PORT=2598)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.101.2.56)(PORT=2598)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dashgp" has 2 instance(s).
Instance "dashgp1", status UNKNOWN, has 1 handler(s) for this service...
Instance "dashgp2", status READY, has 1 handler(s) for this service...
Service "dashgpXDB" has 1 instance(s).
Instance "dashgp2", status READY, has 1 handler(s) for this service...
Service "dashgp_XPT" has 1 instance(s).
Instance "dashgp2", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
Re: listener listening on 2 different ports [message #299991 is a reply to message #299958] Wed, 13 February 2008 23:30 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The dashgp1 instance is being listened for by both of the listeners because you have configured it explicitly in the one listener (2598) and it is auto-registering with the other listener (1521).

You may want to review Configuring Service Registration-Related Parameters in RAC.
Previous Topic: i cant connect my oracle server. there are host problems.
Next Topic: Oracle - MS SQL-Server Transparent Gateway not working
Goto Forum:
  


Current Time: Wed Jul 30 23:11:45 CDT 2014

Total time taken to generate the page: 0.05775 seconds