Grid owner cannot start the database?

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 2 Sep 2017 14:38:38 -0400
Message-ID: <ca8c20a9-a6ed-386c-19e5-7035117df0ff_at_gmail.com>



Hi!

I was playing with my brand new 12.2 RAC and I tried starting it from the user "grid":

[grid_at_rac2 ~]$ srvctl start db -d rac12
PRCR-1079 : Failed to start resource ora.rac12.db CRS-2527: Unable to start 'ora.rac12.db' because it has a 'hard' dependency on 'ora.acfs.acfs.acfs'CRS-0245: User doesn't have enough privilege to perform the operation

Apparently, the GI owner doesn't have enough privileges for this operation. When I log in as "oracle", I have no problems whatsoever:

mgogala_at_umajor:~/mp3$ ssh oracle_at_rac1 Last login: Thu Aug 31 21:15:06 2017
[oracle_at_rac1 ~]$ srvctl start db -d rac12
[oracle_at_rac1 ~]$ srvctl status db -d rac12
Instance rac121 is running on node rac1
Instance rac122 is running on node rac2
[oracle_at_rac1 ~]$ [oracle_at_rac1 ~]$ sqlplus
scott/tiger_at_scan12/orclpdb.home.com

SQL*Plus: Release 12.2.0.1.0 Production on Sat Sep 2 14:33:51 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Last Successful login time: Sat Sep 02 2017 14:33:30 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> This looks a bit counter-intuitive. Why would the user grid not be allowed to start the databases? This is the only RAC configuration I have, so I can't check releases 11G and 12cR1. Does the same thing happen there or is it specific to the new release?

Regards

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 02 2017 - 20:38:38 CEST

Original text of this message