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  |
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 #299958 is a reply to message #299649] |
Wed, 13 February 2008 19:02  |
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>
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Feb 19 17:16:29 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
