on 08-16-2016 1:18 PM
Hi Friends,
We want to restrict instance registration by setting DYNAMIC_REGISTRATION_Listener=OFF
I check note 1714255
As per Note 1714255 we have three options.
1.Setting a COST restriction using the TCP protocol
2.Setting a COST restriction using the IPC protocol
or
3.Alternate option without COST implementation (by adding DYNAMIC_REGISTRATION_<listener_name>=OFF in the listener.ora)
what if we go with 3 rd option by adding DYNAMIC_REGISTRATION_<listener_name>=OFF in the listener.ora is there any impact or any additional entries are require in listener.ora because note says ..then you must ensure that the static service registration (SID_LIST_<LISTENER_NAME>) is correctly configured in your listener.ora configuration file.
Please find below listener.ora content and advice accordingly.
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 6.10
# Name..........:
# Date..........:
# @(#) $Id: //inst/inst_scripts/lmts_007_REL/tpls/ora/LISTENER.ORA#1 $
################
ADMIN_RESTRICTIONS_LISTENER = on
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = SID.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = SID)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = PRDSID)
(PORT = 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = SID)
(ORACLE_HOME = :\oracle\SID\11204)
)
)
ADR_BASE_LISTENER = :\oracle\SID\saptrace
Thanks
Tabrayz
Hi Tabrayz,
DYNAMIC_REGISTRATION_<listener_name>=OFF
will disable dynamic listener register, so it will use static listening.
I saw you are already using statistics listening:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = SID)
(ORACLE_HOME = :\oracle\SID\11204)
)
)
To verify if the static is working, you can run "lsnrctl status", check if the service is "status UNKNOWN", "status UNKNOWN" means the service is static register.
To double confirm please test whether "R3trans -d" works for db connection. If it is fine as well,
then turning of dynamic register does not affect the system working.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear James,
Thanks for your reply please find below LSNRCTL status
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.4.0 - Produ
ction
Start Date 04-MAR-2016 09:17:45
Uptime 165 days 23 hr. 36 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\SID\11204\network\admin\listener.ora
Listener Log File C:\oracle\SID\11204\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SID.WORLDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\SIDipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.xx.xx)(PORT=1521)))
Services Summary...
Service "SID" has 2 instance(s).
Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
Instance "SID", status READY, has 1 handler(s) for this service...
The command completed successfully
and also r3trans -d
C:\Users\sidadm>r3trans -d
This is r3trans version 6.25 (release 742 - 09.07.15 - 20:15:07).
unicode enabled version
r3trans finished (0000).
Thanks
Tabrayz
Hi Tabrayz,
lsnrctl status shows both dynamic and static are used:
Service "SID" has 2 instance(s).
Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
Instance "SID", status READY, has 1 handler(s) for this service...
Please set DYNAMIC_REGISTRATION_<listener_name>=OFF, restart listener.
See if "Instance "SID", status READY, has 1 handler(s) for this service..." disappear and R3trans -d still works.
Dear James,
Yes after adding DYNAMIC_REGISTRATION_<listener_name>=OFF, and restart listener.Instance "SID", status READY, has 1 handler(s) for this service..." has disappeared and r3trans -d is working fine
This is r3trans version
unicode enabled version
r3trans finished (0000).
now i can see only one entry as below
Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
thanks
Tabrayz
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.