X

Information, tips, tricks and sample code for Big Data Warehousing in an autonomous, cloud-driven world

Autonomous Database Newsletter - April 08-2020

Keith Laker
Senior Principal Product Manager
 


Autonomous Database
on
Shared Exadata
Infrastructure

April 08, 2020
 


 

ADB Logo
 

Welcome to our latest customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This newsletter covers the following new features and topics:

Don't forget to checkout our "What's New" page for a comprehensive archive of all the new features we have added to Autonomous Database - click here.

 
Feature Icon

(Shared
Infrastructure
Only)


NEW - Upgrade an Autonomous Database Instance to Oracle Database 19c

Oracle Database 19c is now available on Autonomous Database for all regions. In select regions, customers can choose between Oracle Database 18c and Oracle Database 19c for new databases. The default version for all new databases is 19c and going forward, most new Autonomous Database features will only be available for databases using Oracle Database 19c.

Please start planning for the upgrade of your applications to Database 19c. For most applications, there should not be any changes required. However, it is recommended you should test your applications with Database 19c. You can easily test your applications by creating a clone of your current database to Oracle Database 19c, and testing your application using this clone.

Oracle Database 18c is scheduled to be available in Autonomous Database until September 2020.

You can choose to upgrade your database at any time during this period. After that time, all existing databases will be automatically upgraded to Oracle Database 19c. There are several approaches to upgrading your database which are described in the documentation, see links below.

Note: Autonomous Database plans to offer a new upgrade path starting in April, with a single button that provides a one-way, in-place upgrade.

 
LEARN MORE

 

DOC: Upgrade an ADW instance to Database 19c, click here

DOC: Upgrade an ATP instance to Database 19c, click here

 

DO MORE

 

BLOG: More information about ADB cloning feature is here


 
 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)


NEW - Enhancements to Data Pump

1) Support For Pre-Authenticated URLs

This enhancement allows Oracle Data Pump to use Oracle Cloud Infrastructure pre-authenticated URIs for source files on Oracle Cloud Infrastructure Object Storage.

Note: Customers should carefully assess the business requirement for and the security ramifications of pre-authenticated access. There is more guidance available in the documentation.

 
LEARN MORE

 

DOC: Import Data Using Oracle Data Pump on ADW, click here

DOC: Import Data Using Oracle Data Pump on ATP, click here

 

DO MORE

 

VIDEO: Database Migration with MV2ADB - a tool that provides support for moving existing databases to Oracle Autonomous Database, click here

O.COM: Oracle Database Cloud Migration Solutions page, click here


 
 
Feature Icon

(Shared
Infrastructure
Only)


2) Data Pump Export to Object Store

It is now possible for Oracle Data Pump to export directly to Oracle Object Store. This simplifies the process of moving data between Autonomous Data Warehouse and other Oracle databases. This export method is supported with Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic.

 
LEARN MORE

 

DOC: Move Data with Data Pump Export to Object Store on ADW, click here

DOC: Move Data with Data Pump Export to Object Store on ATP, click here

 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)


NEW - Menu Option to Restart ADB Instance

A new menu option has been added to the OCI console to automate the process of stopping and then starting an ADB instance. The new menu option is labelled "Restart" as shown below:




 
LEARN MORE

 

DOC: How to restart an ADW instance, click here

DOC: How to restart an ATP instance, click here

 

BACK TO TOP
 
Feature Icon

(Shared
Infrastructure
Only)


NEW - README file added to Wallet

The Oracle client credentials wallet zip file now contains a README file. This file provides information about the wallet expiry date. An example of the contents of the new readme file is shown below:

 

Wallet Expiry Date
-----------------------
This wallet was downloaded on 2020-04-03 10:19:43.4 UTC.
The SSL certificates provided in this wallet will expire on 2025-03-31 21:26:18.928 UTC.
In order to avoid any service interruptions due to an expired SSL certificate, you must re-download the wallet before this date.

 
LEARN MORE

 

DOC: Download client credentials (wallets) for an ADW instance, click here

DOC: Download client credentials (wallets) for an ATP instance, click here

 

 

BACK TO TOP
 

VIDEO Oracle Global Leaders - Day With Development

A recording of a recent Oracle Global Leaders Day with Development workshop is now available for viewing. The workshop covers general architecture overview of Data Management Services on OCI and how the following services work together:

  • Big Data Service
  • Autonomous Data Warehouse
  • Data Integration Service
  • Streaming Service, Data Flow
  • Oracle Analytics Cloud

To watch the video click here.


 
 

WEBCAST - Global Leaders Customers: Autonomous Database Use Cases

Our Global Leaders team will be hosting a series of webcasts over the next six months where various customers will talk publicly about how they are using Autonomous Database. The schedule for April is:


April 29, 2020
at 15:00 CET

Oracle Global Leaders Webcast: Oracle Autonomous Database from the view of a CIO.

Join this webcast to discover directly from Rok Planinsec, CIO of Unior, SI how they are using Oracle Autonomous Database and the benefit they are getting.

At Unior Oracle Autonomous Data Warehouse and Oracle Analytics enable real-time operational reporting from months to seconds for more strategic decision-making with zero database administration.

 

 

BACK TO TOP
 
oracle.com Icon

oracle.com

ADW ATP
Documentation Icon

Documentation

ADW ATP
YCO calculation Icon

TCO Calculator

Shared Dedicated
Cloud Cost Estimator Icon

Cloud Cost Estimator

Autonomous Database
Public What's New Icon

ADB New Features

Autonomous Database
Schema Advisor icon

Schema Advisor

Autonomous Database
 
 
 
Public What's New Icon

Customer Forums

ADW ATP
 
 
 

BACK TO TOP
 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.