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