The foundation of Big Data is clear.
More information and insight learned.
Many ideas pops up about the potentials and opportunities
many unhidden diamonds out there
More information and insight learned.
Many ideas pops up about the potentials and opportunities
many unhidden diamonds out there
I was told, that changes has occurred within customer support and education, and it looks like well qualified people have been relocated or dismissed from their duties. Really?
I was informed that the SE climate has gone from a nice warm breeze to a more ice-cold climate. Really?
Tim Hall’s post about Oracle cloud license changes doesn’t leave doubts about the changes.
Somewhere on the net I found an article about the amount of databases available on the market. Sorry but lost the link. The writer explicitly said ‘as an Oracle DBA, I would start learning other vendors DB’s’.
His thoughts and the changes in strategy of Oracle made me ask: “If Oracle strategy is only from an IT perspective instead from a customer perspective. What is the added value of having an Oracle SE database?”
postgreSQL internal database might add some new values for SE customers. For sure looks interesting. Have you read Inc article “How to select the best database software: Know your database software types“. I agree with this quote “experts stress the importance of selecting a system that best meets your needs.”
We are living in a new area where digitalization brings new methods, processes and new ways of looking at things. Customer care is not according to some specialist what it used to be either.
According to the specialists, customers are looking for added value and good experiences not only IT technical stuff.
Changes in climate make customers changing there behaviors. When it is getting cold you by a warmer coat. Right?
So it’s all seems natural when hearing about customers starting to look for new solutions that might add a better ROI from a customer value perspective instead from an IT perspective, doesn’t it?
Take care, stay well and maybe the climate will get nice and warm again. 🙂
26 Feb 2017
New updates below 9.9.2016
I did some googling, and found this document “Using Oracle Database Backup Cloud Service“. In the beginning of the document it states:
“…Use RMAN parallelism and compression…”
To my understanding, the On-prem Standard Edition database have no license model allowing the DBA to use parallelism or compression, so after looking at the above document, I’m asking my self, has there been a change in the Cloud? Can a Standard Edition Cloud database use parallelism and/or compression for free?
Answer from Oracle License Specialist 11.8.2016:
“Standard Edition has the same rules in the Cloud as in On-Prem. So You may not use the parallelism and compression features”
Thanks Oracle for the clarification, and lets remember the golden rule – remember to be careful before starting to do things if your environment includes a Standard Edition database.
Below is the “Special-Use Licensing” part from the 12c License document:
IMHO: The information between these two different documents provided by Oracle is misleading.
To my understanding we are not able to follow this “Best Practice ….” document advice if we have a Standard Edition Cloud database.
Can we find a document like this?
“Standard Edition Howto with Cloud Backup Service”
Update per 9th Sept 2016 – start:
i was speaking about SE at a DOUG meeting in Denmark at the end of August 2016, were we had a great time talking and exchanging thoughts about SE related stuff. We had a great interactive session during my 90 minutes talk!
Thanks to Lars Bo V, and Peter G, I learned new things about the Cloud Backup Service that need to be added to this post.
Oracle Database Backup Service – FAQ (Doc ID 1640149.1) answer the question:
The answer is yes, but there are some restrictions and requirements that need to be fulfilled.
“Please note that all the backup related restrictions – such as single channel etc. still applies to the standard edition. “
As the Oracle License Specialist referred to earlier in this article.
According to the Edition document this feature is free of charge, and available for SE/SE1/SE2 databases:
The good news is that Yes you can backup to the cloud, and the costs might not even be too expensive, so I suggest you look in to it.
Update per 9th Sept 2016 – end
Take care, stay well and enjoy the opportunities in the Cloud
Are you a user of Oracle Standard Edition Database, or are planning to start working with a Standard Edition Database? I would love to meet you and hear about your experiences and exchange thoughts about SE future.
I will be talking about my experiences in SE, and its different pitfalls that I think every Oracle DBA should know about.
More information on the event can be found here.
Take care, stay well, and see you in Copenhagen!
In my previous post, I activated and created a Cloud Standard Edition Database (=CSE) .
“Fully managed by Oracle – no DBA necessary”
The above statement is for a Database Schema Service database, and sounds very promising from a SME business owners perspective. Hopefully I have time to test drive it, to check the degree of truth in that statement.
So I am the lucky “owner” of a Cloud Standard Edition Database.
Our Cloud Standard Edition Database is not yet aware of any companies data.
The picture above shows my newly created CSE.
The CSE database has not yet any business related data in it, and 93% of Operating system Memory in use.
Should I have asked for a bigger Cloud? Are these numbers normal and good enough to hold the real customer data as well? Should I have taken something into considerations, before activating my CSE database? Did I miss something important? How can I be sure not to overdue the small budget, that the SME customer has? How about the automatic backup routines? Can I rely on the default backup policy, or should I urgently fix them? Is this Cloud different from On-Prem or should I stick to the company’s well-known DBA routines?
I found this document, but do still have some open questions that need answers.
Oracle provide us with an “out-of-the-box” the “DBaas Monitor” Console, which helps us monitoring our Cloud Standard Edition Database Instance well being.
Before we can use the “DBaas Monitor” Console, we need to sign in to our Cloud Service account, and enable the https access “Access Rules” option for our instance:
There. Now we can Open the Console and start to explore our newly created CSE.
If your attention is to use SQL Developer remember to enable the listener from our Cloud Service.
After this small exercise in the Cloud, more questions arises.
In my next post I will talk about Cloud Backup Service and what to think about when your DB is a SE Cloud version.
Take care, stay well and let’s enjoy the sunny days of Summer!
It is based on VMs provided by Oracle Compute Cloud Service. You can connect to your Oracle Database Cloud Service (Database as a Service) instances by using Oracle Net Services from outside the Oracle Cloud.
The Cloud is here to stay, and lot’s of people have already tried it out, and by googling, it seems that most of the articles are focused on the Enterprise Edition option. Please check out Tim Hall’s post about his tests from here.
How about if I want a Standard Edition Database? Any different steps needed? Let’s check it out.
IMPORTANT – Save the keys and remember the passphrase for your private key. This will be
used in further steps.
Before creating the SE instance it’s a good idea to create the storage container, since this will be required during the Instance creation phase. It is used for backups, and I used CloudBerry, but you can also create one with REST API if that’s more your “cup-of-tea”.
After you have registered with your (trial) account, login and remember to choose the “Data Center” associated with your services. In my case i use a site geographically near Finland.
Click on the Oracle Database Cloud Service and you will see a a “Create Instance” – button on the right side of the Dashboard, and choose the Database option
Choose the Create Service”- button and fill in the questionnaire form
Choose Virtual Machine or a Cloud Service
Choose a Database version you need
In early days of Oracle Cloud Service, the only available Standard Edition version provided was SE1. Checked the information provided by Oracle at the moment, and they say “Standard Edition”, so I guess they now provide us with the SE2 edition.
Choose Standard Edition Database
Service Configuration Steps
Give your service a suitable name, Description, Shape, timezone, and provide your SSH public Key to be used for authentication when using a SSH client to connect to a compute node VM that is associated with your SE Cloud Service Instance:
Database and Backup Configuration
Provide the rest of the information. Remember the CloudBerry stage performed earlier? Now is the time to provide the information about the storage you created.
That’s all. A note to my self: How about the “automatic backup routines” that came with the above configuration steps?
Checking with CloudBerry, and some backups available already….Nice.
There is my newly created Standard Edition Database and instance, and it didn’t take long and didn’t require much Oracle DB skills to get things working. Anybody can clearly get a DB up and running in no time.
The real question now is how about using or administrating this type of database? Any pitfalls to be aware of? How about migrating the old On-prem database with a different character set to this Cloud SE Database? How do I restore a lost Cloud SE DB? Can anybody perform the normal DBA stuff as easily, or do they need some kind of Oracle DB knowledge? I guess it’s time to figure out, if some Oracle DBA skills are needed at all in this world among clouds.
Take care, stay well, and enjoy the challenges in life!
ps. This YouTube might be handy. It shows the steps mentioned above
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.”
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.
The On-prem Standard Edition 2 processor list price is approx. $17500.
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.
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.
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.
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!
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.
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.
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!
Helsinki, 21. June 2016
My blog was visited by people from 123 countries, so yes I dare to say “SE Community is Big”.
The highlights for SE Community this year:
Can 2016 become an even better year?
It all depends on You in our SE Community, so take care, stay well and lets enjoy the challenges that are waiting for good solutions
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.
As a first timer at UKOUG conference, this was a nice way to get acclimatised. I had the opportunity to listen to
And the take-away from Sunday: “Super Great Experience”. If you haven’t tried it yet, I recommend to schedule it at TECH16 Conference.
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.
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……
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!
Copenhagen 9th Dec 2015