Oracle Database 19c is now available!

Today Oracle Database 19c became available on Exadata on-premises.

Oracle Database 19c is the final member of the 12.2 family a.k.a 12.2.0.3 and is therefore the ‘long term support’ release. This means it will come with 4 years of premium support and 3 years of extended support. Making this release the version of the database that most folks are going to upgrade to next. 

So, what can you expect?

There are hundreds of useful enhancements in Oracle Database 19c as well as a several  new features. Dom Giles‘s latest post on the Oracle Database Insider blog has all the details on the new release, while I’ve listed just a couple of my personal favorites below. 

Continue reading

Posted in New Features, Oracle Database 19c | Tagged , , | 2 Comments

Oracle RAC on Docker just got simplier

Early this year, I wrote a blog to let you know that Oracle Database RAC was available on Docker.  However, in that blog I described a number of manual steps that were required to rebuild the image before you could start using the RAC database.

I’m now delight to announce that you can simple download a Oracle Database RAC Docker image (under database) from the container registry, which has a pre-installed / pre-built image. Making it easier to have a RAC database for your  demos, development or test environments.

 

Posted in Docker, RAC | Tagged , | Leave a comment

Oracle Open World Wrap Up

Oracle Open World this year was a crazy busy week catching up with customers, Oracle Aces, Development Champions and partners as we all crammed into the Moscone center to hear the very latest on Oracle Technologies.

For the database, this year’s conferences saw the introduction of Oracle Database 19c and of course the continuing evolution of the Oracle Autonomous Database Cloud Services.

If you weren’t able to make it to OOW in person, don’t panic as a lot of the session presentations are now available for download in the OOW session catalog. You can download the slides by clicking the down arrow in the right hand side of each session title as shown below.

Alternatively you can check out the video below which provides you with a great technical introduction to the Autonomous Database and how it works.

Since 19c is still in beta the slides from those sessions are not available yet but if you are going to the UKOUG Conference in December Dom Giles and I will be giving you a taste of what you can expect from the new release in the Database Keynote session on Monday Dec. 3rd. While Nigel Bayliss and I will also give you a sneak peek of what you can expect from Automatic Indexing.

And of course I’ll have more Autonomous Database stickers to give away!

Posted in Autonomous Database | Tagged | Leave a comment

Day 2 of Open World 2018

Oracle OpenWorld started yesterday and San Francisco is just buzzing with Oracle folks and the excitement generated by the Oracle Autonomous Database.

If you missed Larry Ellison’s keynote yesterday the short video below will service as a good recap!

If you are interested in more information on the Autonomous Database and how it’s changing the roll of the DBA, be sure to check out the following sessions today:

  • An Insider’s Guide to Oracle Autonomous Transaction Processing
    Session TRN3979 at 11:15am in Moscone West – room 3003
    Robert Greene and I will provide an insiders view to the technology underlying Oracle Autonomous Database  and give you a guided tour of getting started with the Oracle Autonomous Transaction Processing.
  • Test Drive Automatic Index Creation in Oracle Autonomous Database Cloud
    Session TRN3980 at 4:45pm in Moscone West – room 3003
    After hearing all about Autonomous Transaction Processing in the morning session, we are sure you will be ready for a deeper dive into the Automatic Indexing capabilities. Mohamed Zait (lead architect on the Optimizer team) and I will explain exactly how Automatic Indexing works and share with you the results of this awesome capability in action.

You can also get your Autonomous Database laptop stickers at either of these sessions!

Posted in OOW | Tagged | Leave a comment

Day 1 Oracle Open World 2018

The biggest day of the Oracle calendar has arrived.

Oracle OpenWorld 2018 officially starts today!

