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

TNS-12508: TNS:listener could not resolve the COMMAND given

LSNRCTL> set log_status off
TNS-12508: TNS:listener could not resolve the COMMAND given

Am I missing something here?

  • can you check the version of the listener by using the VERSION command? – miracle173 Nov 20 '18 at 7:11
  • check for parameter in listner.ora if ADMIN_RESTRICTIONS_LISTENER was set to ON? – Sam Nov 20 '18 at 7:31
  • Sam is correct here. This is caused by ADMIN_RESTRICTIONS_LISTENER_AAA set to on. – Balazs Papp Nov 20 '18 at 8:23
  • Thanks sam, i cross checked the listener file ADMIN_RESTRICTIONS_LISTENER was ON.Turning it off resolved the issue. – pradyu Nov 20 '18 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 aka hot2use Nov 27 '18 at 7:43

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.

  • 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 Nov 27 '18 at 13:58
  • Looks like RDFozz fixed the answer.Thanks RDFOzz – Sam Nov 28 '18 at 4:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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