ORA - Listener question!!

[martn_sello]

Hi Friends,

In the listener.ora parameter is set to ADMIN_RESTRICTIONS_LISTENER = ON

To rotate the log without having to download the listener, we need these restrictions are in 'OFF'.

Is it imperative for the proper functioning of SAP on Oracle ADMIN_RESTRICTIONS_LISTENER is in 'ON'?

Thanks in advance.

Martin Sello

[Former Member · Accepted solution]

Refer to the link below for an explanation about that parameter

http://arup.blogspot.com/2008/08/why-should-you-set-adminrestrictionslis.html

This is not a SAP requirement. Some Oracle audit tools check this for whether it is off or on and will recommend that it should be set to on for security purpose.

This does not cause rotation of the listener log or any other log. There is a log rotation from Oracle11g onward and in some cases, these logs can reach up to 5GB because by default it retains 100 copies of the log that is in XML format

[martn_sello · Accepted solution]

Thanks for Help.

cheers..

[lbreddemann]

> In the listener.ora parameter is set to ADMIN_RESTRICTIONS_LISTENER = ON

Ok....

> To rotate the log without having to download the listener, we need these restrictions are in 'OFF'.

What? "Download" the listener?

Why would you need to have the ADMIN_RESTRICTIONS off in order to get a new listener log file?

How about just restarting the listener?

(I mean you are the DBA of this machine and you know the password, don't you ? )

> Is it imperative for the proper functioning of SAP on Oracle ADMIN_RESTRICTIONS_LISTENER is in 'ON'?

Nope, SAP does not know about this setting.

In fact no Oracle client would ever know about it.

It's a server side setting.

It's just about the listener.

cheers,

Lars