The show kicks off with ton’s of great technical sessions including several great sessions on Oracle Autonomous Database.

  • 9:00 AM – 9:45AM Oracle Exadata: Strategy and Roadmap for New Technologies, Cloud, and On-Premises – session PRM4114 in Moscone West room 3008.
    Kick off your OpenWorld with Juan Loaiza as he provides an overview of current and future Exadata capabilities, which is the underlying infrastructure for our Autonomous Database both in the public cloud, and Oracle Cloud at Customer technologies.
  • 11:00 AM – 12:15 PM Oracle Autonomous Database – session PKN3947  in the Arena in Moscone South.
    In this general session Andy Mendelsohn will shares the latest updates from the Database Development team along with customer reaction to Oracle Autonomous Database.
  • 1:45 PM – 3:00 PM Larry’s keynote in Moscone North – Hall D. A must see, as he is going to share details on Gen 2 Cloud and the Oracle Autonomous Database!
  • 4:45 PM – 5:30 PM Oracle Autonomous Transaction Processing Overview and Roadmap – session PRO3978 in Moscone West room 3003. Finish your afternoon with Juan Loaiza and I as we< explain how our unique Autonomous Database works and illustrates how it can simplify your approach to data management and accelerate your transition to the cloud.

Hope to see ya there!

Posted in OOW | Tagged | Leave a comment

Time to start planning for Oracle Open World 2018

With just a week to go until Oracle Open Worldthe largest gathering of Oracle customers, partners, developers, and technology enthusiasts, I thought I would share with you what you can expect.

Of course the Autonomous Database team will be there and you will have multiple opportunities to meet up with us, in one of our technical sessions, our hands-on-labs or at the Oracle demogrounds.

This year the Autonomous Database team has 5 technical sessions:

  • Monday, October 22nd at 4:45pm What to expect from Oracle Autonomous Transaction Processing
    Session PRO3978 at Moscone West – room 3003
    Juan Loaiza reveals what motivated Oracle to develop the Autonomous Database and provides a clear understanding of how this unique cloud services works and how you can expect it to change the wait you interact with the Database.
  • Tuesday, October 23rd at 11:15am An Insider’s Guide to Oracle Autonomous Transaction Processing
    Session TRN3979 at Moscone West – room 3003
    Robert Greene and I will provide an insiders view to the technology underlying Oracle Autonomous Database  and give you a guided tour of getting started with the Oracle Autonomous Transaction Processing.
  • Tuesday, October 23rd at 4;45pm Test Drive Automatic Index Creation in Oracle Autonomous Database Cloud
    Session TRN3980 at Moscone West – room 3003
    After hearing all about Autonomous Transaction Processing in the morning session, we are sure you will be ready for a deeper dive into the Automatic Indexing capabilities. Mohamed Zait (lead architect on the Optimizer team) and I will explain exactly how Automatic Indexing works and share with you the results of this awesome capability in action.
  • Wednesday, October 24th at 11:15am The Changing Role of the DBA
    Session TIP5526 at Moscone West – room 3003
    As we move into a new era of Autonomous Database, there is naturally some concern regarding how it will impact the role of the DBA.  In this session Penny Avril and I will describe the evolution of the role of the DBA with the introduction of the Autonomous Database and what you can do to prepare.
  • Thursday,October 25th at 9:00am Autonomous Transaction Processing and the Business-Critical Application
    Session CAS5200 at Moscone West – room 3003
    In our fifth and final session Robert Greene and Binoy Sukumaran, explain how Oracle Autonomous Database  addresses the reality of the business-critical application.

You will also have an opportunity to try out Oracle Autonomous Database for yourself in our hands-on lab, Oracle Autonomous Database Cloud Driving School that will run every day in the Marriott Marquis (Yerba Buena Level) – Salon 9B.

PLEASE NOTE: YOU MUST BRING YOUR OWN LAPTOP (BYOL) TO PARTICIPATE IN THE HANDS-ON LABS.

If you have burning questions related to Oracle Autonomous Database, you can ask them at the Autonomous Database demo booths in the Database area of the demogrounds in Moscone South. Members of theAutonomous Database development team as well as the Product Managers will be there Monday to Wednesday from 9:45am until 5:30pm. The demo booth is also the place to get an Autonomous Database laptop sticker! 

