Re: To ODA or Not?

From: Seth Miller <sethmiller.sm_at_gmail.com>
Date: Sat, 28 Mar 2015 22:50:59 -0500
Message-ID: <CAEueRAUGYH2DfNLqK69m4nkDmZBiC8f_FOn4g0Yn2Aw3Hd74Pw_at_mail.gmail.com>

It's no different in 11gR2. I would be very interested to see an example of what you are talking about if you ever come across it again.

Seth Miller

On Sat, Mar 28, 2015 at 10:09 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> It is possible that 12c works differently. But when I relocated my RAC
> one node instance in 11gR2, the instance name remained the same on both
> nodes. Admittedly I have only set up 3 RAC one node clusters, all in
> 11gR2, but they all behaved the same.
>
> Sent from my iPad
>
> On Mar 28, 2015, at 10:04 PM, Seth Miller <sethmiller.sm_at_gmail.com> wrote:
>
> Andrew,
>
> Help me out here because I can't figure out how you are seeing the same
> SID on two different nodes for RAC One Node.
>
> [oracle_at_odabase1 ~]$ srvctl config database -d racone
> Database unique name: racone
> Database name: racone
> Type: RACOneNode
> Instance name prefix: racone
> Candidate servers: odabase1,odabase2
> Database is administrator managed
> [oracle_at_odabase1 ~]$ export ORACLE_SID=racone
> [oracle_at_odabase1 ~]$ sqlplus / as sysdba
>
> SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 28 19:22:00 2015
>
> Copyright (c) 1982, 2014, Oracle. All rights reserved.
>
> Connected to an idle instance.
>
> SQL> exit
> Disconnected
> [oracle_at_odabase1 ~]$ export ORACLE_SID=racone_1
> [oracle_at_odabase1 ~]$ sqlplus / as sysdba
>
> SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 28 19:22:09 2015
>
> Copyright (c) 1982, 2014, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
> Production
> With the Partitioning, Real Application Clusters, Automatic Storage
> Management, OLAP,
> Advanced Analytics and Real Application Testing options
>
> SQL> show parameter name
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> db_name string racone
> db_unique_name string racone
> instance_name string racone_1
>
> SQL> exit
> Disconnected
> [oracle_at_odabase1 ~]$ srvctl relocate database -d racone -node odabase2
> [oracle_at_odabase1 ~]$ ssh odabase2
> [oracle_at_odabase2 ~]$ export ORACLE_SID=racone
> [oracle_at_odabase2 ~]$ sqlplus / as sysdba
>
> SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 28 21:03:58 2015
>
> Copyright (c) 1982, 2014, Oracle. All rights reserved.
>
> Connected to an idle instance.
>
> SQL> exit
> Disconnected
> [oracle_at_odabase2 ~]$ export ORACLE_SID=racone_2
> [oracle_at_odabase2 ~]$ sqlplus / as sysdba
>
> SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 28 21:04:10 2015
>
> Copyright (c) 1982, 2014, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
> Production
> With the Partitioning, Real Application Clusters, Automatic Storage
> Management, OLAP,
> Advanced Analytics and Real Application Testing options
>
> SQL> show parameter name
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> db_name string racone
> db_unique_name string racone
> instance_name string racone_2
> SQL>
>
>
> Seth Miller
>
>
> On Sat, Mar 28, 2015 at 2:59 PM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> The Oracle SID is the same on both servers in all the RAC One Node
>> installations I have done. The database storage is shared, and if the
>> instance on node 1 goes down, it comes up on node 2. With the same name.
>>
>> On Sat, Mar 28, 2015 at 2:04 PM, Seth Miller <sethmiller.sm_at_gmail.com>
>> wrote:
>>
>>> RAC One Node is not free. Nor does it have anything to do with
>>> Clusterware. Nor does it have anything to do with MySQL. Nor is the
>>> ORACLE_SID the same on all cluster nodes. I think you may be confused by
>>> what RAC One Node is.
>>>
>>> RAC One Node allows a connection failover between two or more active
>>> instances (temporarily) exactly the same as RAC. There is no way to achieve
>>> this with active-passive clustering. A database is one of RAC, RAC One Node
>>> or Single Instance. They are all mutually exclusive.
>>>
>>> Seth Miller
>>>
>>> On Sat, Mar 28, 2015 at 11:34 AM, Mladen Gogala <
>>> dmarc-noreply_at_freelists.org> wrote:
>>>
>>>> On 03/28/2015 01:52 AM, MARK BRINSMEAD wrote:
>>>>
>>>>> When did RAC One Node become "free"? Its been a while, but the last
>>>>> time I checked, it cost something like $5500 ($11,000?) per processor. It
>>>>> certainly wasn't "free". (Although that doesn't mean it isn't now, I
>>>>> guess. I have not looked at a pr
>>>>>
>>>> Hi Mark,
>>>> Clusterware is free. You can install clusterware without paying and use
>>>> it to fail-over MySQL service. Oracle licenses are not free.
>>>>
>>>>
>>>> --
>>>> Mladen Gogala
>>>> Oracle DBA
>>>> http://mgogala.freehostia.com
>>>>
>>>> --
>>>> 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 Sun Mar 29 2015 - 05:50:59 CEST