Re: HAS Without ASM or CFS?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 29 Jul 2014 15:56:51 -0500
Message-ID: <CAJvnOJaNmjBqzKJF6a7BOciEoDNuVnxZxBFnjJRxzbtntwo1QA_at_mail.gmail.com>

They dont have a different group, its more of an oracle restart environment, everything is owned by same user, Oracle.

On Tue, Jul 29, 2014 at 3:52 PM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:

> 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.'
>>
>
>

-- 
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:56:51 CEST