Re: To ODA or Not?

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

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