Tuesday, 26 May 2026

OCI Lead roles and responsibilities 2026

Q2: Can you explain the concept of Regions, Availability Domains, and Fault Domains?
Answer: These are the building blocks of OCI's global footprint:
  • Region: A localized geographic area that contains one or more data centers.
  • Availability Domains (ADs): Standalone, independent data centers located within a region. They are isolated from each other and have independent power and cooling, ensuring high availability.
  • Fault Domains (FDs): Groupings of hardware and infrastructure within an Availability Domain. Each AD has three FDs. FDs allow you to distribute your instances so that they are not on the same physical hardware within a single AD, protecting your application from hardware failures or compute maintenance. 
Q3: What is a Compartment, and why are they important?
Answer: A compartment is a logical collection of related OCI resources (like compute, networks, or databases). They are the fundamental building block you use to organize and isolate your cloud resources. They are essential for:
  • Security: Controlling access using IAM policies.
  • Budgeting & Cost Tracking: Assigning budgets and generating detailed cost reports per project.
Q4: How does Identity and Access Management (IAM) work in OCI?
Answer: IAM is the service that controls who can access your cloud resources and what actions they can perform. It relies on four core components: 
  • Resources: Cloud objects you create (e.g., VMs, VCNs, Block Volumes).
  • Users: Individuals or systems that need to access your resources.
  • Groups: Collections of users.
  • Policies: Documents written in a human-readable language (e.g., Allow group Admins to manage instances in compartment ProjectA) that grant specific permissions to a group to work within a specific compartment. 
  • Q5: What is a Virtual Cloud Network (VCN)?
    Answer: A VCN is a customizable, software-defined private network that you set up in OCI. It provides a secure and isolated environment for your OCI resources. It functions much like a traditional network you would operate in an on-premises data center, complete with subnets, route tables, and gateways, but benefits from OCI's scalable infrastructure. 
    Q6: What are the different types of storage options available in OCI?
    Answer: OCI offers several storage solutions tailored for different workloads:
    • Block Volume: Highly durable, persistent block storage that you attach to virtual machines (similar to a hard drive). Ideal for databases and enterprise applications.
    • Object Storage: Horizontally scalable, region-independent storage for unstructured data (like logs, images, and backups). Uses standard HTTP-based APIs.
    • File Storage (FSS): A managed, shared, network file system (NFS) that provides a persistent and highly available enterprise file system.
    • Archive Storage: A cost-effective, durable storage tier designed for data that is accessed infrequently and requires long-term retention. 


Q: What are the different types of Compute instances available in OCI?
Answer: OCI provides a variety of compute instances tailored to different workloads: 
  • Virtual Machines (VMs): Run on shared hardware but provide dedicated virtualized CPU, memory, and storage, ideal for general-purpose workloads.
  • Bare Metal Instances: Give you a dedicated physical server with no hypervisor, offering maximum performance and isolation for resource-intensive applications.
  • Dedicated Virtual Machine Hosts (DVMH): Allow you to run VMs on a single tenant-dedicated physical server, providing both cloud elasticity and the security/compliance of a bare metal environment
Q: What is an OCI Compute Shape?
Answer: A shape is a template that determines the number of CPUs, amount of memory, and bandwidth allocated to an instance. OCI categorizes shapes into several families: 
  • Standard: General-purpose workloads.
  • E-Series (AMD): Cost-effective, general-purpose workloads.
  • HPC (High-Performance Computing): Designed for complex, compute-intensive tasks.
  • GPU (Graphics Processing Unit): Accelerated computing for AI, machine learning, and graphics. 

  • and graphics. 

Q: What are Dedicated Virtual Machine Hosts, and when should you use them?
Answer: Dedicated VM Hosts provide a single tenant-dedicated physical server for your VMs. You should use them to meet strict compliance, regulatory, and security requirements that mandate physical isolation from other tenants, while still utilizing OCI's virtualization capabilities.

Q: How do you launch a Compute instance in a specific Availability Domain?
Answer: When you create an instance, you must define the placement configuration. You select the target region, compartment, and the specific Availability Domain (AD) within that region. You can do this using the OCI Console, OCI CLI, or infrastructure-as-code tools like Terraform

Q: Can you change the shape of an OCI Compute instance after it has been provisioned?
Answer: Yes, OCI allows you to resize (scale up or down) VM instances without terminating them. For Bare Metal instances, shape changes require a reboot because they involve allocating different physical hardware. 

Q: What is an Instance Configuration and Instance Pool in OCI?
Answer:
  • Instance Configuration: A template that defines the settings for your compute instances (e.g., base image, shape, metadata, and attached block volumes).
  • Instance Pool: A collection of identical instances created from the exact same Instance Configuration. They are highly useful for scaling web applications when used with Load Balancers. 

Q: How does OCI support auto-scaling of compute instances?
Answer: Auto-scaling is implemented using Instance Pools and OCI Autoscaling Configurations. You define performance metrics (such as CPU or memory utilization), and the pool will automatically add or remove instances based on demand to maintain performance while optimizing costs. 

Q: How do OCI Custom Images differ from Boot Volumes?
Answer:
  • Custom Image: A snapshot of an instance's boot volume that includes the OS, installed software, and configurations. It acts as a golden image for deploying multiple new, identical instances.
  • Boot Volume: The actual active drive of a running compute instance. You can detach, move, or back up boot volumes independently of the compute instance itself.
Q: What is a Dedicated Host in OCI versus a Dedicated Region?
Answer:
  • Dedicated Host: A physical server dedicated solely to your compute instances to maintain isolation.
  • Dedicated Region: An entire OCI datacenter region set up on-premises within your own facility. It provides access to all OCI cloud services securely behind your firewall. 



Q1. What is a VCN, and what are its core components?
Answer: A VCN is a customizable virtual network within an OCI region that mirrors a traditional on-premises network. Its core components include: 
  • CIDR Block: The range of IPv4/IPv6 addresses assigned to the VCN.
  • Subnets: Subdivisions of the VCN's CIDR block that determine where resources are placed. Subnets can span across an Availability Domain (Regional) or be limited to a single Availability Domain (AD-specific).
  • Route Tables: A set of rules that dictate where network traffic is directed (e.g., Internet Gateway or DRG).
  • Security Lists & Network Security Groups (NSGs): Virtual firewalls containing rules that dictate the types of traffic (ingress/egress) allowed in and out.
  • Gateways: Components (Internet, NAT, Service, and DRG) that connect your VCN to the internet, on-premises networks, or other OCI services


Q2. Can a VCN or a subnet span multiple OCI regions?
Answer: No. A VCN is restricted to a single region. However, subnets can be regional, meaning they span multiple Availability Domains (ADs) within that single region, providing high availability without the need to manage multiple subnets. [1]
Q3. What is the difference between a Security List and a Network Security Group (NSG)?
Answer: Both act as virtual firewalls to control traffic, but they differ in scope and application:
  • Security Lists: Rules are applied at the subnet level. Any resource (compute instance) launched within that subnet is bound to the security list rules.
  • Network Security Groups (NSGs): Rules are applied at the VNIC (vNIC) level. You define rules that apply only to specific groups of VNICs, regardless of which subnet they are in. NSGs are generally preferred for more granular, application-tier-based security. 


