1

I am trying to turn off listener logging in oracle 12c R2 (SAP on oracle), but I am getting a TNS-12508 error. I have verified that the listener.ora is owned by the oracle user and I am performing the task as same oracle user, but I am still getting an error.

File Permissions

-rw-r--r--    1 oracle   oinstall       1151 Oct 23 13:48 listener.ora

Listener Error

LSNRCTL> set current_listener LISTENER_AAA.
Current Listener is LISTENER_AAA

LSNRCTL> set LOG_STATUS OFF
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=AAA.WORLD))
TNS-12508: TNS:listener could not resolve the COMMAND given

LSNRCTL> set log_status off
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=AAA.WORLD))
TNS-12508: TNS:listener could not resolve the COMMAND given

Am I missing something here?

Improve this question
5
  • can you check the version of the listener by using the VERSION command?
    – miracle173
    Commented Nov 20, 2018 at 7:11
  • check for parameter in listner.ora if ADMIN_RESTRICTIONS_LISTENER was set to ON?
    – user153556
    Commented Nov 20, 2018 at 7:31
  • Sam is correct here. This is caused by ADMIN_RESTRICTIONS_LISTENER_AAA set to on.
    – Balazs Papp
    Commented Nov 20, 2018 at 8:23
  • Thanks sam, i cross checked the listener file ADMIN_RESTRICTIONS_LISTENER was ON.Turning it off resolved the issue.
    – pradyu
    Commented Nov 20, 2018 at 10:55
  • @Sam Could you pop your solution into an answer? It provides an answer to the question and we could clean up things here in the comments. Thanks.
    – John K. N.
    Commented Nov 27, 2018 at 7:43

1 Answer 1

Reset to default
-1

This can happen if you've got ADMIN_RESTRICTIONS_LISTENER set to ON in your listener.ora file.

Turning it off should resolve the problem.

Improve this answer
2
  • This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review
    – mustaccio
    Commented Nov 27, 2018 at 13:58
  • Looks like RDFozz fixed the answer.Thanks RDFOzz
    – user153556
    Commented Nov 28, 2018 at 4:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.