This post covers one of many questions discusses during our Oracle Cloud Infrastructure Architect Associate Training i.e. Why DBA’s & Apps DBAs need to learn OCI or How learning OCI will help DBAs & Apps DBAs in their professional career. This question has been asked repetitively so I thought I should write about it.
(Note: If you are just starting on Cloud or new to Oracle Cloud Infrastructure (OCI), then I would suggest you check my previous post on Oracle Cloud Infrastructure (OCI) basic concepts i.e. Region, AD, Tenancy, Compartment, VCN, IAM, Compute, Storage Service, etc)
Why DBAs & Apps DBAs Needs to Learn OCI
Databases & Applications (EBS R12, Peoplesoft & JDE, etc) are moving to cloud to run in PaaS & IaaS. With this, the role of DBAs & Apps DBAs will not be limited to just database or application management but you’ll be performing other tasks like
- Where to deploy these databases/applications in Cloud (Region, Availability Domain, Fault Domain, etc)
- What network to configure these Databases/Applications in to (VCN, Subnet, Security List)
- How to secure these Databases/Applications (Compartment, IAM Groups & Policies, Encryption, Federation)
- How to Architect for High Availability (HA) & Disaster Recovery (DR) (RAC, DataGuard, Clustering, Load Balancer (Public & Private))
- How to Manage these Databases & Application on Cloud (Provision, Patching, Cloning, Backup & Recovery, Performance Tuning) including Cloud Tools for both UserManaged & Autonomous Databases
- Migrating (Lift & Shift) Databases & Applications from On-Premise to Cloud or Vice Versa
Learning Path for DBA & Apps DBAs in OCI?
Based on things DBAs & Apps DBAs needs to perform in Cloud and after teaching Cloud to 100s of DBAs & Apps DBAs, here is order in which you should learn Oracle Cloud Infrastructure & become Oracle Certified Cloud Architect [1Z0-932]
- As you will be deploying databases & applications in OCI in different Regions, AD & FD, you need to understand these concepts first, to know more about Regions, AD, FD check our post on Oracle Cloud Infrastructure: Availability Domains & Fault Domains
- Then within Region/AD, databases & applications are deployed inside subnet which is part of VCN so you need to understand VCN & Subnet, to know more about VCN, check my Video blog post on Oracle Cloud Networks: VCN, FastConnect, DRG, IGW
- Then databases run on top of Compute (BM or VM) so understand different compute shapes & types, to know more about Compute check our post on Oracle Cloud Infrastructure (OCI) Compute CPU & Memory
- Then depending on the functionality of databases/application and response time, there can be a different type of storage like Block, Object, File Storage Service, and Archived Object Storage so you need to know different File System Types On OCI, More on this at Oracle Cloud Infrastructure (OCI) | Storage Object, Block | File Storage, Data Transfer Service|
- Then there are two main categories of Oracle Databases in the cloud, UserManaged or Self Managed (Autonomous) so DBAs need to know different options within these two database types including Single Instance, RAC, Dataguard, Exadata and how to provision/manage them. More about Database in OCI at Oracle Cloud Infrastructure: Database Offerings
- Then comes configuration/management of these databases like provisioning, patching, cloning, backup & recovery, security, and Performance Tuning. You should know these operations on Cloud & Cloud Tools used to perform these operations.
- Once the Database is created, you must know how to allow connection from selective clients using Security List or allowing only a set of users with specific access using IAM Groups & Policies in OCI.
- Once you know Security List & IAM Policies in OCI to protect databases & Applications, then you need to know Disaster Recovery (DR) set up on the cloud within the Region (AD) or across Region (with or without remote VCN Peering)
- As a DBA & Apps DBA, you should be familiar with how applications & database with connections to both within Cloud or from On-Premise Applications using VPN or FastConnect.
- Overall DBAs & Apps DBAs need to know OCI very well if running and managing applications/databases on Oracle Cloud.
FREE Masterclass: How To Be Oracle Certified Cloud Architect?
Join Me for a FREE masterclass on How to Be An Oracle Certified Cloud Architect Associate in 8 Weeks even you are beginner, Register Here FREE. This is approx 2 Hours Master Class covering
- Cloud For Beginners:
- What is Cloud Computing
- Cloud Service Models: SaaS | PaaS| IaaS
- Oracle’s Cloud Reference Architecture
- Oracle Cloud Infrastructure (OCI) Architect
- Common Services & PaaS Offerings
- Core Services: Network, Compute, Storage Database, Security
- Who Should Learn OCI & Why Now?
- Cloud Architect Certification
- What, Why & How To Clear in 8 Weeks, Even If you are a beginner
- Common Exam Mistakes & How To Avoid Them
- Job Opportunities
- Q/A
Related/Further Readings
- Oracle Cloud Infrastructure Availability Domains & Fault Domains
- Oracle Cloud Infrastructure (OCI) Architect Live Training
Begin Your Cloud Journey
Begin your journey towards becoming an Oracle Cloud Expert and earn a lot more in 2024 by joining our FREE CLASS. You will also know more about the Roles and Responsibilities, Job opportunities for OCI Architects, Admins in the market, and what to study Including Hands-On labs you must perform to get the Higher Paying jobs.
Click on the below image to Register for Our FREE Class on MASTERING ORACLE CLOUD FOR DBAs, APPs DBAs, ARCHITECTS & SYS ADMINS
Shirishkumar T says
This course is project oriented or normal basics.
How much is the course duration and how much is the course fee.
Atul Kumar says
Hi Shirishkumar, All our courses are Job & Certification Focused. I suggest you attend FREE masterclass at https://k21academy.com/oci02 as I’ve everything in this approx 2 Hour masterclass. If you still have any doubt after this FREE session then don’t hesitate to ask here or from my team at contact [at] k21academy.com
Henry says
– Please what is the difference between Oracle DBAs and Oracle AppsDBAs and OCIs?
– How well does this or any of your course manage a total database novice right from SQL to Oracle DB?
Atul Kumar says
Thanks Henry for your comment. Reply in line
– Please what is the difference between Oracle DBAs and Oracle AppsDBAs and OCIs?
[AK] DBAs are database administrators who manages databases and in our terms those who manages relational databases (RDBMS) and Apps DBAs are one who also manages business applications like Oracle E-Business Suite, JD Edward , Peoplesoft or Custom Java Applications. OCI stands for Oracle Cloud Infrastructure and is Oracle’s Generation 2 Cloud on which PaaS offerings (like Database Cloud, WebLogic Cloud/JCS, Exadata CLoud, GoldenGate Cloud, Autonomous Cloud, API Cloud, Integration Cloud) or SaaS offerings (like HCM Cloud, ERP Cloud etc) will run. More on OCI at https://k21academy.com/oci11
– How well does this or any of your course manage a total database novice right from SQL to Oracle DB?
[AK] We have different courses for different skills, course Oracle Cloud Architect Certification [1Z0-932] covers everything that is required from Cloud Certification Point of View. I suggest you register for FREE masterclass given above in this post.
Let me know if you have any further questions.
Divya says
Can we provide 2 hostnames and respective IP address as an input for creating 2 NodeRAC DB in OCI ?
Rahul Dangayach says
Hi Divya,
Yes, you can provide two hostnames and their respective IP addresses as inputs for creating two NodeRAC (Real Application Clusters) databases in OCI (Oracle Cloud Infrastructure).
In a NodeRAC configuration, multiple database instances share a single database storage, and are spread across multiple servers, or nodes, for high availability and scalability. Each node has a unique hostname and IP address, which is used to identify it within the cluster.
When creating two NodeRAC databases in OCI, you would need to provide the hostnames and IP addresses of the nodes that would be part of each database cluster. This information would typically be provided during the database creation process, or when configuring the nodes to join the cluster.
Once the databases are created, you would be able to connect to each database using the appropriate hostname and IP address, and manage the nodes and instances within each cluster using Oracle’s RAC management tools.
Hope this helps.
Thanks and Regards
Rahul Dangayach
Team K21Academy