Re: To ODA or Not?
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Seth Miller <sethmiller.sm@xxxxxxxxx>
- Date: Sat, 28 Mar 2015 22:09:12 -0500
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@xxxxxxxxx> 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@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@odabase1 ~]$ export ORACLE_SID=racone
> [oracle@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@odabase1 ~]$ export ORACLE_SID=racone_1
> [oracle@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@odabase1 ~]$ srvctl relocate database -d racone -node odabase2
> [oracle@odabase1 ~]$ ssh odabase2
> [oracle@odabase2 ~]$ export ORACLE_SID=racone
> [oracle@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@odabase2 ~]$ export ORACLE_SID=racone_2
> [oracle@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@xxxxxxxxx>
>> 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@xxxxxxxxx>
>>> 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@xxxxxxxxxxxxx> 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
>>>>
>>>> --
>>>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>
Other related posts:
