TNS-01190: user not authorized to execute the requested listener

Symptom

> lsnrctl

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-JUL-2013 01:44:11

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> stop
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
TNS-01190: The user is not authorized to execute the requested listener command
LSNRCTL>

Solution

1. Ensure the permission is correct on listener.ora
2. Check the process for the listener. Find the user that did the start for listener. Try to use the user below to stop/start the listener.

ps -ef | grep -i listener
SIDadm    2818   00:01:51 /oracle/SID/112_64/bin/tnslsnr LISTENER -inherit

You May Also Like

Leave a Reply?