Many of you have probably already read from the internet, that Oracle is first distributing the new 12.2 Database to the Cloud, and then at a later stage it will become available for customers who still prefer the On-Prem option (http://www.theregister.co.uk/2016/06/24/oracle_cloud/).
“Cloud is growing, however, and software licensing continues to shrink. This is true right across the industry from Adobe, to IBM to Microsoft.”
Oracle for Small Business Enterprise (SME)?
Can SMEs afford an Oracle Database, or this database only for bigger companies?
Oracle provide a Cloud option for Small and medium-sized enterprises (=SME). The costs for a Standard Edition Cloud Service is according to an Oracle slide approx. £4050 per month.
After the release of their Engineered Systems ODA X6/S and ODA X6/M, which include a bare metal Standard Edition 2 installation for a list price of $18000, I would be tempted to say that Oracle do care about small customers as well.
As a comparison here is the price list for Microsoft SQL Server 2016.
At a first glance, the price difference between the two doesn’t seems to be major, so the argument I hear a lot “Oracle is too expensive” seems a little bit enlarged. Other arguments or just “we don’t know the technology”, sounds more proper when deciding what database to use.
Oracle Database Cloud Service Standard Edition
In May this year at OUGF Conference I had the privilege to talk to Mr. Luis Moreno Campos, who is the EMEA Director, Data Management Cloud at Oracle EMEA. he said that Oracle is concentrating on Cloud, and in the long run we will see less On-Prem environments on the market.
As I told him, we all know a DBA who just needs to be able to “hug” the Database server every know and then. For long I have been a strong believer in ODA, and now Standard Edition 2 is finally available as a bare metal option. So, Oracle didn’t forget all DBAs who just loves to have a physical server luring in the room next door, Pretty cool – and yet an opportunity for Standard Edition Community.
Upcoming post…..Standard Edition Cloud Service – Is it easy or not?
Oracle has just officially announced, that “Little Brother Standard Edition2 Database” has joined the Oracle Database Appliance family.
Started in 2014
It was back in the beginning of 2014 when I first got acquainted with the ODA solution. I have also written about my thoughts on both LinkedIn and on my blog (sejustloveit.com). This old video of ODA will give you a feeling about what it is and what it may provide.
Back in autumn 2014 I asked Mr John Abel, Head of Technology and Cloud for UK, Ireland and Israel at Oracle if it had ever crossed Oracles mind, to make ODA the “Little Brother of EXADATA”, and by so providing an affordable smart solution to small customers”.
Passionately I tried to convince people in Oracle Community about the missing opportunities a ‘Standard-Edition-Bare-Metal-ODA’ solution would bring to the community, but everybody told me “Forget it! Oracle will never make a ‘Standard-Edition-Bare-Metal-ODA’ solution available!”.
Pardon me for saying: “With passion, innovation and creative thinking things do happens, and SE JUST LOVE IT”. Makes me feel good.
UKOUG TECH15- ODA Director
At UKOUG TECH 15 Conference I finally had the opportunity, to talk to Tammy Bednar, Director Product Management, Oracle Database Appliance at Oracle, about ODA with a SE Bare Metal solution. Since then, I have asked and asked, and Thanks Tammy to You and your Oracle team mates. It would be a pleasure to meet the “gang” who made this solution come true!
Have I tested ODA X6/2S?
To my knowledge there are no such service available as an “ODA test drive Cloud”, that would give you an insight on what it is and what it isn’t. Like it is with a new car; everybody wants to test drive before buying – right?
So the answer to the question is unfortunately I haven’t been able to make a deeper test drive. Is there things a Standard Edition DBA should “avoid”? That would be a great thing to explore, and write about. For sure there are much to explore from a Standard Edition point of view. To my understanding, there are “gadgets” in there, that are only available with the Enterprise Edition version of ODA. Will the need of innovative thinking vanish in an ODA X6/2S 2/M? Left to see.
CTO / CIO a ‘ODA X672S’ solution?
IMHO this is a solution worth checking. The costs building a new system will probably be less, than the standard way -buy a server and then start building the system. A customer told me once, that it took them 6 months to get a new server up and running.
Here is some material ODAX6-2CustomerPresentation I received from Tammy. I hope it will guide You, when you start to explore this new solution for your Standard Edition Database. Thanks Tammy
And the entry List Price for X6-2S is $18.000. Did I make you interested?
Oracle Standard Edition Community will have the opportunity to choose from two different “ODA SE2 Bare Metal” versions ODA X6-2S and ODA X6-2M.
Database Appliances for Every Organization – X6/2S/2M
it doen’t yet support virtualization
contains a new Appliance Manager (ODACLI)
NVM Express (new standard for PCI Express (PCIe SSD))
works directly with PCIe interface, No SCSI protcol overhead
there is an REST API that supports Oracle Cloud
SE2 License model is either 1-socket (X6-2s), a 2-socket (X6-2M) or NUP based (NUPS/min 10 users/server)
Security is “Built In, and not Bolt out” – Oracle (c)2016
Secure Oracle Operating System (default to highest levels of security)
Advanced Security Features (EE only)
Secure Out-of-the-Box (RPM requirements)
Timely System Updates (single patch for entire stack)
Complete In-house HW Design( Motherboard, BIOS, and service processor firmware designed 100% Oracle)
High-speed for memory
High Available Network Connectivity
High performance and reliable OS storage
Oracle has today released ODA X6/2S and ODA X6/2M solution that has a Standard Edition 2 Bare Metal Installation.
Is this an opportunity for Oracle Standard Edition Community? Is this an affordable solution for a small customer, and will the customer be able to start small and let his business grow, and eventually be able to upgrade to EE+ODA technology when his business requires? IMHO I think so.
Will ODA X6/2M or ODA X6/2S have a fair chance in the Cloud society? I think we all know at least one DBA, who once in a while loves to hug his DB Server, to check that everything is ok – So, yes I do believe there is a positive future for this solution.
What do you think?
Take care, stay well, and let’s stay curious in life!
From all kind of social medias, I have since Harmony2014 Conference seen a growing activity around the Oracle Database Standard Edition database. People within Oracle Community, including people working only on an Enterprise Edition database environment , have blogged, talked, asked advices etc about the obstacles, struggles, and solutions that the Standard Edition database can/will/have caused.
In April this year, at the OUGN conference this thought of bringing the Standard Edition Database Community together grew and thanks to the UKOUG committee we finally had a Standard Edition Track at the TECH15 Conference in Birmingham 7th-9th December 2015.
Now sitting at the airport in Copenhagen on this Wednesday the 9th Dec reflecting what has been accomplished, I have the same feeling I had after winning my first Gold medal in an European Championship. I feel proud, joy, emptiness, and have high expectations for the future of the Oracle Standard Edition database.
Super Sunday Reflections
As a first timer at UKOUG conference, this was a nice way to get acclimatised. I had the opportunity to listen to
Developing Applications for RAC & Exadata – What You Need to Know by Bjoern Rost – portrix Systems GmbH
12c Features for Developers by Connor McDonald – Oracle
Transforming One Table to Another: SQL or PL/SQL? By Bryn Llewellyn – Oracle and Co-presenter(s): Jonathan Lewis.
And the take-away from Sunday: “Super Great Experience”. If you haven’t tried it yet, I recommend to schedule it at TECH16 Conference.
7th Dec SE Track Reflections
Penny Avril, VP Oracle
We were loaded with many speakers, and a Roundtable.
Many great thoughts, and discussions from both the audience and the speakers during this day. We had the honour of having Penny Avril, Vice President of Oracle and Dominic Giles, Product Managers for the Oracle Database from Oracle listening to some of the talks, and of cause we grabbed the opportunity to exchange our concerns and thoughts that the Standard Edition Community are having.
The speakers of first Standard Edition Track
An Insight into Oracle Standard Edition, What’s Included, What’s Not, and How to plug Some of Those Holes! By Tom Dale – Fivium
Standard Edition Something for the Enterprise or the Cloud? by Ann Sjökvist – SE – JUST LOVE IT
Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You by Marcin Przepiorowski – Delphix
Silent but Deadly : SE Deserves Your Attention by Philippe Fierens – FCP & Jan Karremans – Jk Consult, ACE
Oracle SE – RAC, HA and Standby are Still Available. Even Cloud! by Chris Lawless – Dbvisit Software
SE DBA’s Life a Bed of Roses? by Ann Sjökvist – SE – JUST LOVE IT
Standard Edition Round table
Also at our Standard Edition Roundtable we had the pleasure of beside Dominic Giles having Jonathan Lewis, and Maria Colgan, Master Product Manager For Oracle Database In-Memory.
Oracle support Standard Edition 2 and have plans on doing so for a long time
We received a promise, Oracle will provide a version of SE2 for long, so……
Can we focus on enjoying the Standard Edition 2 opportunities and find good solutions and helping our customers, instead of complaining about the loss of SE1/SE?
Might the old on-premises model be replaced with the Cloud solution, and might the Cloud solution provide a better ROI for a small company?
Can we stay open-minded and give SE2 a chance?
Are we able to provide a solutions for our customers with SE2?
Personally I think so. After talking to a person about cloud and security I’m starting to look at cloud in a different way. He said:
“Oracle have a far bigger budget on hiring the best security specialists in the world, than a small company ever can dream of. So yes, it’s as secure environment as it can be according todays standard”
Finally I would like to thank all our attendees, speakers, and Penny, Dominic, Maria, Jonathan and all the others for attending our Standard Edition Track and the Standard Edition Roundtable.
Also a huge thanks to UKOUG who made this possible.
Take care, stay well and let’s make something positive out of SE2 opportunity!
I will be speaking at DOAG 2015 in less than two weeks!
This is my first time as both a speaker and a visitor, and I am looking forward to this event. I enjoy the opportunity to meet new people and old friends, and I would love to meet up with you personally to exchange thoughts about Oracle Database Standard Edition; or any other topic that might be on your mind. Just grab my arm if you feel for making the acquaintance.
Here is my schedule for the week:
Tuesday, November 17th – arrives (depending on what train I catch, but in the afternoon)
Wednesday, November 18 – gives presentation
08:00 am – 08:45 am Standard Edition Database something for the Enterprise?
Thursday, November 19 – before noon back to Frankfurt
So between November 17-19 – I look forward to meeting you in Nuremberg, Germany at DOAG 2015 Conference+Exhibition!
There are so many good speakers and sessions this year, and very difficult to choose among them, so my personal “chocolate box” contains these others sessions, so let’s see how much I can “consume”. If my travel arrangements had been more favourable I would have also loved to attend these sessions on the 17th:
09:00 am – 09:45 am -Big Data SQL New Features and Roadmap -Jean-Pierre Dijcks
09:00 am – 09:45 am -Saltstack und Oracle – Salzen Sie ihre Installation+Konfig -Martin Bracher
11:00 am – 11:45 am -Transforming one table to another: SQL or PL/SQL? -Bryn Llewellyn
09:00 am – 09:45 am -Best of RMAN Selected features from four versions -Uwe Hesse
11:00 am – 11:45 am -Bad Boys of On-line Replication – Changing Everything – Jan Karremans
12:00 pm – 12:45 pm- Core Strategies for Trouble-shooting-Jonathan Lewis
1:00 pm – 1:45 pm – Combining Relational and Document Storage: The Latest in NoSQL Development with the MySQL Database -Tomas Ulin
Article about Some useful tools from my SE Toolbox…and some SE2 License stuff at the end 😉
A New kid on the block – SQLCLI
As a Standard Edition DBA, I’m sure you have numerous times used the good old SQL*PLUS. Recently I noticed that the new SQLCLI tool is not a common known fact among “DBA’s not attending any conferences”, so I like to promote this nice new tool to the Standard Edition database DBA’s toolbox.
The Oracle SQL Developer Product Manager Jeff Smith’s team has developed this new tool “SQLCLI”, and it can be downloaded from SQLDeveloper homepage. (scroll down the page).
After the download and installation, it is ready for use. Note! On my mac the “sql” didn’t run, so I just started the java jar file from the “sqlcli/lib- directory:
SE2mac$ java -jar oracle.sqldeveloper.sqlcl.jar hr@//se12t1:1521/se2pdb
Why not Check some youtube videos about SQLCLI, to get the drift about this tool?
In older versions of SQLDeveloper, I faced some pitfalls with the predefined DBA reports. For example I was able to use the “AWR reports” without any notifications about violating the license agreement in my Standard Edition database.
The latest version of SQLDeveloper, version 4.1.1, will give you a warning about the license requirements:
And why do you need to READ this note and answer NO?
By answering YES, I am able to use these AWR reports without any problems, and if proceeding I will violate the License agreement, since I am on a Standard Edition 2 database environment.
Note! Also in a Enterprise Edition database this violation is possible, if you haven’t purchased the “Diagnostic&Tuning Pack”.
By answering YES, you will be able to use the reports as shown in the screenshot below:
The “dialog” warning, looks like a normal behaviour independently of the software. For example TOAD software provide with the same kind of dialog during the installation phase. And remember, you can at any later state enable the pack, by changing the softwares preferences/properties; so an other challenge to remember.
Standard Edition 2 on the Menu
After a long wait amongst people in the Standard Edition Community, Oracle Corporation finally released the 220.127.116.11 edition of the Standard Edition Database on the 1st of September.
With this release, lots of buzz has been generated in all Social Medias available, and lots of blog posts have been generated.
As always, a message can be interpreted in many ways, and both good and less good stuff can be found out there on what this SE2 realease bring to the table; after you have carefully read the license documents available, and still feeling unsure, please check with your local Oracle LMS before making any false or unecessary assumptions on the impacts on your business.
Some small rules to remember about SE2
The minimums for Database Standard Edition 2 are 10 Named User Plus licenses per server
This metric is used in environments where users can be identified and counted.
Install onto a servers that have a maximum capacity of 2 sockets (*see)
Oracle Database Standard Edition 2 database may use a maximum of 16 CPU threads(**see) at any time
Oracle Real Application Clusters, Oracle Database Standard Edition 2 may only be licensed on a maximum of 2 one-socket servers
on RAC – each Oracle Database Standard Edition 2 database may use a maximum of 8 CPU threads per instance at any time
Hard partitioning (*** see) can be used on 2 sockets servers to enable you to run RAC on 2 two socket servers with both CPUs populated
(*)When licensing Oracle programs with Standard Edition One, Standard Edition 2, 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.
(**)From the CPU's perspective, a thread (short for "thread of execution") is merely an ordered sequence of instructions that tells the computer what to do.
So when someone talks about a "multithreaded processor," they're talking about a processor that can execute multiple instruction streams simultaneously. There are two ways that a processor can perform such a feat: simultaneous multithreading, and using multiple cores. Neither of these methods is mutually exclusive, and both are often used together.
*** HARD partitioning physically segments a server, by taking a single large server and separating it into distinct smaller systems.
*** SOFT Partitioning: Unless explicitly stated elsewhere in this document, soft partitioning (including features/functionality of any technologies listed as examples above) is not permitted as a means to determine or limit the number of software licenses required for any given server or cluster of servers.
Block Change Tracking – a feature not available in Standard Edition
The best of the Oracle Community, is the joy people obviously feel from sharing great stuff, and I’m sure some of you have already read this great article by Mr Arupa Nada on how this magic Block change tracking feature can boost the performance of a RMAN incremental backup.
Even though a standard edition database may not use this feature I suggest you read this post, because this might be one of those factors that have an impact on the customers business.
The license information on this feature:
Feature/Option SE1 SE/SE2 EE Notes
Block change tracking for fast incremental backup N N Y
Today is a great day for Oracle Standard Edition Community!
The “Oracle Database Standard Edition 2 (=SE2)” has been released, and can now be downloaded.
What’s new with SE2?
The concepts “Standard Edition (=SE)” and “Standard Edition One (=SE1)” is gone, and the new name is “Oracle Database Standard Edition 2 (=SE2) edition”
Oracle Database Standard Edition (=SE) Licensed Customerscan download the new SE2 without any extra costs
Standard Edition One (=SE1) Licensed Customers can download the new SE2 with an extra migration fee. Yes, that’s right. Without the extra migration cost, these customers are not allowed to migrate to the SE2.
The Oracle Database Standard Edition Two (=SE2) will have a restriction of max 2 sockets, and max 16 threads/database. And if hyper thread is in use, there is a max 8 threads/database.
The RAC feature will be available in the new SE2 release. Please keep in mind the max 2 socket and max 16 cores (hyper thread= max2 socket &max 8 core) rule.
How long will Oracle Database 18.104.22.168 in any edition remain under Premier Support?
Full patching support for 22.214.171.124 for all versions of 12gR1 (Enterprise Edition, Standard Edition and Standard One Edition) will be proviced for an additional 12 months from the release of 126.96.36.199 SE2, so through until end August 2016.
After that period Oracle Database 188.8.131.52 will enter Sustaining Support. There won’t be any Extended Support for Oracle Database 184.108.40.206 in any edition.
Will there be an Oracle Database Standard Edition 220.127.116.11 SE/SE1?
Beginning with the release of Oracle Database 18.104.22.168, Oracle Database Standard Edition (SE) and Oracle Database Standard Edition One (SE1) are no longer being released. 22.214.171.124 was the final edition that we will produce for SE and SE1.
Standard Edition Community Represented at Conferences
As an Oracle Standard Edition Advocate, I feel privileged to say, that after many discussions and many blog posts, Standard Edition Database is getting its well deserved spot in the sun, and the Standard Edition Community is starting to speak and socially discuss its role, opportunities, and challenges in the IT society.
Birmingham 7th-9th Dec
This year UKOUG Conference has decided to dedicate a whole day/track (7th Dec 2015) especially for Standard Edition Database. This is the first time ever a conference has done so. If keen to know the reasons why this conference made such decision, please read about this on my blog. But below is a small part from that interview:
Since this is the first conference in history, that has dedicated a whole day to a Standard Edition Track, could you please tell us the database team reasons for having this track?
Martin: Standard Edition is used by a large number of UKOUG members (and non-members), either because there has been a decision to only licence SE to reduce costs or because they have SE databases as part of the whole mix of Oracle systems within the organisation. SE has it’s own challenges, mostly due to the lack of certain options and technologies such as Partitioning, Data Guard and many of the security features. There are ways to work around these issues but there are few presentation given that address them. Joel Goodman (a highly respected Oracle trainer and presenter who is part of the database committee) initially raised the need for such talks to support what is often an under-represented part of the community and we were happy to support it within this year’s conference. Joel: I attended Harmony 2014 and saw the interest there in SE. I also help to organise the Oracle University Expert Summits and in the London 2014 summit attended by about 50 people.
Of those over 30 of them either used or supported Standard Edition for at least some of their databases. I realised then that UKOUG should be addressing that audience, so proposed this to the committee at the kick-off meeting for planning Tech15. The committee accepted this suggestion immediately, agreeing that there is a large SE community for whom there has not been a conference before and that we should be the first to do so.
In Birmingham I will have two presentations, plus one Standard Edition Roundtable. Please see below, there are lots of good presentations in this track! Here is the whole UKOUG agenda.
Official Standard Edition AGENDA – 7th of December:
09:00 – 09:50 “Oracle Standard Edition is Awesome!” – Tom Dale – Fivium
11:20-12:10 “Standard Edition Something for the Enterprise?” – Ann Sjökvist
12:20 – 13:10 “Looking for Performance Issues in Oracle SE – Check what OraSASH Can do for You” -Marcin Przepiorowski – Delphix
14:10 – 15:00 – “Silent but Deadly : SE Deserves Your Attention” -Philippe Fierens – FCP
15:10 – 16:00- “Max Protection Standby in Standard Edition RAC Environment” -Eter Pani – TSYS International
16:30 – 17:20 – “SE DBA’s Life a Bed of Roses?” – Ann Sjökvist
17:30 – 18:20 – “A Manly Man’s Guide to Open-Source Database Tuning Tools: Life Without EM12c” – Bjorn Rost
17:30-18:20 – “Oracle Standard Edition Round Table” – Joel Goodman – Oracle Co-presenter(s): Ann Sjokvist (also:Philippe Fierens, and Jan Karremans)
DOAG Conference 17th-20th November
I just received the acceptance letter from DOAG conference team, so the Standard Edition Community will also be represented in Nuremberg. I have not yet seen the agenda, but I am sure other people who supports Oracle Standard Edition Database will be there.
Keen to make Standard Edition Community even bigger?
Can we rock the boat like APEX Community has done in the past months?
Join the Standard Edition Community lovers at both DOAG conference in Nuremberg (17th-20th Nov) UKOUG TECH15 in Birmingham (7th-9th Dec). Book your tickets as soon as possible!