Re: HAS Without ASM or CFS?

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Tue, 29 Jul 2014 15:52:34 -0500
Message-ID: <CAEueRAU=nG1iQ6wXcDs6VK_xNkFQ2CCnrYH87ZAcBm3VrNRJVw_at_mail.gmail.com>

With proper privileges, yes (see my previous message about the OSDBA group). However, it is not the way Clusterware was meant to be managed. Separation of duties indicates that you might want a user to manage a database but not manage Clusterware daemons.

Clusterware database operations are designed to be run from the Oracle home in which they reside.

Seth Miller

On Tue, Jul 29, 2014 at 3:24 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Ok, I was able to get this to work by using srvctl from the 11g home to
> manage the 11g instance. However, it would definitely be better to manage
> all instances out of the oracle 12g GI home. Is there any way to do that?
>
>
> On Tue, Jul 29, 2014 at 2:47 PM, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>> Does your 11g installation have a different OSDBA group?
>>
>>
>> *Note:*
>> *When you manually add a database to the Oracle Restart configuration,
>> you must also add the Oracle grid infrastructure software owner as a member
>> of the OSDBA group of that database. This is because the grid
>> infrastructure components must be able to connect to the database
>> as SYSDBA to start and stop the database.*
>>
>> *For example, if the host user who installed the grid infrastructure home
>> is named grid and the OSDBA group of the new database is named dba, then
>> user grid must be a member of the dba group.*
>>
>>
>>
>>
>>
>> On Tue, Jul 29, 2014 at 12:30 PM, Hans Forbrich <
>> fuzzy.graybeard_at_gmail.com> wrote:
>>
>>> Curious - DB at 11.2.0.1? or higher?
>>>
>>> /Hans
>>>
>>>
>>> On 29/07/2014 11:19 AM, Andrew Kerber wrote:
>>>
>>>> Tried both, same error.
>>>>
>>>> [oracle_at_o11gtest ~]$ srvctl add database -db test11g1 -oraclehome
>>>> /u01/app/oracle/product/11.2.0/dbhome_1
>>>> PRCD-1025 : Failed to create database test11g1
>>>> PRCT-1011 : Failed to run "srvctl". Detailed error: []
>>>> [oracle_at_o11gtest ~]$ srvctl add database -d test11g1 -o
>>>> /u01/app/oracle/product/11.2.0/dbhome_1
>>>> PRCD-1025 : Failed to create database test11g1
>>>> PRCT-1011 : Failed to run "srvctl". Detailed error: []
>>>>
>>>
>>> --
>>> http://www.freelists.org/webpage/oracle-l
>>>
>>>
>>>
>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

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

Received on Tue Jul 29 2014 - 22:52:34 CEST