Q4. What is an OCI Service Gateway and why is it used?
Answer: A Service Gateway allows your VCN to securely access OCI public services (such as OCI Object Storage, Autonomous Databases, or API Gateway) without going through an Internet Gateway and without giving instances a public IP address. It keeps traffic within the Oracle network, improving security and performance. 
Q5. How does a NAT Gateway differ from an Internet Gateway?
Answer:
  • Internet Gateway: Allows bidirectional traffic. Resources (like a web server) inside a public subnet can communicate with the internet, and the internet can connect to those resources.
  • NAT (Network Address Translation) Gateway: Allows outbound-only connections to the internet. Resources in a private subnet can download software patches or updates, but external hosts on the internet cannot initiate an inbound connection to those private resources. 


Q6. Explain VCN Peering and its types.
Answer: VCN Peering is the process of connecting two VCNs so they can communicate using private IP addresses. OCI supports:
  • Local VCN Peering: Connecting two VCNs within the same region.
  • Remote VCN Peering: Connecting two VCNs located in different OCI regions. Traffic routes over Oracle's private backbone network rather than the public internet.
Q7. How does Transit Routing work in OCI?
Answer: Transit Routing allows traffic to flow from one network (e.g., an on-premises network connected via VPN) through a "hub" VCN to reach another "spoke" VCN, or to an internet/NAT gateway. This is configured using a Dynamic Routing Gateway (DRG) and custom route tables that point next-hop routing to specific DRGs or VCN attachments. 
Q8. How many IP addresses does OCI reserve in each subnet?
Answer: OCI reserves the first 3 IP addresses and the last 1 IP address in every subnet CIDR block for internal networking purposes. Therefore, a /24 subnet will provide \(256 - 4 = 252\) usable IP addresses.


Q1: What is the difference between an OCI User, a Group, and a Dynamic Group?
Answer:
  • Users are individual identities (employees or administrators) representing humans.
  • Groups are collections of users. In OCI, permissions are granted to Groups, not directly to Users.
  • Dynamic Groups are collections of OCI resources (like Compute instances) that act as "principals." Instead of using standard user credentials, instances use Dynamic Groups to authenticate with OCI APIs and services using Instance Principals

Q2: How does OCI Authorization work, and what is the basic structure of a policy?
Answer:
Authorization defines what an authenticated user is allowed to do. OCI uses human-readable Policy Statements evaluated at the Tenancy or Compartment level.
The basic syntax is:
Allow <subject> to <verb> <resource-type> in <location> 
  • Subject: The group (or dynamic group).
  • Verb: Action level (e.g., inspect, read, use, manage).
  • Resource-type: OCI service component (e.g., instance-family, vcns, object-family).
  • Location: Tenancy or specific compartment


Q3: What is the difference between the 'use' and 'manage' verbs in OCI policies?
Answer:
  • use grants permissions to perform actions that let you modify or update existing resources, but prevents you from creating or deleting them. For example, use instances allows you to stop/start/reboot an existing instance, but not launch a new one.
  • manage grants full administrative control over the specified resources. For example, manage instances allows you to create, update, and terminate instances. 

Q4: Can you explain Compartments and how they relate to IAM Policies?
Answer:
Compartments are logical collections of related OCI resources (like VMs, DBs, Networks) used to organize and isolate your cloud infrastructure.
They relate to IAM because policies are strictly tied to them. If you grant a group access to a specific compartment, the users can only see and manipulate resources within that compartment. This allows you to enforce hierarchical security, separating Development from Production environments
Q5: What are OCI Federation and Single Sign-On (SSO)?
Answer:
Federation allows you to map your existing enterprise identities (such as Microsoft Active Directory, Okta, or Azure AD) to OCI. Instead of creating distinct OCI users for every employee, you federate your Identity Provider (IdP) with OCI using SAML 2.0. This allows users to log in to the OCI Console using their corporate credentials. 

Q6: How do you allow a Compute instance to read/write objects in an OCI Object Storage bucket without storing user credentials on the VM?
Answer:
You achieve this by leveraging Instance Principals
  1. Add the Compute instance to a Dynamic Group (e.g., using matching rules like Any {instance.id = 'ocid1.instance...'}).
  2. Write an IAM Policy granting that Dynamic Group permission to access the Object Storage.
  3. The instance can then call OCI APIs and securely authenticate using its built-in security token. 


Q7: What is an OCI Master Encryption Key and where is it managed?
Answer:
Master Encryption Keys are used to protect your data across OCI services. They are managed and stored using the OCI Vault (formerly Key Management Service or KMS). OCI Vault allows you to create and manage your own cryptographic keys, which can be backed by Hardware Security Modules (HSMs) to ensure compliance and secure data-at-rest encryption. 
Q8: What is the Principle of Least Privilege, and how does OCI IAM enforce it?
Answer:
The Principle of Least Privilege is the security concept of providing a user or service only the minimum access necessary to perform their job. OCI enforces this by allowing you to attach precise IAM policies down to specific compartment levels rather than granting tenancy-wide access. For example, rather than giving a developer tenancy administrator rights, you might only give them manage object-family in a specific "Dev-Storage" compartment. 



 

1. What are the different types of storage services available in OCI?
Answer: OCI provides four main storage options designed for different use cases:
  • Block Volume: Provides persistent, block-level storage (like hard drives) for Compute instances. It is ideal for databases and enterprise applications requiring high IOPS.
  • File Storage Service (FSS): A managed, shared Network File System (NFS) that allows multiple compute instances to mount and access the same file system concurrently.
  • Object Storage: A highly scalable, regional storage service for unstructured data (images, backups, logs). It offers two tiers: Standard (frequent access) and Archive (cold storage).
  • Local NVMe: Temporary, locally attached NVMe SSDs providing extremely low latency and high IOPS, perfect for temporary scratch spaces or big data. 


2. What is the difference between Block Storage and Object Storage in OCI?
Answer:
  • Block Storage: Data is organized as raw volumes of data (blocks). It is attached to specific Operating Systems, supports file systems, is mounted like a hard drive, and delivers low latency suited for database workloads.
  • Object Storage: Data is managed as objects, where each object includes data and metadata. It is accessed via REST APIs over the internet, scales infinitely, and is ideal for data lakes, backups, and web content. 

3. When would you use OCI Archive Storage versus Standard Object Storage?
Answer:
  • Standard Object Storage: Used for data that needs to be accessed frequently and rapidly (e.g., website assets, application data).
  • Archive Storage: Designed for long-term retention of "cold" data (e.g., regulatory compliance, long-term backups). While it is significantly cheaper, retrieving archived objects requires a "restore" process that can take up to 4 hours, and there is a minimum 90-day storage requirement. 
