RE: Grid owner cannot start the database?
Date: Sat, 2 Sep 2017 12:11:12 -0700
Message-ID: <036401d3241f$3e4a7710$badf6530$_at_comcast.net>
Standard separation of duties, which was the purpose of having a grid and an oracle user.
Matthew Parker
Chief Technologist
Dimensional DBA
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
<mailto:Dimensional.dba_at_comcast.net> Dimensional.dba_at_comcast.net
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn
<http://www.dimensionaldba.com/> www.dimensionaldba.com
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Saturday, September 2, 2017 11:39 AM
To: oracle-l <oracle-l_at_freelists.org>
Subject: Grid owner cannot start the database?
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
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
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
[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@scan12/orclpdb.home.com <mailto: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 -- http://www.freelists.org/webpage/oracle-lReceived on Sat Sep 02 2017 - 21:11:12 CEST