| [](README.md)
Last Updated: |
# Working with Autonomous Transaction Processing - Dedicated |
Oracle's Dedicated Autonomous Transaction Processing service allows an organization to Rethink Database IT, enabling a customizable private database cloud in the public cloud. The dedicated choice makes it possible to deliver a self-service database capability that aligns with organizational structure. Different lines of business or project teams can have complete autonomy in their individual execution while the company itself gets a fleet wide simplified aggregation of overall health, availability and cost management. This separation of Fleet vs Database administration allows simple budgeting controls and resource isolation without getting in the way of the line of business execution. And a dedicated database deployment will support the entire spectrum of needs from simple apps to apps that require the highest governance, consistent performance and operational controls.
These hands-on lab guides provide step-by-step directions to setting up and using your dedicated Autonomous database platform in the Oracle Cloud Infrastructure.
Lab 1 deals with setting up the network, users and groups and requires administrator privileges on your OCI account.
Labs 2 & 3 are geared towards the fleet administrator role responsible for deploying the autonomous exadata infrastructure and container databases.
Labs 4 and 6 - 12 are intended for a regular database user, DBA or developer who simply want to spin up an autonomous database in one of the pre-provisioned containers and start building applications.
Lab 13 onwards demonstrate the operational aspects of the service
- Prepare your private network in the Oracle Cloud Infrastructure
- Provision Exadata Infrastructure in a private OCI network
- Provision an Autonomous Container Database
- Provision databases on your dedicated Autonomous Infrastructure
- Setup VPN Connectivity to your Autonomous Exadata Infrastructure
- Configure a development system for use with your dedicated autonomous database
- Build and deploy Python application stacks on dedicated autonomous infrastructure
- Build and deploy node.js application stacks on dedicated autonomous infrastructure
- Build and deploy Java application stacks on dedicated autonomous infrastructure
- Use OCI CLI commands to work with your autonomous databases
- Invoke and use the sqldevweb console
- Build apex applications on the autonomous database
- Migrate an on-prem application schema using Data Pump
- Setup live migration of business critical databases using Oracle Goldengate replication
- Build 'Always-On' application on the autonomous database
- Manage database performance with Performance Hub
- Scale your database service with zero downtime
- Protect your data with Database Vault
- Recover from user errors using flashback recovery
- Setup monitoring events and notifications
What is an Autonomous Transaction Processing Dedicated?
The dedicated infrastructure feature of Oracle Autonomous Transaction Processing enables you to create an Oracle Autonomous Database platform that is private and isolated to your use all the way down to the Oracle Exadata hardware running your database instances and storing your database data.
You define and use Oracle Cloud Infrastructure Networking and IAM (Identity and Access Management) resources to ensure secure and authorized use of your dedicated Autonomous Transaction Processing databases and the database resources that underlie them.
You are all set, let's begin!
Key Objectives:
- Create compartments and user groups with the right set of access policies for separation of duties
- Create fleet admin and database user accounts
- Layout a secure network for the database and application infrastructure
Key Objectives:
As a fleet administrator,
- deploy an Autonomous Exadata Infrastructure in a pre-provisioned private network in your OCI account
- Understand AEI maintenance scheduling
- Understand database licensing options
Key Objectives:
As a fleet administrator,
- Deploy an Autonomous Container Database (ACD) onto an Autonomous Exadata Infrastructure (AEI)
Key Objectives:
As a database user, DBA or application developer,
- Rapidly deploy autonomous transaction processing databases
- Manage your database backups
Key Objectives: As a database user, DBA or application developer,
- Configure a secure connection from your application instance to your dedicated autonomous database using Oracle SQL Developer, SQLCL and SQL*Plus.
Key Objectives:
As a fleet / network admin,
- Configure a VPN server in OCI based on OpenVPN software
- Configure your VPN client and connect to VPN Server
As a database admin / user,
- Configure your VPN client and connect to VPN Server
- Launch SQL Developer on client and connect to a dedicated ATP instance
Key Objectives:
As an application developer,
- Learn how to deploy a node.js application and connect it to your dedicated autonomous database instance
Key Objectives:
As an application developer,
- Learn how to deploy a python application and connect it to your dedicated autonomous database instance
Key Objectives:
As an application developer,
- Learn how to deploy a java application and connect it to your dedicated autonomous database instance
Key Objectives:
As an application developer, DBA or DevOps user,
- Create/Destroy your autonomous database instances using a command line interface
- Interact with Oracle Cloud Infrastructure resource using a CLI instead of a web console
Key Objectives:
As an application developer, DBA or DevOps user,
- Access OCI autonomous database console and get URL for sql developer web cosole
- Create a VNC connection to developer client VM and access sqldevweb console
- Understand features of sqldevweb
Key Objectives:
As an application developer, DBA or DevOps user,
- Access OCI autonomous database console and get URL for apex web cosole
- Create a VNC connection to developer client VM and access apex on your database as admin user
- Setup additional apex developer users
Key Objectives:
As a database admin or user,
- Download a sample datapump export dump file from Oracle Learning Library github reposiory.
- Upload .dmp file to OCI Object storage bucket.
- Setup cloud credentials and use data pump import to move data to your ATP database.
Key Objectives:
As a database admin,
- Install Golden Gate on both source and target database
- Configure extract,pump and replicat processes on source and target golden gate instances respectively
- Replicate real time data from a simulated on-premise database to ATP-Dedicated
Key Objectives:
As a database admin,
- Install and configure a Java OLTP application for High Availability
- Simulate a planned maintenance event and observe workload
Key Objectives:
As a database admin or database user,
- Simulate a production OLTP workload using Swingbench load generator
- Monitor and Manage your autonomous database performance using Performance Hub.
Key Objectives:
As a database admin or database user,
- Simulate a production workload using Swingbench load generator
- Scale up and scale down a database online and observe workload
Key Objectives:
As a database security admin,
- Enable database vault in your autonomous database service
- Implement separation of duties to protect sensitive data in your autonomous database
Key Objectives:
As a developer or database admin,
- Setup recovery points in your database code
- Flashback your database to recover from erroneous updates
Key Objectives:
As a developer or database admin,
- Setup autonomous database event topics
- Add subscribers to recieve service event notifications via email, SMS & Slack
Common tools for windows Users Finding the IP address of your AEI Cluster