4. How can you automate the lifecycle of data in OCI Object Storage?
Answer: You can use Object Storage Lifecycle Management. This feature allows you to create rules that automatically delete or transition objects from the Standard tier to the Archive tier based on the age of the data or custom prefixes.


5. What are the performance tiers available for OCI Block Volumes?
Answer: OCI provides three performance tiers for Block Volumes to balance cost and Input/Output Operations Per Second (IOPS):
  • Lower Cost: Best for dev/test environments.
  • Balanced: The default tier, suitable for most general-purpose workloads.
  • High Performance: Designed for IO-intensive workloads like large relational databases that require maximum throughput.
6. Can you share a Block Volume between multiple compute instances?

Answer: Yes. OCI Block Volumes support Multi-Attach. This allows a single block volume to be attached to multiple compute instances in read/write mode. However, you must use a clustered file system (like Oracle Cluster File System or OCFS2) to manage file access and prevent data corruption across instances.


7. Does OCI File Storage Service support encryption?
Answer: Yes, OCI File Storage (FSS) is encrypted by default. Data at rest is encrypted using Oracle-managed keys or customer-managed keys via the OCI Vault service. Data in transit is encrypted by default if you use the NFS network encryption features. 



Question : Manage day-to-day OCI operational activities across Dev, UAT, and Production environments


Managing day-to-day OCI operational activities across Dev, UAT, and Production requires a structured framework that ensures seamless resource administration, proactive monitoring, automated deployments, and strict security compliance aligned with the OCI Well-Architected Framework

1. Routine Administration

  • Resource Management: Manage and scale compute shapes (e.g., VMs, Bare Metal), storage (Block, Object, File), and Virtual Cloud Networks (VCNs).
  • Infrastructure as Code (IaC): Use OCI Resource Manager to apply, update, and track Terraform scripts consistently across environments.
  • Cost & Budgeting: Monitor budgets and usage through OCI Cost Analysis to track cross-environment consumption

2. Deployment & Release Management
  • CI/CD Pipelines: Use OCI DevOps Service to automate continuous integration and delivery.
  • Environment Segregation: Enforce deployment pipelines (Dev \(\rightarrow \) UAT \(\rightarrow \) Prod) with strict access policies to ensure deployments remain consistent and risk-free.
. Monitoring & Incident Management

4. Patching, Backups & Compliance
  • OS & Database Maintenance: Automate patching and OS lifecycles using Oracle OS Management Hub to maintain compliance across instances.
  • Backup Readiness: Regularly maintain data backups and test recovery procedures for High Availability (HA) and Disaster Recovery (DR) operations.
  • Security Posture: Enforce the principle of least privilege, limit access within OCI Identity and Access Management (IAM), and enable Cloud Guard for threat mitigation


Question : Execute routine administration tasks for OCI compute, storage, networking, and security services.

Routine OCI administration involves executing standard Day-2 operations for Compute, Storage, Networking, and Security to maintain a healthy, compliant, and cost-effective cloud posture. These operations keep your infrastructure resources Oracle Cloud Infrastructure Administration Essentials_free performing optimally. 

Compute Administration
Storage Administration

 Networking Administration
Security & Identity Administration

Question : Work closely with application developers to support deployments, releases, and application issues.


Supporting application developers requires bridging the gap between development and IT operations by managing CI/CD pipelines, automating infrastructure provisioning, and ensuring reliable, secure software delivery. The core objective is to streamline deployment workflows, resolve operational issues, and maintain high application availability.

Key Pillars of Developer Support
1. Deployment Support & Pipeline Management
  • CI/CD Automation: Build, maintain, and optimize continuous integration and continuous delivery (CI/CD) pipelines using tools like GitHub Actions or GitLab.
  • Environment Consistency: Standardize and provision infrastructure across development, testing, and production environments using Infrastructure-as-Code (IaC) tools like Terraform.
  • Container Orchestration: Support containerized applications by managing Docker images and orchestrating workloads using Kubernetes or Helm. 

2. Release Management
  • Rollout Strategies: Implement deployment strategies such as blue/green, canary, or rolling deployments to minimize downtime.
  • Governance & Versioning: Enforce Git branching strategies and deployment governance to ensure that releases are traceable, tested, and secure.
  • Automated Testing: Integrate automated security scanning (e.g., secret management, vulnerability checks) and quality tests into the deployment workflow.

3. Application Issue Resolution
  • Observability & Monitoring: Implement centralized logging, metrics, and tracing using tools like Splunk, Prometheus, or the ELK Stack.
  • Troubleshooting & RCA: Act as the primary point of contact for resolving environment issues, build failures, and production incidents by performing root-cause analysis.
  • Feedback Loops: Work in Agile environments alongside development and quality assurance (QA) teams to refine code configuration and improve system reliability based on production feedback

Question : Coordinate with Oracle Database teams for database provisioning, maintenance, and performance support.


Coordinate with Oracle Database teams to automate database provisioning, streamline maintenance, and optimize performance across environments


Align on the following operational pillars for seamless collaboration:
1. Database Provisioning
  • Infrastructure & Services: Collaborate to provision Oracle Exadata Database Service or Autonomous Databases.
  • Interfaces: Utilize the Oracle Cloud Infrastructure (OCI) Console or integrated portals like Oracle Database@Azure to deploy pluggable and container databases.
  • Resource Management: Align on compute shapes, networking, and high-availability (HA) settings before resources are spun up

2. Maintenance & Patching
  • Quarterly Updates: Coordinate with DBAs to track the Oracle-Managed Infrastructure Maintenance Schedule to minimize disruptions.
  • Patching: Implement rolling patches for Real Application Clusters (RAC) and handle Release Updates (RU) collaboratively to ensure security and stability. 
3. Performance Support
  • Monitoring: Use Oracle Enterprise Manager and OCI Observability tools to continuously track database capacity and health.
  • Tuning: Work with DBAs on query optimization, memory allocation, and tuning packs to maintain performance stability during migrations or upgrades

Question : Collaborate with OCI Architects to implement and maintain cloud architecture and standards.


Collaborating with Oracle Cloud Infrastructure (OCI) Architects involves translating business requirements into scalable, secure, and cost-effective cloud solutions. By aligning with architectural standards, you can establish a robust tenancy, optimize resources, and ensure long-term operational excellence

A successful collaboration strategy includes the following core components:
  • Design and Planning: Work with architects to design resilient Virtual Cloud Networks (VCN), compute deployments, and storage solutions tailored to your workload demands.
  • Resource Optimization: Implement flexible VM shapes, autoscaling, and Object Storage lifecycle policies to dynamically scale and reduce idle resources.
  • Security and Compliance: Enforce enterprise governance by applying strict Identity and Access Management (IAM) policies and securing private endpoints.
  • Observability and Auditing: Adopt OCI Observability and Management tools to continuously monitor infrastructure health, automate alerting, and maintain compliance.
  • Framework Adoption: Leverage the OCI Well-Architected Framework to conduct periodic gap assessments and ensure all deployments follow established cloud best practices

