peoplesoft dba course content

Oracle PeopleSoft DBA
Course Contents

Oracle-PeopleSoft Latest Versions
PeopleTools: 8.50/8.53/8.54
Applications: HRMS 9.1/FSCM 9.1/CRM 9.1/HRMS 9.2
Database: Oracle 10gR2/11gR2/12cR1
Middleware: Oracle WebLogic 10.3/12c
: Oracle Application Server 10.3/12c
People Books: 8.50/8.53/8.54
And also PeopleTools 8.48 , Application HCM 9, BEA TUXEDO 8.1, BEA WEBLOGIC 8.1, People Books 8.48.

Technology Overview
Describing the functions of PeopleSoft PeopleTools in PeopleSoft applications
Describing PeopleTools in an Implementation
Describing how to find information about PeopleSoft PepleTools in PeopleBooks

Describing PeopleSoft Architecture
Describing the development of multi tired processing
Describing the PeopleSoft Pure Internet Architecture
Describing how PeopleSoft uses databases
Contrasting PeopleSoft Servers
Discussing PeopleSoft Clients
Designing configuration for an application

Installing the PeopleSoft Environment
Preparing for the Installation of the PeopleSoft Environment
Describing PeopleSoft Installation Tools
Building a PeopleTools installation
Setting up the installation and development personal computers (PCs)
Testing an installation and Planning for future changes

Installing PeopleSoft Databases
Describing PeopleSoft databases
Preparing for database installation
Summarizing database creation steps
Determining what databases to install
Running the database configuration wizard
Creating databases using Data Mover and other PeopleTools
Performing post database installation testing

Installing TUXEDO and JOLT
Explaining middleware
Summarizing Tuxedo in the PeopleSoft system
Installing TUXEDO
Removing and Upgrading TUXEDO

Creating and Configuring Application Server domains
Describing the elements of application server domain
Explaining domain servers and functions
Using Specialized domains
Creating an initial domain Configuration
Automating domain startup and shutdown
Testing a domain
Configuring Search server domain

Administrating Application Servers
Troubleshooting common domain boot problems
Administering the domain and view status
Using PSADMIN to reconfigure a domain
Setting individual process parameters

Administering the Web Server
Describing common web server elements
Explaining web server installation
Locating and identifying web server files
Interpreting various web server configuration files and determining web server behavior

Installing and Configuring web Components
Installing the PeopleSoft web components
Configuring the browser connection
Locating web server configuration files
Modifying web server Configuration files to change web server behaviour
Installing multiple PeopleSoft applications
Using load balancing and fall-over features in PeopleSoft applications

Examining the Batch Environment
Identifying batch components
Describing batch process flow
Determining batch server locations

Setting Up and configuring the Batch Environment
Creating a Batch server
Modifying batch server configuration settings
Starting and stopping the Process scheduler
Creating a new Process Scheduler server definition

Configuring Report Distributing and Monitoring the batch Environment
Launching processes
Using the Process Monitor
Describing Report Manager
Describing automated windows report distribution

Managing and Troubleshooting an Implementation
Summarizing PeopleSoft troubleshooting tools
Examining PeopleSoft server log files
Listing troubleshooting tools available after installation

Troubleshooting Application and Batch Servers
Tracing application server activity
Tracing Process scheduler server activity

Using Other PeopleSoft Troubleshooting Tools
Describing Performance Monitor Architecture
Activating a self-monitoring Performance Monitor system
Accessing Performance Monitor information
Using PeopleSoft Ping (PSPING)

Tuning Implementation
Defining tuning layers
Evaluating application server settings to improve performance
Creating dedicated messaging servers
Tuning a batch environment
Loading balancing with the Master Scheduler

Installing and Configuring PeopleBooks
Installing PeopleBooks
Configuring the web server to access PeopleBooks

Objects In PeopleSoft Record, Field, Page, Component, Menu, Application Engine
Migration
Project Migration and Building the records, Compare Reports
Data Migration Data Mover
How to Setup the Client System for the Developer
1. Install Oracle Client Software
2. Install workstation for the client

Tracing, Troubleshooting and debugging
Single user Tracing - &trace = y (In PIA URL)
Tracing in Application Server and Process Scheduler
PC Debugger (application server Domain)
Application Server Log Files
Data Mover Troubleshooting
WebServer -PIA Log files
Process Scheduler Log files

PeopleSoft Security
User Profiles
Roles
Permission Lists
Password Controls
Resetting Admin Password
PIA Security
Logon to PeopleSoft Customer Connection
Patches, Updates, Fixes, Tax Updates
Create, Update and Manage the PeopleSoft Cases
Finding the Resolutions

Upgrade Assistant, Change Assistant
Integration Broker- Configuration and Setup
Sample UNIX Commands
Load Balancing and Tuning
PeopleSoft Environment refreshes

