Oracle Ebs – System Administration

Presentation on Oracle EBS – System Administration

Agenda
 How Apps DBA is different from Oracle DBA  Tasks of a System Administrator  Security related Tasks of System Administrator  Clarifications

www.arowanaconsulting.com

System Administrator Responsibilities & Tasks

www.arowanaconsulting.com

Overview
Oracle EBS Administration is different from and Oracle DBA
        Needs to be an Oracle DBA Needs to have knowledge of Oracle Application Fundamentals Needs to have Concept of Oracle EBS Architecture Expertise in Oracle EBS Installation and Configuration Expertise in application of Patches and Upgrading Applications Cloning of Application and Database to create new support instance Managing Customizations of Applications User Access Management

www.arowanaconsulting.com

1.1 System Administrator Tasks
The System Administrator needs to perform the following tasks
            Backup & Cloning Manage Concurrent Managers Patching and Maintenance Performance Management Manage Concurrent Programs and Requests Purging of Concurrent Request /Program Data Manage Workflow Manager Monitoring Oracle E-Business Suite Administering Oracle E-Business Suite Application Inventory Management License Management Manage User Profiles & Profile Options

www.arowanaconsulting.com

1.2 System Administrator Tasks
Some more Tasks performed by the System Administrator
             Manage Concurrent Programs & Executables Manage Responsibilities Manage Request Groups and Request Sets Manage Data Groups Running Utilities Manage Folders, Lookups, Profile Options and Profile Values Query Optimization & Gathering Statistics RAC Management Manage Document Sequences Administering Globalization Managing KFF, DFF Managing Value Sets, Values Managing New Customizations and Updates

www.arowanaconsulting.com

2.1 Security Management
Tasks related to Security of Oracle EBS
 Access Control & User Management  Function