Thursday 7 March 2013

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




Few days back some os level issue on oracle server machine when we try to restart the listener we get below error
TNS - 01190:the user is not authorized to execute the requested listener command
checked  the services status of service using command

ps -ef | grep -i listener
output
 1091  78960       1   0   nov 20      -  0:33 /home/oracle/db_1/bin/tnslsnr LISTENER -inherit

Find the owner of listener service are changed or null

Above TNS - 01190 comes when we try to restart the listener which is running from different owner

then  tried to kill the services using os kill command but
it shows insufficient privileges .
Then i told my system administrator to kill the services from root user using

kill -9 78960

Now i started the listener from oracle user and it stated successfully.

lsnrctl start

No comments: