Feed aggregator

Le programme Oracle ACE

Yann Neuhaus - Sat, 2016-09-17 19:55

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.

Pour donner une idée du nombre de ACE Directors présents au siège, voici l’équipe:
2016-09-16 17.08.58

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:

2016-09-16 07.35.12

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.

Et n’hésitez pas à venir voir ma session sur le Multitenant et j-interviens aussi pour parler Transportable Tablespace dans la session de l’EMEA User Group Community (EOUC)

 

Cet article Le programme Oracle ACE est apparu en premier sur Blog dbi services.

Pro*C Multithread Extracting Table Data

Tom Kyte - Sat, 2016-09-17 02:06
Hi Tom, I have created pro*c multithreaded application to download data from oracle table to flatfile. Each thread has its own sql context, cursor and fetch statements. I am generating separate WHERE clause for each thread with MOD function on one...
Categories: DBA Blogs

Performance Tuning

Tom Kyte - Sat, 2016-09-17 02:06
I'm junior DBA and i join an organization in last month. we are using oracle 11g Standard Edition. we does not have licence of performance tuning so I have a performance tab disable in EM Manager . I want to find out Top SQL , Top Activity , To...
Categories: DBA Blogs

Relation between SCN and checkpoint SCN

Tom Kyte - Sat, 2016-09-17 02:06
Hi Tom, I have gone through many of your threads regarding SCN and I have a few questions regarding them. 1. Is SCN generated only for committed transctions and that is when the transaction is committed not when the transaction is begun, right ...
Categories: DBA Blogs

Need to generate script to delete values from various tables

Tom Kyte - Sat, 2016-09-17 02:06
I want to delete values from various tables. These table name are in a column field. Will this be possible . For example lets say Table A has column as SID. And these SID are the table names too. I want to pick values from SID and delete values f...
Categories: DBA Blogs

Convert an Integer into Years, Month and Days.

Tom Kyte - Sat, 2016-09-17 02:06
Hello- I am working on a seniority report, for which I need to compute number of years in employment but with the deduction in the number of days of un-paid absences. I have all the computations done, and have the number of days a employee is em...
Categories: DBA Blogs

How to zero fill a sum of a count field using SQL

Tom Kyte - Sat, 2016-09-17 02:06
For two records, this part of the select returns 2, would like to return 000000000000002 (sum(count(distinct(RPAD(to_char(spriden_pidm),15,'000000000000000'))))) Record_count
Categories: DBA Blogs

Alternative to global temp tables?

Tom Kyte - Sat, 2016-09-17 02:06
I asked this in a "review" of a related question (https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9531768700346881365) but it may have been considered slightly off topic so here it is by itself. I was a SQL Server developer for ...
Categories: DBA Blogs

move tables within same tablespace

Tom Kyte - Sat, 2016-09-17 02:06
Hi Tom, Is it possible to move tables from one datafile to another datafile within the same tablespace..? Could you please suggest me. Thanks, Prakash
Categories: DBA Blogs

PL/SQL how to quote variables?

Tom Kyte - Sat, 2016-09-17 02:06
Hi team askTom: This is not an export/import question, more of a pl/sql and 'quoting' question, and I always have trouble quoting my variables, especially those that get evaluated at run time. Here I am trying to export 2 schemas, so I wrote a ...
Categories: DBA Blogs

Will data returned from "select for update" once row lock is obtained always contain the latest committed values?

Tom Kyte - Sat, 2016-09-17 02:06
Hello Hopefully a quick question to confirm my understanding of "select for update" and data consistency. I have a primary JDBC thread with autocommit false that begins a transaction, selects a batch of row "for update skip locked", and recurse...
Categories: DBA Blogs

Dynamic Flying Dashboard UI in ADF 12.2.1.1

Andrejus Baranovski - Fri, 2016-09-16 23:43
I took my old sample application implemented in 2010 - Dynamic Flying Dashboard UI Shell and upgraded it to recent ADF 12.2.1.1. It runs pretty well, without major changes - this proves ADF migration between releases can be smooth (well, not always in practice - but let's be positive).

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.

Oracle ACE Director Briefing – Day 2

Tim Hall - Fri, 2016-09-16 22:58

ace-directorToday 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!

Cheers

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.

SQL Server 2016 : Basic availability groups may fit to your HA needs

Yann Neuhaus - Fri, 2016-09-16 13:22

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:

blog 103 - STD AG - listener 1

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

blog 103 - STD AG - automatic seeding

Here the listener configuration retrieved from the sys.availability_group_listeners DMV:

blog 103 - STD AG - listener 2

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.

blog 103 - STD AG - async replication

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.

blog 103 - STD AG - direct seeding

Sounds good right?

Bottom line

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.

Oracle Openworld SF: Windows and .NET Sessions and demogrounds

Christian Shay - Fri, 2016-09-16 12:00

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.



#OOW16: What You Must Add to Your Agenda

WebCenter Team - Fri, 2016-09-16 09:42

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:

    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!

    Wait event

    Tom Kyte - Fri, 2016-09-16 07:46
    Hi team, Can you pls brief me regarding this wait event because i have continuously and every time getting this event. So pls let me know what is the meaning of this event and how to resolve this what is the solution of this event. EVENT ...
    Categories: DBA Blogs

    how to recover table with out backup

    Tom Kyte - Fri, 2016-09-16 07:46
    Hi Tom, one table is dropped, there is no backup and no flashback enable, then how can we restore the table. thanks.
    Categories: DBA Blogs

    Audit commit delay

    Tom Kyte - Fri, 2016-09-16 07:46
    Hi team, Every day we got some alert like - AUD: Audit Commit Delay exceeded, written a copy to OS Audit Trail Could you pls let us know what is this and how to resolve this ? thanks
    Categories: DBA Blogs

    The dbi Open Infrastructure Technology Division

    Yann Neuhaus - Fri, 2016-09-16 07:37

    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:

    to-organization-overview

    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.

    … 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 …

    traffic-sign-6727_960_720

    … 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:

    logo_redhat logo_centos logo_suse logo_debian logo_ubuntu

    On the rdbms level:

    logo_mariadb logo_postgresql logo_mysql

    On the NoSQL level:

    logo_mongodb logo_cassandra

    On the provisioning and deployment level:

    logo_ansible

    On the monitoring level:

    logo_nagios

    On the DevOps and OpenStack level:

    logo_atomichost logo_docker logo_mirantis

    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.

     

    Cet article The dbi Open Infrastructure Technology Division est apparu en premier sur Blog dbi services.

    Pages

    Subscribe to Oracle FAQ aggregator