Venant de passer les deux derniers jours au siège d’Oracle pour le ACE Director briefing, j’en profite pour expliquer ce que représente le programme Oracle ACE car il y a peu de ressources en français.
On ne le sent pas toujours, mais Oracle est à l’écoute des utilisateurs. Oracle encourage les spécialiste de la communauté d’utilisateurs à partager et communiquer sur ses produits. Ce n’est pas pour faire simplement de la publicité commerciale, mais d’échanger et de faire connaitre la technologie. C’est l’OTN (Oracle Technology Network) qui gère le programme ACE.
Les titres de ACE Associate, ACE, et ACE Director sont une reconnaissance du travail effectué par les spécialistes au travers de différent canaux d’information: blogs, articles, présentation, organisation des groupes d’utilisateurs, écriture de livres techniques, etc.
Mais c’est aussi le moyen pour Oracle d’être à l’écoute des utilisateurs finaux, en dehors du réseau commercial. Les ACEs ont un contact privilégié avec les Product Manager pour tester les produits, parfois en beta, ouvrir et suivre les bugs rencontrés et faire un retour sur l’utilisation des fonctionnalités.
Les ACE directors se réunissent au siège juste avant l’Oracle Open World pour un briefing sur ce qui va être annoncé à l’Open World, et sur la Road Map des futures releases. Cela permet aux products managers de mieux présenter les nouveautés en fonction de ce qu’attendent les utilisateurs, et aux ACEs de pouvoir répondre aux questions des utilisateurs qui apprennent ces nouveautés.
Aujourd’hui, Oracle couvre un domaine beaucoup plus large que la base de donnée. Il y a du hardware, de la virtualisation, des systèmes d’exploitation, plusieurs bases de données, de la BI, ERP… L’objectif aujourd’hui d’Oracle est de s’imposer face à Amazon sur le IaaS, d’offrir la plus grande agilité en PaaS et une gamme très large en SaaS.
Mais heureusement, les bâtiments d’Oracle Corporation montrent toujours d’où ils sont partis: la base de donnée, stockée sur disque dur, toujours représentée par des cylindres rotatifs:
Aujourd’hui, les disques ne ressemblent plus à cela et de sont plus l’élément critique de l’IT car on ne dépend plus de la latence mécanique. Mais le symbole reste.
Si vous êtes à l’Oracle Open World cette année, n’hésitez pas à passer à l’OTN Lounge au Moscone South. Vous pourrez vous renseigner sur la communauté autour de la technologie Oracle, et sur le programme ACE.
Si vous ne maîtrisez pas l’anglais, pas de problème la Délégation Française propose plusieurs points de rencontre.
Will data returned from "select for update" once row lock is obtained always contain the latest committed values?
I have recorded gif to give you an impression how it runs and how UI switch works in ADF UI panel dashboard component:
There are four blocks in the dashboard, user can remove each of the blocks or select predefined group of blocks:
It is possible to maximize selected block to occupy more space:
Some of the blocks can be minimized and only a subset of blocks will be displayed:
Such functionality is implemented with out of the box ADF UI components - af:panelStretchLayout, af:panelSplitter and af:panelDashboard. Depending on selection, block is minimized, displayed or maximized:
Toolbar items (minimize, maximize and restore) are implemented in the separate JSF container and reused in the main page:
Hopefully you will find such use case interesting and will have a chance to apply in the project. Download sample application - ADFIntegrationDashboard_v2.zip.
Today was Day 2 of the Oracle ACE Director Briefing.
As with yesterday’s post, we had a number of speakers coming in to talk about specific areas of the Oracle stack and Oracle Cloud. Once again, I’m not going to mention any details.
There were a few areas that were super-relevant to what’s going on with me at work, so it was good to make some more contacts in those areas.
The shear volume of stuff going on at Oracle at the moment is actually quite scary. I’m sitting in the sessions wondering how I’m going to do my job, learn all the new regular Oracle stuff and learn all the new Oracle Cloud stuff as well. It’s quite daunting…
Thanks to the folks at the Oracle ACE Program for making this event happen. This last two days has been like a full-on conference, complete with multiple tracks. Your efforts are greatly appreciated. Thanks to all the speakers too. I know we sometimes give you a hard time, but we do appreciate you taking the time to come and speak to us!
I’ve got tomorrow off, then the crazy world of Oracle OpenWorld 2016 starts!
Tim…Oracle ACE Director Briefing – Day 2 was first posted on September 17, 2016 at 4:58 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.
In this blog let’s talk about SQL Server and availability groups in standard Edition. I had some customer questions about existing limitations and this is a good opportunity to review them on this blog post. First of all, let’s say that Microsoft has already documented the restrictions here and from my side, I already written a blog post on the subject at the time of the CTP version of SQL Server 2016. In the meantime, some changes occurred and are now included in the RTM version.
As a reminder, the Standard Edition offers limited capabilities of availability groups and it tends to be a replacement of previous feature called mirroring. This is a good news for customers that may finally upgrade their old environment.
The first main limitation concerns the number of replicas capped to only 2 and with no possibility to use the secondary replica for Reporting and backups offloading as well. But we want to use a Standard Edition and it is supposed to be sold at a lower cost right?
Let’s just have a quick check by using the T-SQL script. Generally speaking, I’m not a big fan of the GUI! So if I try to create an availability group with 3 replicas, I will obviously face the following error message:
Msg 35233, Level 16, State 0, Line 2
Cannot create an availability group containing 3 availability replica(s).
The maximum number of availability replicas in an availability group with (basic) is 2.
Reenter your CREATE AVAILABILITY GROUP command specifying fewer availability replicas.
Let’s try to use a secondary replica as read-only replica (ALLOW_CONNECTIONS = ALL)
-- primary replica CREATE AVAILABILITY GROUP [testGrpStd] FOR REPLICA ON N'WIN20121SQL16\SQL16STD' WITH (ENDPOINT_URL = N'TCP://WIN20121SQL16.dbi-services.test:5023', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, BACKUP_PRIORITY = 50, SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL), SEEDING_MODE = MANUAL) , N'WIN20124SQL16\SQL16STD' WITH (ENDPOINT_URL = N'TCP://WIN20124SQL16.dbi-services.test:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, BACKUP_PRIORITY = 50, SECONDARY_ROLE(ALLOW_CONNECTIONS = ALL), SEEDING_MODE = MANUAL); GO
Well another error message I got here:
Msg 41199, Level 16, State 8, Line 2
The specified command is invalid because the Always On Availability Groups allow_connections feature
is not supported by this edition of SQL Server. For information about features supported by the editions
of SQL Server, see SQL Server Books Online.
However, I noticed a big change compared to my first test with a CTP version concerning the possibility to add a listener to my availability group. From my point of view, this is a very good improvement compared to the mirroring feature because no changes will be required at the application layer with additional options at the connection string level. Let me prove it with the following script:
USE [master] GO ALTER AVAILABILITY GROUP [testGrpStd] ADD LISTENER N'Test-GrpSTD' ( WITH IP ((N'192.168.5.122', N'255.255.255.0') ) , PORT=1433); GO
We can check the listener creation by using DMVs to get the listener configuration as shown below:
According to my discussions with some customers at our last SQL Server 2016 event, availability groups in Standard Edition may also suggest that more complex infrastructures like multi-subnet availability groups or new special features like direct seeding will not be supported. A first look at the Microsoft documentation doesn’t provide any clues. You can argue that the Microsoft documentation is black-list oriented and if it is not written explicitly in the documentation it should work and you are probably right. But you know, I’m curious and I was interesting to check myself on my lab environment!
For the both suppositions, I can confirm that I didn’t face any issue when creating an availability group with a different setup scenario on the top of multi-subnet WSFC or when using direct seeding. Here the script used to create my availability group with a listener and two IP addresses on different subnet. I also have enabled the direct seeding feature by configuring the SEEDING_MODE parameter to AUTOMATIC as shown below.
-- Availability groups with SEEDING_MODE = AUTOMATIC CREATE AVAILABILITY GROUP [testGrpStd] FOR REPLICA ON N'WIN20121SQL16\SQL16STD' WITH (ENDPOINT_URL = N'TCP://WIN20121SQL16.dbi-services.test:5023', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, BACKUP_PRIORITY = 50, SECONDARY_ROLE(ALLOW_CONNECTIONS = NO), SEEDING_MODE = AUTOMATIC) , N'WIN20124SQL16\SQL16STD' WITH (ENDPOINT_URL = N'TCP://WIN20124SQL16.dbi-services.test:5022', FAILOVER_MODE = AUTOMATIC, AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, BACKUP_PRIORITY = 50, SECONDARY_ROLE(ALLOW_CONNECTIONS = NO), SEEDING_MODE = AUTOMATIC); GO -- Listener with two IP addresses on a different subnet ALTER AVAILABILITY GROUP [testGrpStd] ADD LISTENER N'Test-GrpSTD' ( WITH IP ((N'192.168.5.122', N'255.255.255.0'), (N'192.168.50.122', N'255.255.255.0') ) , PORT=1433); GO
Now let’s have a look at the availability group configuration and direct seeding parameter value
Here the listener configuration retrieved from the sys.availability_group_listeners DMV:
Let’s take this opportunity to change the replication type to ASYNCHRONOUS. In fact, I had in mind the mirroring feature when using the asynchronous replication that was only available with Enterprise edition. This is another interesting point and now we may benefit from both asynchronous and synchronous replication mode regardless the edition. By the way this feature is clearly documented in the BOL.
Finally let’s check if direct seeding works as expected. If you don’t know what direct seeding is please refer to my previous blog. Just as reminder, we must first configure direct seeding on the secondary by granting the correct permission to the availability group itself.
ALTER AVAILABILITY GROUP [testGrpStd] GRANT CREATE ANY DATABASE GO
Here we go. Let’s finally add the database to my existing availability and let’s see if direct seeding comes into play
ALTER AVAILABILITY GROUP testGrpStd ADD DATABASE test_db; GO
To get data from direct seeding session states we may use DMVs like sys.dm_hadr_automatic_seeding and sys.dm_hadr_physical_seeding_stats as well.
Sounds good right?
Basic availability groups feature is shipped with limited features. Yes, but in a meantime it will still respond to a large number of customer scenarios where we have to find a balance between high availability options and costs. Referring to some discussions I had with some customers, they don’t need special features provided by availability groups like readable secondaries or offloading backups. They just want to benefit from high availability for only some critical applications. I’m looking forward to see basic availability groups at customer shops!
Cet article SQL Server 2016 : Basic availability groups may fit to your HA needs est apparu en premier sur Blog dbi services.
I'll be at Oracle Openworld San Francisco (Sept 18-22) next week and we have a host of sessions aimed for .NET developers and Oracle Database on Windows administrators. Click the links below for the session times and locations.
Oracle Database on Windows Sessions
Active Directory and Windows Security Integration with Oracle Database [CON6573]
Best Practices for Oracle Database Performance on Windows [CON6575]
What's New with Oracle Database 12c on Windows: On-Premises and in the Cloud [CON6576]
.NET Development Sessions
Best Practices for Performance Part 1: .NET and Oracle Database [CON6574]
Best Practices for Performance Part 2: .NET and Oracle Database [CON6610]
PL/SQL Programming for .NET Developers: Tips, Tricks, and Debugging [CON6612]
What’s New for .NET Developers in Oracle Database [CON6577]
Best Practices for High Availability: .NET and Oracle Database [CON6580]
Meet the Oracle Programming and Scripting Experts [MTE7200]
I've also uploaded a map showing where the demobooth is located (SDB-003 in Moscone South).
Click here to view the image in full res.
We can't believe that OpenWorld is just days away. As you can tell from the past month, we've been working hard on getting sessions, demos, hands on labs and a slough of various other things ready in preparation for the event. We are excited to see familiar faces next week and meet new contacts as well! We wanted to highlight some of the "must add" things to your agenda.
Must Attend Sessions:
Don’t miss the Strategy and Vision sessions for the overall Content and Experience Management portfolio and each of the respective solution and cloud technologies. Attendees will also get an opportunity to hear from customer organizations on implementation successes.
Monday, Sep 19
- Content and Experience Management: Roadmap and Vision [CON7256]
- 11:00 a.m. - 11:45 a.m. | Moscone West—2014
- Oracle Process Cloud Service: Digital Process Apps Made Simple [HOL7613]
- 11:00 a.m. - 12:00 p.m. | Hotel Nikko—Nikko Ballroom III (3rd Floor)
- Content Management in the Cloud: Strategy & Roadmap [CON7257]
- 12:30 p.m. - 1:15 p.m. | Moscone West—2014
- Digital Experience in the Cloud: Strategy & Roadmap [CON7258]
- 1:45 p.m. - 2:30 p.m. | Moscone West—3000
- Create an Employee Portal Using Oracle Documents Cloud Service/Oracle Sites Cloud Service [HOL7607]
- 2:30 p.m. - 3:30 p.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)
Tuesday, Sep 20
- Drive Productivity in Your Enterprise with Oracle Documents Cloud Service [HOL7611]
- 8:00 a.m. - 9:00 a.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)
- WebCenter Content, Imaging, Capture & Forms Recognition: Roadmap & Strategy [CON7259]
- 4:00 p.m. - 4:45 p.m. | Moscone West—2014
- Oracle WebCenter Digital Experience: Sites & Portal Strategy and Roadmap [CON7260]
- 5:15 p.m. - 6:00 p.m. | Moscone West—2014
Wednesday, Sep 21
- Deep Dive into Oracle's Content and Experience Cloud Platform [HOL7612]
- 11:30 a.m. - 12:30 p.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)
- Cox Enterprises Reimagines the Digital Workplace with Oracle WebCenter [CAS4789]
- 3:00 p.m. - 3:45 p.m. | Marriott Marquis—Golden Gate C3
Thursday, Sep 22
- Create Rich Solution Templates with Oracle's Content and Experience Cloud Platform [HOL7616]
- 9:45 a.m. - 10:45 a.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)
There are PaaS General Sessions and many more sessions highlighting customer successes, product deep dives, partner discussions, persona and/or industry based discussions, Cloud/PaaS lessons, live product demonstrations and Hands-On-Labs (HOL) sessions so do bookmark the following links for a complete, up to date listing:
- Focus on Content and Experience Management | (webpage)
- Focus on Content and Experience Management | (pdf)
My Schedule is available for Oracle OpenWorld! Customer and partner attendees can use My Schedule to plan and optimize their time during the conferences by building personalized conference schedules beforehand. We recommend adding the sessions mentioned above and the others of interest from the Focus on Documents listed above.
Content and Experience Management Auxiliary Events at OOW
In addition to regularly scheduled programs of sessions, hands-on labs and demos, we have planned additional events for our customers and partners to network with their peers. These auxiliary events include:
- Innovation Awards Ceremony | Tuesday 9/20 | 4:00pm – 6:00pm | YBCA Theater | Event Contact | OOW Registration Required
- Oracle Appreciation Event at OOW16 with Billy Joel, Sting & Gwen Steffani | Wednesday 9/21 | 7:00pm – 11:00pm | Event Information
Oracle OpenWorld Content and Experience Management Website
At this year’s Oracle OpenWorld, you will have a much more simplified and engaging experience, from any device – web, phone, tablet! The Oracle OpenWorld Content and Experience Management website is the ONLY link you will need to keep tabs on all things Digital Experience at Oracle OpenWorld 2016. You will find information on the upcoming sessions, the day’s agenda, ready information on Hands-on-Labs, Demo locations and hours, and more. Live twitter feed and pictures will allow you to experience the conference in real time. The site is mobile-first so you can enjoy a rich, dynamic mobile experience. They say…you have to experience it to believe it, and @ #OOW16 you will get your chance! Please bookmark this website to stay in the know of all things #OracleDX at #OOW16. https://sites.oracle.com/oowdx
Mobile Challenge App Game
The #OOW16 Mobile Experience will include an interactive, Pokémon Go-styled, mobile app that was built using Oracle Mobile Cloud Service, through which you can win prizes. More details can be found here!
Social Media Communications
We will be highlighting our key sessions and other important information on the Oracle DX blog periodically. In addition, please use the following hashtags to discuss OOW on your respective channels!
- #OOW16 | #OracleDX
And we are asking you to please follow along and join the conversations on our social media channels.
We are looking forward to a successful #OOW16!
As you already might know dbi (on a technical level) is organized into several technology divisions. Traditionally there is one for Oracle, one for Microsoft and one for Middleware products. Almost a year ago a new technology division was born to reflect the new requirements we see on the market. This does not mean that we did not provide expertise in these areas before but the goal was to more clearly organize ourself for being able to rapidly adopt new technologies and provide the best expertise for our current and future customers. In this post I’ll take a look at our Open Infrastructure Technology Division. What is it about, what do we believe in and what you can expect now and in the future.
To start with: What do we call a technology division? As the name already adumbrates it is all about technology. You could also say: The technology division are the heart of dbi. This is where people work on the different technologies, organize technical events, do researching, define and plan new workshops, adopt new products and have lots of fun. Each of these technology divisions is led by a so called technology leader who is responsible for his technology division. Currently dbi supports four of these divisions which reflect the areas we work in:
On the top there is Hervé who is our CTO and then we have the four technology divisions:
- We have Franck who is responsible for all aspects around the Oracle database
- We have Stéphane who is responsible for the Microsoft stuff
- We have Gérard who is responsible for everything around the middleware products we support
- And finally we have the Open Infrastructure Technology Division which I am happy to represent
A very important point to notice here is that each of these divisions is cross connected to every other. We are not working in isolated silos but do work together wherever we can. Nowadays you can never be sure what happens and things have recently happened you never thought would be possible in the past, e.g.
- Microsoft and Red Hat to deliver new standard for enterprise cloud experiences
- PowerShell on Linux and Open Source!
- SQL Server on Linux
… just to name a few. Do you know if you need a SQL Server expert on Linux tomorrow? Are you running Oracle on Windows? Are you planning to run Docker on Windows? These are just a few examples where you might need expertise which goes beyond the traditional “I only do Windows” or “I only do Oracle” way of working. This is what the technology divisions are there for: Build expertise inside the divisions but even more important build a kind of “backbone” where everyone can get help from others (inside and outside of dbi). Share what you learned, be open, be communicative, be mindful and have an open eye on what is going on around you. No matter which technology division you take: All of them share their knowledge by writing blogs, attending, organizing and speaking at events (e.g. DOAG 2016, Oracle Open World 2016, IT-Tage 2016, SWISS PGDay, PASS SQLSaturdays and many more), writing articles, creating hands-on workshops and even come together twice a year for exchanging knowledge across the technology divisions.
So far for the overview (which is far longer that it intended to be, sorry). Lets focus on the Open Infrastructure Division from now on. Probably the most important point in any division is what it stands for, so what do we stand for? As you can see from the name the word “Open” plays a central role. We do not only believe in open source software but even more important believe that being and thinking open is key to success. There are plenty of wonderful open source projects out there, each of them having an active community and each of them supporting business critical applications. Our idea is not to favor one over another but rather selecting the right technology for the right requirement. This might range from one specific product to a whole set of products. This could even result in extending (or interfacing) a proprietary solution by open source solutions when it makes sense (remember the cross connected divisions described above).
On the other hand we can not support the whole open source world because this is just not possible so we have to select a kind of technology set we want to focus on (more on that later). This set is and will be changing over time, we are absolutely aware of that. New technologies will come in, others will go out and some will stay. That’s the way of life. Important for us is the “Open Infrastructure” because when things change you need to adopt. When you keep your infrastructure open it is much more easy to adopt than when you have to adopt your closed systems. When you focus on real open standards, open formats and open software you are free to decide in which direction you want to go and even if it was the wrong decision you are not on a …
… you are free to adjust the direction This is more or less what we believe in and work on every day: Making infrastructures more open, easier to maintain, easier to adapt, faster to profit from and more fun to work with. Yes, work can be fun when you have the right tools and the right people to work with.
Going deeper into our division what do we actually provide? We had various internal discussion about that and it was not easy to come to a final conclusion. Indeed there is no final set or conclusion but we do provide what we call a “core” set. This are our core technologies we currently work on, provide best practices, provide trainings for (some), provide consulting (all), provide SLAs (some), implement (all) and do reviews or feasibility studies (all). So, finally here they are (bottom up):
On the Linux level:
On the rdbms level:
On the NoSQL level:
On the provisioning and deployment level:
On the monitoring level:
On the DevOps and OpenStack level:
This are quite a few but not too much technologies. As already stated somewhere above we do not provide everything for every product but we are constantly extending our knowledge and best practices so that products might be fully supported by us in the future which are not today. Other products we are working on are not even listed above (e.g. the E(astic search) L(ogstash) K(ibana) stack). Believe me: It is really hard to select the right tools for the right job: This is what we are here for.