cancel
Showing results for 
Search instead for 
Did you mean: 

Restrict Instance Registration DYNAMIC_REGISTRATION_Listener=OFF

former_member209962
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

JamesZ
Advisor
Advisor
0 Kudos

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

former_member209962
Participant
0 Kudos

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

JamesZ
Advisor
Advisor
0 Kudos

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.

former_member209962
Participant
0 Kudos

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

JamesZ
Advisor
Advisor
0 Kudos

hi Tabrayz,

Then I would say you turned of listener dynamic registry and the SAP is not getting affected.

Best regards,
James

former_member209962
Participant
0 Kudos

Dear James,

Thank you very much for your time and advice!!

Thanks

Tabrayz

Answers (0)