PeopleSoft Database

1) LINUX Administration for Oracle PeopleSoft DBA

2) SQL for Oracle PeopleSoft DBA

3) OPERATING SYSTEM INSTALLATIONS

Oracle Enterprise Linux 5.5 and 6 Installations (Text Mode and Graphical Mode)
Oracle Enterprise Linux 5.5 and 6 Installations (Text Mode and Graphical Mode)
Redhat Enterprise Linux 5.5 and 12c Installations (Text Mode and Graphical Mode)

4) ORACLE Database Creations

Oracle Manual database creation for 11g R2 and 12c
Oracle Database Creation Using Basic Installation Method for 11g R2 and 12c
Oracle Advanced Database Creation for 11g R2 and 12c
Oracle Database Creation using Database Configuration Assistant (DBCA)

5) Oracle Database 11g R2 and 12c Architecture.

Oracle Logical Storage Structures
Oracle Logical Database Structures.
Oracle Physical Storage Structures.
Oracle Instance Architecture
Shared and Dedicated Server processes
Oracle Memory Structures
Database Buffer Cache
Redolog Buffer Cache
Shared Pool
Large Pool
Java Pool
Streams Pool
Background Processes

6) Controlling the Database

Creating and Configuring a listener.ora and tnsnames.ora file
For Manual Installations as well as advanced and DBCA installations.
Starting and Stopping ISQL* Plus
Starting and Stopping Database Control
Changing the Listener Status
Startup and Shutdown
Starting Up a Database NOMOUNT
Starting Up a Database MOUNT
Starting Up a Database OPEN
Shutting down the database.
SHUTDOWN OPTIONS like Shutdown Normal, Shutdown Transactional, Shutdown Immediate and Shutdown Abort

7) TableSpace Management

Tablespaces and Data Files
Space Management in Tablespaces
Creating a New Tablespace
Storage for Locally Managed Tablespaces
Altering a Tablespace
Actions with Tablespaces
Dropping Tablespaces
Viewing Tablespace Information
How to find the database size
How to find used database size
How to find free database size
How to find the table size

8) Control files management
Multiplexing Control files
How to recreate a controlfiles from the trace file.
How to take backup of a controlfile
How to restore a controlfile

9) Redologfile Management
How to multiplex redo log files.
Creating Redo log groups
How to drop redo log groups
Adding Redolog Members to a Redolog Group
Dropping a Redolog Member from a Group

10) Archivelog files management
How to configure flash_recovery_area for manual database installations.
How to configure flash_recovery_area size for manual database installations
How to configure flash_recovery_area and flash_recovery_area size for basic, advanced and dbca installations.
How to enable Archivelogmode
How to change database mode from noarchivelog mode to Archivelogmode

11) Pfile and spfile
Pfile
Spfile
Advantage and Disadvantages of pfile and spfile
Creating spfile from pfile
Creating pfile from spfile
Creating pfile

12) Security
Users and Resource Control
Creating New Users
Modifying User Settings with the ALTER USER Statement
Removing Users
Introduction to Profiles
Creating Profiles
Managing Passwords
Controlling Resource Usage
Dropping a Profile
Changing User, Profile, Password, and Resource Data
System and Object Privileges
Identifying System Privileges
Using Object Privileges
Managing System and Object Privileges
Granting and Revoking System Privileges
Granting and Revoking Object Privileges
Database Roles
How to Use Roles
Using Predefined Roles
Creating and Modifying Roles
Creating and Assigning Privileges to a Role
Assigning Roles to Users and to Other Roles
Limiting Availability and Removing Roles
Roles in the Enterprise Manager Console
Quotas
Assigning Quota to User
Altering Quota to a User
Assigning Unlimited Quota to a User
Removing Entire Quota from a User
Assigning Permanent and Temporary Tablespaces to a User

13) Oracle Net Services

Creating and configure a listener in client server environment
Starting the Listener Server Process
Stopping a listener process
Oracle Networking and Database Connectivity
Establishing Oracle Connectivity
Listener Control Utility
Monitoring with Listener Control
Local Naming
Testing Oracle Net Connectivity
Linux Server to Linux Server Communication (DBA)
Windows to Linux Server Communication (DBA) using putty
Windows to Linux Server Communication by using tnsnames.ora file (DBA)
Windows to Linux Server Communication by using Oracle 11g Client Software
(Developer, Tester etc)
Windows to Windows Server Communication using Remote Desktop (DBA)
Windows to Windows Server communication using tnsnames.ora file (DBA)
Windows Client to Windows Server Communication using Oracle 11g Client Software (Developer, Tester etc)

