listener admin_restrictions violations

Posted on 2011-05-03
Last Modified: 2012-06-22
I have a server with admin_restrictions violations informed by my team lead. How do we check the violations and resolve it. I really appreciate your help. Thanks in advance
Question by:hussainkhan22
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    I believe these should be logged in the listener.log.  Check that for messages about the violations.
    LVL 73

    Expert Comment

    if you have admin_restrictions turned on then nobody can modify the listener directly,  there is nothing to resolve unless you've found a bug where somebody could alter the listener even with restrictions turned on.  If that's the case then contact oracle support immediately.

    if the problem is you have admin_restrictions on and you need to change something, then edit the listener.ora file and restart the listener

    if securing your listener isn't important then edit the listener.ora to turn admin_restrictions off and restart

    LVL 23

    Expert Comment

    - i believe the listener have been set with ADMIN_RESTRICTIONS_LISTENER=ON. therefore the violation is related to attempted changes to parameters in the listener.ora through set commands.
    LVL 73

    Accepted Solution

    note a full listener restart (stop/start) isn't really needed.  
    you can simply reload too to do it on the fly
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)

    Can I ask why you selected the answer you did on this question?
    The question asked was:  How do we check the violations and resolve it.

    The selected answer was a link to the docs on how to set the listener.ora parameter to turn restrictions on and off.

    If turning it on and off was what you were after then the post above should be selected and at best an 'assist' for the actual doc link.

    Please clarify.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now