Question : Monitor OCI environments for availability, performance, capacity, and cost.


To monitor Oracle Cloud Infrastructure (OCI) environments, leverage OCI's native Observability and Management services. Use the unified OCI Console to track health metrics, establish performance baselines, predict future capacity limits, and optimize cloud expenditures

1. Availability
Ensure applications and endpoints remain accessible:
  • Availability Monitoring: Utilize OCI Application Performance Monitoring to execute scheduled, scripted monitors globally. Simulate critical user flows to prevent issues before they impact users.
  • Stack Monitoring: Proactively discover and monitor the health of your entire application stack, including underlying infrastructure, databases, and application servers
2. Performance
Track system health in real time:
  • Metrics Explorer & Alarms: Track resource metrics (e.g., CPU, memory, latency) using OCI Metrics Explorer. Configure threshold-based alarms that integrate with the OCI Notifications service.
  • Logging Analytics: Aggregate structured diagnostic logs to deeply analyze errors and isolate root causes across resources

3. Capacity
Avoid over-provisioning and prevent resource bottlenecks:
  • Operations Insights: Leverage machine learning-based forecasting in OCI Operations Insights to analyze host and database resource usage. Project future growth and determine exact lead times to expand capacity.
  • OCI Capacity Reservations: Reserve compute capacity ahead of time to ensure it is available when you need it

4. Cost
Manage and optimize cloud spend:
  • FinOps Hub: Consolidate usage data and view spending trends across your tenancies natively in the OCI FinOps Hub.
  • OCI Budgets & Cost Analysis: Set customized spending thresholds that notify you when you approach budget limits, ensuring unauthorized spending or cost overruns are managed proactively.
  • Cloud Advisor: Receive actionable recommendations to eliminate idle resources and right-size compute and storage services.

Question : Perform incident management, root cause analysis, and issue resolution.


Incident Management is the process of restoring normal service operations as quickly as possible following a disruption, while Root Cause Analysis (RCA) and issue resolution aim to identify the underlying source of the failure to prevent recurrence. A structured approach ensures system stability and minimizes business impact

1. Incident Management
The primary goal here is to triage and mitigate the issue, not to figure out why it happened.
  • Detection & Logging: Record the incident in an ITSM platform (e.g., ServiceNow or Jira Service Management) with exact symptoms, timestamps, and impact.
  • Triage & Prioritization: Assess the impact and urgency to assign a priority level (e.g., P1 for critical/outage, P4 for minor).
  • Containment & Mitigation: Apply temporary workarounds or failovers to restore services
