Transcript HCL-Exadata-Services

Novartis - Executive
Summary
Proof of HCL & Novartis
HCL & Novartis
Exadata managed service
Exadata managed service
Concept
Oracle Life Sciences Hub on Exadata
1
Oracle Exadata managed service
HCL will help maximise the benefits of Novartis’s investment in Exadata with a complete end to end Exadata managed service
Exadata migration planning and Exadata best practice consultation
Understand the
existing platform
 Observe current
workload and record
database for replay and
real application testing
on Exadata
 Educate Novartis team
on Exadata features
 Use ASH and AWR to
observer baseline SQL
 Educate DBA and DMA
with top X database
segments and top Y SQL
statements
 Plan for desired
availability model HA or
MAA
Leverage the power
of Exadata now and
in the future
Configure Oracle
database to leverage
Exadata performance
 Identify Exadata features
which will provide best
performance
 Configure Exadata
platform, ready scripts to
assist migration and
ensure Exadata features
are leveraged
Migration planning
and execution
Post migration services
Continuous
improvement
Business As Usual
Support
 Recommend best
migration strategy. e.g
Datapump, ASM
redundancy or
Goldengate,
 Monitor workload and
visualise database objects
using HCL Workload
Discovery workbench and
visualisation tools
 Leverage skills in Exadata
Centre of Excellence after
migration. Adopt COE
best practices for BAU
 Utilise real application
testing to test scale-out
and scale-up
 Establish Exadata SQL
tuning team and profiling
e.g Method-R
performance toolkit
 Identify database
segments which may
need tuning once on
Exadata
 Baseline SQL statements
to ensure performance
improvements are
recognized post migration
 Observe database replay
behavior & tune specific
Exadata parameters
 Design scripts to modify
segments for partitioning
and implement the correct
compression
 Educate DBAs and
developers in Oracle’s
advanced SQL features
for Exadata and ensure
inefficient SQL statements
are eradicated from the
landscape
 Ensure maximum
availability architectures
are maintained
 Provide patching services
to guarantee Platinum
Support from Oracle
 Implementation of agile
data platforms to make
clones available for free
and without expensive
downtime. E.g Flex Clone
or Delphix appliance
HCL will guarantee Novartis get the best from your Exadata investment. Oracle Engineered Systems and
Exadata database machine are the best place to run Oracle database. HCL’s team of experts will help
you through all stages of this journey and help you leverage the best from your Exadata environment. We
will also help your understand how you can leverage private cloud initiatives, DBaaS, MWaaS, PaaS and
IaaS from Exadata, Supercluster and Exalogic when combined with OEM 12c Cloud Control
HCL has invested in it’s own Oracle DBAs and certified them on Oracle Engineered Systems. We have also
recruited the very best talent to ensure HCL provide a world class service and innovation to Novartis
2
HCL – Implementation Approach for Exadata
3
HCL - Oracle Exadata/Exalogic Services
Consulting
Services
• Feasibility study for
Datacenter and
Databases
consolidation
• Implementation
roadmap
• Fitment for OLTP , DW
and Mixed workloads
• Application and
Middleware
architecture for
Exalogic
• Architecture
Readiness Service
Installation and
Configuration
• Exadata Machine
Installation
• Storage Server
configuration
• Backup and Restore
setup using RMAN
• Exalogic
implementation
Service
• Elastic Cloud
configuration Service
• Oracle Volume
Manager
implementation and
configuration on
Exalogic
Migration/
Consolidation
Operational
services
• Database/Application
Consolidation
• Define Pre/Post
Migration process
• Database and ASM
Software Installation
and configuration
• Migrate DB2, MS
SQL, Teradata to
Exadata
• Application Migration
service from current
platform to Exalogic.
• Data migration service
• Application Go Live
support.
• Day to day Operation
for Exadata services
• Patch Management
for Exadata setup
• Monitoring Services &
Health check
• Go Live support
Service
• Post Go Live Exalogic
Support.
HCL - Exadata – Implementation Services – Task List
Installation
• Standard
installation of
Oracle Exadata
Database
Machines
• Hardware,
network
and
operating
system
functionality
validation
• Installation
documentat
ion
Configuration
• Configure
Exadata
Storage
Servers and
db compute
host nodes
• Install
licensed and
configure
database
servers
• Configure
shared
storage to
support
Oracle RAC
• Run
verification
tests and
document
configuration
and
maintenance
procedures
Ten Point
Acceptance Test
•Test on Exadata
Storage Server
Test on Exadata
Database Server
•Test on
Infiniband Switch
•Test on Cisco
Ethernet Switch
•Hardware Profile
Test
•Calibration Test
•Network
Topology Test various kinds of
connectivity
tests
•Power
Redundancy
Test
•Failover Test
•RAC capability
tests including
failover, load
balancing.
5
Exadata Ready
To Go
•Exadata 11g
Database Server
Pre-requisite
checks &
planning
•Exadata 11g
Database Server
Configure RAC
Instance to
Customer
Environment
•Exadata 11g
Database Server
Start-up Patches
•Default
Operating
Systems
Configuration
•Configure OS
software,
patches (for
Solaris & Linux
only)
•Run Exachk
Exadata Expansion
Node
•Exadata 11g
Database Server
Pre-requisite
checks &
planning
•Configure Single
Database to
Customer
Environment
•Start-up Patches
•Default
Operating
Systems
Configuration ,
Configure OS
software,
patches
•Acceptance
Testing &
Documentations
HCL - Exadata – Implementation Services – Task List
Installation
• Standard
installation of
Oracle Exadata
Database
Machines
• Hardware,
network
and
operating
system
functionality
validation
• Installation
documentat
ion
Configuration
• Configure
Exadata
Storage
Servers and
db compute
host nodes
• Install
licensed and
configure
database
servers
• Configure
shared
storage to
support
Oracle RAC
• Run
verification
tests and
document
configuration
and
maintenance
procedures
Ten Point
Acceptance Test
•Test on Exadata
Storage Server
Test on Exadata
Database Server
•Test on
Infiniband Switch
•Test on Cisco
Ethernet Switch
•Hardware Profile
Test
•Calibration Test
•Network
Topology Test various kinds of
connectivity
tests
•Power
Redundancy
Test
•Failover Test
•RAC capability
tests including
failover, load
balancing.
6
Exadata Ready
To Go
•Exadata 11g
Database Server
Pre-requisite
checks &
planning
•Exadata 11g
Database Server
Configure RAC
Instance to
Customer
Environment
•Exadata 11g
Database Server
Start-up Patches
•Default
Operating
Systems
Configuration
•Configure OS
software,
patches (for
Solaris & Linux
only)
•Run Exachk
Exadata Expansion
Node
•Exadata 11g
Database Server
Pre-requisite
checks &
planning
•Configure Single
Database to
Customer
Environment
•Start-up Patches
•Default
Operating
Systems
Configuration ,
Configure OS
software,
patches
•Acceptance
Testing &
Documentations
Role to manage Exadata - DMA Role
DMA Role
Apps DBA OS
Customer
TASK
/DBA
SYSADMIN NETWORK STORAGE /Oracle
Day-to-day Operation
R/A
C
Testing
R/A
C/I
Monitoring
R/A
C/I
Configuration Management
R/A
C
C/I
Tuning
R/A
C
C/I
Patching
R/A
Patching
Storage Cells
R/A
C/I
InfiniBand
R/A
C/I
C/I
Cisco Public Network
R/A
C
C/I
Db Compute Nodes OS
R/A
C/I
Database
R/A
C/I
Backing Up Data
R/A
C/I
Upgrading SW
R/A
C/I
Replacing HW
R/A
C/I
Metering and Charging
R/A
C/I
Resource Roadmap (Exadata)
Total Number
Certified
Expected Cetified
Resoure Split
FY14 – FY15
75+
10+
JFM- FY’ 15
10+
75% - L3
25% - L2
TRAINED
15
CERTIFIED
3
TRAINED
15
CERTIFIED
5
JAS FY’14
OND – FY’14
TRAINED
CERTIFIED
3
TRAINED
5
CERTIFIED
5
0
AMJ- FY ’14
JFM- FY ‘14
TRAINED
6
CERTIFIED
0
HCL Value Adds
•
•
•
•
•
•
•
•
Feasibility study, roadmap and planning.
Simplification of Implementation and Migration Process.
Post Database migration, taking performance scalability of Database/Application to
next level through code, business logic optimization, etc.
Storage optimization.
Post migration, optimization of Exadata nodes (Databases, Cells, Flashcache etc.)
configurations according to Organization data behavior like OLTP, DW or MIX LOAD.
Maximum Availability Architecture (MAA) implementation using best practices and
according to organization norms with optimal resource utilization.
Strong Monitoring & Alerts deployment on Exadata Architecture using Oracle
Enterprise Manager Grid Control, ASR, Exadata Utilities and Custom scripts to avoid
severity and downtime proactively.
Gradual consolidation for future scalability.
Delivery - Resource Alignment
Practice
Delivery
COE
Transition – Resource 1
Transition
Lead/SLM
Transition Resource 2
Domain Resource1
SDM
Steady State
Team Lead Exa
Domain Resource 2
Project Resource 1
Transformation Lead
Project Resource 2
Sample Profile 1 :- L3
Required Skills: Individual should have good Database administration skills , Linux expertise, as well as Volume Manager, Oracle RAC, ASM, and
networking skills. They should be well versed in SAN topology and have previous experience with all aspects of designing/implementing
Exadata solutions. The person must have strong verbal and written communication skills as they will need to produce
processes/procedures for IT team that can be easily followed.
Responsibilities include but are not limited to the following:









Software and firmware maintenance of the Database servers in the Database machine including upgrades and patching
Software and firmware maintenance of the Exadata storage servers in the Database machine including upgrades and patching
Software and firmware maintenance of the InfiniBand switches in the Database machine including upgrades and patching
Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions
Provide and implement performance and tuning recommendations of all components in the Database machines
Advise, provide guidance and develop Disaster Recovery strategies for these Database machines
Configure the machines to meet internal security requirements
Provide business as usual data structure manipulation (add, remove, modify storage) in the Database machine
Analyze and determine the feasibility of leveraging the Oracle Enterprise Manager solution to report on performance, provide metrics,
and become the centralized proactive maintenance solution for Exadata distributions
 Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Database
machines.
 Expertise in Performance Tuning - IO,CPU & database codes(sqls).
 Exadata support Certification will be an added advantage
Additional requirements:





8+ years of Technical/Business Consulting experience.
Strong client relationship skills
Strong written and verbal communication skills with technical and non-technical personnel
Working with Global teams across the continents
Flexibility for relocation and willingness to travel
11
Sample Profile 2 :- L2
Required Skills: 














The candidates should have hands on experience in production environment and most of the following skills:
Exposure to Oracle Engineered (Exadata) Systems
Maintenance of Oracle Exadata machines
Migration of databases to Exadata.
Good understanding of Exadata features like smart scans, HCC, flash cache, Infiniband, ILOM.
In depth knowledge of ASM architecture
In depth knowledge of RAC architecture
Thorough understanding of the Oracle database features (backup and recovery, user management etc. and other generic DBA
functions).
Oracle RDBMS installation, configuration and maintenance activities
Understanding of Oracle's Maximum Availability Architecture (MAA)
Good understanding of Oracle Support Services mechanism
Good knowledge on UNIX, Linux
Good hardware debugging skills
Good understanding of networking concepts
Exposure to Golden gate, data vault etc. will be an added advantage
Additional requirements:





5+ years’ experience in administrator of Production Databases ,RAC and Data Guard environment.
Strong written and verbal communication skills.
Working with Global teams across the continents
Flexibility for supporting 24*7 environment.
Flexibility for relocation and willingness to travel.
12
Database Consolidation/Migration Using
Exadata
Why Consolidation/Migration ?
•
Shrink data center costs
•
Increase system utilization
•
Promote Application integration.
Exadata Migration Approach
Sun RISC
·
·
·
·
Planning and Analysis
Environment Understanding
Validate Source and Target Version
Develop Migration / Back out plan
Explore Migration method
QA
Prod
IBM AIX
·
·
·
·
·
Migration Methods
RMAN Conversion
Data Pump
Transportable Tablespace
Transportable Tablespaces with incremental backup
Golden Gate
HP Unix
Migration
Legacy
systems
· Preparing Source & Exadata
Environment
· Migrate Databases
· Functional & load testing
· Release environment
· Post-Migration Support
Remote
DR
Dev
Test
Local
DR
Exa
Systems
AN
W
Consolidation/Migration Challenges & Solution
Consolidation/ Migrations Options & Best Strategy
Case Study
Exadata Case Study -1
Europian Customer
Scope -
Migration to Oracle Exadata from Non-Exadata
Server & Operation Support
• Challenges
• Current Performance Issues
• Current Hardware Support Issues
• Migration to Exadata
• Test Cases After Migration to Exadata Qtr.
Rack & Performance comparison
Inventory :
Non Exadata –
HP Rx8640 database server with 12 Intel
Itanium CPU cores and 64 GB of RAM
1,2 TB of storage space assigned to MIS database
Inventory •
•
1 Qtr. Rack - Dev/Test
1 Qtr. Rack – Prod.
Migration Approach •
•
•
•
Entire database was transferred to Exadata server.
Workflow components were transferred to interim test server and tested
Mappings were transferred to Exadata.
Several long-running mappings were executed on Exadata and execution times were
captured.
Daily Operational Tasks
•
Along with Database Administration (DBA Role) …
•
Administration of Resource Manager (IORM,DBRM) to ensure Quality of Service
•
Monitoring and Performing Health Checks of the Exadata infrastructure
•
Exadata Bugs and operation issues Fix
•
Firmware and image patching of compute and CELL servers (scheduled)
•
Administration of Operating system accounts on Exadata infrastructure
•
Administer Exadata Database-scoped Security
•
Exadata local and remote DR administration
Exadata Case study - 2
Non-Exadata Servers
Below Database have been planned to migrate to Exadata
Australian Government
Inventory
Four X3-2 Exadata Half Rack
Database appliances
Database Versions
Number of Database
Installations
Oracle8i Database Server
31
Oracle9i Database server
115
Oracle 10g Database Server
151
Oracle 11g Database Server
82
Scope •
•
•
•
Migration to Oracle Exadata from Oracle Legacy databases & Operation support
Oracle Database upgrade from de-supported version
Migration to Oracle Exadata Machine
To support Council’s database strategy to Consolidate, consistent, Scalable and
highly available solution
Daily Operational Tasks
•
Along with Database Administration (DBA Role) …
•
Exadata Bugs and operation issues Fix
•
Exadata local and remote DR administration
•
Monitoring and Performing Health Checks of the Exadata infrastructure
•
Administration of Resource Manager (IORM,DBRM) to ensure Quality of Service
•
Firmware and image patching of compute and CELL servers (scheduled)
•
Administration of Operating system accounts on Exadata infrastructure
HCL Technologies- Snapshot
HCL Technologies
Product Engineering & R&D, Enterprise
& Custom Applications, Enterprise
Transformation Services, Infrastructure
Management & BPO Services
Global Market Focus
Financials
HCL Infosystems
Total Revenues - $ 6.4 Bn
EBITDA
- $ 1070 Mn
Employees
- 96,000
ICT System Integration Solutions,
Products & Services, Hardware
Solutions, Homeland Security,
Education and Learning & ICT
Distribution
India & Emerging Market Focus
Enterprise Revenue Growth
USD 6368 Mn
India Presence - Offices in 170 cities,
505 points of presence reaching 4,000
towns
Global Presence - Operations
spanning 31 countries
Delivery Facilities - USA, UK,
Finland, Poland, Puerto Rico, Brazil,
China, Malaysia, Singapore,
Australia, Czech and India
Global Presence - Operations in
Emerging Markets including South Asia,
Middle East & Africa
USD 455 Mn
2000
2013
Year
Distribution Network - 93,000 outlets in
over 9,000 towns
Questions
For any query please connect to - [email protected]