dba / system administrator activities

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

.

The material contained in this document is proprietary to Triniti Corporation (Triniti). This material may not be disclosed, duplicated or otherwise

revealed, in whole or in part, without prior written consent.

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

DBA / System Administrator

Activities

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Index

q  DBA Activities

q  System Administrator Activities

q  Operating System Administrator Activities

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

DBA Activities

Ø  New Installations

Ø  Upgrade to New Releases Ø  Instance Refreshes Ø  Backup and Recovery

Ø  Tuning

Ø  Change Management

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

New Installations

§  Single and Multi-node Installation of Oracle Applications e-Business Suite 11i, R12 and R12.2 releases on various Operating Systems like RedHat Linux, Oracle Enterprise Linux, Solaris, AIX etc.

§  Installation of RAC and Non-RAC Oracle Database Release 9i, 10g and 11g on various Operating Systems like RedHat Linux, Oracle Enterprise Linux, Solaris, AIX etc.

§  Installation and administration of Oracle Software such as ü  Oracle Application Server ü  Oracle WebLogic Server ü  Oracle Business Intelligence Enterprise Edition (OBIEE) ü  Oracle Discoverer Server ü  Oracle Warehouse Builder (OWB 11g) ü  Demantra ü  Oracle Integrated Operational Planning ü  Oracle User Productivity Kit (UPK)

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Upgrade to New Releases

§  Plan and execute upgrade of Oracle Applications e-Business Suite 11i and R12 from prior releases

§  Plan and execute upgrade of Oracle Database Release 9i, 10g and 11g from prior releases

§  Plan and execute Oracle Warehouse Builder (OWB) Upgrade to 11g from 10g

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Instance Refreshes

§  Refresh Non-Production Oracle Applications e-Business Suite 11i and R12

instances from Production instance

§  Refresh Non-Production Oracle Database Release 9i, 10g and 11g from

Production instance

§  Instance refresh using rman backup / hot backup and cold backup

§  Database only refresh for e-Business suite instances

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Backup and Recovery

§  Plan Backup and Recovery strategy as per customer requirement §  Setup Stand-by instance : Setup Stand-by for Production instance off-site for

disaster recovery

§  Setup and manage rman backup for databases using OEM

§  Cold Backup for E-Business Suite instances

§  Backup and Restore Database schemas using exp/imp utility

§  Recover database using rman backups

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Tuning

§  Tuning Oracle E-Business Suite to improving response time

§  Tuning the Oracle Database Memory Setting for better performance

§  Tuning bad SQL Queries

§  Enable Trace for Oracle Form and Concurrent Programs to troubleshoot

performance issues

§  Scheduling statspack on Database to identify Bad Performing Code

§  Schedule Gather Stats for all the Schemas

§  Concurrent manager tuning for Oracle E-Business Suite

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Change Management

§  Database objects migration across the instances

§  Oracle Forms and Reports migration across the instances

§  Workflow migrations using WFLOAD utility across the instances

§  Migrations using FNDLOAD across the instances ü  Concurrent Programs ü  Menu ü  Responsibilities ü  Users ü  Profiles ü  Value sets ü  Personalizations etc…

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

System Administrator Activities

Ø  Application Security

Ø  Application Defaulting

Ø  Concurrent Processing

Ø  Register Hardware

Ø  Document Sequence

Ø  Workflow Administration

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Defining Responsibilities

§  Defining Request Groups

§  User Session Limits

§  Defining Security Groups

§  User Management

§  Defining Form Functions

§  Implementing Function Security

§  Menus

Application Security

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Overview of System Profiles

§  Setting Profile Values at Different Levels (Site, Application,

Responsibility, User)

§  Defining Custom Profiles

§  Setting Custom Profile Values at Different Levels (Site,

Application, Responsibility, User)

Application Defaults

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Define Concurrent Programs and Executables §  Define Data Groups §  Define Request Groups §  Define Request Sets §  Define Program Incompatibility Rules §  Define Custom Concurrent Programs §  Copying and Modifying Program Definitions §  Reviewing Requests, Request Log Files, and Report Output

Files §  Changing the Status of Concurrent Requests

Concurrent Processing

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Managing Concurrent Processing Files and Tables §  Purge Concurrent Request and/or Manager Data §  Defining Managers and their Work Shifts §  Specializing Managers to Run Only Certain Programs §  Grouping Programs by Request Type §  Controlling Concurrent Managers §  Managing Parallel Concurrent Processing §  Administer Concurrent Managers §  Define Concurrent Request Types

Concurrent Processing Contd….

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Define Document Sequences

§  Define Document Categories

§  Sequence Assignments

Document Sequence

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Setting up Printers

§  Defining Printer Types

§  Defining Print Styles

§  Defining Printer Drivers

§  Common Unix Printing System (CUPS) Integration

§  Customizing Printing Support in Oracle Applications

§  Postscript Printing in UNIX

Register Hardware

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Administering Notifications

ü  Restarting Workflow Services ü  Monitoring Workflow Services for availability ü  Setting Override address to test Notifications

§  Workflow Status Monitoring

ü  Viewing Status Diagram ü  Viewing Activity History ü  Viewing Workflow Details ü  Viewing Error Information for a Workflow

Workflow Administration

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

§  Workflow Mangers

ü  Notification Mailer for Inbound and Outbound notifications ü  Enabling Workflow Agent Listeners ü  Deferred Work Items ü  Suspended Work Items ü  Purging Workflow Data ü  Errored work Items

Workflow Administration Contd….

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Operating System Administrator Activities

Ø  Installing Red Hat Linux Ø  Installing Packages (rpms) Ø  Operating system User Management Ø  Monitoring the server for Disk space Ø  Monitoring the server for processes consuming high resources Ø  Planning file system backups Ø  Installing/Configuring Printers

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

The material contained in this document is proprietary to Triniti Corporation (Triniti). This material may not be disclosed, duplicated or otherwise

revealed, in whole or in part, without prior written consent.

E N A B L E R S O F T H E V I R T U A L E N T E R P R I S E

Thank You