14) Flashback Technologies
Flashback Drop (Uses Recycle bin feature)
Flashback Table (Uses undo data)
Flashback Version Query (Uses undo data)
Flashback Database (Uses flashback log/flash recovery area)
15) Logical Backups
Logical backups using exp/imp
Full Logical Backups, User Level Backups and Table level backups
Logical backups
The Data Pump Export/Import Process
Using Data Pump Export and Import
Creating a Directory
Data Pump Export Options
Starting a Data Pump Export job
Data Pump Import Options
Starting a Data Pump Import Job
Comparing Data Pump Export/Import to Export/Import
Logical Incremental backups using exp and imp
Logical Incremental backups using data pump technologies i.e expdp and impdp

16) Physical Backups

Cold Backups or Offline backups or Closed Backups
How to take cold backups for non-production environments like DEV, TST and STAGING
Hot backups or Online Backups or Open Backups
How to take Hot Backups for Production environments.

17) RMAN Backups and Recovery (Physical Backups)

RMAN Features and Components
RMAN vs. Traditional Backup Methods
Backup Types
RMAN commands and Options
Configuring the RMAN Environment
Setting up a Repository
Registering a Database
Controlfile Autobackup
Backup Operations
Full Database Backups
Tablespace
Datafiles
Control File, SPFILE Backup
Archived Redo Logs
Incrementally Updated Backups
Backup Compression
Validating Backups

Using the Recovery Catalog
Making Backups with RMAN
Maintaining RMAN Backups and the Repository
Scripting RMAN
Restoring a Control File
Restoring a Tablespace
Restoring a Datafile
Restoring an Entire Database
Validating Restore Operations
Restore Preview
Restore Validate
Point in Time Recovery
REPORT and LIST

Performing Complete Recovery
Performing Incomplete Recovery
Performing Flashback Recovery
Handling Online Redo Log Failures
Tuning RMAN
Troubleshooting RMAN
Performing Backup and Recovery with Enterprise Manager (OEM)

18) Database Cloning
Online Cloning for the Production Servers
Offline Cloning for the Non-Production Servers.
Database Online and Offline Cloning Using RMAN with Oracle Enterprise Manager (OEM)
19) Data Guard (Disaster and Recovery)
Introduction to Oracle Data Guard
Data Guard Architecture
Complete Implementation of Data Guard between Primary and Standby Servers
Preparing the Primary Database
Implementing Standby databases
Standby Database Administration
Log Management Services
Switchover and Failover
Data Guard Troubleshooting

20) Upgrading to Oracle Database 11g
Manual Upgradation

21) Patch Management
What is a Patch?
How to apply CPU (critical patch updates) to the Database.
How to file SR (Service Requests) using
https://support.oracle.com
How to download Oracle patches from the Oracle Customer Connection
i.e httS://support.oracle.com
How to Apply Patches to the Database

22) Database Tuning
Both Text based as well as OEM based
Monitoring the Database Aspects
Tuning the Database Areas
Monitoring using the ADDM (Automatic Database Diagnostic Monitor)
Running ADDM using OEM
Running ADDM using Command prompt
Using the UTLBSTAT.SQL and UTLESTAT.SQL files
Implementing the OEM-Tuning Pack
Using SQL Tuning Advisor
Running SQL Access Advisor
Managing AWR (Automatic Workload Repository)
Accessing AWR through OEM
Managing AWR using DBMS_WORKLOAD_REPOSITORY package
Using OEM to View AWR Report

23) Automatic Storage Management (ASM)
Introduction to Automatic Storage Management (ASM)
How to implement RDBMS instance
How to implement ASM instance
How to maintain ASM Disks
Diskgroups and Failure Groups
ASM Command-Line
Managing Databases in ASM
ASM Operations
Typical ASM Diskgroup Commands
Troubleshooting ASM

24) Database Refreshes
Refreshing Data from Production Server to the Development and Testing Servers

25) Managing Large Databases
Bigfile Tablespace Basics
Creating and Modifying Bigfile Tablespaces
Managing Oracle Application Databases
Managing Oracle-PeopleSoft Databases
Managing SAP Databases
Managing SOA Applications Database

26) Database Server Troubleshooting.
Listener Issues
Client Server issues
Data Guard Issues
RMAN issues
Performance and Tuning Troubleshooting Issues
Upgrade issues
Patch Management issues
Installation and Configuration issues
Online and Offline Cloning issues
Logical Backup and Physical backup issues
Flashback issues
Control file issues
Redolog file issues
Archive log file issues

27) Miscellaneous
Uninstalling Oracle Software
Dropping Databases using Drop database command
Dropping database using DBCA

28) Oracle Background Processes
Oracle 11gR2 DBA@DBA School Hyderabad
System Monitor (SMON)
Process Monitor (PMON)
Database Write (DBWR)
Archiver (arch)
Recover (reco)
Managed Recovery Process (MRP)
Check Point (CKPT) and so on