Oracle 11g r2 one node RAC
zigzagdna
I have read Oracle’s documentation on this new feature is 11gr2, but
not clear what exactly it does?
http://www.oracle.com/technology/products/database/clustering/pdf/ug_raconenode-2009.pdf
1. Can I have multiple instances of same database on same node of
RAC. In absence of one node RAC, I will have one instance on server 1,
another instance on server2, etc. If only one instance is allowed on
a single node, then what is the purpose of one node RAC? I am not
using vmware or vpar's.
2. During setup/configuration of one node ARC, it asks for names of
other nodes/severs where database can be moved using omotion. If I am
just setting up RAC for learning, I do not have any other servers to
specify. Is it OK not to specify any servers for omotion.
3. Assuming that I can have multiple instances of same database on one
node, is it necessary for me to use ASM. Is it possible to use RAW
devices of UNIX instead of ASM for one node RAC setup?
Thanks a lot.
vsevolod afanassiev
between running Oracle RAC One Node and running normal standalone
instance in a clustered environment where it will run as a cluster
service. May be it improves handling of relocating service
from one node to another? But it still needs to be shut down, while
IBM offers dynamic relocation of an LPAR from one node to another -
without shutdown!
raw devices instead of ASM should be fine
Mark D Powell
> I have read Oracle’s documentation on this new feature is 11gr2, but
> 1. Can I have multiple instances of same database on same node of
> RAC. In absence of one node RAC, I will have one instance on server 1,
> another instance on server2, etc. If only one instance is allowed on
> a single node, then what is the purpose of one node RAC? I am not
> using vmware or vpar's.
>
> 2. During setup/configuration of one node ARC, it asks for names of
> other nodes/severs where database can be moved using omotion. If I am
> just setting up RAC for learning, I do not have any other servers to
> specify. Is it OK not to specify any servers for omotion.
> 3. Assuming that I can have multiple instances of same database on one
> node, is it necessary for me to use ASM. Is it possible to use RAW
> devices of UNIX instead of ASM for one node RAC setup?
> Thanks a lot.
"Oracle RAC One Node is a single instance of Oracle RAC running
on one node in a cluster. Many databases can be consolidated into a
single cluster with minimal overhead yet providing the high
availability benefits of failover protection, online rolling patch
application, as well as rolling upgrades for Operating System and
Oracle Clusterware. "
Ref: http://www.oracle.com/technology/products/database/clustering/pdf/ds-oracleraconenode-2009.pdf
Much more detail is available at
http://download.oracle.com/docs/cd/E11882_01/rac.112/e10718/whatsnew.htm
HTH -- Mark D Powell --
zigzagdna
>
> Much more detail is available athttp://download.oracle.com/docs/cd/E11882_01/rac.112/e10718/whatsnew.htm
>
> HTH -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -
>Oracle RAC One Node is a single instance of Oracle RAC running
> on one node in a cluster. Many databases can be consolidated into a
> single cluster with minimal overhead yet providing the high
> availability benefits of failover protection, online rolling patch
> application, as well as rolling upgrades for Operating System and
> Oracle Clusterware. "
>
If one can have only single instance of a database on one Node
(server) and one needs another server for
failover, what is differentce in one Node RAC vs two Node RAC. Why one
won't want to run one instance on one Node (one server) another on
another Node (on a dufferent server) I do not see any diference.
I am very confused with Oracle documentation..
If one can run several instances of a database on One Node, then it
adds value. For example, one instance can have init.ora optimized for
OLTP, another instance of init.ora optimezed for DSS etc, still one
has just one database and one Node. Both instances can ahve thier own
ORALE_HOME, one can do rolling upgrades.
Mladen Gogala
> what is differentce in one Node RAC vs two Node RAC.
The answer to that is: one node. Two node RAC has one node more than the
one node RAC. The difference between the three node RAC and one node RAC
is 2 nodes. Merry Christmas.
Noons
>
> "Oracle RAC One Node is a single instance of Oracle RAC running
> on one node in a cluster. Many databases can be consolidated into a
> single cluster with minimal overhead yet providing the high
> availability benefits of failover protection, online rolling patch
> application, as well as rolling upgrades for Operating System and
> Oracle Clusterware. "
>
I'd love to know how many "databases" can be consolidated into one cluster IF
that cluster is running a single node RAC? Isn't that exactly and precisely the
same as moving schemas across instances?
And how is "high availability" any better in a single node RAC than in a single
instance database? And how do "rolling patch application as well as rolling
upgrades" work in a single node RAC?
Oh, it needs more than one node, doesn't it? So exactly what is the point of
all that "one node RAC" utter marketing nonsense?
Mladen Gogala
> So exactly what is the point of
> all that "one node RAC" utter marketing nonsense?
That's fairly simple: it is easy to expand one node RAC into two node RAC
and three node RAC. Basically, it's a sales tool. If you already own one
node RAC, you are far more likely to expand it into a several node RAC
than if you just have an Oracle EE server without RAC.
hpuxrac
snip
> > So exactly what is the point of
> > all that "one node RAC" utter marketing nonsense?
>
> That's fairly simple: it is easy to expand one node RAC into two node RAC
> and three node RAC. Basically, it's a sales tool. If you already own one
> node RAC, you are far more likely to expand it into a several node RAC
> than if you just have an Oracle EE server without RAC.
The claim of course is that the customers demanded this "feature".
It certainly may have been demanded by Oracle partners who may be able
to sell the one node rac first then upsell to multi node rac later.
hpuxrac
snip
> I am very confused with Oracle documentation..
>
> If one can run several instances of a database on One Node, then it
> adds value. For example, one instance can have init.ora optimized for
> OLTP, another instance of init.ora optimezed for DSS etc, still one
> has just one database and one Node. Both instances can ahve thier own
> ORALE_HOME, one can do rolling upgrades.
Why don't you setup a test environment and check it out?
newbie
snip
Both instances can ahve thier own
> > ORALE_HOME, one can do rolling upgrades.
snip
Huh ?
Are you sure you can do rolling upgrades ?
I dont think so.
zigzagdna
Whatever rolling uogrades RAC allows in multi-node environment, I
think one should be able to do in one node RAC.
I still do not know what is the value of one node RAC if only a single
instance of database can be on one node.
joel garry
> On Dec 28, 5:05 pm, newbie <rjngh2...@gmail.com> wrote:
>
>
>
> > On Dec 28, 10:30 am, hpuxrac <johnbhur...@sbcglobal.net> wrote:
>
> > > On Dec 25, 10:35 pm, zigzagdna <zigzag...@yahoo.com> wrote:
>
> > > snip
>
> > > > I am very confused with Oracle documentation..
>
> > > > If one can run several instances of a database on One Node, then it
> > > > adds value. For example, one instance can have init.ora optimized for
> > > > OLTP, another instance of init.ora optimezed for DSS etc, still one
> > > > has just one database and one Node. Both instances can ahve thier own
> > > > ORALE_HOME, one can do rolling upgrades.
>
> > > Why don't you setup a test environment and check it out?
>
> > snip
> > Both instances can ahve thier own> > ORALE_HOME, one can do rolling upgrades.
>
> > snip
>
> > Huh ?
> > Are you sure you can do rolling upgrades ?
>
> > I dont think so.
>
> Whatever rolling uogrades RAC allows in multi-node environment, I
> think one should be able to do in one node RAC.
Yes, according to the marketing materials, you can migrate the one
node to another node, upgrade the original node, then migrate back -
and these can be virtual nodes. I got a laugh when I tried to access
the marketing materials and got a "file is damaged" error, but was
able to see it with google quick view.
http://www.oracle.com/technology/products/database/clustering/pdf/ds-oracleraconenode-2009.pdf
(same link as Mark posted, I now see).
> I still do not know what is the value of one node RAC if only a single
> instance of database can be on one node.
I think Noons, Mladen and hpuxrac said the real value, but the
marketing material spake thus:
• High Availability
•
Failover protection for
database and server
failures
•
Operating System Rolling
Upgrades and Patches
•
Database Rolling Patches
• Performance
•
Server scalability with no
core limit
•
Online load balancing and
scale-up
•
Online upgrade to Oracle
RAC
• Support for all Oracle
supported platforms
• Standardized database
deployment across enterprise
• Increases the benefit of
Oracle VM with the high
availability and scalability of
Oracle RAC
In my site, I don't need RAC, though there is a big push for virtual
environments on everything else (Virtual Iron).
jg
--
@home.com is bogus.
Bad year for Ponzi schemes. http://www.telegram.com/article/20091229/NEWS/912290348
Noons
Indeed. To me that's exactly how it reads. All the arguments put forward in
its favour are nothing but a pile of marketing excrement: the thing is just a
ruse to nail sites to the RAC bandwagon, period. Never mind if folks need RAC
or not, that's immaterial!
Just like the idiotic videos of the 2 dbas, with the "savvy looking girl" doing
"everything with a click of the mouse". Most of what she does, she'd simply be
fired on the spot at most sites...
Noons
>
> • High Availability
> •
How, with only one node?
> Failover protection for
> database and server
> failures
Failover to WHAT, since it's a single node?
> •
> Operating System Rolling
> Upgrades and Patches
How? In a single node? I'd love to see proof...
> •
> Database Rolling Patches
See above
> • Performance
Really? So, single node non-RAC databases perform what? Badly?...
> •
> Server scalability with no
> core limit
Hmmmmm..., must be that snuff thing in action again.
I'd love to have one of these servers they keep talking about...
> •
> Online load balancing and
> scale-up
And that of course is possible with a single node?
> •
> Online upgrade to Oracle
> RAC
At last! A smidgeon of reality...
> • Support for all Oracle
> supported platforms
Ah OK: so single node non_RAC does not support all platforms that RAC supports?
Where is the RAC version for Mac osx then?
> • Standardized database
> deployment across enterprise
Ah yes: so, non-RAC is non-standard now?
> • Increases the benefit of
> Oracle VM with the high
> availability and scalability of
> Oracle RAC
How many sites out there are running production RAC dbs in a virtual
environment? Last time I asked back in mid2009, I got no answer...
> In my site, I don't need RAC, though there is a big push for virtual
> environments on everything else (Virtual Iron).
Same here, Jgar. And let me say this while I'm here:
none of the above applies to you, I understand you're just quoting.
and quite frankly, the sort of total marketing excrement above is reflecting
very badly on Oracle's credibility as a db supplier...
joel garry
> joel garry wrote,on my timestamp of 30/12/2009 4:13 AM:
>
>
>
> > • High Availability
> > •
>
> How, with only one node?
>
> > Failover protection for
> > database and server
> > failures
>
> Failover to WHAT, since it's a single node?
They are referring to running RAC on a single node of a cluster, so
they can auto start on another node when failover.
http://docs.google.com/viewer?a=v&q=cache%3Asfmkrhr1lUIJ%3Awww.oracle.com%2Ftechnology%2Fproducts%2Fdatabase%2Fclustering%2Fpdf%2Fds-oracleraconenode-2009.pdf+http%3A%2F%2Fwww.oracle.com%2Ftechnology%2Fproducts%2Fdatabase%2Fclustering%2Fpdf%2Fds-oracleraconenode-2009.pdf&hl=en&gl=us&sig=AHIEtbSs0FJaKY-eRr6t-EuWQE_chsu5sw&pli=1
>
> > •
> > Operating System Rolling
> > Upgrades and Patches
>
> How? In a single node? I'd love to see proof...
That would be the Omotion utility. "Your search - oracle +omotion
site:tahiti.oracle.com - did not match any documents. "
Funny what sites come up googling for Omotion. I still have a button
from the early '80s that has a circular TKB forever and ever and
ever... (referring to the DEC Task Builder, particularly its
performance on Rainbow IIRC). Perhaps now we need one that says DKB
forever and ever and ever and...
>
> > •
> > Database Rolling Patches
>
> See above
>
> > • Performance
>
> Really? So, single node non-RAC databases perform what? Badly?...
>
> > •
> > Server scalability with no
> > core limit
>
> Hmmmmm..., must be that snuff thing in action again.
> I'd love to have one of these servers they keep talking about...
>
> > •
> > Online load balancing and
> > scale-up
>
> And that of course is possible with a single node?
Simple, just move to a larger VM. Or two. (what was that goofy face
smiley again?)
>
> > •
> > Online upgrade to Oracle
> > RAC
>
> At last! A smidgeon of reality...
>
> > • Support for all Oracle
> > supported platforms
>
> Ah OK: so single node non_RAC does not support all platforms that RAC supports?
> Where is the RAC version for Mac osx then?
Glad I wasn't sipping the coffee just then...
>
> > • Standardized database
> > deployment across enterprise
>
> Ah yes: so, non-RAC is non-standard now?
I revel in non-conformity!
>
> > • Increases the benefit of
> > Oracle VM with the high
> > availability and scalability of
> > Oracle RAC
>
> How many sites out there are running production RAC dbs in a virtual
> environment? Last time I asked back in mid2009, I got no answer...
Yeah, it's like how many DB2 environments are running 32000 linux
images.
>
> > In my site, I don't need RAC, though there is a big push for virtual
> > environments on everything else (Virtual Iron).
>
> Same here, Jgar. And let me say this while I'm here:
> none of the above applies to you, I understand you're just quoting.
I know, but thanks for clarifying for those who don't.
>
> and quite frankly, the sort of total marketing excrement above is reflecting
> very badly on Oracle's credibility as a db supplier...
This is nothing new.
jg
--
@home.com is bogus
Scott misspelled "Garry": http://www.dilbert.com/2009-12-27/
Noons
>>> Failover protection for
>>> database and server
>>> failures
>> Failover to WHAT, since it's a single node?
>
> They are referring to running RAC on a single node of a cluster, so
> they can auto start on another node when failover.
Yeah, but they don't tell anyone that. It's simply stated that one-node RAC can
do all that. It can't. Not by itself.
>>> •
>>> Operating System Rolling
>>> Upgrades and Patches
>> How? In a single node? I'd love to see proof...
>
> That would be the Omotion utility. "Your search - oracle +omotion
> site:tahiti.oracle.com - did not match any documents. "
>
> Funny what sites come up googling for Omotion. I still have a button
> from the early '80s that has a circular TKB forever and ever and
> ever... (referring to the DEC Task Builder, particularly its
> performance on Rainbow IIRC). Perhaps now we need one that says DKB
> forever and ever and ever and...
Look, when RAC first came out I asked Grant Ronald very specifically: exactly
how does one address upgrades and patches in a RAC setup?
His "reassuring" answer was: "it's all automatic". Alarm bells straight up,
everytime someone from Oracle says: "it's all automatic"!
That was with 9i, nearly 10 years ago! Nowadays, they still can't do it...
I'll bet anything that Omotion only works in one system: the one they use for demos!
>>> Online load balancing and
>>> scale-up
>> And that of course is possible with a single node?
>
> Simple, just move to a larger VM. Or two. (what was that goofy face
> smiley again?)
Oh yeah! LOL!
>>> • Support for all Oracle
>>> supported platforms
>> Ah OK: so single node non_RAC does not support all platforms that RAC supports?
>> Where is the RAC version for Mac osx then?
>
> Glad I wasn't sipping the coffee just then...
But the really sad thing is these marketing nongs make claims like that without
even checking their own product range!
Talk about absolutely, totally, *no clue*!...
Cripes, half the add-on product range of the last two years has been on Linux
only! For a long time the best advantage of Oracle was their portability and
availability in a wide range of platforms, now they are finally shooting
themselves in the foot with their strongest (only?) advantage...
>>> • Increases the benefit of
>>> Oracle VM with the high
>>> availability and scalability of
>>> Oracle RAC
>> How many sites out there are running production RAC dbs in a virtual
>> environment? Last time I asked back in mid2009, I got no answer...
>
> Yeah, it's like how many DB2 environments are running 32000 linux
> images.
ROFL!
Couldn't have said it better!
Serge Rielau
>>>> Oracle VM with the high
>>>> availability and scalability of
>>>> Oracle RAC
>>> How many sites out there are running production RAC dbs in a virtual
>>> environment? Last time I asked back in mid2009, I got no answer...
>>
>> Yeah, it's like how many DB2 environments are running 32000 linux
>> images.
> ROFL!
> Couldn't have said it better!
heck was that all about?
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
hpuxrac
snip
> >> Yeah, it's like how many DB2 environments are running 32000 linux
> >> images.
> > ROFL!
> > Couldn't have said it better!
>
> I know it's not funny when a joke has to be explained.. but what the
> heck was that all about?
No idea ... must be some strange inside reference to something.
joel garry
> >>>> • Increases the benefit of
> >>>> Oracle VM with the high
> >>>> availability and scalability of
> >>>> Oracle RAC
> >>> How many sites out there are running production RAC dbs in a virtual
> >>> environment? Last time I asked back in mid2009, I got no answer...
>
> >> Yeah, it's like how many DB2 environments are running 32000 linux
> >> images.
> > ROFL!
> > Couldn't have said it better!
>
> I know it's not funny when a joke has to be explained.. but what the
> heck was that all about?
Just a cheap shot, Serge. You can find a zillion references on the
web to z-whatever systems, and the news at some point picked up on
someone running large numbers of linux images just to show it could be
done. Then taking a sarcastic leap of marketing-will-always-
exaggerate faith.
Stuff like http://cactuscode.org/media/news/BGP-131072/ is cool, but
the marketeering it engenders is just sad/funny.
To possibly answer Noons' question about who is using vm rac, maybe
the case study at http://www.oracle.com/technology/tech/cloud/index.html
though I don't see anything about RAC.. they probably don't need it :-
O Oh wait, the cc faq says you can't. Never mind.
jg
--
@home.com is bogus.
TITs in your face: http://www.10news.com/news/22079493/detail.html
Serge Rielau
> On Dec 30, 7:12 pm, Serge Rielau<srie...@ca.ibm.com> wrote:
>>>>>> Oracle VM with the high
>>>>>> availability and scalability of
>>>>>> Oracle RAC
>>>>> How many sites out there are running production RAC dbs in a virtual
>>>>> environment? Last time I asked back in mid2009, I got no answer...
>>
>>>> Yeah, it's like how many DB2 environments are running 32000 linux
>>>> images.
>>> ROFL!
>>> Couldn't have said it better!
>>
>> I know it's not funny when a joke has to be explained.. but what the
>> heck was that all about?
>
> Just a cheap shot, Serge. You can find a zillion references on the
> web to z-whatever systems, and the news at some point picked up on
> someone running large numbers of linux images just to show it could be
> done. Then taking a sarcastic leap of marketing-will-always-
> exaggerate faith.
That was the only way I could resolve the puzzle...
joel garry
> On 12/31/2009 12:10 PM, joel garry wrote:
>
> > On Dec 30, 7:12 pm, Serge Rielau<srie...@ca.ibm.com> wrote:
> >>>>>> Oracle VM with the high
> >>>>>> availability and scalability of
> >>>>>> Oracle RAC
> >>>>> How many sites out there are running production RAC dbs in a virtual
> >>>>> environment? Last time I asked back in mid2009, I got no answer...
>
> >>>> Yeah, it's like how many DB2 environments are running 32000 linux
> >>>> images.
> >>> ROFL!
> >>> Couldn't have said it better!
>
> >> I know it's not funny when a joke has to be explained.. but what the
> >> heck was that all about?
>
> > Just a cheap shot, Serge. You can find a zillion references on the
> > web to z-whatever systems, and the news at some point picked up on
> > someone running large numbers of linux images just to show it could be
> > done. Then taking a sarcastic leap of marketing-will-always-
> > exaggerate faith.
>
> I did wonder whether Noons intended to say mainframe instead of DB2.
> That was the only way I could resolve the puzzle...
>
That was me goof, sorry! I should've said sites rather than
environments. I can only plead end-of-year workload, and not properly
proofing a silly usenet post.
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2009/dec/31/internet-writer-to-challenge-tsa-subpoena-in-court/
Noons
>>>>>>> • Increases the benefit of
>>>>>>> Oracle VM with the high
>>>>>>> availability and scalability of
>>>>>>> Oracle RAC
>>>>>> How many sites out there are running production RAC dbs in a virtual
>>>>>> environment? Last time I asked back in mid2009, I got no answer...
>>>
>>>>> Yeah, it's like how many DB2 environments are running 32000 linux
>>>>> images.
>>>> ROFL!
>>>> Couldn't have said it better!
>>>
>>> I know it's not funny when a joke has to be explained.. but what the
>>> heck was that all about?
>>
>> Just a cheap shot, Serge. You can find a zillion references on the
>> web to z-whatever systems, and the news at some point picked up on
>> someone running large numbers of linux images just to show it could be
>> done. Then taking a sarcastic leap of marketing-will-always-
>> exaggerate faith.
> I did wonder whether Noons intended to say mainframe instead of DB2.
> That was the only way I could resolve the puzzle...
Relax, Serge: Noons didn't write it, he just laughed at the joke.
Maybe if IBM bozos spent some time reading instead of jumping into the usual
ad-homine insinuations they wouldn't look so ridiculous?
HNY:
http://wizofoz2k.deviantart.com/art/Welcome-2010-148684836
joel garry
> HNY:http://wizofoz2k.deviantart.com/art/Welcome-2010-148684836
Ooh baby!
I just finished work...
jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2009/dec/30/2nd-man-to-plead-guilty-to-uploading-love-guru/
hpuxrac
snip
> Relax, Serge: Noons didn't write it, he just laughed at the joke.
> Maybe if IBM bozos spent some time reading instead of jumping into the usual
> ad-homine insinuations they wouldn't look so ridiculous?
I don't think I understand Australians evidently but are you calling
Serge an IBM bozo for just asking what the inside joke was or is this
some other reference to other IBM employees?
I do not at all understand why there is so much anti IBM trash talking
that goes on in this newsgroup.
Mladen Gogala
> I don't think I understand Australians evidently but are you calling
> Serge an IBM bozo for just asking what the inside joke was or is this
> some other reference to other IBM employees?
Ah, saint John on yet another mission to preserve civility on this group.
Nuno, you shall wash your hands before lunch and eat your spinach! While
at that, have a happy New Year, both of you.
Noons
> I don't think I understand Australians evidently but are you calling
> Serge an IBM bozo for just asking what the inside joke was
no, for claiming that I wrote it. When clearly - even to you I think - I did not.
> or is this
> some other reference to other IBM employees?
The ones that troll around the db2 nonsense? Yes, it is.
> I do not at all understand why there is so much anti IBM trash talking
> that goes on in this newsgroup.
You've got to go back a few years...
Mostly not IBM, just one of their products. But given they all blurt from the
same stable...
And no: it's not going to stop because you might dislike it.
Noons
> Ah, saint John on yet another mission to preserve civility on this group.
> Nuno, you shall wash your hands before lunch and eat your spinach! While
> at that, have a happy New Year, both of you.
Spinach? Now you just gave me an idea for dinner tonight!
Thanks, Mladen! And a HNY to you as well.