I've hit strange issue on my Exadata X5 while creating new database (database were not able to register to listener).
After some investigation I've found out that listener process is owned by daemon user instead of grid somehow .
All Oracle 12.1.0.2 EE
ps -ef | grep LIST_1047
root 7200 39303 0 15:27 pts/0 00:00:00 grep LIST_1047
daemon 102666 1 0 14:40 ? 00:00:00 /u01/app/12.1.0.2/grid/bin/tnslsnr LIST_1047 -no_crs_notify -inherit
good one:
ps -ef | grep LIST_1057
root 7644 39303 0 15:28 pts/0 00:00:00 grep LIST_1057
grid 111588 1 0 May17 ? 00:08:54 /u01/app/12.1.0.2/grid/bin/tnslsnr LIST_1057 -no_crs_notify -inherit
$ORACLE_HOME/bin/crsctl stat resource ora.LIST_1047.lsnr -f | grep ACL
ACL=owner:root:rwx,pgrp:root:r-x,other::r--
ORACLE_HOME=%CRS_HOME%
good:
$ORACLE_HOME/bin/crsctl stat resource ora.LIST_1057.lsnr -f | grep ACL
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
ORACLE_HOME=%CRS_HOME%
Tried to fix this via:
$ORACLE_HOME/bin/crsctl setperm resource ora.LIST_1047.lsnr -o grid
CRS-4995: The command 'Setperm resource' is invalid in crsctl. Use srvctl for this command.
stoped here .
So I think that solution would be to have
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
for 1047 listener resource , right ?
Opened SR, still waiting .
Any ideas ?
Regards
G