An event dedicated to OCI (Cloud) enthusiasts, full of sessions, workshops, and hands-on labs in English, Chinese, Japanese and Korean languages.



APACOUC (APAC Oracle Users Groups Community) was formed to unify and support all Oracle Users Groups and Java User Groups in the Asia Pacific region as one, with the main goal of promoting knowledge exchange and helping the growth of all the communities within the Asia Pacific. 

Our main mission is to help all Oracle User Groups and Java User Groups communities in the APAC region to increase their membership numbers, content and potentiate knowledge exchange in the region. For the past 12 years, APACOUC has organized the Oracle Groundbreakers APAC and Webinar Tours that brought Oracle Celebrities to many countries, such as Australia, New Zealand, Japan, South Korea, China Mainland, and Singapore.

An event dedicated to OCI (Cloud) enthusiasts, full of sessions, workshops, and hands-on labs in English, Chinese, Japanese and Korean languages. APACOUC (APAC Oracle Users Groups Community) was formed to unify and support all Oracle Users Groups and Java User Groups in the Asia Pacific region as one, with the main goal of promoting knowledge exchange and helping the growth of all the communities within the Asia Pacific. Our main mission is to help all Oracle User Groups and Java User Groups communities in the APAC region to increase their membership numbers, content and potentiate knowledge exchange in the region. For the past 12 years, APACOUC has organized the Oracle Groundbreakers APAC and Webinar Tours that brought Oracle Celebrities to many countries, such as Australia, New Zealand, Japan, South Korea, China Mainland, and Singapore.

APAC OCI Days 2022

The Oracle and Microsoft cloud interoperability partnership enables customer workloads to run across Azure and Oracle Cloud seamlessly. Developers can manage common Oracle Cloud and Oracle Autonomous Database design-time tasks with Visual Studio and Visual Studio Code tools. In this session, we will present the latest partnership updates and demo various ways to deploy and configure Azure ASP.NET Core web apps connecting to Oracle Autonomous Database, a common usage scenario.

Multicloud Development with Azure and Oracle Database Cloud

Database-Autonomous-PaaS

Developer

When you buy a car it comes with seat belts ... but seat belts do not enable themselves when you get into the car. An Oracle Database comes with an extensive set of configurable security options but they, like the seat belt, require owner input. This session by Oracle ACE Director Alum and Oracle Consulting Technical Director for Database Security is focused on ways that DBAs and Developers can reduce the attack surface of Oracle databases and enhance security.

Oracle Database Attack Surface Reduction

When you buy a car it comes with seat belts ... but seat belts do not enable themselves when you get into the car. An Oracle Database comes with an extensive set of configurable security options but they, like the seat belt, require owner input.

This session by Oracle ACE Director Alum and Oracle Consulting Technical Director for Database Security is focused on ways that DBAs and Developers can reduce the attack surface of Oracle databases and enhance security.

Identity and Security

You will hear how to Get on a Minimal Viable Product (MVP) Journey with Oracle's Cloud Platform, where the horizontal and vertical engineering nature of our Cloud Capabilities means organisations can fast learn and validate, what is possible both from a Business and Tech outcome perspective. We will see and touch an MVP Example which had a variety of Iterative Approaches, where APEX was the technology of choice.

Creating a Minimal Viable Product with Oracle 

You will hear how to Get on a Minimal Viable Product (MVP) Journey with Oracle's Cloud Platform, where the horizontal and vertical engineering nature of our Cloud Capabilities means organisations can fast learn and validate, what is possible both from a Business and Tech outcome perspective. We will see and touch an MVP Example which had a variety of Iterative Approaches, where APEX was the technology of choice.

Connection Manager with Traffic Director Mode (CMAN-TDM) is Oracle's comprehensive database connection proxy solution that brings high availability, scalability, security, and performance benefits for accessing local and remote Oracle databases. This practical session walks through the process of configuring CMAN-TDM to connect to Oracle Cloud Autonomous Database and also puts forth the benefits of using CMAN-TDM.

Configuring Connection Manager with Traffic Director Mode (CMAN-TDM) on Oracle Cloud

OCI Infrastructure Track (Compute, Storage and Network)

Infrastucture

The presentation covers 2 main topic: #1 why to use Oracle Autonomous Database in the Cloud and #2 how Oracle Autonomous Database performance compares to other major databases in the Cloud

