Transcript HCL-Database-Upgrade-Capabilities_V1-1

HCL’s Oracle Database Upgrade &
Migration Capabilities
Agenda
1
Oracle Database CoE – Methodologies
2
Oracle Database Experience Snapshot – Case Studies
3
Client testimonies for Database Upgrades & Migrations
2
DBA Center of Excellence
DB Architecture Group
Performance Engineering Group
 Data Architecture & Design
 Logical & Physical Model – ErWin
 Forward & Reverse engineering DB models –
Release Management
 Database migration
 Star and Snow Flake schema design for
DWH application design
 Dedicated DBA Team to optimize the application and
DB performance criteria
 High Availability (RAC) & DR Performance management
 Closely Interact with application developers in designing
for optimal performance
Security, Standards & Best Practices Support Group
Research & Innovation group




 Beta testing and assessment
 Advanced (Multi-Master) replication, High availability (RAC)
& DR (Data Guard)
 RCA, Incident & Problem management
 R & D for DBA Innovation
 Platform support research
Industry standard security best practices adherence
SOX Compliance
Industry & Customer specific standards compliance
Advanced Security & Audit
DBA CoE Highlights
 Streamlined Knowledge Transition Methodology and DBA Cross Training
on Database Products
 Advanced Certified Partner with Oracle
 Long Term Support (Onsite-Offshore Model)
 Quick Turnaround time for Issues
 85% of HCL DBAs are certified on Oracle 10g
 50% of HCL DBAs are hands-on with Oracle11g
3
Database Services
Services
DB/2
Oracle
Database
COE
SQL Server
Monitoring
Administration
Problem Management
Patch Management
Performance Tuning & Optimization
Consolidation/ Roll Out/ Migration
Sybase
Technical
Groups
Service Level Management
Consistent end-user satisfaction
Process based service delivery
Domain expertise
on top SLM
4
Reduced costs of operations
Continuous improvement
DBA Activities
Change the business (Implementations/ Upgrades)
 Installation, Configuration & Upgrade





Upgrade/ Migration Analysis
Preparing Installation/ Upgrade/ Migration Check-list
Capturing the issues faced during Installation, Configuration, Upgrade, Migration etc.,
Documenting the resolutions
Special configurations {Hardware Load balancing, Heterogeneous installation etc.,}
 Database Design and Configuration


Analyse short and long term database growth trends




Logical & Physical Design
Reverse & Forward Engineering
Redesign/ Consolidation
Capacity planning
Maximum Availability Architecture Implementation


Analysis of current architecture
Set up and manage different levels of Oracle database HA based on client's requirements including
 Standby Databases
 Oracle Data Guard
 Oracle Replication
 Oracle Advanced Queuing
 Oracle RAC
5
DBA Activities
Run the business (Support)
 Regular Database & Application Management
 Regular DBA Procedures
 Backup and Recovery (RMAN, hot backup, cold backup – Scheduled/on-demand etc.,)
 Application development Support
 Patch Application
 Cloning support instances
 Minor upgrades
 Change Control Management
 Pro-active Monitoring
 Resource utilization {Memory, CPU, Space etc.,}
 Collect statistics to pinpoint resource bottlenecks, monitor database and Application matrices
 Analyse short and long term database growth trends
 User access
 Creating and maintaining alerts for database and application monitoring attributes
 Troubleshooting & Tuning
 Incident Management
 Problem Management – Root Cause Analysis
 Periodic performance analysis & identification of tuning activities
 Database reorganizations and row re-sequencing for performance
 User Administration and Security Implementation
 Oracle advanced security options
 Application security management
