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



Share this article :

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

Related posts

Difference: PFILE and SPFILE
Difference: JRE & JDK
sqlplus: Command not found
Relink Oracle Binaries
© 2017 ITsiti. All Rights Reserved
Powered by KEEM