Licensing rules for Data Guard
Neil Truby
- am I right that that it is not available as an option for Standard
Edition, and is available only in Enterprise Edition?
- is there anything within the code of Standard Ediiton that stops me trying
it, or is it just an honour-based licensing system?
The price differential between the versions is so vast that it is
inconceivable that we could buy Enterprise Edition, so I'd like to find out
the facts before wasting my time trying it.
thanks
Neil
Donkey Hottie
news:6gqogcF...@mid.individual.net:
> I'd like to try out Data Guard.
>
> - am I right that that it is not available as an option for Standard
> Edition, and is available only in Enterprise Edition?
Enterprise Edition only.
> - is there anything within the code of Standard Ediiton that stops me
> trying it, or is it just an honour-based licensing system?
Code refuses with an error message "Option not available" or something, if
you try to configure Data Guard under Standard Edition.
>
> The price differential between the versions is so vast that it is
> inconceivable that we could buy Enterprise Edition, so I'd like to
> find out the facts before wasting my time trying it.
>
I once learned all about Data Guard for a client, but when it was time to
implement it we learned that the cost of Enterprise Edition was too much,
and the project failed.
Neil Truby
"Donkey Hottie" <sp...@plc.is-a-geek.com> wrote in message
news:Xns9AFDCC321BBABSH...@194.100.2.89...
Thanks. That's a shame though. I guess I can't trial it.
Ana C. Dent
There is nothing to stop anyone from creating a remote standby database &
manually shipping the redo log files from the primary to the standby and
applying the changes. It trivial to implement.
hpuxrac
While the marketing and changes to the various different ways you can
configure it ( aka Data Guard ) have increased over the years the
ability to run a standby database has been around for a very long time
in oracle.
Check out the oracle documentation for the release you are interested
in. Does it work? Yes. Are there some caveats and ways to configure
yourself into non-optimal situations? Absolutely.
Lots of people have written books about it also some better than
others if you don't want to use the free doc from oracle.
Do you have an OTN login? You can download EE version free and setup
and test it out before deciding on a purchase.
Neil Truby
news:Xns9AFD7550B34ABa...@69.16.185.250...
> manually shipping the redo log files from the primary to the standby and
> applying the changes. It trivial to implement.
Thanks for the reply.
If I read correctly, the log shipping technique, which is as you say well
documented on multiple sites, involves shipping archived, rather than
active, re-do logs and therefore is certain to be minutes, rather than the
max 5 seconds, out-of-phase that we need. Is that right?
Neil Truby
news:59351d20-2c23-48c3...@z66g2000hsc.googlegroups.com...
On Aug 17, 9:50 am, "Neil Truby" <neil.tr...@ardenta.com> wrote:
> I'd like to try out Data Guard.
>
> - am I right that that it is not available as an option for Standard
> Edition, and is available only in Enterprise Edition?
> - is there anything within the code of Standard Ediiton that stops me
> trying
> it, or is it just an honour-based licensing system?
>
> The price differential between the versions is so vast that it is
> inconceivable that we could buy Enterprise Edition, so I'd like to find
> out
> the facts before wasting my time trying it.
>
> thanks
> Neil
>> While the marketing and changes to the various different ways you can
configure it ( aka Data Guard ) have increased over the years the
ability to run a standby database has been around for a very long time
in oracle.
>> Check out the oracle documentation for the release you are interested
in. Does it work? Yes. Are there some caveats and ways to configure
yourself into non-optimal situations? Absolutely.
Thanks for the reply.
If I read correctly, the log shipping technique, which is well documented on
multiple sites, involves shipping archived, rather than active, re-do logs
and therefore is certain to be minutes, rather than the max 5 seconds,
out-of-phase that we need.
>> Do you have an OTN login? You can download EE version free and setup
and test it out before deciding on a purchase.
Thanks for the tip!
Ana C. Dent
> Thanks for the reply.
> If I read correctly, the log shipping technique, which is as you say
> well documented on multiple sites, involves shipping archived, rather
> than active, re-do logs and therefore is certain to be minutes, rather
> than the max 5 seconds, out-of-phase that we need. Is that right?
>
>
Correct. Previously a 15 minute cron job to switch log files & apply them
to the standby was deemed an accepatble trade-off.
You can have it Good, Fast, or Cheap; pick any 2 from preceeding list.
DA Morgan
Of course you can. Go to http://otn.oracle.com and click on downloads.
Download Enterprise Edition ... it is free, undamaged, and does not expire.
Oracle, unlike some companies, does not charge for possession of their
software ... they charge for its commercial use.
Also, unlike some software companies, Oracle trusts its customers. No
question there is compliance verification as there should be. But what
is important to many is the trust.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
DA Morgan
Keep in mind the difference in price between SE and EE is entirely
dependent upon your ability to negotiate with your Oracle sales rep.
Oracle has list prices (http://store.oracle.com) but those are merely
the beginning point for negotiations.
Depending on the volume of log files being shipped best practice is
to do the shipping on a separate NIC card using a private network.
You can find configuration files here:
http://www.psoug.org/reference/data_guard.html
that may help you setting it up.
Neil Truby
news:12190053...@bubbleator.drizzle.com...
> Keep in mind the difference in price between SE and EE is entirely
> dependent upon your ability to negotiate with your Oracle sales rep.
> Oracle has list prices (http://store.oracle.com) but those are merely
> the beginning point for negotiations.
Thanks. The differential in price was about £150k. The lady from Oracle
was interested in some incentive for going Enterprise, but nothing like that
much. You get hit with a double whammy anyway: Enterprise is more expensive
than Standard, but you also have to licence per core rather than socket. It
could be a triple whammy, as no-one I spoke to seemed very sure if you have
to licence the replicate or not.
We were able to set up SAN replication to do the job for about £30k for the
software. It's not quite as elegant or instant as I imagine Data Guard
would be, which is why I was interested in trying it for comparison.
As you know, Daniel, I come from an IBM database background: it seems like
IBM might (amazingly!) have a more enlightened view to Feature pricing than
Oracle, in this respect at least!
rgds
N
The Boss
[..]
>
> Oracle, unlike some companies, does not charge for possession of their
> software ... they charge for its commercial use.
>
Do you imply that NPO's can use any Oracle software without charge to run
their buss..., ehrm, voluntary work?
That would be good news I guess for not only Red Cross, Amnesty
International, Greenpeace and their likes, but also for instance for the US
Federal Government and the Bill and Melinda Gates Foundation ... ;-)
--
Jeroen
DA Morgan
I don't know where the £150k price came from but here's a reality check
for her. In the US there are plenty of Oracle customers buying for
$20-25K per CPU and I don't know of anyone paying per core.
On IBM's zSeries architecture where 1 IFL = 30 x86 cores licensing is
by IFL.
DA Morgan
Implying no such thing. Read the license that goes with the download
at OTN. By "commercial" I did not mean to invite politicians or lawyers
to start parsing the meaning of the word "is."
Palooka
to Oracle a few years back? It was for some retailer or other (Londis
was my guess). I recommended SQL*Loader direct path if the data was
known to be clean. How did it go?
Palooka
Neil Truby
news:8a4qk.60992$8y1....@newsfe18.ams2...
> Aren't you the guy who was asking about transferring a whole lot of data
> to Oracle a few years back? It was for some retailer or other (Londis was
> my guess). I recommended SQL*Loader direct path if the data was known to
> be clean. How did it go?
What a good memory!
The requirement arose because Lawson removed Informix support from its new
product.
There were several hundred Gig to migrate, and in the end it never happened.
The customer contibues to run on Informix on the elderly version of Lawson,
but is in the process of moving much of the system to Oracle Financials.
Neil Truby
From: "DA Morgan" <damo...@psoug.org>
Newsgroups: comp.databases.oracle.server
Sent: Monday, August 18, 2008 12:42 AM
Subject: Re: Licensing rules for Data Guard
> I don't know where the £150k price came from but here's a reality check
> for her. In the US there are plenty of Oracle customers buying for
> $20-25K per CPU and I don't know of anyone paying per core.
The cost of Oracle Enterprise is £24k per core. So a 4 quad-core cpu server
is 16x24 = £384k. You get to multiply the cores by a "fudge factor" of
0.75, which gives £288k.
Standard Edition is £8.5k per cpu, so £34k total.
So I don't know where the £150k differential came from either. It's much
higher!
DA Morgan
£24k per core is the list price:
http://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?minisite=10061&respid=1298373&grp=STORE&language=US
I can't think of a single customer of mine that has ever paid that
price.
Neil Truby
> Neil Truby wrote:
>> ----- Original Message ----- From: "DA Morgan" <damo...@psoug.org>
>> Newsgroups: comp.databases.oracle.server
>> Sent: Monday, August 18, 2008 12:42 AM
>> Subject: Re: Licensing rules for Data Guard
>>
>>
>>> I don't know where the £150k price came from but here's a reality check
>>> for her. In the US there are plenty of Oracle customers buying for
>>> $20-25K per CPU and I don't know of anyone paying per core.
>>
>> The cost of Oracle Enterprise is £24k per core. So a 4 quad-core cpu
>> server is 16x24 = £384k. You get to multiply the cores by a "fudge
>> factor" of 0.75, which gives £288k.
>> Standard Edition is £8.5k per cpu, so £34k total.
>> So I don't know where the £150k differential came from either. It's much
>> higher!
>
> £24k per core is the list price:
> http://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?minisite=10061&respid=1298373&grp=STORE&language=US
>
> I can't think of a single customer of mine that has ever paid that
> price.
Yeah but you're American.
We Brits are too polite to ask for a discount for fear of being thought
vulgar ... ;-)
DA Morgan
> Yeah but you're American.
> We Brits are too polite to ask for a discount for fear of being thought
> vulgar ... ;-)
Perhaps this would not be a good time to remind you of Obnoxio. <g>
Mark Townsend
> Neil Truby wrote:
>
>> Yeah but you're American.
>> We Brits are too polite to ask for a discount for fear of being
>> thought vulgar ... ;-)
>
> Perhaps this would not be a good time to remind you of Obnoxio. <g>
That's truly funny...
Jonathan Leffler
> Neil Truby wrote:
>> Yeah but you're American.
>> We Brits are too polite to ask for a discount for fear of being
>> thought vulgar ... ;-)
>
> Perhaps this would not be a good time to remind you of Obnoxio. <g>
OTC is just a guest in England - he isn't really British.
--
Jonathan Leffler #include <disclaimer.h>
Email: jlef...@earthlink.net, jlef...@us.ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/
publictimestamp.org/ptb/PTB-4013 ripemd256 2008-08-19 03:00:09
5132A4D6F2A59A9DB88CEF4FB98663E8BC291888E90BBE6B05DC1F177FFE62A7
Mark Townsend
>> Perhaps this would not be a good time to remind you of Obnoxio. <g>
>
> OTC is just a guest in England - he isn't really British.
>
Do tell - where is he from initially ?