Restrict Instance Registration DYNAMIC_REGISTRATION_Listener=OFF

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