Comparing Oracle Database Performance in the Cloud

The presentation covers 2 main topic: #1 why to use Oracle Autonomous Database in the Cloud and #2 how Oracle Autonomous Database performance compares to other major databases in the Cloud

I work with Exadata since 2010, but recently got one project to move to EXACC, but what did I learn from this project? In this session, I will show some important technical detail about this project. Let's discuss how to create databases using ExaCC/OCI tools, JSON, domains, and several other details that can help you to decide to use (or not) ExaCC. But not just that, architecture datils for CPU calling and even protection to each MAA blueprint.

Moving from Exadata to ExaCC - What I learned?

I work with Exadata since 2010, but recently got one project to move to EXACC, but what did I learn from this project? In this session, I will show some important technical detail about this project. 

Let's discuss how to create databases using ExaCC/OCI tools, JSON, domains, and several other details that can help you to decide to use (or not) ExaCC. But not just that, architecture datils for CPU calling and even protection to each MAA blueprint.


Cloud Migration

Businesses want to enjoy the benefits of the cloud. Lots of them are looking to modernize and adopt new digital technologies to replace old, none efficient systems or manual processes. 
This could dramatically improve how they operate and how they deliver value to their customers.
We all know about the advantages of going to the cloud:
- cost saving.
- improve time to market. 
- use new technologies.
- etc.
 
But one concern is still there, even more today, “Security”. “Is my data safe and securely stored on the cloud”.
 
In this session, I will cover the subjects like:
- Data and Application Protection
- What is the Cloud Shared Responsibility Security Model
- Cloud Services to observe and control the Security
            - Cloud Guard
            - Security Zones
            - Data Safe
            - etc.
 
The objective of that session is to explain how you can control your security posture on OCI and, we will conclude by saying that “security” might be one of the good reasons you should go to the cloud.

I know, I know, I need to improve my security on Oracle Cloud Infrastructure !

Businesses want to enjoy the benefits of the cloud. Lots of them are looking to modernize and adopt new digital technologies to replace old, none efficient systems or manual processes. This could dramatically improve how they operate and how they deliver value to their customers.
We all know about the advantages of going to the cloud:
- cost saving.
- improve time to market. 
- use new technologies.
- etc.
 
It’s a no brainer, businesses are going on cloud. Last couple of years, with the pandemic, the journey to the cloud was even accelerated. 
But one concern is this there, even more today, “Security”. “Is my data safe and securely stored on the cloud”. Some people feel more confident when the data resides on a server they can see.
 
Yes, Security is still a valid concern. 
 
In this session, I will cover the subjects like:
- Security first-design and Platform Security
- Fault Tolerant Infrastructure
- Data and Application Protection
- What is the Cloud Shared Responsibility Security Model
- Cloud Services to observe and control the Security
            - Cloud Guard
            - Security Zones
            - Data Safe
            - etc.
 
The objective of that session is to explain how you can control your security posture on OCI and at the end, we will try to conclude saying that “security” might be one of the reason to go to the cloud.

I knonw, I know, I need to improve my security on Oracle Cloud Infrastructure !

When it comes to database infrastructure, it seems there's never enough to go around. Backup and recovery validation, patching, and performance tuning affect systems availability and function, and don't coexist with business processes. Organizations usually prioritize the competitive needs of visible, customer-facing improvements over seemingly less-immediate backend testing.

Cloud services change the equation. Cheap, virtually unlimited compute power and storage are there for the taking—with one catch. Who sets it up? Navigating a cloud interface to create hosts, assign disks, and configure networking is tedious and time consuming. Once that's done you still have to install software and prepare the environment. Enter Terraform, an automation tool that streamlines and simplifies infrastructure builds. In this session, database administrators learn the basics to provision a database and supporting infrastructure on Oracle Cloud with Terraform. No prior experience with Terraform or Oracle Cloud is required. 

Terraform on Oracle Cloud: A Primer for DBAs

