RingMaster Software

1
Kill Two Birds with One Stone.  Best Practices of
Maintaining the Oracle E-Business Suite while
Getting Compliance for Free

• RingMaster Software
• Because your enterprise depends on Oracle
• Change Management
• Automated Patch Management
• Automated Clone/Backkup/Restore Management

2
Todays Agenda

• RingMaster Software
• Challenges
• Best Practices
• Change Management Capabilities
• Compliance
• Benefits

3
RingMaster Software

• World leader in change management solutions for
  Oracle Applications
• patching,
• cloning,
• backup/restore
• Managing People, Process Technology
• Responding to customer needs for over 10 years
• 100 Focused on Oracle Applications

4
Solutions that help reduce the chaos, risk and
time associated with managing changes for Oracle
Applications.
5
The Challenge
The Technology Age Chaos!
6
DBAs Busy Day to Day

• Busy addressing immediate issues
• Defects
• Performance
• Researching issues and dependencies
• Patching applications and tech stack
• Cloning to patch, test and train
• Testing to ensure reliability and identify
  changed functionality
• Training users on new/changed functionality
• Documenting for SOX compliance
• Managing people and dependencies

7
Manual Patching
Run Patchsets.sh
Check Applied Patches
Download Patch
Transfer Patch
Update Spread Sheets
Patch Download
Change Reporting
UnZip Patch
Create Summary
Customization Impact
Review Readme
Research
Issue search
Database Impact
File System Impact
Review Drivers
Review Invalid DB Objects
Parse Actions
Patch Testing
Find Pre-reqs
Review Log File
Compare Envirs
Run Adpatch
Each Driver
Apply to test
Each Tier
Transfer Patch
Server Login
UnZip Patch
Prepare Envir.
Patch Application
Run Datainstall
8
Clone Manual
Manual Process (typical Instance) Backup Develop
backup scripts Test backup scripts Deploy third
party scheduling tool Run backup (on all
tiers) Monitor back up process Record back up
status Average time to backup 3
Hrs Restore Develop restore scripts Test restore
scripts Run restore Monitor restore
process Record restore status Average time to
restore 3 Hrs Cloning Backup source DB and
Application Ftp application software DB
files Rename/create directories Recreate the
Database Perform pre-clone activities Run
Rapidclone or adclone Monitor cloning
process Reset user password, responsibilities,
etc. Change Concurrent Manager setting Change DB
links Perform post clone activities Record Clone
status and keep audit logs. Average time to
clone 10-15 Hrs Instance Management Use Oracle
scripts to Start/Stop application Logon to each
app server start/stop services Verify each
server has services up and running Manually
Track the downtime of different
instances. Cloning using SAN Snapshots Shutdown
services on target Un mount target mount
points Initiate Snapshots Start copy data to
target server or start mirror sync
process Monitor copy/sync process Mount target
mount points Run RapidClone or AdClone
scripts Verify all services are up running on
each server Reset user password,
responsibilities, etc. Change Concurrent Manager
settings Change Database links Perform post-clone
activities. Record clone status and keep audit
logs. Average time to clone 3 Hrs
9
Patching with Best Practices
Workflows, Approvals, Notifications, Audit Trails
10
Cloning with Best Practices
Repeatable Automation Backup 50
faster Initiate Backup and schedule backup
Instance Respond to issued Alerts Review finished
reports Average time to backup a typical
instance 1.5 Hrs Restore 50 faster Initiate
Restore and restore Instance Respond to issued
Alerts Review finished reports Average time to
restore a typical instance1.5 Hrs Cloning
400 faster Initiate Clone and clone
Instance Respond to issued Alerts Review finished
reports Average time to clone a typical
instance 3 Hrs Instance Management Initiate
Clone Review finished reports Cloning using SAN
Snapshots 90 faster Initiate Clone and clone
instance Respond to issued Alerts Review finished
reports Average time to clone a typical instance
20Mins.
Manual Process (typical Instance) Backup Develop
backup scripts Test backup scripts Deploy third
party scheduling tool Run backup (on all
tiers) Monitor back up process Record back up
status Average time to backup 3
Hrs Restore Develop restore scripts Test restore
scripts Run restore Monitor restore
process Record restore status Average time to
restore 3 Hrs Cloning Backup source DB and
Application Ftp application software DB
files Rename/create directories Recreate the
Database Perform pre-clone activities Run
Rapidclone or adclone Monitor cloning
process Reset user password, responsibilities,
etc. Change Concurrent Manager setting Change DB
links Perform post clone activities Record Clone
status and keep audit logs. Average time to
clone 10-15 Hrs Instance Management Use Oracle
scripts to Start/Stop application Logon to each
app server start/stop services Verify each
server has services up and running Manually
Track the downtime of different
instances. Cloning using SAN Snapshots Shutdown
services on target Un mount target mount
points Initiate Snapshots Start copy data to
target server or start mirror sync
process Monitor copy/sync process Mount target
mount points Run RapidClone or AdClone
scripts Verify all services are up running on
each server Reset user password,
responsibilities, etc. Change Concurrent Manager
settings Change Database links Perform post-clone
activities. Record clone status and keep audit
logs. Average time to clone 3 Hrs

