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

1. 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

2. 1 2 3 4 Our Proposed Solutions The Service Objective eNCASS Packages eNCASS In Action Contents

3. 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.

4. 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.

5. 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

6. 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.

7. 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

8. 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.

9. dbAuditTM Features and scope (cont.) • Database best practice and features by version. • Default configuration is disable or require detail analysis.

10. dbAuditTM When ? 1st Milestone Last Milestone 2nd Milestone 3rd Milestone Awarded PIP Sign Off Meeting dbAuditTM Activities End of the Support Period

11. dbAuditTM Duration and Deliverables • 1 – 2 days for execution

12. 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.

13. dbInspectTM Scope: • Review space allocation • Performance Analysis • Network Analysis • General OS house keeping • Ensure scheduled backup is in place • Review database object and structure

14. 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

15. dbInspectTM Duration and Deliverables • 1 – 2 days for execution

16. 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.

17. 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

18. 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

19. 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

20. 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

21. 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

22. 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

23. dbProTM Duration and Deliverables • Depending on service

24. dbHelpTM Multiple channel for problem and issue reporting.

25. 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

26. Support Flow Customer dbAssist Escalate to Engineer On-Site Engineer dbAssist

27. 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.

28. eNCASS In Action

29. Past Experience On RAC Implementation

30. Thank You !