6
Database Implementation Methodology
7
HCL’s Upgrade Methodology
Maintain
Optimize
Upgrade
Assess
Tune the Upgrade
Upgrade & Post-Upg tasks
Develop
Plan
Support
Pre-upgrade tasks and steps
Plan and prepare Roadmaps for Upgrade
Evaluate the value available in target release
8
Typical Upgrade Process Flow
Start the
process
Evaluate new
release
Upgrade
?
No
Make
adjustments
Stay put
Yes
Install new
release
No
Perform initial
upgrade pass
Test/ make
adjustments
Perform test
move to Prod.
Test
Acceptable
Yes
Go Live
Yes
Ready?
No
Make final
adjustments
9
Final Testing
Schedule cut
over date
Case Study 1 – Tier One Automotive Supplier in
North America and Europe
Project Background
HCL Role
Benefits
 Upgrade of Oracle
Datawarehouse Database &
ETL tool informatica
 HCL is providing L1 and L2
support from Offshore
 Client will benefit from the
advanced data compression
features of the Oracle 11g and
Increased performance in Daily
ETL Loads
 Oracle Database and informatica
runs on Solaris 5.9
 As part of IT road map of client the
upgrade was performed to
increase the performance of daily
ETL loads at the same time to
utilize the new features like
advance data compression in the
new 11g version
 HCL is responsible for maintaining
mission critical Application
databases for the customer
 Oracle Database upgrade from
release 9i (9.2.0.8) to 11g
Release 1 (11.1.0.7)
 Upgrade the entire application
(Informatica + Database) for
Datawarehouse Management
system
10
Case Study 2 – Leading Publishing Company
based out of UK
Project Background
HCL Role
Benefits
 Upgrade of Oracle Content
Management Applications
& sub system
 HCL is providing L1 and L2
support for Customer from
Onsite and Offshore
 Client will benefit the new
features of the Application
and more robust Integration
with their sub-systems
 Oracle CMS and Sub-Systems
runs on Solaris and Windows
 HCL is responsible for maintaining
mission critical Application
databases for the customer
 As part of IT road map of client the
upgrade was performed as
Designer repository was one of
the integrated sub system
 Oracle Database upgrade from
release 9i (9.2.0.4) to 11g Release
1 (11.1.0.7)
 Upgrade the entire application
(Application stack + Database)
for Content Management system
and their sub-system
11
Case Study 3 – A Live Events Company based
in California
Project Background
HCL Role
Benefits
 18 months old implementation of
E-Business Suite 11i
 Upgrading from 9.2.0.6 to 10.2.0.4
in a High Availability RAC
Architecture on RHAS 5.1
 This helped the Client move to
High Availability Architecture to
cater to the growing business
and the increasing number
of users
 Oracle Applications 11.5.10.2
running on 9.2.0.6 database
 Two node architecture with
database on one node and all
the application services on
another node
 Intended to be 9i RAC on OCFS
but 2nd RAC Node never worked
due to OCFS issues hence being
used as a single instance
 Oracle Database migration from
32-bit Linux server to new 64-bit
Linux server with 64-bit O/S
 Oracle Database upgrade from
release 9i (9.2.0.6) to 10g Release
2 (10.2.0.4)
 Converted 10g database
(10.2.0.4) from single-instance to
RAC (Real Application Clusters)
 Configured ASM on RAW devices
on EMC SAN
12
Case Study 4 – Largest Provider of
Conferencing Services in Europe
Database Upgrade
Challenges
Benefits
 Building the RAC Database
 The company’s globalization
project demanded a common
Business Intelligence system
across the globe which would
provide them a single storage
location of all their business data
with maximum performance
benefits and high availability
 Implemented a system with
a centralized repository,
hardware, and a common
interface for the client’s
business across the globe,
which resulted in further
reduction of their TCO
and maintenance
 The existing 9i RAC nodes were
serving only users based in UK
and was fast becoming outdated
as the business demanded more
advanced features
 The new enhanced features of
10g like Merge & Schedulers
were used to restructure the
application, which helped in
reducing the time of Data
Warehouse loads by 50%
and helped manage it
more efficiently
 TAF Configuration
 Deploying the Application to the