2. Root Cause Analysis (RCA)
Once the incident is resolved, transition to problem management to investigate the fundamental defect
  • Define the Problem: Clearly document exactly what failed, when, and for whom.
  • Gather Data: Pull application logs, metrics, performance thresholds, and error codes.
  • Identify Causal Factors: Use diagnostic methods like the 5 Whys technique (repeatedly asking "why" to drill down) or a Fishbone Diagram to map potential physical, human, or process causes.
  • Determine the Root Cause: Distinguish between surface-level symptoms and the primary underlying trigger
  • 3. Issue Resolution
    The final phase focuses on implementing a permanent fix and documenting your finding
  • Formulate a Solution: Develop corrective actions (e.g., code deployment, patch, or process update).
  • Implementation: Deploy the fix, usually following standard change management procedures.
  • Verify & Monitor: Ensure the fix works and that the issue does not reoccur.
  • Document and Share: Finalize the RCA document in your ticketing system or internal wiki so your team can learn from the event and mitigate future risks

  • Question : Execute approved changes including configuration updates, scaling, and maintenance activities in OCI.

    To execute approved changes, configuration updates, and scaling or maintenance activities in Oracle Cloud Infrastructure (OCI), navigate to the relevant resources in the OCI Console or use the OCI CLI

    Depending on your approved change ticket, follow these targeted execution paths:
    1. Configuration & Shape Updates
    • Vertical Scaling (Resizing): In the OCI Console, go to Compute > Instances > click your instance > click Stop (if not utilizing live resizing) > click Edit Shape, and select your newly approved OCPU and memory allocation.
    • Storage Updates: Go to Block Storage > Block Volumes, select your volume, click Edit, and increase the size or performance tier. 
    2. Horizontal Scaling & Autoscaling
    • Instance Pools: If scaling out your application horizontally, navigate to Compute > Instance Configurations and Instance Pools to update the pool size.
    • Autoscaling: To adjust resources based on demand, go to Compute > Autoscaling Configurations. Here, you can define metric-based (e.g., CPU utilization) or schedule-based scaling policies to automate up-scaling and down-scaling

    3. Maintenance Activities
    • Instance Maintenance: If Oracle has scheduled infrastructure maintenance on your underlying hosts, check the Instance Maintenance section in the OCI Console to review event details, monitor progress, or reschedule your maintenance window.
    • Patching & Operations: Utilize OCI Fleet Application Management to deploy approved software patches, orchestrate reboots, and run pre- or post-maintenance tasks across compute, database, and middleware footprints
    Actionable Steps: Log into the OCI Console using your identity credentials, navigate to the specific service (Compute, Block Storage, or Fleet Application Management), and apply the settings outlined in your authorized work request.

    Question : Support application hosting on OCI including Oracle EBS and other enterprise applications.

    OCI is purpose-built to host and support enterprise workloads like Oracle E-Business Suite (EBS) and other applications. It delivers dedicated automation, such as the EBS Cloud Manager for lift-and-shift deployments, and provides single-vendor support

    Why Host Enterprise Applications on OCI?
    • Single Vendor Support: Eliminate finger-pointing. Oracle provides complete infrastructure and application support directly.
    • Exclusive Capabilities: OCI is the only cloud that supports complex, high-performance database options like Oracle RAC and Exadata Database Service.
    • Better TCO: Studies show running EBS on OCI can cost up to 30-44% less compared to on-premises or other hyperscalers
    Supported Oracle Enterprise Applications
    • Oracle EBS: Full R12 certification, automated provisioning, and out-of-the-box cloning.
    • Other Platforms: Includes deep certification and support for JD Edwards, PeopleSoft, and Siebel.
    • Oracle Integration Cloud (OIC): Seamlessly connects Oracle SaaS apps, EBS, and third-party systems like Salesforce, SAP, and ServiceNow

    Migration & Modernization Tools
    • EBS Cloud Manager: The primary tool for automating the migration, provisioning, patching, and daily management of your EBS environments.
    • Flexible Infrastructure: Easily resize compute cores and memory in minutes to handle intensive transaction periods without application downtime.
    • Multicloud Connectivity: Utilize the Oracle Interconnect for Microsoft Azure to maintain hybrid/multicloud setups for complex enterprise topologies.

    Question : Assist with OS, middleware, database, and OCI patching activities.

    Patching environments efficiently across operating systems, middleware, databases, and OCI services minimizes your security risk and ensures compliance. The best practices and steps for each layer are outlined below:

    1. Operating System (OS)
    • Linux/Windows instances: Use OCI Fleet Application Management to scan for vulnerabilities, group resources into logical fleets, and automate scheduling.
    • Action: From the OCI Console, navigate to Fleet Application Management > Fleets to apply manual or automated OS updates across your compute instances
    2. Middleware
    • WebLogic Server: Leverage the WebLogic Remote Console or the WebLogic Software Update feature within Oracle Enterprise Manager.
    • Patching steps:
      1. Always back up your WebLogic Domains using OCI block volume backups or native recovery tools.
      2. Download the latest Patch Set Updates (PSU) or Critical Patch Updates (CPU) via My Oracle Support.
      3. Use the OPatch utility to apply patches to your Oracle Homes, then apply domain-level configuration updates.
    3. Database
    • OCI Base Database / Exadata: Utilize OCI Fleet Application Management or Oracle Enterprise Manager’s Fleet Maintenance hub to centralize compliance and apply missing patches without disruption.
    • Manual Console Action: In the OCI Console, navigate to Oracle Database > Bare Metal, VM, and Exadata DB Systems. Select your DB system, click View Missing Patches, run a pre-check, and apply.
    • Autonomous Database: Patches are fully managed and automated. You can only view the next scheduled maintenance window and patch history under the Maintenance tab in your Autonomous Database detail
    4. OCI Infrastructure
    • OCI Cloud Guard: Ensure your tenancy and compartments are continuously assessed for unpatched vulnerabilities by utilizing OCI Vulnerability Scanning within the Oracle Cloud Console.
    • Scheduled Maintenance: For underlying OCI hypervisors, OCI will notify you of scheduled maintenance. You can adjust maintenance windows to Regular or Early via the Console to minimize operational impact.

    Question : Support CI/CD pipelines and automation processes.

    A CI/CD pipeline is an automated workflow that streamlines software delivery by continuously building, testing, and deploying code. It minimizes manual errors and speeds up release cycles. The core process integrates continuous integration (CI) and continuous deployment/delivery (CD) to maintain reliable software
    Key Pillars of CI/CD
    • Continuous Integration (CI): Developers merge code changes frequently into a shared repository. The pipeline automatically builds the application and runs unit and integration tests to catch bugs early.
    • Continuous Delivery (CD): Validated code is automatically prepared and staged for release.
    • Continuous Deployment (CD): Fully tested changes are automatically pushed to production environments without manual intervention, provided they pass all quality gates
    Core Stages of an Automated Pipeline
    1. Source Control: Code is committed to version control platforms. This initiates the automated pipeline.
    2. Build: The system compiles code, resolves dependencies, and creates executable build artifacts (e.g., Docker containers or binaries).
    3. Test: The artifact runs through automated suites—including security checks, performance, and functional tests—to ensure it behaves as expected.
    4. Deploy: Passed artifacts are deployed to specific environments (like Staging, UAT, or Production) for end-user access
    Popular Tools and Frameworks
    Depending on your infrastructure and ecosystem, you can utilize built-in or open-source tools to orchestrate these pipelines: [1, 2]
    • GitHub Actions: Tightly integrated CI/CD directly within your code repositories to automate workflows.
    • GitLab CI/CD: Offers an all-in-one DevOps platform covering source code management to continuous delivery.
    • Jenkins: A highly customizable, open-source automation server supporting a massive ecosystem of plugins.
    • AWS CodePipeline: A managed continuous delivery service for fast, reliable application updates on Amazon Web Services.

    Question : Assist in High Availability (HA) and Disaster Recovery (DR) operations and testing.


    High Availability (HA) and Disaster Recovery (DR) operations ensure business continuity by minimizing downtime and preventing data loss. HA keeps systems operational during component failures, while DR restores systems after catastrophic outages. Testing validates these strategies against your Recovery Time Objective (RTO) and Recovery Point Objective (RPO)

    1. Key Frameworks & Objectives
    • Recovery Time Objective (RTO): The maximum acceptable downtime before services are restored.
    • Recovery Point Objective (RPO): The maximum tolerable timeframe of data loss measured in time (e.g., losing 5 minutes vs. 24 hours of data).
    • Availability Tiers: Ranging from basic automated backups to active-active geo-redundant environments


    2. Core HA/DR Operations
    • HA (Redundancy): Implement load balancing, clustering, and automated failover to eliminate single points of failure (SPOFs).
    • DR (Replication): Utilize synchronous replication (zero data loss) over short distances and asynchronous replication (low latency) for cross-region disaster protection.
    • Backups: Enforce the 3-2-1 backup rule (3 copies, 2 different media types, 1 offsite/air-gapped) to protect against ransomware and data corruption

    3. Testing Methodologies
    • Failover Testing: Intentionally simulate node or data center failures to test automated network rerouting and data consistency.
    • Tabletop Drills: Regular walkthroughs of the incident response plan to ensure all team roles and communication channels are clearly defined.
    • Disaster Recovery as a Service (DRaaS): Leverage cloud-native tools to replicate on-premise or cloud environments and automate failover and failback testing.
    4. Enterprise Resources & Tools

    Question : Maintain backups, recovery procedures, and operational readiness.


    Maintaining backups, recovery procedures, and operational readiness is the backbone of business continuity. To minimize downtime and data loss, implement the 3-2-1 backup rule, define strict recovery metrics, and conduct continuous drills to ensure immediate recoverability during unexpected outages

    1. Establish the 3-2-1 Backup Strategy
    Ensure data availability and uphold the security triad (Integrity, Confidentiality, and Availability) by following the industry-standard backup methodology:
  • 3 Copies: Keep three copies of all critical production data.
  • 2 Media Types: Store backups on two different types of storage media (e.g., local disk, cloud storage, tape, or immutable storage).
  • 1 Offsite Location: Keep one backup copy in an offsite physical location or a separate cloud region

  • 2. Define Clear Recovery Objectives
    Design and refine your Disaster Recovery Plan (DRP) based on two critical time-based metrics
  • RTO (Recovery Time Objective): The maximum acceptable time to restore critical business operations after a disruption.
  • RPO (Recovery Point Objective): The maximum acceptable amount of data loss measured in time (e.g., losing the last 15 minutes of transactions versus a full day)
  • 3. Operational Readiness and Testing
    A backup is only as good as its successful restoration. Ensure operational readiness through the following
  • Automated & Immutability Checks: Use automated backup solutions and enable immutable backups (Write Once, Read Many - WORM) to guard against ransomware.
  • Regular Drills: Validate backup configurations and procedures by performing full, unannounced recovery drills to identify gaps in your recovery workflows.
  • Update Documentation: Continuously document and review recovery procedures, escalation paths, and system restoration sequencing

  • Question : Implement and follow security best practices, access controls, and compliance requirements.
    Implementing security, access controls, and compliance in Oracle Cloud Infrastructure (OCI) requires a defense-in-depth strategy. Key best practices include leveraging native OCI services, adhering to the principle of least privilege, and automating compliance monitoring

    1. Identity and Access Management (IAM)
    Control who has access to your resources by strictly enforcing the principle of least privilege. 
  • Compartments: Organize resources into logical compartments and apply OCI IAM Policies to restrict who can manage or view them.
  • Groups and Dynamic Groups: Assign permissions to user groups rather than individual users. Use Dynamic Groups to grant compute instances and other OCI resources API permissions to interact with OCI services.
  • Multi-Factor Authentication (MFA): Mandate MFA for all user accounts, particularly those with administrative privileges.
  • Federation: Integrate existing enterprise identity providers (IdP)—such as Microsoft Entra ID or Okta—with OCI IAM Federation to centralize user lifecycle management. 

  • 2. Network Security and Isolation
    Isolate network resources to prevent unauthorized access and data exfiltration.
    • Virtual Cloud Networks (VCNs): Create dedicated VCNs for different environments (e.g., Development, Staging, Production).
    • Subnets: Use regional subnets to distribute resources and partition them using private and public subnets.
    • Network Security Groups (NSGs) & Security Lists: Implement NSGs (recommended) for micro-segmentation at the VNIC level. Use Security Lists primarily for broad, VCN-level ingress/egress rules.
    • VCN Flow Logs: Enable VCN Flow Logs to capture traffic information and use OCI Logging Analytics for traffic auditing.
    • Private Connectivity: Utilize FastConnect for dedicated, private network connectivity to OCI, and Service Gateways to access OCI public services without traversing the public internet
    3. Data Encryption
    Protect sensitive data both at rest and in transit.
    • Encryption at Rest: Utilize OCI Vault to create and manage your own master encryption keys (Customer-Managed Keys) for OCI Block Volumes, Object Storage, and Databases.
    • Encryption in Transit: Ensure all data moving between your on-premises environment and OCI is encrypted via VPN or FastConnect, and enforce TLS 1.2 or higher for application endpoints. 
    4. Governance and Compliance
    Maintain visibility and enforce regulatory standards across your cloud footprint.
    • OCI Audit: Enable OCI Audit to track all API calls and administrative actions. Export these logs to immutable Object Storage buckets for long-term retention.
    • OCI Cloud Guard: Activate Cloud Guard to continuously monitor your environment for security misconfigurations and insecure operational practices.
    • Maximum Security Zones: Deploy highly sensitive workloads in Maximum Security Zones, which enforce strict policies preventing the creation of public buckets, unencrypted volumes, or internet-facing compute instances.
    • Compliance Frameworks: Use built-in compliance mappings in OCI (e.g., CIS Benchmarks, HIPAA, PCI-DSS) available within Cloud Guard and OCI Compliance to automatically assess and report on your regulatory posture

    Question : Maintain operational documentation, SOPs, runbooks, and support procedures for oci environment
    Maintaining documentation in an Oracle Cloud Infrastructure (OCI) environment requires a structured approach. Leverage Fleet Application Management for native runbook execution, establish a centralized knowledge repository, and integrate with OCI Audit and Vault to manage security and compliance
    1. Structure Your Documentation Tier
    Adopt a distinct, three-tiered framework to scale your operations
  • Standard Operating Procedures (SOPs): Broad, non-branching instructions for routine, predictable governance tasks (e.g., quarterly access reviews, monthly backups).
  • Runbooks: Highly granular, step-by-step technical guides used for managing OCI resources (e.g., executing a database failover using Oracle Data Guard).
  • Playbooks: Strategic, high-level troubleshooting flows used to handle unpredictable incidents (e.g., responding to an OCI Web Application Firewall (WAF) mitigation incident
  • 2.Best Practices for OCI Environments
    • Centralize with Fleet Application Management: Use OCI's Fleet Application Management to capture and automate procedural tasks. You can natively track lifecycles and deploy operational runbooks.
    • Implement Version Control: Store your text-based runbooks and SOPs in version-controlled repositories (e.g., GitHub, GitLab, or OCI DevOps service). Track all updates to align with your change management processes.
    • Secure Sensitive Information: Never hardcode credentials in documentation. Instead, use OCI Vault to store secret credentials securely and reference them dynamically.
    • Automate Discovery and Tracing: Utilize the OCI Audit service to maintain a complete log of all API activities, which is critical for incident investigations and compliance verifications
  • 3. Lifecycle Management of Operational Docs
    • Regular Reviews: Ensure your runbooks are living documents. Schedule a review at least quarterly, or immediately following any significant OCI environment update (e.g., VCN restructuring or new compute instance provisioning).
    • Testing and Validation: Validate runbooks in lower environments (e.g., Dev/Test) before applying them to Production. Have team members walk through the steps blindly to ensure they are clear and executable.
    • Transition from Manual to Automated: As your operations mature, transform flat-text runbooks into automated scripts using tools like OCI CLI, Resource Manager, or Ansible within the OCI Resource Manager service

    Question : Provide guidance and support to junior engineers and operations teams in OCI enviroment

    To effectively guide junior engineers and operations teams in an Oracle Cloud Infrastructure (OCI) environment, establish a structured mentorship program emphasizing hands-on practice, automated runbooks, and continuous learning. Prioritize Infrastructure as Code (IaC) to standardize deployments and mitigate configuration errors
    1. Standardize Training and Certifications
    Provide structured onboarding through Oracle's official resources to establish a baseline of OCI architecture and operations
  • Learning Paths: Assign the OCI Cloud Operations Professional Course to help junior engineers master day-to-day administration and security.
  • Certifications: Encourage completion of the OCI Foundations and Architect Associate certifications using the Oracle Cloud Infrastructure Training portal

  • 2. Implement Operational Runbooks & Tooling
    Maintain step-by-step documentation for incident management, fleet maintenance, and daily operations

    3. Establish Monitoring and Observability
    Ensure the team can rapidly detect, acknowledge, and resolve incidents by utilizing OCI’s native observability tools
  • Logging & Alerts: Configure OCI Logging for centralized log collection and implement OCI Alarms and Notifications so junior engineers are proactively alerted to system metrics.
  • Cloud Advisor: Direct the team to use Cloud Advisor to review recommendations regarding cost optimization, security posture, and performance

  • 4. Foster a Culture of Automation
    Transition the team from manual console operations to automation and scripting:
    • OCI Cloud Shell: Have them utilize Day One and Beyond: Intro to Oracle Cloud Operations to learn how to operate the web-based terminal, pre-installed CLI, and SDKs.
    • Task Automation: Encourage the use of Python, Bash, and Terraform to automate repetitive provisioning and maintenance tasks, reducing manual errors.

    Question : Participate in on-call support and planned maintenance windows. in OCI enviroment

    Participating in on-call support and planned maintenance in Oracle Cloud Infrastructure (OCI) requires robust operational runbooks. This involves monitoring system health, executing rolling patches, failing over database workloads, and managing maintenance window notifications directly within the OCI console

    Effectively managing these on-call and maintenance operations in your OCI environment involves executing these specific practices:
    1. Proactive Maintenance & Patching
    • Exadata & Database Services: Use scheduling policies to ensure your Exadata and database updates happen in a rolling manner. This allows compute and storage nodes to be updated sequentially without total downtime.
    • Compute Maintenance: Take advantage of Non-Terminating Repair (NTR) capabilities where OCI repairs underlying infrastructure components without terminating or evacuating your running Compute VMs.
    • OS Management Hub: Utilize the OCI OS Management Hub service to set policies that automate OS patching schedules across your Linux and Windows VMs.
    • Review Notifications: Regularly check the OCI Console Announcements or set up notification event rules to receive alerts at least 14 days prior to any planned maintenance event
    2. High Availability (HA) & Disaster Recovery (DR)
    • Data Guard Switchovers: If you manage critical databases, use Oracle Maximum Availability Architecture (MAA) best practices. If your primary database needs maintenance, perform a manual switchover to your standby database prior to the maintenance window.
    • Load Balancers & Network: Configure redundant Virtual Circuits (e.g., FastConnect and IPSec) across diverse physical routers. When performing planned maintenance on CPE devices, configure your network to respond to OCI graceful shutdown community messages to prevent packet drops
    3. On-Call Support & Alert Suppression
    • Suppression Windows: When performing deliberate maintenance, configure Maintenance Windows in OCI Stack Monitoring. This suppresses unwanted alerts and alarm notifications while continuing to monitor the resource's state.
    • Oversight Tools: Combine OCI Monitoring with the Notifications service to get alerts for critical metrics like high CPU usage or memory leaks so you can triage issues the moment they spike during maintenance
    4. Incident Management & Support Escalation
    • Support Ticket Handling: If maintenance packs introduce regressions, immediately log a support ticket on My Oracle Support.
    • Contact Management: Ensure you keep your operational support contacts and notification channels updated within the console's OCI Operations Actions section so the right engineers are paged during emergencies

    Question : How to migration oracle database to OCI


    OCI Database Migration is a fully managed, self-service cloud tool designed to move workloads from on-premises systems, partner clouds, or other cloud deployments into Oracle Cloud Infrastructure (OCI). This service streamlines the migration process into a single visual interface, combining multiple enterprise-level tools to eliminate complex manual infrastructure management

    Key Capabilities
    • Unified Tooling: Seamlessly bundles Zero Downtime Migration (ZDM), Data Pump, and Oracle GoldenGate behind a single managed workflow.
    • Cross-Version & Hardware Modernization: Facilitates version upgrades and structural platform changes alongside the migration itself.
    • Cost Efficiency: Provided as a free-to-use platform service (you only pay for underlying cloud infrastructure resources like storage or target compute).

    Migration Methods
    When setting up your migration project through the Oracle Help Center console, you can select between two primary pathways:
    Online Migration (Minimal Downtime) 
    • Initial Load: Leverages Oracle Data Pump to take a logical snapshot and transport data directly or through OCI Object Storage.
    • Delta Synchronization: Deploys a managed, real-time GoldenGate replication stream to capture active changes made on the source database.
    • Cutover: Swaps application traffic to the cloud destination with near-zero business impact

    Offline Migration (Requires Maintenance Window) 
    • Direct Transfer: Shuts down incoming transactions at the source, running a clean extraction and immediate recovery sequence on the cloud target.
    • Best Use Case: Ideal for development environments, test sandboxes, or instances with strict change windows where active synchronization is not required
    Core Architectural Process
    [ Source Database ] ──( 1. CPAT Validation )──> [ OCI Object Storage / DB Link ] ──( 2. Data Pump Import )──> [ Target OCI Database ]
             │                                                                                                             ▲
             └───────────────────────────( 3. Online GoldenGate Replication )─────────────────────────────────────────────┘
    
    1. Premigration Validation: The integrated Cloud Premigration Advisor Tool (CPAT) automatically evaluates the source, highlights platform compatibility flags, and exports actionable repair scripts.

         
  • Check for source and target compatibility.
  • Identify problematic database objects, deprecated features, or unsupported data types.
  • Automatically generate actionable repair scripts to resolve exception
  •          

    2. Storage Configuration
          Data is staged during transit. You must create and configure an OCI Object Storage bucket to hold the dump files, or utilize direct Database Links for fast, network-based transfers


    3. Execution & Replication
    You can run migrations in two modes:
    • Offline Migration: Suitable for non-production databases where downtime is acceptable. It uses Oracle Data Pump to unload data directly to object storage and import it into the OCI target.
    • Online Migration (Zero-Downtime): Utilizes Data Pump for the initial base load and configures Oracle GoldenGate to replicate ongoing, real-time changes while your application remains live
    Key Supported Endpoints
    • Source: On-premises Oracle Database (versions 11g, 12c, 18c, 19c) Standard or Enterprise Edition.
    • Targets in OCI: Autonomous Database (ATP/ADW), Base Database Service (VM/Bare Metal), or Exadata Cloud Service

    Supported Workloads
    • Oracle Databases: Full multi-version capabilities for migrating physical deployments, virtual machine setups, or Oracle Database@Azure ecosystems.
    • MySQL Systems: Native support for logical cloud onboarding into OCI MySQL HeatWave target


    Configuring an Oracle Zero Downtime Migration (ZDM) response file requires copying the default template and updating parameters for your environment. You can choose between Logical (Data Pump) or Physical (Data Guard) migrations depending on your target (e.g., Exadata or Autonomous Database)

    1. Copy the Template
    Log into your ZDM host as the zdmuser and copy the appropriate template to your working directory
    bash
    # Example for Logical Migration
    cp $ZDM_HOME/rhp/zdm/template/zdm_logical_template.rsp ~/zdm_logical.rsp
    
    # Example for Physical Migration
    cp $ZDM_HOME/rhp/zdm/template/zdm_template.rsp ~/zdm_physical.rsp


    2. Configure Key Parameters
    Open the response file in a text editor (e.g., vi) and update the required values.
    Target Database & Migration Method:
    • TGT_DB_UNIQUE_NAME: The unique name of your target database.
    • MIGRATION_METHOD: Set to ONLINE_PHYSICAL (Physical with Data Guard) or OFFLINE_LOGICAL (Data Pump)
    • Source & Target Connectivity:
      • SRC_DB_UNIQUE_NAME: The unique name of your source database.
      • SRC_HOST_NAME: FQDN or IP of your source database host.
      • TGT_HOST_NAME: FQDN or IP of your target database host.

      Backup Medium (For Physical Migrations):
      • DATA_TRANSFER_MEDIUM: Set to DIRECT (Network/dblink) or OSS (OCI Object Storage).
      • TGT_BASTION_HOST_IP / SRC_HOST_IP: Add bastion IP configurations if your nodes are located behind jump hosts

    3. Review Official Documentation
    For the complete list of parameters, reference the official templates:
    Once configured, validate your settings by running your migration command with the -eval flag before executing the actual move

    for More Details

    Load Balancer

    In Oracle Cloud Infrastructure (OCI), a Load Balancer provides automated traffic distribution to improve fault tolerance and scalability. Key resources include Public/Private Load Balancers for ingress, Network Load Balancers for Layer 4 pass-through, backend sets, and health checks. [1, 2, 3, 4, 5]
    Here are the top interview questions and answers for OCI Load Balancers:
    Q1: What is the difference between an OCI Load Balancer (LB) and a Network Load Balancer (NLB)?
    Answer:
    • OCI Load Balancer (Layer 7): Operates at the application layer. It inspects HTTP/HTTPS traffic, supports SSL termination, content-based routing (path, hostname), and cookie-based session persistence.
    • Network Load Balancer (Layer 4): Operates at the transport layer. It handles TCP/UDP traffic and provides high-throughput, ultra-low latency, non-terminating packet forwarding without examining application content. [1, 2, 3, 4, 5]
    Q2: What are the primary Load Balancing Policies available in OCI?
    Answer: OCI LBs support three main policies for distributing traffic:
    • Round Robin: The default algorithm that evenly distributes requests sequentially across all backend servers.
    • Least Connections: Routes traffic to the backend server with the fewest active connections, ideal for long-lived connections.
    • IP Hash: Uses the client's source IP to route requests, ensuring that the same client is always directed to the same backend server (if available).
    Q3: How do you handle high availability for an OCI Load Balancer?
    Answer: OCI manages the underlying high availability of load balancers automatically.
    You can ensure high availability at the regional level by using regional subnets,
    which distribute the load across multiple Availability Domains (ADs).
    Furthermore, OCI deploys LBs as highly available active-standby pairs under the hood.
    Q4: What is SSL Offloading (Termination), and can OCI Load Balancers do it?
    Answer: Yes. SSL offloading is the process of decrypting encrypted incoming traffic (HTTPS)
    at the load balancer before sending it as plain text (HTTP) to the backend servers.
    This saves compute resources on the backend servers.
    OCI LBs support SSL termination, end-to-end SSL encryption, and custom SSL certificates.
    Q5: Can a single OCI Load Balancer distribute traffic to backend instances in different Virtual Cloud Networks (VCNs)?
    Answer: No. An OCI Load Balancer is strictly tied to a single VCN.
    All backend instances and the load balancer itself must reside within the same VCN.
    If you need to balance traffic across resources in different VCNs,
    you must use VCN Peering or multiple load balancers.
    Q6: What is session persistence (sticky sessions), and how does OCI handle it?
    Answer: Session persistence ensures that a client's subsequent requests are routed to the same
    backend server, maintaining state
    (e.g., shopping cart data). OCI Load Balancers support Cookie-Based Persistence,
    where the LB issues a cookie to the client, or Source IP Persistence,
    which pins connections based on the client's IP address.
    Q7: What are Backend Sets and Health Checks in OCI?
    Answer:
    • Backend Set: A logical entity that defines a list of backend servers
    • (compute instances), their port settings, the load balancing policy,
    • and health check configurations.
    • Health Checks: A configuration where the LB continuously pings backend instances
    • via TCP or HTTP on a specified port and path.
    • If an instance fails, the LB automatically stops routing traffic to



    1. How do you integrate Oracle Enterprise Manager (EM) with Exadata Cloud Service in OCI?
    • Answer: You integrate by provisioning an EM Management Agent on the Exadata Database VM clusters in OCI.
      • First, ensure network connectivity and security rules allow the VMs to communicate with the central EM OMS (Oracle Management Service) server.
      • Next, download and install the EM Agent software on the database compute nodes.
      • Finally, run the agentDeploy script to register the agent with OMS.
      • The agent will then automatically discover the databases and Exadata components.

    2. How does Enterprise Manager discover the Exadata Storage Servers (Cells) in a cloud environment?
    • Answer: Enterprise Manager discovers Exadata storage servers through the Management Server (MS) process running on each Exadata cell.
      • You must configure SNMP traps on the Exadata storage cells to point to the EM Agent.
      • During the discovery process in EM, you provide the grid user credentials and the cell IP addresses so EM can connect, query the cell components, and build the physical-to-logical topology


    3. What is the difference between Exadata-level monitoring and OCI native monitoring for ExaCS?
    • Answer:
      • OCI Native Monitoring: Primarily handles infrastructure health out-of-the-box, such as compute node CPU utilization, VCN networking, and storage capacity limits. It uses OCI Native Services like OCI Monitoring.
      • Enterprise Manager (EM) Monitoring: Provides deep-dive, application-to-disk database performance tuning, automatic diagnostic repository (ADR) integration, compliance checks, and end-to-end incident management. It is best used for holistic lifecycle management.

    4. How do you monitor Exadata-specific hardware and software metrics (like Smart Scan or Flash Cache) using Enterprise Manager?
    Answer: EM provides a dedicated Exadata Plug-in. Once the plug-in is deployed to the
    EM Agent, it captures specific cell metrics.
    You can monitor the Cell Flash Cache Hit Ratio, Smart Scan offloading efficiency,
    Storage Server I/O latency, and IORM (I/O Resource Manager) configurations.
    These metrics are available via the Exadata dashboards within the EM Console


    5. In an Exadata Cloud Service deployment in OCI, what are your specific management responsibilities versus Oracle's?
    • Answer: This represents the shared responsibility model in OCI.
      • Oracle Responsibilities: Managing and maintaining the underlying Exadata hardware,
    physical networking, power, and the hypervisor layer.
      • Customer Responsibilities: Managing the Virtual Machine Operating System (OS), Oracle Grid Infrastructure, Database software, and application tuning. Enterprise Manager is the tool the customer uses to monitor
    and manage these specific responsibilities


    6. What is the process for managing Exadata patches in OCI when using Enterprise Manager?
    • Answer: In OCI, patching the Exadata Cloud Infrastructure (Grid Infrastructure and
    • Database patches) is generally handled through OCI Cloud Automation or
    • the OCI Console directly, as Oracle manages the underlying patching mechanisms.
    • However, Enterprise Manager's Compliance and Patching Frameworks
    • can still be used to assess the database versions, run pre-upgrade validation checks
    • (like DBUA), and apply quarterly Release Updates (RUs) at the database tier


    7. What should you verify if EM is not receiving performance metrics from the Exadata Compute VMs?
    • Answer:
      • Network & Security Lists: Verify that the OCI Virtual Cloud Network (VCN) Security Lists and Network Security Groups (NSGs) allow inbound/outbound traffic on the EM OMS ports (e.g., 4903 or 4904).
      • Agent Status: Check the status of the EM Management Agent on the ExaCS node by running /sbin/init.d/oraclemgmt_agent status or emctl status agent.
      • Cell SNMP configuration: Ensure the MS process on the Exadata cells is successfully sending SNMP traps to the EM Agent port