Oracle Database Cloud for DBAs

Set up the Oracle practice environment by building a Linux-based virtual appliance with Oracle database 19c, swing bench, and PuTTY, then configure network, shared folder, and staging access.

Install swing bench 2.6 on a virtual appliance and create its schema in DBRS with the wizard, then connect via the easy connect string to observe transactions per minute saturating.

Explore cloud computing fundamentals, comparing on-premises costs with cloud benefits, service and deployment models, and how cloud providers offer virtual machines and resources to reduce total cost of ownership.

Explore how cloud computing delivers web-based resources, including servers, networks, storage, and applications, with easy provisioning, scalable capacity, and highly available OpEx-friendly cost models.

Examine the three cloud service models—IaaS, PaaS, and SaaS—highlighting provider versus client responsibilities, database as a service options, and market trends.

Compare public, private, hybrid, and community cloud deployment models and explain pay-as-you-go pricing and on-premises costs. Identify cloud benefits, challenges, and service and deployment models, and preview Oracle Cloud Infrastructure.

Explore how Oracle Cloud Infrastructure delivers cloud service models across regions and availability domains, covering compute, storage, networking, and databases, with security and basic terminology for DBAs.

Oracle cloud infrastructure distributes data centers across regions worldwide to provide local access, including government regions; availability domains isolate hardware within regions for disaster recovery and regional or domain-scoped resources.

Explore Oracle cloud infrastructure basics: tenancy and compartments, bare metal and virtual compute instances, shapes, and the console, plus vcns, subnets, and access policies.

Sign up for Oracle Cloud by creating a Gmail and OCI account, verify emails and payment, and review identity, users, home region, and DBRS service limits.

Learn how Oracle database services on OCI compare: fully user-managed VM, DB systems (VM, bare metal, Exadata), and autonomous databases, with automation for backup, recovery, and patching.

Oracle database cloud service options with bare metal hardware, dedicated resources, and private networks, including two server ships to choose from and region availability.

Discover Oracle Exadata Cloud Service options, including cloud and at‑customer deployments, high‑performance hardware, and autonomous database features.

Compare vm db systems and bare metal db systems for Oracle Database Cloud. Review storage options using LVM or ASM, provisioning methods, and scaling on Linux.

Assess restrictions before provisioning bare metal or vm db systems, estimate costs with Oracle cloud cost estimate, and review DBRS editions for TDE standard and Active Data Guard enterprise extreme.

Learn how to provision Oracle database cloud DV systems, including bare metal and VM options, by configuring compartments, availability domain, shapes, storage, networking, key pairs, licensing, and security settings.

Explore provisioning Oracle database systems in OCI, comparing bare metal and VM options, and manage backups, patches, licensing, and administration via the OCI console and CLI.

Provision a vcn in the OCI console, create a public subnet and key pair, configure security lists and an internet gateway, and add route rules to enable internet access.

Generate a public-private key pair with PuTTYgen for Putty access to the database and save the public key. Check tenancy limits and quotas to learn how to request resource increases.

Provision a db system in OCI using the Ossi console, selecting compartment, system name, availability domain, and a suitable virtual machine shape with appropriate storage and image settings.

Provision and monitor a db system in the oracle cloud, tracking the DBRS status to available, exploring the DBI system page, and managing backups, patches, and shutdowns to save costs.

Harness the browser-based OCI CLI to search and run commands that display DB system details, view outputs in JSON, and safely stop or shut down resources from the console.

Learn to connect to Oracle database cloud systems by configuring subnets, security lists, and NSGs, then use private keys and open essential ports such as 1521.

Open required ports by configuring security list ingress and egress rules for the DB subnet, and adjust the firewall (iptables) to enable connectivity on ports 22 and 5500.

Practice connecting to DB systems via PuTTY, obtaining public IP, configuring private key authentication, and saving the session. Inspect the environment by verifying firewall rules, DBRS status, and CDB/PDB details.

Explore the Oracle database cli for managing Oracle database systems on bare metal and virtual machines, with root-only commands, extensive options, and comprehensive documentation.

Learn to create pluggable databases (PDBs) inside a multitenant CDB, enable TDE, and manage per-PDB master encryption keys by opening the key store and activating keys.

Learn how to create a pdb in a db system, configure a master encryption key and wallet, create a tablespace in the pdb, and verify encryption status.

Explore updating and patching Oracle DB cloud systems, including DBE updates, DBI and DBRS patching, and using tools like youm and OCI/DP interfaces; plan downtime and test patches.

Learn how to check available patches before updating oracle database cloud systems, compare current and target versions, and use describe latest batch to plan patching.

Follow the official update and patch procedure for an Oracle database system on Oracle Linux seven, including patch file download, downtime, and OCI console checks.

Patch DBRS homes in DBI systems after applying the system patch, using the console or CLI: list databases, update DB home, monitor jobs, verify the patch, and restart DBRS.

Apply and troubleshoot updates and patches for db systems using console or cli, check patch history and logs for failed jobs, and ensure connectivity via service gateways for private subnets.

Practice updating and patching a VM by creating a service gateway to access object storage and the Oracle yum repository, then patch the OS and the database home.

Learn step-by-step how to update and patch a DB system’s operating system using Putty, verify kernel versions before and after reboot, and safely restart services and the database.

Apply the latest patch set to the DB system by comparing versions, executing the patch with pre checks, and verifying the update in the OCI console, including the DBRS home.