Oracle Database Adminstration, RAC Experts, Our RAC and GI Strategy

18 Years of Oracle Database Consulting Services

For Oracle Database Administration projects (e.g. installations, upgrades, patches, data guard implementations), SkillBuilders can dramatically reduce your time and cost to deployment. Either Remote DBA or on-site presence can be provided.

For defense against prolonged downtime and meeting SLA's, SkillBuilders provides 24x7x365 Support - or support tailored to your organization's needs and budget. This includes immediate response to automated database and system alerts - including Oracle Standard Edition using our proprietary alerts system.

Oracle Database Experts with Extensive Experience (See our Success Stories)

  • Oracle 12c
  • APEX Turnkey Solutions
    Let us Take Some of the Load
  • Oracle Internet Directory, SSO
  • RAC and Grid Infrastructure
  • ASM
  • Data Guard / Active Data Guard
  • Manual Failover Implementations for SE / SE1 Database
  • SQL and Database Performance Tuning
  • Database Installations, Upgrades and Patching
  • E-Business Suite Administration
  • Data Warehouse
  • Database Design
  • Partitioning
  • Resource Management
  • Database Security including Advanced Security Option
  • Licensing
  • Oracle Enterprise Manager, Grid Control and Database Control
  • Unix, Linux, Solaris, AIX, Windows
  • SQL and PL/SQL

24 x 7 Remote DBA Support

Immediate response to automatic database alerts (Standard Edition included using our proprietary alerts system),

twenty four hours a day, seven days a week.

Available for

  • 24 x 7 x 365 on-call support
  • Limited support, e.g. after hours and / or weekends
  • Support tailored to your organization's needs and budget

SkillBuilders in the Cloud

We saw the potential in cloud-based computing early on. In mid-2010, we ran our first classes using cloud-based servers for hands-on workshops, greatly reducing class setup time and cost for our customers.

In February, 2011, SkillBuilders migrated our web site - a ColdFusion web server backed with an Oracle SE database - to the cloud, and turned off the power in our data center.


Licensing

We are Oracle Database technicians (and masters to boot) who sell Oracle Database licenses. We are database experts. We listen; we take the time to understand your requirements, then we'll suggest a solution.

Often that solution is Standard Edition - saving our customers tens of thousands of dollars in licensing costs. SkillBuilders alerts and notifications system replaces the costly Enterprise Edition Diagnostics pack Event/Alert Notifications system.

Our skill at database and SQL tuning can make the EE Advisors unnecessary as well. Bottom line: We can often save you a ton of money.


App Development

We are experts in full life-cycle application development. The tools in our toolkit include:

  • SQL
  • PL/SQL
  • APEX - Learn more
  • ColdFusion
  • HTML
  • XML
  • JavaScript and jQuery
  • CSS
  • Linux
  • Solaris
  • Shell scripting
  • Java and Groovy & Grails
 

Contact us at (888) 803-5607 (01-401-783-6172 outside U.S.) or email us to see how we can help you.


Oracle RAC Consultants

John Watson, Oracle Certified Master and SkillBuilders Director of Oracle Database Services, has been working with clustered databases (Parallel Server) since version 7.

Our consulting team, led by John, can provide the following Oracle RAC-related services:

  • Oracle 11g RAC and Grid Infrastructure Strategy Review
    (Why Are You thinking about RAC? Fault Tolerance? Scalability? Performance?)
  • Oracle RAC Installations / Implementations
  • Performance Tuning
  • Automatic Storage Management (ASM) Disk Tuning and Configurations
  • Patching and Upgrades
  • Load and Scalability Testing
  • Transparent Application Failover, Implementation and Testing

 

Contact us at (888) 803-5607 (01-401-783-6172 outside U.S.) or email us to see how we can help you.

LINO comment: what to do with large video file 74MB?

Oracle 12g RAC and Grid Infrastructure Strategy Review

Before you plan your migration to 12c RAC and Grid Infrastructure, ensure that the implementation strategy decided upon is appropriate for your organization's present and future needs.

Oracle 12g Grid Infrastructure (Clusterware, Flex ASM and the ASM Cluster File System) combined with Real Application Clusters provide amazing scalability, stability and flexibility for Enterprise database management. However, it also introduces new concepts, complexities and a possible paradigm shift for an organizations DBA's and System/Storage Administrators.

This poses new questions. Grid Infrastructure is comprised of many components - which are best for your organizations current and future needs? Whereas in the past, the DBA and System Admin roles where clearly defined and delineated; how - and who - will manage storage for your Oracle databases?

SkillBuilders' Oracle Certified Master DBA John Watson will work with your management and key technical personnel to answer these questions.

Your organization's personnel will

  • Gain an appreciation of the major Grid Infrastructure facilities
  • Gain the knowledge required to make informed decisions regarding how Clusterware, ACFS, and RAC - and the key components of each - should be used. This will ensure that the implementation strategy decided upon is appropriate for present and future needs.
  • Help the organization decide how the separation of job roles (e.g. system administrator vs DBA) will best be handled in their organization given the new integrated architecture presented by Oracle Grid Infrastructure (i.e. Oracle Clusterware and ASM Cluster File System).
  • Help define the training requirements for Oracle Database Administrators and System and Storage Administrators.

The lectures and discussions will be technical and will assume knowledge of Oracle database and instance architecture. If available environments permit, possibly a few demos but generally chalk-and-talk.

Topics

  1. The SA (System Admin) domain and the DBA (DB Admin) domain
  2. Grid infrastructure includes facilities for managing IT components that traditionally have been within the SA domain: storage, networking, and clusterware. A decision needs to be made on whether responsibility for these components should lie with SA staff, DBA staff, or both.

  3. Which GI components should be implemented?
  4. Implementing the Grid Plug and Play functionality is potentially very useful, but not all sites choose to use it. A decision needs to be made early in the project on whether to implement GPnP. It would not be easy to change the decision later.

  5. Policy managed databases
  6. Policy management allows the clusterware to determine where instances should run, automating the distribution of resources across available nodes. Again, a decision needs to be made early on whether to implement this.

  7. The database listening architecture
  8. Whatever decisions are made in 1 through 3 above, the 12c (actually 11.2 and up) listener model is very different from earlier releases. An appreciation of this is necessary to inform the design of the cluster(s).

  9. Storage technologies
  10. Various technologies are usable as database storage, such as clustered file systems, SAN, NFS, and iSCSI. Grid Infrastructure can replace or work in harmony with facilities such as third party clustered files systems and file servers for non-database applications. There may be significant cost and functionality implications that need to be considered.

  11. High availability
  12. Oracle's HA architecture consists of one or more of RAC, Data Guard, ACFS, RMAN, Streams (and other products) working together. Network, SAN, and operating system technologies are also relevant. All of these need to be considered together when deciding how to meet whatever service levels are required.

Contact us at (888) 803-5607 (01-401-783-6172 outside U.S.) or email us to see how we can help you.

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×