Oracle EBS DBA – Day to Day Activities

R12.2.x Install Patch and Maintain Oracle E Business Suite

 

Overview of R12.2.x Installation

Module Summary

Overview of Oracle E-Business Suite 12.2 installation

Overview of Rapid Install

Single Node Installation

Two Node Installation

 

Oracle E-Business Suite Architecture R12.2.x

 

Introduction to Oracle E-Business Suite

Oracle E-Business Suite Architecture

Oracle E-Business Suite Multi-Tier Architecture

Desktop Tier

Application Tier

Database Tier

Oracle Homes Architecture

Oracle E-Business Suite Technology Layer

 

AD Utilities

 

Overview of AD Utilities in Oracle E Business Suite R12.2 Server

Process of running AD Utilities

Overview of ADOP, ADPATCH and ADADMIN

Discussion on various AD Utilities, running AD utilities and their day-to-day usage by an Oracle

Applications DBA

Overview of special utilities including AD Controller and resolving worker status

 

 

AD Administration

 

Generate Applications Files Tasks

Maintain Applications Files Tasks

Compile/Reload Database Entities Tasks

 

Online Patching Concepts

 

Patch Types, Terminology, and Components

Patch Creation and Patching Order

Patching Utilities

Introduction to Online Patching

Architectural Changes to Support Online Patching

Database Implementation

Editioning Views and the Application Data Model

Phases of the Online Patching Cycle

 

Running the AD Online Patching Utility

 

AD Online Patching Utility

Running the adop Utility

adop Commands

Executing the Patching Cycle

Status of a Patching Cycle

Patching in Multi-Node Environments

adop Remote Invocation

Hotpatch Mode

 

Auto Config

 

Overview of AutoConfig in Oracle E Business Suite R12.2

Autoconfig related Terminology

The Application Context

AutoConfig Managed AD Utility Files

AutoConfig Scripts and Directories

Running AutoConfig on DB Tier in R12.2.x

Running AutoConfig on Applications Tier in R12.2.x

AutoConfig Log Files

Rolling back AutoConfig

 

 

Cloning Oracle E-Business Suite

Principles and Terminology

Cloning Scenarios

Prerequisite Steps

Cloning Steps

Finishing Tasks

Refresh a Target System

Clone a Single node to Single node

Clone a Multi-Node System to Multi-Node

Add a Node to an Existing System

 

Upgrade from Release 12.2 to 12.2.10

 

How to upgrade from Release 12.2 to 12.2.10

Run Database Checker Tool

New UI in Oracle EBS 12.2.10

 

Advance Topics

Upgrade from R12.2 to R12.2.10
Upgrade from R12.1.3 to R12.2.10

Upgrade database from 12c to 19c (container database)

Data Guard setup for Oracle EBS including switchover and switchback

Lift and Shift using Oracle Cloud manager (automatic) and manual

SSL setup for R12.2

 

System Administrator

 

R12.2 System Administrator Fundamentals

 

Description:

In this course you will learn concepts and functions that are critical to the System Administrator role. You will also learn information to help you manage the R12.2 E-Business Suite, such as workflows and alerts that are specifically tailored to the System Administrator’s needs. The System Administrator Fundamentals course is a part of the Learning Path for Implementation Consultants and will provide you with the foundation you need to effectively control security and ensure smooth operations for an E-Business Suite installation. Demonstrations and hands-on practice reinforce the fundamental concepts.

 

Objectives:

– Incorporate custom help files and concurrent programs

– Manage system resources, printers, and folders

– Manage concurrent managers, programs, and reports

– Manage application security

– Implement Oracle Alert

 

Topics:

1 – Managing Application Security

2 – Managing Concurrent Programs and Reports

3 – Administering Concurrent Managers

4 – Managing Profile Options –

5 – Incorporating a Custom Program

Register custom top

6 – Auditing System Resources –

7 – Managing Printers –

8 – System Management using Oracle Application Manager (OAM)

9 – Applications DBA Duties

10 – Configure Oracle Workflow –

11 – Overview of Oracle Alert

12 – Code Migration