Finally …
Oracle Database 12.1.0.2 Standard Edition (SE2) is available for download.
Some information is already available in the Oracle Database Licensing Information. And you’ll find more here: https://www.oracle.com/database/standard-edition-two/index.html
Quoting from the pricing document:
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.”
Download Oracle Database 12.1.0.2 Standard Edition (SE2) on OTN:
(12.1.0.2.0) – Standard Edition (SE2)
 Microsoft Windows x64 (64-bit) |
File 1, File 2 (2.6 GB) |
| Linux x86-64 |
File 1, File 2 (2.5 GB) |
| Oracle Solaris (SPARC systems, 64-bit) |
File 1, File 2 (2.7 GB) |
| Oracle Solaris (x86 systems, 64-bit) |
File 1, File 2 (2.5 GB) |
| HP-UX Itanium |
File 1, File 2 (3.3 GB) |
| AIX (PPC64) |
File 1, File 2 (2.9 GB) |
| zLinux64 |
File 1, File 2 (2.5 GB) |
And on the Oracle Software Cloud (edelivery.oracle.com) which is the recommended download location.
This location has been a corrected download link pointing to OTN as well:
https://www.oracle.com/database/standard-edition-two/index.html
For a good overview about first experiences with Oracle Database Standard Edition 12.1.0.2 (SE2) please see Franck Pachot‘s excellent blog post here:
Please find all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:
- Sept 17, 2015:
SE2 – Some questions, some answers - Sept 8, 2015:
MOS Download for Oracle SE2 - Sept 7, 2015:
Support and Patches for Oracle 12.1.0.1 SE/SE1 - Sept 3, 2015:
Can you have Multitenant with Oracle SE2? - Sept 1, 2015:
Oracle Standard Edition SE2 available for download
–Mike
Hi Mike,
It seems this release is only for Standard Edition. How about Standard Edition One? Is there any plan for SE1? Or 12.1.0.1 is the only choice for SE1?
Thanks,
Pauline
Markus,
I’ve updated the blog post with the licensening information. Please see the pricing doc above.
Cheers
Mike
Pauline,
yes, SE and SEone will only be available as Oracle 12.1.0.1 releases. Whereas Oracle 12.1.0.2 will be automatically SE2.
Cheers
Mike
Hi Mike , great message !
Oracle Database 12.1.0.2 Standard Edition (SE2) it is certified for Windows Server 2012R2 ?
Hi,
certification is exactly the same as for EE 12.1.0.2
Thanks
Mike
Mike,
I know you (probably) have no say in it, but it’s kinda funny that Oracle is again producing a document with new license rules (number of cpu threads) that is to amend the olsa, but has disclaimer in the footer that it is only for educational purposes only and does not constitute a contract or a commitment to any specific term…
In my opinion this kind of practices is fueling the insecurity about oracle licenses and will damage Oracle in the long run.
ok, now that that is of my chest, does the change from SE to SE2 mean that if you want to upgrade you first need to convert the licenses?
And they are only telling now that there will be no SE1 🙁
I have a lot of smaller customers running SE1 on Oracle 11 and they bought 5 NUPS though they only have 2 or 3 users. SE2 requires them to buy a minimum of 10 NUPS.
I see your point but please understand that this is not in my hands.
Cheers
Mike
Johan,
I fully see your point – but I’m the wrong person to address this to 🙁
Cheers
Mike
Hi Mike,
"…each Oracle Database Standard Edition 2 database may use a maximum of 16 CPU threads at any time."
What does this mean exactly? We have a 2 socket Power8 machine with 20 cores (10 per socket) and 160 threads (8 per core). All cores are within one shared CPU pool. Does this simply mean every database may use up to 16 threads out of this shared 160 thread pool?
Cheers, Markus
Hi Mike!
I just installed SE2 and started dbca.
To my surprise there where an option to create the db as cdb and even to create any number of pdb’s!
Does this mean that multitenant is included in SE2?
br
Daniel
Markus,
SE2 has some sort of instance caging hardcoded to 16 threads (not sessions!!!).
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN13332
Mike
Daniel,
Single Tenant (one active PDB) is allowed and will work. My first guess: the DBCA team forgot to disable this choice for creating more than 1 PDB in SE2.
But according to the Multitenant guys the creation of the 2nd PDB will fail later on.
If you’ve had the chance to try it out I’d be eager to get your feedback on what happens IF …
Cheers
Mike
Hi Mike,
Just do clarify. Does this mean __I am allowed to present all 160 threads to any SE2 database__ which will only use 16 threads at any time due to this hardcoded instance caging restriction?
Cheers, Markus
Hi Mike,
in the download files of SE2 there is only a database folder, no grid folder. Where do I get the grid installation for SE2?
Cheers
Klaus
Markus,
my understanding is the same than yours – you may check the excellent blog post of Frank Pachot – he has published some stats about what’s going on when you open more threads:
http://blog.dbi-services.com/oracle-standard-edition-two/
Mike
Klaus,
my understanding and assumption:
Take the regular GI. There’s no difference in GI for SE2 or EE.
Cheers
Mike
Daniel just let me know this morning that he had picked the wrong DBCA from an existing EE installation on the same box.
The DBCA of SE2 allows you to create a container database with only 1 PDB. We call this Single Tenant and this is fully supported and does not require any extra license.
Mike
Hi Mike,
A little bit deeper on Markus question about the thread usage:
1) Do I really need exactly 8/16 threads (or less) or can it be more? (Oracle uses only its maximum number if I read the comments above correctly due to caging).
2) I suppose activated intel hyper threading is counted, so octacore + HT means 16 threads?
3) two sockets means always populated sockets, doesn’t it?
Best regards,
Andreas
Hi Mike (and others).
I still find this new limitation VERY strange.
Basically we have a situation where we want to support RHEL7. On RHEL7 you MUST use Oracle 12.1.0.2. That is fine, but we normally recommend different types of hardware with some of the Intel Xeon E5 CPU’s with 10+ cores.
So then we have the issue! This hardware can no longer be used. With the new rules you can have two sockets, but you can only use one 8-core CPU as this is 16 threads. It makes absolutely no sense.
We need a 12.1.0.2 Standard Edition One that can be used with two sockets (no matter how many cores) and a 12.1.0.2 Standard Edition that can support up to 4 sockets.
Perhaps I have misunderstood this new release. If that’s the case then please bare with me …
br,
Morten
Andreas,
no, you don’t need that number of threads. And I hope that we’ll have an FAQ ready soon.
The SE2 will enforce the maximum via hard coded instance caging by resource manager. You can easily let it sail on a machine with more threads available. Please see the excellent blog post of Frank Pachot who experimented with the thread limitation enforcement:
http://blog.dbi-services.com/oracle-standard-edition-two/
Frank also tried to increase the CPU_COUNT manually – this is not possible above the limit. You’ll get an ORA-2097.
And regarding your other questions, yes and yes (I think). But please wait for the official docs getting completed.
Thanks!
Mike
Morten,
no – it’s not that complicated 😉
You can of course have SE2 on a machine with more cores – but per database you’ll see only 16 parallel threads maximum. No matter how many cores you’ll have in your CPU(s). That is enforced by sort of instance caging.
If we would require that you machine has the max of 16 cores available a lot of the modern CPU machines wouldn’t be usable anymore (including some of our own boxes) 😉
Hope this helps and clarifies 🙂
Mike
Hi Mike,
Regarding your answer to Morten, is it correct in understanding that having SE2 on a server with more than 8 CPU cores or 16 CPU threads is not a violation of the SE2 license agreement. It just that even if you have 32 CPU threads it will behave has if you have just 16 CPU thread?
SE2 license is the limitation on the sockets only and is violated if you have more than 2 sockets per server or more than 1 if it’s in RAC configuration?
Asanga
^^
.. test ..
Asanga,
your understanding is correct.
If you have more sockets then you could always try hard partitioning with OVM etc – but in terms of threads instance caging will limit the usage no matter how many threads your underlying CPU(s) present.
Cheers
Mike
Hi Mike.
I think I understand how it works, but practically, how will I "experience" this limitation? Will Oracle only be able to start 16 background processes?
And in general I do not understand this new concept …!? Are we still to expect a 12.1.0.2 SE and SEOne without the thread limitation? I really do not hope that Oracle is trying to force customers onto 12.1.0.2 EE using this crazy licensing model. Our customers that are today running on SEOne can benefit from the full hardware potential with e.g. 2x 10 or 12 core CPU’s, but when we need to upgrade them to e.g. RHEL7/OEL7, suddenly they can no longer benefit from this as 12.1.0.2 is a MUST on RHEL7/OEL7…!?
What happened inside Oracle since you came up with this crazy new concept?
Sorry, but I do find it very annoying having to deal with this! It is not personal :o)
br,
Morten
Morten,
I see your points but please understand that Oracle license policies is far beyond my scope or knowledge or influence. So I’m not able to comment on this topic.
Regarding your technical question – as I don’t want to repost what others have done already in such an excellent way – may I please ask you to scroll down in Franck Pachot’s excellent blog post here:
http://blog.dbi-services.com/oracle-standard-edition-two/
Scroll down the the topic THREAD LIMITATION.
Thanks again!
Mike
Morten,
forgot to answer the other question:
As far as I understand there won’t be an Oracle 12.1.0.2 SE or SEone.
Thanks
Mike
@Morten
For clarity I work with Mike and I’m a product manager for the Oracle Database
To be clear. We don’t throttle background processes and they aren’t included in the 16 threads…. You can also run as many Oracle SE databases as you want on the the server. 1, 2, 4, 8, 16… up to you. So if you want to run on an Oracle X5-2 (great machine) then go ahead… use all 36 cores or 72 thread processing units.
Dom
I am just trying to understand the 16 thread limit. What does it then mean? When will I hit this limit? Perhaps a few examples, as I think it is quite unclear, and we all seem to think that now all our existing customers will be limited on the existing hardware which cannot be fully utilized.
I agree that we can run many databases on one server, but that most likely won’t happen. Perhaps on non-production databases, but not on production.
– Morten
Hi,
Suppose, we want to use SE2 on 2xT5-2 servers in RAC cluster.
Should we implement Solaris Zone and have all zones with a maximum 1 socket per zone, and install SE2 in zones?
Until Oracle announced SE2 we will planned to use SE on this hardware.
Best regards,
Mikhail.
Mikhail,
as far as my understanding of the license doc goes (and I’m neither a license nor a sales person) you can’t operate RAC nodes with this system (T5-2) as it has already to sockets in one node. For RAC with SE2 (my understanding) you’ll have to have only 1 socket per node. Another alternative would be to remove 1 CPU and leave the 2nd socket unoccupied.
But please check back with your Oracle sales rep. I can’t give any official license advice here.
Cheers
Mike
Mikhail,
maybe your proposal may be allowed as well (hard partitioning of CPUs). Please wait for the official license FAQ as I’m not in the position to comment.
Cheers
Mike
Hi,
i already read Francks blog about thread limitation and Doms clarification about background processes not counting into 16 CPU-threads at a time, but i would want to check how this throttling affects our environment to see if SE2-license is still suitable for us or EE is needed.
Is there a way to simulate this throttle in 11.2 Standard Edition ONE? on Windows?
Or how can i check my thread usage for only the relevant threads (no background tasks) right now with windows tools?
@DOM so i could migrate to SE2 from my two instances on 11.2 SEOne using => CDB1 (PDB 1) having 16 CPU-Threads + CDB2 (PDB2) = 16 CPU-Threads on 1 Hardware-Server?
Sorry my previous post about testing thread throotle on 11.2 windows and 2 CDBs on SE2 had "guest" as name after previewing the post and i forgot to change back to "Ingo". Perhaps you can correct this on moderating my questing.
Regards Ingo
Ok,
how can we upgrade from standard edition 1 to standard edition 2.
I think we have about 20 CPU based SEones.
Do we really have to "invest" $200.000 just to keep getting updates for oracle DBs after summer 2016? ($10.000 is about the price difference between SE1 and SE)
Ingo,
regarding your questions:
I think only monitoring could do the job. Maybe in conjunction with limiting the CPU_COUNT parameter. Usually I would propose using the Resource Manager but as far as I see from the License Guide Resource Manager is not available in SE1.
Yes, you can migrate as you’d proposed. But I’m not sure about the change in license costs between SE1 and SE2. Please check either the license doc for SE2 or with your Oracle sales person.
Tolomir,
please contact your Oracle sales rep. I won’t be able to answer license and pricing questions here. Technically the migration is not a problem at all. But you’ll have to check back with Oracle sales about if there’s any change in pricing for your environment.
Kind regards
Mike
Hi all.
We just had a meeting with our account manager and a product manager. Unfortunately not anything new to add, but one important thing must be to load test your application to see if the thread limit imposes any performance degradation in real life.
And another VERY IMPORTANT issue reg. license – which I hope that everyone has discovered. The SE2 license is now the same as the SE license and NOT the SEOne license. It means that the processor license is now $17,500 and no $5,800. So you have to pay three times as much, but you don’t get any new benefits. Only limitations.
br,
Morten
Hello Mike,
my point is not if we get a discount, at least not in the 1st place. My point is since we run a vmware cluster making it virtually impossible to license EE properly we were forced to run SE1 to license our complete cluster (of 10 server with 2 cpus each) for an amount we were able to pay.
Now the costs to run oracle at all get much higher, with no benefit, letting us more and more think about alternatives.
We will see what times brings. For a year or two not much changes for us. But then it might be a good choice to run our remaning oracle databases as managed services and set a stop oracle flag to new projects…
Tolomir,
I see all your points and I clearly understand them. But please understand as well that I’m not in the position to discuss license and pricing.
Thanks
Mike
Hi Mike, thanks for the blog update.
I’m having a hard time trying to find information regarding the thread capability of Oracle SE versus SE2. Can you point me to a tech paper describing the differences in more detail? As I understand, there’s no limitation on thread execution on SE, can you confirm this?
We currently are running a two node RAC of 10g SE in the middle of a migration to a two node RAC of 12G SE, the new servers are two socket servers but with only one 12 core xeon cpu installed. Are there any limitations to this setup if we want to migrate to SE2 in the future? Will be the two socket servers conform to the new licesing?
Thanks.
Regarding (networking@coomecipar.coop.py):
If your server is a 2-socket-server with only 1 socket populated you are all set.
Regarding the 16 thread (singe instance) or 8 threads (RAC mode) you’ll find more information here:
http://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN13332
(Topic: Instance Caging).
Thanks
Mike
Additional clearification on 4 socket / 8 socket servers by Oracle:
a) Definition of „One Socket Server“:
SE2 is designed and intended only for 2 socket servers. Our definition of a one socket server is either
• A server designed explicitly as a one socket server with a single CPU populated.
• A server designed as a two socket server with a single CPU populated and the other socket empty.
• A server designed as a two socket server with two CPUs populated but using hard partitioning (per any of the approved hard partitioning technologies as presented on the partitioning document) to bind a VM to a single CPU/socket.
The only servers that you can install Oracle Database SE2 on is a 1 or 2 socket server.
• You cannot install Oracle SE2 on a 4 socket server with only 2 CPUs installed
• You cannot install Oracle SE2 on a 8 socket server with only 2 CPUs installed
• You cannot use hard partitioning (i.e OVM) on a 4 socket server to bind a VM to just 2 sockets/CPUs
• You cannot use hard partitioning (i.e OVM) on a 8 socket server to bind a VM to just 2 sockets/CPUs
• You cannot use the BIOS to disable CPUs on any server (2,4,8 etc) and consider this an empty socket(s)
You can install Oracle SE2 on a server with
• A single socket server
• A dual socket server with one or both CPUs enabled
• A dual socket server that uses hard partitioning (i.e. supported hard partitioning software) to bind a VM to a specific CPU for the purposes of running
SE2 single instance on a single CPU or running RAC across 2 dual socket servers.
Basically Oracle SE2 can only ever run on a 1 or 2 socket server. The server may have as many cores as you like. >>> You may run as many databases as you like on the server.<<<
b) Definition of “Thread”:
The thread limit of 16 threads per database (RAC: 8threads per Database on 1 Server = 2×8=16) per is coded in the product. Threads are logical processors (=Hyperthread-Processors). It only applies to user processes (not our background processes).
For SE1 to SE2 upgrades our oracle sales rep. says only a support licence uplift/increase (certain percent) needs to be paid for us.
Regards Ingo
Ok here comes the interesting question:
Assuming we got a vmware cluster with 4 servers each having 2 cpus with 10 cores. The cluster is managed my VI that provides failover.
We are not running any RACs just simple oracle se2 databases.
Giving the licensing condition we would license 4 physical servers with one SE2 license for each of them.
Since it is not possible to run a virtual server on 2 physical servers concurrently I think this setup would be compliant to the oracle licensing conditions, isn’t it?
I.e. we agree to license all 4 physical servers to run 1…n virtual servers running oracle SE2 databases (i.e. same licensing condition as with windows servers)
So now this is the question, since each physical server comes with 10 cores, 2 cpus altogether, we are allowed to run each SE2 with 8 virtual cpus right? (8 cores of a single cpu or a mix of 2 cpus)
Or are we forced to count virtual cpus (i.e. cores) as physical cpus and assign just 2 vcpus to an oracle database?
Tolomir,
as said before, I can’t and won’t answer license questions. Please contact your Oracle sales rep. I’m not familiar with this topic.
Thanks
Mike
@Tolomir,
as far as I understood for your Environment:
4 physical servers, each with two sockets, every socket populated with a 10-core CPU,
no other servers connected to the shared storage,
only one VMware Cluster (VMware 5.0 or smaller) or only one vCenter (VMware 5.1 – 5.5),
no RAC
you need 8 Processor licenses of DB SE1 or DB SE2.
The maximum usage of threads is hard-coded in the DB-software. So you are allowed to run DB SE2 on a fully equipped 2-socket 10 core server with dual hyperthreading enabled (2x10x2 -> 40 virtual cores). The DB will use only 16 Threads.
1.5 years of development work done, with the plan to deploy on SE1, since it’s an affordable cost for a small startup to pay just under $2000 in software licenses per year. It works out and it’s something you can make back in a year, in exchange for running it on a familiar, robust and well supported software stack.
Now you’re not only charging a minimum of $8000, for EXACTLY THE SAME THING, you’re also stopping sales of the SE1 licenses end of next month? This means that all that work is gone. Poof.
I can’t but ask: Why??
What’s to gain from screwing over SMEs like that?
Stefan
Stefan,
I see your points – the only thing I can offer you is to drop me an email in English with your situation and concerns – and I can route it internally to people who may be interested in such feedback.
But please understand my situation:
This is far beyond my scope. It is a company decision. So personally I can’t offer you a solution. But you may contact your Oracle sales rep to discuss this in broader details.
Thanks
Mike
Hi,
Say I have a server that has 4 sockets, but 2 are physically empty, and the other 2 are populated and used.
Is it then a ‘2 socket server’ , or a ‘4 socket server’?
😉
I think you’ve answered your question by yourself already.
A "4-socket server" is a "4-socket server".
Cheers
Mike
Hello Mike,
Thank you for your answer.
But I am left confused.
Higher up in the thread it states (Posted by Ingo on September 17, 2015 at 06:42 PM CEST): "
Additional clarification on 4 socket / 8 socket servers by Oracle:
a) Definition of „One Socket Server“:
SE2 is designed and intended only for 2 socket servers. Our definition of a one socket server is either
• A server designed explicitly as a one socket server with a single CPU populated.
• A server designed as a two socket server with a single CPU populated and the other socket empty.
"
Extrapolating remedial math and applying the same logic (last statement of above multiplied by 2 would read: "a four socket server with two CPU populated and the other two sockets empty would be considered a ‘two socket server’."
Or is the statement by Ingo false?
Alex,
Ingo’s statement is correct. Oracle came out with that very special definition of a one-socket-server.
But you can’t apply math and logic and multiply by 2 for the definition of a two-socket-server. A two-socket-server is a server thst has not more than two sockets.
Kind regards,
Michael Paege
Mike,
How does this affect the current SE and SE1 customers that purchase their ESL licenses through an ISV?
Best,
Please see above:
I’m not able to answer license questions regarding how to migrate licenses or how does it affect … 😉
Appologies but this is far beyond my scope and responsibilities. Please get in touch with either your Oracle sales contact or with your ISV’s rep.
Thanks and all the best
Mike
Alex,
Michael is correct – you can’t extrapolate as license rules don’t follow plain math 😉
The restriction is simply:
SE2 is not allowed to be used on a server with more than 2 physical sockets. No matter if you’d remove CPUs from other (such as 3 and 4) sockets.
Cheers
Mike
Hello,
what about 16 threads limitation in 2 nodes rac confguration and its split 8+8 when one of them is down (eg maintenance, hw failure, etc.)?
Will the only active one be able to run the overall 16 threads or not?
Anyone already tried?
Thanks
Gianluca
Hi,
as it is enforced via CPU_COUNT it will depend on whether CLUSTER_DATABASE=TRUE or FALSE. Therefore (without having it tried out yet) my assumption would be simply that as long as CLUSTER_DATABASE=TRUE the CPU_COUNT will be 8 whereas you switch CLUSTER_DATABASE=FALSE you’ll get 16.
As I don’t have an SE2 RAC here to test this is my assumption only.
Cheers
Mike
Hi
I am working on EE to SE software migration, and looking ahead to work on SE2, but unfortunately I didn’t find example cd as download for SE2.
Please let me know how can I have it.
Thanks
Shaik
Hi Mike.
Just a general comment. I have by now understood that you do not comment on licensing :o).
I would still like to express my concern/worries about this new licensing concept! One thing is that everyone now have to pay more (MUCH more as SE/One has been used a lot for our customers), BUT at the same time Oracle introduces the thread limit.
Suggestion: At least make some of the EE (extra cost options) available in SE2. Has this ever been considered by Oracle?
Examples: Rebuilding indexes online, parallel RMAN backup/restore, parallel Datapump export/import.
It’s identical to EE’s – shared.
Cheers
Mike
Morten,
I fully see all your points.
In fact that all gets decided many hierarchies above my head. So there’s really nothing I can do for you except tell me that I understand all your points but you should really contact your Oracle sales rep to discuss this topic.
Thanks
Mike
Any pointer about possibility to use ACFS on SE2 RAC environment for database files and other Oracle structure?
In the manual it says you have to use ASM in SE2, but overall ACFS is indeed based on ADVM/ASM…
Thanks for any pointer in case.
Gianluca
Gianluca,
thanks for your message.
Please see here:
https://docs.oracle.com/database/121/DBLIC/editions.htm#CIHDDJCJ
And further down below:
Oracle Database Standard Edition and Oracle Real Application Clusters (Oracle RAC)
When used with Oracle Real Application Clusters in a clustered server environment, Oracle Database Standard Edition requires the use of Oracle Clusterware. Third-party clusterware management solutions are not supported.
The license restrictions for Standard Edition must be adhered to. The maximum number of CPUs defined is for the entire cluster; it is not a per node maximum.
Oracle Automatic Storage Management is required for creating and managing all Oracle database file types. Raw volumes, partitions, or third-party cluster file systems are not supported for storing Oracle database files with Oracle Standard Edition and Oracle RAC. Refer to Oracle Automatic Storage Management Administrator’s Guide for a comprehensive list of all database file types.
ASM Cluster File System (ACFS) or a local OS file system must be used to store all non-database files. No Oracle-maintained copies of any non-database files can exist in any other locations, with the following exceptions:
Customers who want to manually script maintenance of a standby database can create a second copy of their archive logs outside of Oracle ASM on a local file system only, designated by the LOG_ARCHIVE_DEST_n parameter.
RMAN backups of files can reside on either a local or network mounted file system.
No other cluster software can be installed on the system, including OCFS, OCFS2, third-party clusterware, third-party cluster volume managers, and third-party cluster file systems.
Hi Mike
According to the SE2 features at
https://docs.oracle.com/database/121/DBLIC/editions.htm#DBLIC116
Instance caging and Resource manager are not available.
If I have SE2 can I change the cpu_count below 16 and use own resource manager plan?
Hi Mike,
I’ve just been on a Oracle SE2 webinar from Allen Hoke. Oracle said going to SE2/12.1.0.2 we would get the following benefits/new features
– Full database caching
– Instance Caging
– Resource Manager
Of course Instance Caging and resource manager have been around for a while now on EE.
However it looks like can’t change the resource manager plan.
So yet again it looks to me like oracle are not telling the full truth. Yes SE2 is using the features instance caging and resource manager but only to implement the 16 thread restriction and cant change the plan or create your own new plan.
So not only do we have the 16 thread restriction also at the mercy of the oracle resource plan which can’t be changed.
Could you confirm this please
thanks
Brian
Brian,
the link you’ve provided is correct – but when you look down in the table for Instance Caging you’ll find in the NOTES column: "Included with SE2 and EE. Not included with SE1 and SE"
The Resource Manager works implicitly – therefore no interface to the customer for SE2 – but it ensures the limitations. That’s why it is not included as an extra feature for SE2 – nothing you could tweak.
Hope this helps – cheers
Mike
Brian,
and regarding the seminar you’ve attended you may please contact Allen directly (firstname.lastname@oracle.com) as I didn’t say or write that Resource Manager is included.
In fact Resource Manager as an API or feature for self-usage is not included and you have linked the doc correctly already in your other comment. Instance Caging is included in SE2 but Resource Manager works underneath the covers but not in any way that you can create a resource plan by yourself.
I can only imagine that Allen wanted to say it like that but I haven’t participated in the webinar so I can’t say anything further.
Cheers
Mike
Hello Mike,
For SE1, I have two sockets with 8 cores each.
If I want to use only one socket for each instance, how can I achieve that?
Can I set CPU_COUNT to 8?
Saby,
regarding your question:
"For SE1, I have two sockets with 8 cores each.
If I want to use only one socket for each instance, how can I achieve that? Can I set CPU_COUNT to 8?"
That won’t work out as expected as CPU_COUNT=8 will introduce a limitation to 8 concurrent threads – but won’t pin the load to CPU socket 1 or 2.
The option I see if you really want to pin the load of database 1 on CPU 1 and database 2 on CPU 2 is hard partitioning such as OVM offers. This would allow you to introduce such a separation.
Cheers
Mike
Does Oracle Database 12.1.0.2 Standard Edition required additional license as monitoring target of Oracle Enterprise Management Cloud Control?
Does Oracle Database 12.1.0.2 Standard Edition required additional license as monitoring target of Oracle Enterprise Management Cloud Control?
You can monitor SE or SE1 or SE2 or EE without the need for additional licenses – hope that I understood your message correctly.
Cheers
Mike
Mike,
One more question, does additional of diagnostic and tuning pack need to purchase for monitor Oracle DB by Oracle Enterprise Manager Cloud Control.
Roger
Roger,
You can do basic monitoring of SE[12] with OEM. You don’t need additional licenses.
Be warned. You _must not_ send any notifications (email, traps, sms,…). It _works_ but notification require the diagnostic pack license which is only available for EE.
Roger,
just make sure that you’ll have the init.ora/spfile parameter CONTROL_MANAGEMENT_PACK_ACCESS=NONE instead of the default ‘DIAGNOSTIC+TUNING’ – and in addition you may go into the EM Setup (find it in the right upper corner), and configure which packs you have access to.
That should do the job.
Cheers
Mike
unzip is giving me the below error.. please help
$
$ unzip aix.ppc64_12102_SE2_database_1of2.zip
Archive: aix.ppc64_12102_SE2_database_1of2.zip
End-of-central-directory signature not found. Either this file is not
a zipfile, or it constitutes one disk of a multi-part archive. In the
latter case the central directory and zipfile comment will be found on
the last disk(s) of this archive.
unzip: cannot find zipfile directory in one of aix.ppc64_12102_SE2_database_1of2.zip or
aix.ppc64_12102_SE2_database_1of2.zip.zip, and cannot find aix.ppc64_12102_SE2_database_1of2.zip.ZIP, period.
$
$
Mike,
Can I upgrade my existing SE license to SE2 but retain the installation as SE ? I will licensed as per SE2 license requirement.
Please ask your Oracle sales rep for any questions regarding licensing and license upgrade questions.
Cheers
Mike
@guest: AFAIK it is possible to license DB SE2 and use DB SE1 (e.g. 10.2, 11.2 or 12.1.0.1) if and as long as you pay your support fee for the DB SE2 license. If you do so you have to meet the resstrictions fro DB SE2 (2 Sockets, 16 threads, …).
Kind regards
Michael Paege (non-Oracle-employee)
Sadly, I think I will be downloading Postgres instead… Too bad, I remember Oracle from the Oracle 6 days on Data General, but it is just getting too expensive for what it provides compared to open source solutions, for those of us with modest database needs that where well served by SE1. 11.2 SE1 is where it ends for us. I might have been able to swallow SE2, with its two socket limitation, but I cannot understand the 16 thread limitation. IT IS INFERIOR to SE1 in every way, it should have been called SE 0.5 instead of SE2.
Hi there, i would like to ask :
I have 1 Hyper-V server, in one of the VM already setup with Oracle Standard Edition version 11.2. Can i make use of this Oracle license to create another DB in new VM ?
Ashvind,
unfortunately I can’t tell you as I’m not a license expert and I can’t give any license advice. As you are based in Malaysia (based on the email you’d been given) would you mind to call your local Oracle rep please:
https://www.oracle.com/my/corporate/contact/index.html
Toll Free Number:
Toll-Free No: 1800-801-837
E-Mail:
SALESINQUIRY_MY@ORACLE.COM
Thanks in advance – cheers
Mike
Hi Mike! Came across your blog while doing some research on Oracle SE/SE1/SE2 licensing.
Would like to ask If I have 2 x Oracle SE/SE1/SE2 Standard Edition Processor license, is it possible to license SE/SE1/SE2 (without RAC) across 2 x two-socket servers that have only 1 socket populated on each? (I know in RAC mode it is possible)
@Ming:
Sorry Ming but I’m not able to assist with license questions. You may please contact your Oracle office.
Cheers
Mike