Skip to Content

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Aug 17, 2016 at 01:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.