Re: listener proces owner by deamon user instead of grid

Have you checkt the logfiles how this LIST_1047 was started? From my understanding the ACLs are more about manipulating the resources in CRS-stack (who is allowed to start/stop/edit/... them) - but of course I can be totally wrong.

Can you please check the oraagent processes - which user-IDs do they have? when were they started?

I can imagine dozens of reasons how to create such an observation, but guessing is not useful here.

Martin

2016-09-16 15:30 GMT+02:00 <grzegorzof_at_interia.pl>:

> Hi,
>
> 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
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l