11
Best Practices Management of People and Process

• How to Manage Change
• Must know the change
• Must control the change
• Must communicate the change
• Must document the change

12
Know the Change

• Looking Thru the Windshield, not the Rear View
  Mirror
• Patch Research and Testing
• Metalink - patch info, bugs
• Patchsets released by Oracle
• Pre-requisites - current, obsolete
• Patch Prediction and Impact Analysis

13
Quick MetaLink Info

• Access MetaLink from
• APM Main Menu
• Verify Patch, Patch Prediction
• View patch status
• View bug numbers in this patch
• View patch information
• Reports
• Find latest patchset/minipack levels
• Find latest Oracle applications 11i Packs
• Find latest Oracle Server/Tools Patchsets
• List all patchsets released by Oracle
• View patchset levels for a specific environment

14
Patch Automation

• Patch download
• Automatic obsolete/updated patch checking
• Transfer patch to multiple servers
• Schedule single patch or patch group
• Group or Merge patches
• Manual steps (ADADMIN, sqlplus/shell scripts)
• Compile / list invalid objects (delta)
• Start/stop Oracle processes
• Email/pager notification
• And more

15
Implement Control the Change

• Approval Workflows
• Technical Approval
• Functional Approvals
• Automation

16
Approving Change

• Technical Approval
• Check adpatch logs
• Check invalid objects
• Functional Approval
• File system impact
• Database impact
• Customizations impact
• Final Approval
• Notifications

17
Workflow/Approval Process
18
Communicate Change

• Share Knowledge
• Automatic alerts and emails
• Administrator to Analyst
• Analyst to Administrator
• Error/Completion/Down Alerts
• Repository Access is Open

19
Reports and Queries

• Dozens of useful reports
• Environment comparisons,
• Patch detail, Patch Impact Analysis,
• Patches applied by date, by environment, by
  application, by person, etc.
• Find patchset levels,
• Find where patch was applied,
• Compare your patches against those released from
  Oracle,

20
Document Change

• One Repository for All Environments
• Document and Report
• All events
• All results
• All impacts
• Audit
• what has happened? where? by whom? when?
• point of reference,
• source for trouble-shooting
• Share knowledge

Everywhere
21
Value-Added Features

• Post-Impact Analysis Reporting
• - Impact on Customizations
• - Impact on Database Objects
• (tables, views, sequences, indexes)
• - Analyze Log Files
• - Summarize warnings, errors in log files
• Customizations
• - Track Customizations
• - Store Attachments in Repository
• - Alert if Customization Impacted
• - Customizations on File, DB Objects

22
(No Transcript)
23
Dashboard
24
Architecture Works with What You Have Today
Web Application Server
PRODUCTION
SQLNet
Web Browser
APM Database
DEVELOPMENT
Client PCs
TEST
25
IMPACTS ON THE ORGANIZATION
26
Best Practices Benefits

• People and Processes Managed
• Reduction in Errors and Rework
• Research is Easier
• Changes and Impacts are Known
• Save Time
• Documentation is Automatic
• Improved Service Levels

27
The Impact of Using Best Practices

• Technical Group
• Reduced workload through automation
• Reduced error through automation
• Reduced risk through impact analysis
• Complete, accessible audit trail
• Faster problem resolution
• System Uptime Improved!!

28
The Impact of Using Best Practices

• Functional Group
• Reduced, focused user testing
• Verify testing took place
• Access to information
• Faster support from Oracle
• Facilitated research

29
The Impact of Using Best Practices

• Organizational Effect
• Established procedures
• Decreased workload
• Communication, accountability between business
  groups
• Improved problem resolution
• Reduced costs
• Reduced risks

30