RAC environment
 TAF Testing, and
 Structured Testing & Tuning
 Migrated terabytes of data from
the 9i database to the new 10g
database RAC
 Added 6 Node Cluster for
performance
 Platforms migrated from AIX 4.3.3
to Linux 3.0 ES
 Platforms migrated from UK
DWHS 9i RAC to US Global
DWHS 10g RAC Rel 2
13
Case Study 5 – Leading Manufacturer of
Software & Storage for Info. Management
Infrastructure
Challenges
Benefits
 Oracle 11i Applications with 48
Applications Server and DB
Server maintain by HCL Onsite &
Offshore team
 Upgrade of Application
as well as database
 New Technology components
are configured like Hardware
Load Balancing, 48 Application
Nodes, Mobile Applications
Servers and Automatic
memory tuning
 DR server maintain in different
location and data synchronized
online by every 15 minutes
 24*7 Production Support and
Minimum production down time
for maintenance
 SUN OS
 Configuring 48 Application Nodes
with single Database
DBA Support
Achievements
 Maintain common instance for
application and other tools
 Completed the Database Upgrade
activity with in a scheduled period
 HCL DBA team spread with 6
Onsite DBA’s and 4 offshore DBA
 Patches applied on
Heterogeneous Network
 65 databases are maintained
by DBA team
 Hardware Load Balancer with
48 nodes were maintained
14
 Oracle Enterprise Manager
has been integrated with
OEBS sign on, through which
client can see all the patches
applied on the system and can
monitor Concurrent Manager
Activities etc.
 Shared Appltop Load Balance –
new Technology introduced
where it reduces drastically the
down time of Applications and
Improve the Performance
Case Study 6 – Leading Provider of Simulation
Software & Services
Infrastructure
Challenges
Benefits
 Oracle 11i Applications on Solaris
Servers. Application Support being
done HCL team
 Upgrade of following technology
stacks in single downtime window
 Developer 6i Patch set Upgrade
 Application Technology Group
Patch level change { 5 to 6}
 9.2.0.7 to 11.1.0.7 upgrade
 JInitiator to SUN JRE Migration
 JDK upgrade
 Shared Appl_top migration
 Critical patches update
 HR Family Pack upgrade
 Vertex Tax Engine Upgrade
 Shared Appl_top along with
Distributed Admin reduced the
down time of Applications
 Several Application Technology
Stack need to be upgraded
 Version of EBS to be maintained
@ 11.5.1.0.2
 Shared APPL_TOP also reduced
the over-all disk requirements
 Distributed AD enabled better
resource utilization
 Oracle’s recommended and
supported Level of RDBMS,
Java Plug-in with Oracle EBS
 Recommend patch-set level for
Critical Patch Updates
DBA Support
Achievements
 Regular Support and Maintenance
of Oracle EBS environments
 Completed the Database Upgrade
activity with in a scheduled period
 Technical Upgrades
 Regular Patching and Cloning
 Reduced patching window
because of shared Appl_top and
distributed processing
 Support for Enhancements
and Customizations
 Adherence to Oracle’s
recommended patch set level
15
Case Study 7 – A Lifestyle Merchandising
Company Operating Specialty Retail Stores
Infrastructure
Challenges
Benefits
 Client is currently using db2
and mssql to maintain their
enterprise information
 Testing of the upgrade required
lot of coordination effort
 Scalable and high available
environment for Production
instance because of
RAC Implementation
 The requirement was to migrate
data from db2 and mssql to Oracle
11g database
 The requirement was also to
implement 2-node RAC for new
Oracle 11g database
 Setting up RAC cluster
environment with Red Hat
Linux and porting database
into RAC environment
 Performance tuning of new
Oracle Database when
benchmarking from db2
could not be used directly
 Defining new administration
procedure for RAC Database
DBA Support
Achievements
 RAC Implementation
 Completed the Database Upgrade