You are a business expert and a real guru with data but why does machine learning feel so difficult? A successful machine learning needs a team of people with different skills and you are only one person with the skillset you have. How to get started with machine learning? Do I need to go back to school to learn mathematics and statistics again? Do I need to learn all the machine learning processes, algorithms, hyperparameters and whatever is related to machine learning? Panic! But luckily there is no need for a panic: AutoML is for you. Automated machine learning (AutoML) is a shortcut to machine learning. It automates many of the steps on machine learning process, and lets you concentrate on your expertise: data. Machine learning services are easy to use tools for a particular machine learning use case. In this presentation we talk about AutoML and machine learning services. We will do some demos on using automated machine learning and machine learning services.

Automated machine learning and machine learning services in OCI

You are a business expert and a real guru with data but why does machine learning feel so difficult? A successful machine learning needs a team of people with different skills and you are only one person with the skillset you have. How to get started with machine learning? Do I need to go back to school to learn mathematics and statistics again? Do I need to learn all the machine learning processes, algorithms, hyperparameters and whatever is related to machine learning?
Panic!
But luckily there is no need for a panic: AutoML is for you. Automated machine learning (AutoML) is a shortcut to machine learning. It automates many of the steps on machine learning process, and lets you concentrate on your expertise: data. Machine learning services are easy to use tools for a particular machine learning use case.
In this presentation we talk about AutoML and machine learning services. We will do some demos on using automated machine learning and machine learning services.

Analytics and AI

Learn how to migrate on-premises Database with confidence to Autonomous, and to DBCS (ExaCC, ExaCS, BM, or VM), Use Migration Workbench to evaluate the readiness of database assets to securely migrate, efficient, and agile while reducing the risks of human error. Find out how the performance of the migrated databases is validated automatically

Use Migration Workbench to:
- Evaluate database migration readiness, dependencies, shapes and pre-requisites
- Prepare databases for migration, use appropriate migration methods
- Validate results, compare performance and configuration to the source database
- Automate end-to-end migration at scale using REST APIs

Foolproof migration to Oracle Autonomous Database Using Migration Workbench

Automation of software delivery has several advantages. Prevention of human error is certainly one. Consistent and complete execution of tried and tested build and deployment tasks as the only way to apply changes in the live environment. Once the pipelines have been set up, the engineers can focus on the software and applying the required changes to it. To bring that software all the way to production is a breeze. Oracle Cloud Infrastructure offers the DevOps service, introduced in the Summer of 2021. This service comes with git style code repositories, build servers and build pipelines, artifact repositories as well as deployment pipelines.  This session introduces OCI DevOps and demonstrates how software can be built and deployed on OKE Kubernetes, Compute Instance VMs and Oracle Functions. From simple source code an application is put in production without manual intervention in the build and deployment process.

Automation of Software Engineering with OCI DevOps Build and Deployment Pipelines

As database professionals we are the custodians of our organisations data and the event of any data related issue are usually one of the first Data Heroes on the scene. As Guardians of the Data we need to constantly review and reduce our exposure to malware and other threats, by adopting a multi-level approach to data protection we can give ourselves the best possible protection. In this presentation I will discuss the need for a multi-layered approach and share some of the steps we can take to protect our backups from ransomware attacks and malicious intent. I will share code and examples of the steps need to avoid becoming headline news across the globe.

Guardians of the Data - Protecting Oracle Backups from Ransomware and Malicious Intent

As database professionals we are the custodians of our organisations data and the event of any data related issue are usually one of the first Data Heroes on the scene.

As Guardians of the Data we need to constantly review and reduce our exposure to malware and other threats, by adopting a multi-level approach to data protection we can give ourselves the best possible protection.

In this presentation I will discuss the need for a multi-layered approach and share some of the steps we can take to protect our backups from ransomware attacks and malicious intent.

I will share code and examples of the steps need to avoid becoming headline news across the globe.

Transactions gather data, which when processed becomes information. Knowledge is accumulation of information, that empowers you. Imagine having a single platform that empowers your entire organization to ask any question of any data in any environment on any device. Regardless of which applications you use, imagine being able to use this in your organization today! Join Oracle ACE Director, Basheer Khan, as he introduces you to the capabilities of Oracle Analytics Cloud and provides an effective approach to start using it today. This session includes a live demonstration of Oracle Analytics and Oracle Quick SQL, a rapid design tool.

Oracle Analytics Cloud: You can leverage it today!

