Introduction Thanks to the ODI JKMs for GoldenGate, we do not need to have much experience with GoldenGate to configure a replication environment: ODI generates...
Introduction Thanks to the ODI JKMs for GoldenGate, we do not need to have much experience with GoldenGate to configure a replication environment: ODI generates all the necessary parameters for GoldenGate; it can communicate in real-time with your GoldenGate instance and make sure that changes propagated by GoldenGate will be processed by ODI with no additional setup or configuration. But when we already have a fine tuned GoldenGate installation, the last thing we want is for...
Introduction Thanks to the ODI JKMs for GoldenGate, we do not need to have much experience with GoldenGate to configure a replication environment: ODI generates all the necessary parameters...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC)....
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys will produce a JSON file with log information that can be used for monitoring purposes. The naming style per file looks like shown below: EXTRACT_STATUS_DATA_SCHEDULE_<Schedule ID>_REQUEST_<Request ID>.JSON BICC Extract log file for VO data if been chosen in run definition...
Introduction EXTRACT JSON files Since end of 2018 SaaS Cloud provides a new feature to track the status of a data extraction run in BI Cloud Connector (BICC). Every single run to extract data or keys...
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; } We are reworking the content of this blog. Please stay tuned. Thanks.
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...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It demonstrates both the Thin and Oracle Call Interface (oci) versions of the Oracle JDBC driver. It is a companion post to Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse which uses ODI Studio on Windows and Connecting DIPC ODI Studio to the Autonomous...
Introduction This post details the steps required to create connections in Oracle Data Integrator Cloud Service (ODICS) on Oracle Cloud Infrastructure (OCI) to the Autonomous Data Warehouse (ADW). It...
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: August 1, 2019 for OAC Version 105.3 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse...
Last Validation: August 1, 2019 for OAC Version 105.3 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 Data Visualization (DV) data sets, DV Replications, Metadata (RPD) connection pools, and Thin Client Modeler (TCM) models. Data connections are used for DV data sets. Replication connections are used for DV...
Last Validation: August 1, 2019 for OAC Version 105.3 Introduction This post details the steps required in OAC versions 5.1+ to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data,...
