Grid owner cannot start the database?
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-lReceived on Sat Sep 02 2017 - 20:38:38 CEST