The Autonomous Database team aren’t the only ones talking about Oracle Autonomous Database at this year’s conference. There are also a number of great sessions being delivered by Oracle ACEs including Julian Dontcheff‘s session on Migrating to Oracle Autonomous Data and Jim Czuprynski‘s case study. Check out the full searchable OOW catalog on-line to start planning your trip today!

Posted in OOW | Tagged , | Leave a comment

Getting started with Oracle Autonomous Transaction Processing

Getting started with Oracle Autonomous Transaction Processing is actually much easier than you might think. In fact, with Oracle’s $300 in free cloud credits you can probably get your first 30 days on the service for free. Please note, you will require an active email address and credit card in order to sign up for a trial account. Of course, if you have existing cloud credits you can skip this step.

Once you sign up for trail account you’ll get an email with your tenancy, username and password. Armed with this information, head on over to https://cloud.oracle.com to sign in. The video below explains in detailed the simple steps needed to provision a new Autonomous Transaction Processing database. I’ve also listed these steps below the video, for  easy reference.

Continue reading

Posted in Autonomous Database, Beginners, Oracle Database 18c, Top_Tip | Tagged , , , | 1 Comment

What you can expect from Oracle Autonomous Transaction Processing

Today Larry Ellison announced the general availability of Oracle Autonomous Transaction Processing (ATP), the newest member of the Oracle Autonomous Database family, combining the flexibility of cloud with the power of machine learning to deliver data management as a service.

Traditionally, creating a database management system required a team of experts to custom build and manually maintain a complex hardware and software stack. With each system being unique, this approach led to poor economies of scale and a lack of the agility typically needed to give the business a competitive edge.

ATP enables businesses to safely run a complex mix of high-performance transactions, reporting, and batch processing using the most secure, available, performant, and proven platform – Oracle Database on Exadata in the cloud. Unlike manually managed transaction processing databases, ATP provides instant, elastic compute and storage, so only the required resources are provisioned at any given time, decreasing runtime costs.

But what does the Autonomous in Autonomous Transaction Processing really mean?

Self-Driving

ATP is a self-driving database, meaning it eliminates the human labor needed to provision, secure, update, monitor, backup, and troubleshooting a database.  This reduction in database maintenance tasks, reducing costs and freeing scarce administrator resources to work on higher value tasks.

Continue reading

Posted in Autonomous Database, Exadata, Oracle Database 18c | Tagged , , | 1 Comment

How does Autonomous Transaction Processing differ from the Autonomous Data Warehouse?

In my previous post, I explained that  Oracle Autonomous Transaction Processing has three main attribute: Self-Driving, Self-Securing and Self-Repairing. All of the functionality I described in that post is shared between both the Autonomous Data Warehouse (ADW) and ATP.

Where the two services differ is actually inside the database itself. Although both services use Oracle Database 18c, they have been optimized differently to support two very different but complimentary workloads. The primary goal of ADW is to achieve fast complex analytics, while ATP has been designed to efficiently execute a high volume of simple transactions.

Configuration

The differences in the two services begins with how we configure them. Continue reading

Posted in Autonomous Database, Oracle Database 18c | Tagged , , , | 2 Comments

Oracle Launches TimesTen Scaleout!

What a week for announcements! First we had Oracle Database 18c available on-premises and now Oracle TimesTen Scaleout.

If you are not familiar with TimesTen, let me reminder you that it’s Oracle’s  In-Memory Database. In fact, it’s been a leading in-memory database for mission critical applications for over 20 years, and today they just launched an exciting new scalability feature called TimesTen Scaleout.

So, What is Scaleout?

TimesTen Scaleout is a distributed database, with a shared nothing architecture specifically designed to address real-time, transaction processing workloads. Think IoT, real-time trading, telecommunications billing or real-time fraud detection.

Continue reading

Posted in Database In-Memory, New Features, Uncategorized | Tagged , | Leave a comment