In an age where businesses run 24x7, 365 days a year, if critical applications, servers, or databases become unavailable, your entire business might be jeopardized. Lost revenue, dissatisfied customers, penalties, and negative press will have a lasting effect on your organization's reputation. You need to protect against failures - computer failures as well as data and disaster failures.

This is where Oracle's idea of the GRID comes in - encompassing Oracle Real Application Clusters (RAC) for redundancy, Oracle Data Guard for disaster recovery, Oracle Enterprise Manager (Grid Control) for Database and Server Provisioning, Configuration Management to capture all changes at server or database level, and the Diagnostic and Tuning packs for performance management of both databases and application servers.

Join us once a month on Fridays for 2½hrs from 24 July to 20 November at our series of Oracle workshops to see how you can leverage the concept of the Oracle GRID and prevent failures and downtime from happening, so that you can focus on delivering the services that your business really needs for success.

Learn how Oracle Real Application Clusters, Data Guard and Enterprise Manager can facilitate the effective use of your database and server infrastructure to help you lower your costs through:

• Outstanding reliability - Multiple commodity servers ensure
  affordable availability and eliminate downtime costs

• Simple on-demand scalability - Need more capacity?
  Just add another commodity server to your cluster

• 24/7 availability - Provide continuous uptime for
  database applications

• Lower computing costs - Use low-cost commodity
  hardware and reduce cost of downtime


The complimentary workshops are conducted by Porus Homi Havewala, the first Oracle ACE Director in Singapore and the author of several technical articles on Grid Control in the Oracle Technology Network (OTN).
 

Who should attend

DBAs
Understand how RAC and Active Dataguard along with Enterprise Manager can assist in redundancy, disaster recovery, performance management, database and server provisioning, and next-generation patching, configuration management & much more.

IT Managers
Understand how DBA productivity can be increased, how SLAs can be met, how you can become overseers of the corporate system, generate security compliance reports, use application level performance dashboards, find the database versions in use, licencing aspects, and analyse the proper use / wastage of expensive storage space.

About the Presenter

Porus Homi Havewala is a Principal Consultant in S & I with extensive experience in Oracle technology since 1994, including as a Senior Production DBA, Senior Database Consultant, Database Architect, E-Business Technical DBA, Development DBA, and Database Designer Modeller. He has worked in Oracle India and is an enthusiast for Oracle technology, especially Grid Control and RMAN, on which he has conducted seminars for large MNCs and implemented powerful enterprise tools.

Porus has also worked with the first production Grid Control site in the world, Telstra in Australia. He has published technical articles on Grid Control and RMAN on the Oracle Technology Network (OTN), and created the world's first blog dedicated to Grid Control, showcasing podcasts exclusively based on this technology. He was awarded the prestigious “Oracle ACE Director” title by Oracle USA in 2008. There are less than 80 ACE Directors in the world and Porus is the first ACE Director in Singapore – a recognition of his outstanding achievements in the Oracle world.

24 July 2009, Friday
Time: 2.30pm – 5pm
What are REAL APPLICATION CLUSTERS (RAC) all about?
 
14 August 2009, Friday
Time: 2.30pm – 5pm
Oracle ACTIVE DATAGUARD 11g - the NEW DR OPTION
   
•
Oracle's concept of the GRID
   


Storage Grids using Automatic Storage Management (ASM)
   
Server Grids using Real Application Cluster (RAC)
 
•
Difference between RAC & HA (High Availability)
 
•
Scalability advantages of RAC
 
•

Hardware setup - considerations and requirements
for RAC nodes

   
•
Common production issues in RAC
   
 
   
•
Disaster Recovery and Replication Options:
   
Dataguard: Physical or Logical Standby
   
Active Dataguard (New in 11g)
   
Rolling Upgrades using SQL Apply in Dataguard
   
Differences between all options:
  • Dataguard, Streams and Replication
    - Highlights of differences
    - Under what type of circumstance which solution works best
    - Setup requirement and considerations
   
11 September 2009, Friday
Time: 2.30pm – 5pm
Enterprise Manager Provisioning Pack - CLONE and PATCH databases
 
20 November 2009, Friday
Time: 2.30pm – 5pm
Enterprise Manager Diagnostic and Tuning Packs - Performance Management
   
•

NEXT-GENERATION Database Provisioning and Patching using Grid Control

 
•
Critical patch advisory for databases on Grid Control
 
•
Overview of Deployment Procedures using Grid Control
 
•
Connect to Metalink & find a patch, download to staging area on OMS server
 
•
After testing, deploy patch on multiple databases in an automated "lights-out" operation
   
 
   
•
Easily diagnose and tune performance issues on database and application server
 
•
Drill down to specific performance issues & top events
 
•
Generate stress load on the database using Swingbench & demonstrate ADDM capabilities
 
•
Demonstrate Advisor Central capabilities eg. SQL Tuning Advisor, SQL tuning sets

About S & I Systems
S & I Systems Pte Ltd is a premier IT solution provider of enterprise infrastructure, business solutions & integration services that deliver the best value IT solutions that help improve our clients’ business performance.

Established in 1998 and headquartered in Singapore, S & I has over 160 employees within Asia Pacific, with presence in China, Malaysia and Thailand.

Working together with leading technology vendors and solution partners, S & I provides infrastructure and business solutions to a customer base of over 1000 spanning a broad spectrum of industries across Asia Pacific. For more information, visit http://www.si-asia.com/

Organiser

In Conjunction with