activity with in a scheduled period
 Database Migration to 11g
 Performance tuning
 Post Production Support
16
 Greater business productivity
 Costs reduction as Oracle
Databases are created on
Linux Platform
 Customer is better placed to
plan and leverage the new
features of 11g.
Recommendations have been
given to the customer on same
Case Study 8 – Leading Automated Test
Equipment Manufacturer in Semi-Conductor
Infrastructure
Challenges
Benefits
 Client is currently using
150+ Oracle Databases and
50+ MSSql Databases to maintain
their enterprise information
 Datawarehouse Upgrade
 Complex Upstream and
Downstream applications.
 New DB Version integration
incompatibility in certain old
Legacy Upstream System
 Cannot afford longer downtime
 No Direct Upgrade Path to
8.1.x to 9.x
 Datawarehouse Applications
and Database are compatible
and in Supported Platform
 HCL is collaboratively running the
clients IT Division and DBA
services are part of this
Multi-Service Delivery
Engagement
 One of the requirement was
to upgrade their Enterprise
Datawarehouse Oracle Databases
from 8.1.6 to 9.2.0.8
 Another requirement was to
upgrade their Parts and Drawing
Application (SMARTEAM)
database from 9.x to 10.2.x with
Advanced 8 Site Multi-Master
Replication
 SMARTEAM
 All sites have to be
upgraded simultaneously
 Ensuring Multi-Master
Replication is intact after
Upgrade
Achievements
 DB Upgrade with Planned
minimum downtime, Multiple
DBA’s were engaged for multi
Database Upgrade
17
 Customer is better placed
to plan and leverage the
new features of upgraded
DB Versions
 Enabled Customer to save
on 3rd Party utility licenses
 Enabled better customer
satisfaction
Client Appreciations…
On Technical upgrade of EBS Environment…
“
Thank you for your hard work during the upgrade. Overall, the process went extremely well and is a result of your
dedication in both preparation and execution of this highly visible project…persistence and teamwork prevailed! I am
especially pleased with the success of working with a 'remote' team. We were able to coordinate a smooth continuous
schedule that contributed to achieving our goal without any major incident and ahead of schedule! Congratulations on a
job well done!
”
– Paula Hockster, IT Director {A leading provider of Simulation Software and related services.}
On Migration of EBS Environment…
“
The migration of our Conferencing Oracle Applications E-Business suite from a UK AIX/RS6000 infrastructure to a US
LINUX/Intel based infrastructure posed a significant number of managerial, technical and logistical challenges. The
three-man (HCL) Database Administration Team ably resolved all the challenges this major application migration posed
them. The team utilized their technical skills, experience and applied their own original approach to resolve each of the
challenges successfully and delivered the migration on time and on budget.
”
– Andrew Gray, Globalization Programme/ Project Manager, RLT Member
On RAC Implementation…
“
I wanted to send you a quick email to say a big THANK YOU for all the work that you have been doing not just this past
weekend, but throughout the globalization process. I really do appreciate the level of commitment and calibre that you
bring to the team.
– Global CIO
”
18
HCL’s Value Proposition
Checklist based
assessment
Point out overlooked issues deep within your database environments that may be causing poor
performance/ slowing down your operations.
Database administration is not restricted to Core Database infrastructure alone, but spans across
the application landscape as well, giving you a robust support framework.
Increased
Availability
Take advantage of our DBA maintenance services and decrease the chance of sudden failure.
Our team pro-actively monitors problem areas and fixes them before they can cause havoc due to
instance down times/ systems crash.
Regular MIS reports and Dashboard generated tracks; evaluation of application and database
performance and growth, with pro-active steps taken to mitigate risk and improve system up-time.
Flexibility
Application
Practice
Improved
Performance &
Risk Mgmt.
With requirements on DB management increasing by the day, HCL’s strong skill-base of experts
give you the flexibility to find the right resource with the right knowledge to augment your team
during project crunches.
19
Next Steps…
20