Re: To ODA or Not?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Sat, 28 Mar 2015 22:09:12 -0500
Message-Id: <9340E918-3253-4F8E-A677-A27642ECE0F5_at_gmail.com>

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:09:12 CEST