User “oracle” unable to start or stop listeners in RAC


Getting the error while try to stop the listener.
oracle$ srvctl stop listener
PRCR-1065 : Failed to stop resource ora.LISTENER.lsnr
CRS-0245:  User doesn’t have enough privilege to perform the operation
CRS-0245:  User doesn’t have enough privilege to perform the operation
PRCR-1065 : Failed to stop resource ora.LISTENER_IB.lsnr
CRS-0245:  User doesn’t have enough privilege to perform the operation
CRS-0245:  User doesn’t have enough privilege to perform the operation

Solution:

Before:

# crsctl status resource ora.LISTENER.lsnr -p | grep ACL=
ACL=owner:root:rwx,pgrp:root:r-x,other::r–

# crsctl status resource ora.LISTENER_IB.lsnr -p | grep ACL=
ACL=owner:root:rwx,pgrp:root:r-x,other::r–

“Fix”:

# crsctl setperm resource ora.LISTENER.lsnr -o oracle
# crsctl setperm resource ora.LISTENER.lsnr -g oinstall
# crsctl setperm resource ora.LISTENER_IB.lsnr -g oinstall
# crsctl setperm resource ora.LISTENER_IB.lsnr -o oracle

After:

# crsctl status resource ora.LISTENER.lsnr -p | grep ACL=
ACL=owner:oracle:rwx,pgrp:oinstall:r-x,other::r–

# crsctl status resource ora.LISTENER_IB.lsnr -p | grep ACL=
ACL=owner:oracle:rwx,pgrp:oinstall:r-x,other::r–


Start the listener now,

oracle$ srvctl start listener
oracle$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): etc9cn02,etc9cn01
Listener LISTENER_IB is enabled
Listener LISTENER_IB is running on node(s): etc9cn02,etc9cn01

oracle$ srvctl stop listener

oracle$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is not running
Listener LISTENER_IB is enabled
Listener LISTENER_IB is not running

oracle$ srvctl start listener

  • January 10, 2017 | 21 views
  • Comments