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

V$BACKUP_DATAFILE: Data File Backup Information
Oracle init.ora File
ORA-27101: shared memory realm does not exist
Find Oracle Control File Location
© 2018 ITsiti. All Rights Reserved
Powered by KEEM