Transactions gather data, which when processed becomes information. Knowledge is accumulation of information, that empowers you. Imagine having a single platform that empowers your entire organization to ask any question of any data in any environment on any device. Regardless of which applications you use, imagine being able to use this in your organization today! Join Oracle ACE Director, Basheer Khan, as he introduces you to the capabilities of Oracle Analytics Cloud and provides an effective approach to start using it today. This session includes a live demonstration of Oracle Analytics and Oracle Quick SQL, a rapid design tool.

A major new version of the extremely popular Python DB API for Oracle Database brings significant ease-of-use benefits. Learn all about the new driver version functionality and see how to create efficient Python applications for Oracle Database.

The Latest and Greatest Python DB API for Oracle Database

A major new version of the extremely popular Python DB API for Oracle Database brings significant ease-of-use benefits.  Learn all about the new driver version functionality and see how to create efficient Python applications for Oracle Database.

Oracle Zero Downtime Migration (ZDM) is Oracle’s premier solution for a simplified and automated migration experience to the Cloud providing zero to negligible downtime for migration of on-premise production workloads to the Oracle Cloud Infrastructure. ZDM follows Oracle Maximum Availability Architecture (MAA) principles completely and incorporates products such as GoldenGate and Data Guard to ensure High Availability and an online migration workflow which supports both a logical as well as physical model. This technical brief provides an overview of Oracle Zero Downtime Migration 21.3, the latest version, explaining its underlying workflow and how you can use it for efficient and seamless migration of your Oracle Databases.

Zero Downtime Migration 21.3 Overview 

Oracle Zero Downtime Migration (ZDM) is Oracle’s premier solution for a simplified and automated migration experience to the Cloud providing zero to negligible downtime for migration of on-premise production workloads to the Oracle Cloud Infrastructure.

ZDM follows Oracle Maximum Availability Architecture (MAA) principles completely and incorporates products such as GoldenGate and Data Guard to ensure High Availability and an online migration workflow which supports both a logical as well as physical  model.

This technical brief provides an overview of Oracle Zero Downtime Migration 21.3, the latest version, explaining its underlying workflow and how you can use it for efficient and seamless migration of your Oracle Databases.


If you are running MySQL on AWS RDS or Aurora and users always complain about database performance, then it's time to migrate your database to OCI MySQL Database Service (MDS). MDS is a fully managed OCI native service developed, managed, and supported by the MySQL team in Oracle. Heatwave is an add-on to MDS that provides a highly performant and scalable in-memory analytic processing engine optimized for OCI. As per the latest performance benchmark results, MDS with Heatwave is 5400x faster than Amazon RDS and 1400x faster than Amazon Aurora. Also, MDS is a single stop for both OLTP and OLAP and this eliminates the need for a separate analytics database. All this comes with 2/3 the cost of Amazon RDS and 1/2 the cost of Amazon Aurora. In this presentation, we talk about the steps required to migrate your RDS/Aurora database to OCI MDS.

Migrate AWS RDS MySQL/Aurora to OCI MySQL Database Service (MDS)

If you are running MySQL on AWS RDS or Aurora and users always complain about database performance, then it's time to migrate your database to OCI MySQL Database Service (MDS). 

MDS is a fully managed OCI native service developed, managed, and supported by the MySQL team in Oracle. Heatwave is an add-on to MDS that provides a highly performant and scalable in-memory analytic processing engine optimized for OCI.

As per the latest performance benchmark results, MDS with Heatwave is 5400x faster than Amazon RDS and 1400x faster than Amazon Aurora. Also, MDS is a single stop for both OLTP and OLAP and this eliminates the need for a separate analytics database. All this comes with 2/3 the cost of Amazon RDS and 1/2 the cost of Amazon Aurora. 

In this presentation, we talk about the steps required to migrate your RDS/Aurora database to OCI MDS. 

In this session Ron will introduce Kubernetes database Operators and share how they can be used to deliver database-as-a-service (DaaS). Ron will explorer what functionality database administrators require from their database Operators to provide enterprise level support. Ron will provide the latest news on the Oracle database Kubernetes Operator and deliver a demonstration of it’s use.

Delivering Database-as-a-Service with Kubernetes Operators

In this session Ron will introduce Kubernetes database Operators and share how they can be used to deliver database-as-a-service (DaaS). Ron will explorer what functionality database administrators require from their database Operators to provide enterprise level support. Ron will provide the latest news on the Oracle database Kubernetes Operator and deliver a demonstration of it’s use.