Re: Extended RAC on SE
Date: Wed, 2 Sep 2015 12:10:52 +0200
Message-ID: <CAJ2-Qb_R7i78uF7=Y9kzj_xUzSpVJBOMX6ZJRhv=9B+SFcfeoA_at_mail.gmail.com>
now choose... should I use threads or cores if we use Intel CPUs?
I think someone did some comparison between hyperthreading and core a couple of years ago, I forgot who though!
On Wed, Sep 2, 2015 at 11:53 AM, Tom Dale <tom.dale_at_fivium.co.uk> wrote:
> Oracle has updated their licence doc with SE2 details
>
> http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf
>
> Oracle Database Standard Edition 2 may only be licensed on servers that
> have a maximum capacity of 2 sockets. When used with Oracle Real
> Application Clusters, Oracle Database Standard Edition 2 may only be
> licensed on a maximum of 2 one-socket servers. In addition, notwithstanding
> any provision in Your Oracle license agreement to the contrary, each Oracle
> Database Standard Edition 2 database may use a maximum of 16 CPU threads at
> any time. When used with Oracle Real Application Clusters, each Oracle
> Database Standard Edition 2 database may use a maximum of 8 CPU threads per
> instance at any time. The minimums when licensing by Named User Plus (NUP)
> metric are 10 NUP licenses per server.
>
> This is a pretty big change :
>
> - a change to a maximum of 2 sockets, this will be a problem for anyone on
> a 4 socket server, even if only 2 are populated.
>
> - standard edition RAC now requires 1 socket servers, and as Mark pointed
> out these are very hard to find as data centre rack servers, you won't get
> them from the big vendors, HP etc, its only supermicro I know of who supply
> them.
>
> - Capped at 16 threads, but 16 threads on physical cores is actually quite
> a lot of capacity, eg Intel E5-2667 v3 (3.2 GHz, Max Turbo 3.6 GHz, 8
> core), considering you can't use multiple RMAN threads etc
>
> Andrea,
> I have not seen a list of chips that qualify for what license,
> Has anyone else?
>
> Tom
>
> On Wed, Sep 2, 2015 at 10:21 AM, Andrea Monti <ilsuonogiallo_at_gmail.com>
> wrote:
>
>> Hi ,
>> in the past I was told by Oracle people that "multi-chip modules" only
>> refers to some unix-class processors (some IBM Power and SPARC processors).
>> Do you have any other clues about that?
>> Did anyone find some evidence to say that *any* x86 processor will not be
>> considered a multi-chip module?
>>
>> Regards
>> Andrea
>>
>>
>> 2015-09-02 2:45 GMT+02:00 Mark Brinsmead <mark.brinsmead_at_gmail.com>:
>>
>>> Yeah. And that "multi-chip module" language is a serious issue too.
>>>
>>> Is your CPU a multichip module? How do you know? Its surprisingly hard
>>> to find out, even if you *do* know the exact model of CPU.
>>>
>>> On Tue, Sep 1, 2015 at 1:30 AM, Tom Dale <tom.dale_at_fivium.co.uk> wrote:
>>>
>>>> I agree Mark,
>>>>
>>>> Finding single-socket servers is indeed tricky!
>>>>
>>>> We have bought many servers from broadberry in the UK, they allow us to
>>>> have SSD's, lsi controllers and 4hr hardware support, at a reasonable
>>>> cost, they do some single socket servers
>>>>
>>>> eg
>>>>
>>>>
>>>> http://www.broadberry.co.uk/superservers-supermicro-servers/as-1012a-m73rf
>>>>
>>>> Full spec :
>>>>
>>>> http://www.supermicro.com/products/system/1u/1018/sys-1018gr-t.cfm
>>>>
>>>> I just configured one
>>>>
>>>> E5-2699 v3 Intel 18 Core Xeon 2.3GHz 45Mb Cache 145 Watts
>>>> 6x 800GB Intel SSD S3500 DataCentre SERIES 2.5IN SATA3 MLC
>>>> LSI MegaRAID 9380-4i4e 12Gb/s SAS/SATA RAID Controller, 1Gb DDR4 Cache,
>>>> with Internal & External Ports
>>>> 10GbE Dual-Port SFP+ (Direct Attached) Server Adapter - Intel E10G42BTDA
>>>> 1st Year 24/7 Support - Up to 4 hours after submission of ticket, up to
>>>> 5 incidents per year
>>>>
>>>> £9,618.81 Ex. VAT
>>>>
>>>>
>>>> The E5-2699 v3 Intel 18 Core is a single chip processor, so my
>>>> understanding has always been it only needs one license, but I am no
>>>> licensing expert!
>>>>
>>>> From http://www.oracle.com/us/corporate/pricing/sig-070616.pdf
>>>>
>>>> When licensing Oracle programs with Standard Edition One or Standard
>>>> Edition in the product name, a processor is counted equivalent to an
>>>> occupied socket; however, in the case of multi-chip modules, each chip in
>>>> the multi-chip module is counted as one occupied socket.
>>>>
>>>> But as Alfredo and Svetoslav have said a change in licensing might make
>>>> this a pointless exercise.
>>>>
>>>> Oh well!
>>>>
>>>>
>>>>
>>>> On Wed, Aug 26, 2015 at 4:33 PM, Mark Brinsmead <
>>>> mark.brinsmead_at_gmail.com> wrote:
>>>>
>>>>> This is true. However, finding single-socket servers can be something
>>>>> of a challenge.
>>>>>
>>>>> The example cited seems to work -- unless that 18-core processor is
>>>>> implemented as a multi-chip-module ;-) -- but the majority of servers these
>>>>> days are equipped with at least two sockets. You'll also need to make
>>>>> certain your single socket server has enough network interfaces.
>>>>>
>>>>> I don't know whether Oracle ever removed the language about multi-chip
>>>>> modules from the OLSA. If they haven't though, it (still) makes license
>>>>> management with SE very tricky.
>>>>>
>>>>>
>>>>> On Wed, Aug 26, 2015 at 3:05 AM, Tom Dale <tom.dale_at_fivium.co.uk>
>>>>> wrote:
>>>>>
>>>>>> As I read it you can 4 nodes,
>>>>>>
>>>>>>
>>>>>> https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=358910255816631&id=220970.1&_adf.ctrl-state=znnb3zko4_57#A5750
>>>>>>
>>>>>> Oracle Database Standard Edition can only be licensed on servers that
>>>>>> have a maximum capacity of 4 sockets. If licensing by Named User Plus, the
>>>>>> minimum is 5 Named User Plus licenses. Oracle Database Standard Edition,
>>>>>> when used with Oracle Real Application Clusters, may only be licensed on a
>>>>>> single cluster of servers supporting up to a total maximum capacity of 4
>>>>>> sockets.
>>>>>>
>>>>>> *NOTE: This means that the server capacity must meet the restriction
>>>>>> even if the sockets are empty, since they count towards capacity.*
>>>>>>
>>>>>> So if you have 4 single *socket* servers
>>>>>>
>>>>>> eg you could have a single 18 core intel 2600 v3 with 512gb of ram in
>>>>>> -
>>>>>>
>>>>>> http://www.supermicro.com/products/system/1U/1018/SYS-1018R-WC0R.cfm
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Aug 26, 2015 at 12:40 AM, Fernando Andrade <
>>>>>> correo_at_fjandrade.com> wrote:
>>>>>>
>>>>>>> Thanks _at_Joe
>>>>>>> The answer was in the referenced doc. 220970.1
>>>>>>>
>>>>>>> On Tue, Aug 25, 2015 at 6:33 PM, Sweetser, Joe <JSweetser_at_icat.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Check out Doc ID 220970.1 on MOS/metalink (old school J ).
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Short answer is yes but there are a few restrictions.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Hth,
>>>>>>>>
>>>>>>>> -joe
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>>>>>>>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Fernando Andrade
>>>>>>>> *Sent:* Tuesday, August 25, 2015 5:23 PM
>>>>>>>> *To:* Oracle-L Group <oracle-l_at_freelists.org>
>>>>>>>> *Subject:* Extended RAC on SE
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Hi I recieved an extrange request for a client.
>>>>>>>>
>>>>>>>> He wants a extended RAC on SE, I have found this reference googling:
>>>>>>>>
>>>>>>>> http://isu.ifmo.ru/docs/doc111/license.111/b28287/editions.htm
>>>>>>>>
>>>>>>>> "Extended or stretch clusters are not supported with Standard
>>>>>>>> Edition and Oracle RAC. An Extended or stretch cluster is defined as "A
>>>>>>>> cluster where all nodes are not located in the same room"
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> I havent found this paragraph in the documentation provided by
>>>>>>>> Oracle nor in 11.1, 11.2 or 12.1.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Any one with more information? Thanks
>>>>>>>>
>>>>>>>> FJA
>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>> ---------------------------------------
>>>>>>>> Fernando Jose Andrade
>>>>>>>> http://www.fjandrade.com
>>>>>>>> 0983032550
>>>>>>>> twitter: _fjandrade_
>>>>>>>> _at_Quito,Ecuador
>>>>>>>> ---------------------------------------
>>>>>>>> Confidentiality Note: This message contains information that may be
>>>>>>>> confidential and/or privileged. If you are not the intended recipient, you
>>>>>>>> should not use, copy, disclose, distribute or take any action based on this
>>>>>>>> message. If you have received this message in error, please advise the
>>>>>>>> sender immediately by reply email and delete this message. Although ICAT,
>>>>>>>> Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for
>>>>>>>> viruses, it does not guarantee that either are virus-free and accepts no
>>>>>>>> liability for any damage sustained as a result of viruses. Thank you.
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> ---------------------------------------
>>>>>>> Fernando Jose Andrade
>>>>>>> http://www.fjandrade.com
>>>>>>> 0983032550
>>>>>>> twitter: _fjandrade_
>>>>>>> _at_Quito,Ecuador
>>>>>>> ---------------------------------------
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 02 2015 - 12:10:52 CEST