Oracle Autonomous Database: A DBA Perspective

When more people started using Autonomous Database services, more Admin tools are made available as well. When ADW was introduced, all the DBA had for monitoring or diagnosis or utilization was only the Service Console. Here are some administrative enhancements in ATP/ADW we saw in the past 1+ year.

  • July 2018: SQL Developer 18.2.0 and later allows for setting up connections without the need for Keystore passwords.
  • September 2018: Autonomous Data Warehouse allows users to create partitioned tables, indexes, and materialized views. 
  • March 2019: Autonomous Database provides cloning where you can choose to clone either the full database or only the database metadata. 
  • April 2019: A simple way to secure your autonomous database instances using network access control lists. Specifying an access control list blocks all IP addresses that are not in the list from accessing the database. 
  • May 2019: Oracle Management Cloud supports monitoring Autonomous Databases via its Oracle Database Management console. This provides both monitoring and alerting for your Autonomous Database instances. 
  • May 2019: It is possible to create a database link from an ADW instance to any database that is accessible from an ADW/ATP including other ADW/ATP instances.
  • June 2019: You can select auto-scaling during provisioning or later using the Scale-Up/Down button on the Oracle Cloud Infrastructure console.
  • June 2019: Oracle Rest Data Services (ORDS) is included with Autonomous Database. ORDS maps HTTP(S) verbs (GET, POST, PUT, DELETE, etc.) to database operations and returns any results formatted using JSON. 
  • June 2019: Oracle SQL Developer Web provides a browser-based integrated development environment and administration interface for Oracle Autonomous Database. 
  • June 2019: Autonomous Database includes Oracle’s premiere low-code development platform: Application Express (APEX). 
  • July 2019: Customers can get a real-time and historical view of performance data directly on the OCI console using Performance Hub.
  • August 2019: Autonomous Database supports multiple directories which makes it even easier for customers to migrate their existing applications to ADB.

Oracle Open World 2019 announced that there are two autonomous databases included in the Always Free tier! Great news!! Now, DBAs and developers have no reason not to get into Autonomous Database and start playing. Maybe you can develop an application using APEX and ATP for your favorite local charity 🙂

I will be comparing the traditional DBA activities against the activities you can do on ATP or ADW of Autonomous Database service in my talk “Autonomous Database: What’s the Admin’s Role?” on Sep 27th at the Arizona User Group meeting.

https://www.meetup.com/Arizona-Oracle-User-Group/events/264171869/

East Coast Oracle #ECO14 Conference

eco14

Today I am traveling to Raleigh, North Carolina for the East Coast Oracle conference. Very excited to be part of this conference, as I have activities planned for all three days. This is the first time attending and presenting at ECO.

Though I attended OOW14, ECO14 will be the conference after GLOC14 (Great Lakes Oracle Conference – May 2014) where I present.

Monday Nov 3: I am truly excited to help Eric Benner to organize the #RACATTACK event – “RAC Attack Isn’t Just about RAC“. RAC Attack is a wonderful and creative effort by the experts in RAC to get everyone have hands on experience with RAC installation and configuration. This is great. Even if you are not able to make to any of the user group conferences and try out RAC Attack, I encourage you to download the RAC Attack Wiki book and start setting up your RAC on the laptop using Virtual Machine.

Tuesday Nov 4: I am presenting at 3:15 on “Flashback Instead of Restore… Save Time and Be a Hero!”. Here I will be taking about the various flashback features of the database since 9i and how a developer, power user or DBA can retrieve past state of data (table) without much recovery effort. Though this presentation was very late addition due to a cancellation, I am sure I will have something for you no matter what your role is – power user, developer, DBA or Manager!

Wednesday Nov 5: I will be presenting right after the keynote by Floyd Teter on “Lesser Known New Features of Oracle Database 12c“. Though I titled it “new features”, Oracle 12c was released over a year ago, so most people are familiar with the top features of 12c. I will be concentrating on the changes and quick benefits you as an 11g DBA can take from upgrading to 12c. You might also take home a copy of my “OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062” book!

The timing of my article in North California Oracle User Group (NoCOUG) Journal is perfect, where I discussed few of the Oracle Database 12c features. The session on Wed will be talking about a lot more!

There are several great presentations in the agenda. Please review the list of presentations here… If you are in the North Carolina neighborhood, do not miss the opportunity to listen to many great speakers.

The conference registration and agenda are available at https://www.eastcoastoracle.org

I am also excited and happy that OneNeck is sponsoring the event and is an exhibitor!

See you in Raleigh!