Introduction Oracle Recovery Manager (RMAN) is a sophisticated tool that database administrators have been using to take the backup of their on-premises...
Introduction Oracle Recovery Manager (RMAN) is a sophisticated tool that database administrators have been using to take the backup of their on-premises databases. As the organizations move their databases to cloud, the database administrators may want to continue to use RMAN to perform backup and recovery operations. Oracle Cloud Infrastructure (OCI) offers several services and options, including RMAN, to take the backup of your databases. In this blog I will not be...
Introduction Oracle Recovery Manager (RMAN) is a sophisticated tool that database administrators have been using to take the backup of their on-premises databases. As the organizations move...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } Introduction In order to have a single source of truth for an organization’s data,...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } Introduction In order to have a single source of truth for an organization’s data, a reference data solution is often required. This reference data once define can be used by operational systems as well as reporting and analytics system. A common analytics requirement is to integrate and ingest reference data into a data warehouse or a data mart. The Oracle Cloud solution to support reference data...
p { margin:0; padding:0; line-height:20px; } div { margin:0; padding:0; } Introduction In order to have a single source of truth for an organization’s data, a reference data solution is often...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions OCI Compute Oracle-Linux-7.6-2018.11.19-0 Instant Client 18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB 18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud Account and an OCI Tenancy Access to an ADW instance Administrator Credentials to both of the above An export...
Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Cloud Infrastructure (OCI). Versions...
This blog has been retired as ODICS is no longer offered. Please see...
This blog has been retired as ODICS is no longer offered. Please see https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.3/odimp/getting-started-oracle-cloud-marketplace.html#GUID-1793F6A6-8581-465D-BBE3-8F0C8ADD6536 for the new ODI Marketplace usage.
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring their environments. In this article we're going to discuss various areas that should be monitored regularly to avoid degradations in performance and unscheduled outages. The concepts, scripts, and information presented in this article are for educational purposes only. They are not supported by...
Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring...
For other A-Team articles by Richard, click here Note: This article is for Classic Cloud Storage. For Oracle Cloud Infrastructure (OCI) Object Storage please...
For other A-Team articles by Richard, click here Note: This article is for Classic Cloud Storage. For Oracle Cloud Infrastructure (OCI) Object Storage please use this article. Introduction Set up Oracle Fusion SaaS Business Intelligence Cloud Connector (BICC) to use Oracle Cloud Infrastructure (OCI) Object Storage This article walks through the steps to set up a Cloud Storage Container, for use with the Fusion SaaS BI Cloud Connector. This may be of particular interest...
For other A-Team articles by Richard, click here Note: This article is for Classic Cloud Storage. For Oracle Cloud Infrastructure (OCI) Object Storage please use this article. Introduction Set up...
Last Validation: May 19, 2020 for OAC 105.6 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW)...
Last Validation: May 19, 2020 for OAC 105.6 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data, replication and console connections. The wallets are used for Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for DV data sets. Replication connections are used for DV replications. Console connections are used for TCM models and RPD models...
Last Validation: May 19, 2020 for OAC 105.6 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data, replication...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics Cloud (OAC and OAAC), to replicate data, on a schedule, from a number of Oracle's SaaS offerings. For many use cases, this will mean that a separate extract and load processes, is no longer required. In this initial release, the sources that can be replicated are: - Oracle Fusion...
For other A-Team articles by Richard, click here Introduction In the recent Oracle Analytics Cloud release, exciting new SaaS data replication functionality was added. This allows Oracle Analytics...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to extract data for most use cases, is through the BI Cloud Connector tool. This pulls data from 'View Objects' in the Business Intelligence layer of Fusion SaaS. Other tools can also extract from these view objects. BI Apps customers have pre-created ODI mappings, that take the...
For other A-Team articles by Richard, click here Introduction For good reason, the database of Fusion SaaS products is not available for ETL tools to work directly against. The recommended approach to...
