DBCA (12.2) template for the Enterprise Manager Cloud Control 13c Release 2 repository DB

Enterprise Manager Cloud Control 13c Release requires a repository database, which can be either Oracle 12c Release 1 (12.1.0.2) or Oracle 12c Release 2. Unfortunately, Oracle provides only templates for Oracle 12c Release 1 on Technet (http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/db-templates-3233309.html). So I created my own template from my small Linux-based OEM Repository database (12.2, Non-CDB).

Continue reading

Posted in Common | Tagged , , , , , | Comments Off on DBCA (12.2) template for the Enterprise Manager Cloud Control 13c Release 2 repository DB

DOAG 2017: Application Containers

Today was the first day of the annual DOAG conference. I had a presentation „Application Containers – Multitenancy for Applications with Oracle Database 12c Release 2“. You can find the presentation and the demos here:

Continue reading

Posted in Common | Tagged , , | Comments Off on DOAG 2017: Application Containers

#otw17sf: Oak TableWorld 2017 started

Day 2 at San Francisco started with the opening of the Oak Table World at the Childrens Creativity Museum. As Mogens Norgaard, the founder of the Oaktable, stated it‘s less marketing and more technical than the typical OpenWorld sessions. So perfect for people like me. But this year the Oaktable World started with two great sessions, which were less technical.

Mogens Norgards: it was worse, it is good and it will be better

So sum up his keynote, which covered history, economics, politics, health-care and other non-technical stuff, Mogens said: it was worse, it is good and it will be better in the future. This applies for database administrators and developers, too. The more data is available, the more work will be there. But it changes (and it has constantly changed in the past). Developers should call themselves „DevOps-Engineers“, DBA should name themselves „Platform specialists“. Add terms like „real-time“, „AI“ and you are up to date. There‘s a bright future for the real-time-articifial-intelligence-platform-implementation-specialist“.

Personally, I consider this session one of the most inspring talks I‘ve ever seen at an OOW.

Kellyn Pot‘Vin-Gorman: Fighting Dinosaurs

Kellyn brought us back to the history of computer technology. Von Neumann, Shannon‘s Law and all the implications these famous theories of computer science still have to the infrastructure we are dealing with today. Another great session. No slideware on new features.

Link: http://www.oaktable.net/blog/oak-table-world-2017-oracle-open-world

Posted in Common | Tagged , | Comments Off on #otw17sf: Oak TableWorld 2017 started

Oracle Open World 2017: Application Containers

Today I had my presentation at the Oracle Open World 2017 on Application Containers. It was fun talking about the new feature of Oracle Database 12c Release 2.

Thanks to all the attendents for coming to my session.

Link to the talk:  2017-10-oow-fma-application-containers-v01-final

Posted in Common | Tagged , | Comments Off on Oracle Open World 2017: Application Containers

Setting OPTIMIZER_ADAPTIVE_FEATURES in Oracle Database 12c Release 2

In Oracle Database 12c Release 2 the parameter OPTIMIZER_ADAPTIVE_FEATURES was declared “Obsolete”. It was replaced by the parameters optimizer_adaptive_statistics, optimizer_adaptive_plans and AUTO_STAT_EXTENSIONS to allow better control of the adaptive features of the optimizer but what happens, if you try the set OPTIMIZER_ADAPTIVE_FEATURES on a 12.2 database?

Continue reading

Posted in Oracle 12c | Tagged , | Comments Off on Setting OPTIMIZER_ADAPTIVE_FEATURES in Oracle Database 12c Release 2