Grid owner cannot start the database?

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 2 Sep 2017 14:38:38 -0400

Hi!

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

[grid@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@umajor:~/mp3$ ssh oracle@rac1
Last login: Thu Aug 31 21:15:06 2017
[oracle@rac1 ~]$ srvctl start db -d rac12
[oracle@rac1 ~]$ srvctl status db -d rac12
Instance rac121 is running on node rac1
Instance rac122 is running on node rac2
[oracle@rac1 ~]$ [oracle@rac1 ~]$ sqlplus scott/tiger@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

Other related posts: