ENCoral Advanced Support Services (eNCASS)
This presentation is the property of its rightful owner.
Sponsored Links
1 / 30

No. 9 Jalan Tasik Selatan 3, 57100 Kuala Lumpur, Malaysia Tel : +60-3-9058 8000. nc.my PowerPoint PPT Presentation


  • 47 Views
  • Uploaded on
  • Presentation posted in: General

eNCoral Advanced Support Services (eNCASS) Your Oracle Consulting & Implementation Partner. No. 9 Jalan Tasik Selatan 3, 57100 Kuala Lumpur, Malaysia Tel : +60-3-9058 8000. www.nc.com.my. 1. 2. 3. 4. Our Proposed Solutions. The Service Objective. eNCASS Packages. eNCASS In Action.

Download Presentation

No. 9 Jalan Tasik Selatan 3, 57100 Kuala Lumpur, Malaysia Tel : +60-3-9058 8000. nc.my

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

eNCoral Advanced Support Services (eNCASS)

Your Oracle Consulting & Implementation Partner

No. 9 Jalan Tasik Selatan 3,

57100 Kuala Lumpur, Malaysia

Tel : +60-3-9058 8000.

www.nc.com.my


Contents

1

2

3

4

Our Proposed Solutions

The Service Objective

eNCASS Packages

eNCASS In Action

Contents


Our proposed solutions

Our Proposed Solutions

eNCoral Advanced Support Services (eNCASSTM)

  • eNCASSTM, gives you the freedom to focus on your core business by letting eNCoral manage your Oracle database environment. By leveraging eNCoral’s industry leading experience with Oracle database along with cost effective support, the service gives the results you expect: Oracle databases that are up and running faster, cheaper and more efficient.


Our proposed solutions1

Our Proposed Solutions

  • Key Features

  • To carry out best and proven methodologies of CUSTOMER’s database in the dbAuditTM package.

  • The dbAssistTM is your Oracle On-Site and Remote DBA. We monitor and tune all of your Oracle database environments, proactively respond to down situations, ensure backup and recovery capability, and offer a variety of service levels.

  • Real-time solutions through 24 x 7 dbHelpTM technical expertise.

  • Your Oracle environment will go through complete diagnosing procedure by our preventive maintenance (dbInspectTM) package quarterly.

  • The highly qualified, certified, and hands-on Oracle DBAs through dbProTM package help you reduce time to complete a complex database tasks.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

The Service Objective

  • The service’s objectives are :-

  • To provide 1 year coverage of eNCASS standard package, which consist of the following service components from eNCoral:

    • dbAuditTM

    • dbAssistTM

    • dbInspectTM

    • dbProTM

    • dbHelpTM


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAuditTM

  • Overview

  • Study and analyze existing database configuration.

  • Provide short-term and long-term recommendations.

  • Recommendation not only for best practice approach but also specifically designed for your environment and requirement.

  • Provide specific service based on release features – 9i, 10g, 11g

  • No changes will be made to current configuration.

  • No house keeping task will be performed.

  • Present findings and recommendation along with report.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAuditTM

Benefits:

  • Initial Oracle configuration review

  • You will get to know your database well

  • Know the database features/potential and fully utilize it

  • Highlight potential problem before it happen

  • Know database best practice for your environment

  • Assist in future planning – capacity planning, purchasing new hardware

  • Improves database performance

  • Improve database security and audit trail


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAuditTM

Features and scope :

  • Operating system installation structure.

  • Binary location

  • Trace file location

  • Log file

  • General database configuration.

  • Data file

  • Control file

  • Redo log file

  • Database parameter file

  • Review backup policy and implementation

  • Database performance

  • AWR

  • ADDM

  • OS tools

  • Database security

  • Oracle binary owner password.

  • Database user password, roles and privilege.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAuditTM

Features and scope (cont.)

  • Database best practice and features by version.

  • Default configuration is disable or require detail analysis.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAuditTM

When ?

1st

Milestone

Last

Milestone

2nd

Milestone

3rd

Milestone

Awarded

PIP Sign Off

Meeting

dbAuditTM

Activities

End of the

Support

Period


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAuditTM

Duration and Deliverables

  • 1 – 2 days for execution


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbInspectTM

Overview:

  • Perform database health check.

  • Periodic /quarterly database preventive maintenance.

  • No changes for current database configuration, backup policy procedure and no backup set restoration test.

    Benefits :

  • Periodically dedicated DBA check and verify database health and condition.

  • Provide database growth information – useful for capacity planning

  • Able to avoid critical error before it happen

  • Maintain database performance and availability through continuous preventive maintenance.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbInspectTM

Scope:

  • Review space allocation

  • Performance Analysis

  • Network Analysis

  • General OS house keeping

  • Ensure scheduled backup is in place

  • Review database object and structure


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbInspectTM

When ?

1st

Milestone

Last

Milestone

2nd

Milestone

3rd

Milestone

1st

dbInspectTM

2nd

dbInspectTM

3rd

dbInspectTM

4th

dbInspectTM

dbAssistTMService-on-demand

Awarded

PIP Sign Off

Meeting

dbAuditTM

End of the

Support Period

1Year


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbInspectTM

Duration and Deliverables

  • 1 – 2 days for execution


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAssistTM

  • Overview:

  • Premium database service to compliment with dbAuditTMor dbInspectTM.

  • Mode of service:

    • Service on demand

  • Cover most of critical and complex database job.

  • Benefits:

  • Corrective Maintenance

  • 24x7 Oracle database emergency support 

  • On-Site and Remote DBA support

  • Reporting and resolving all serious Oracle errors such as database crash and performance issue.

  • Quick response emergency support for production database outages.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAssistTM

  • Scope:

  • Corrective maintenance

  • To provide non-operation Database Administrator (DBA) responsibility.

  • Performance tuning

  • Backup planning and recovery

  • DBA service upon request

  • During special event – e.g. Student registration


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAssistTM

  • Within Scope:

  • eNCoral defined non-operation DBA responsibility :-

  • Installing and upgrading the Oracle Server.

    • Note: Excluding convert database from single to Real Application Cluster

  • Allocating system storage and planning future storage requirements for the database system.

  • Creating primary storage structure as requested by customer

  • Creating primary object as requested by customer

  • Modify the database structure as requested by customer

  • Enrolling users and maintaining system security

  • Monitoring and optimizing the performance

  • Planning for backup and recovery of database information


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAssistTM

Out Of Scope:

eNCoral defined operation DBA responsibility :-

Controlling and monitoring user access to the database

Ensuring compliance with customer’s Oracle license agreement

Maintaining archived data on tape

Backing up the database

OS House keeping


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbAssistTM

When ?

1st

Milestone

Last

Milestone

2nd

Milestone

3rd

Milestone

dbAssistTMService-on-demand

Awarded

PIP Sign Off

Meeting

dbAuditTM

End of the

Support Period

1Year


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbProTM

  • Overview:

  • Specifically designed for you to choose individual service.

  • Fixed and one time service only.

  • Charges is based on time and material.

  • Mode of services:

    • Service-on-demand


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbProTM

  • Scope of Service

    • To provide eNCoral defined Professional Services such as:

    • Data Guard implementation

    • DBVault implementation

    • Backup Policy Audit

    • Database Troubleshooting

    • RAC implementation

    • Database Performance Tuning

    • Any service related to Oracle database


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbProTM

Duration and Deliverables

  • Depending on service


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

dbHelpTM

Multiple channel for problem and issue reporting.


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

Helpdesk Access Hotline

Service Request through

multiple Channels

By Customer team

Email / Web

Phone

Support Center Agents

Helpdesk Agents

Engineer

Log into our Helpdesk Systems or

being notified by our

HelpDesk Agents

Engineer Routing


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

Support Flow

Customer

dbAssist

Escalate to

Engineer

On-Site Engineer

dbAssist


Past experience

Past Experience

  • JUPeM eKadaster Project, sub-partner of Precision Portal Sdn Bhd (Main Contractor)

    • To carry out best and proven methodologies of JUPeM’s Oracle 10g database setup and configuration.

    • These activities include all 14 Jabatan Ukur dan Pemetaan Malaysia, nationwide.

    • Deploy 3 groups of engineer to perform the task simultaneously.

  • Kementerian Pelajaran Malaysia – Servers and Database upgrade

    • To carry out best and proven methodologies of MOE’s database migration in the StarterPackTM package.

    • These activities include 14 Jabatan Pendidikan Negeri nation wide.

    • Deploy 3 groups of engineer to perform the task simultaneously.


Encass in action

eNCASS In Action


Past experience on rac implementation

Past Experience On RAC Implementation


No 9 jalan tasik selatan 3 57100 kuala lumpur malaysia tel 60 3 9058 8000 nc my

Thank You !


  • Login