Wednesday Feb 11, 2015

Cross-Site Load Balancing - Prerequisites and Steps to Be Performed

Summary of the Prerequisites and Steps to Be Performed


Let’s consider the following configuration:

Site A: Primary is replicated by Active Data Guard to Site B: Secondary

Site B: Primary is replicated by Active Data Guard to Site A: Secondary

Let's assume that we have a pdb (MY_PDB) which runs on Site A: Primary. If, for example the workload is too high on Site A: Primary and a specific SLA can not be fulfilled, we can perform the following steps in order to move MY_PDB to Site B: Primary where the SLA can be met:

1. Stop MY_PDB on Site A: Primary and Site B: Secondary(Log files will continue to apply in MOUNT DB Mode)

2. Unplug MY_PDB from Site A: Primary

3. Copy XML manifest to the other site – Site B: Primary

4. Setup aliases on Site B: Primary and Site A: Secondary

5. Ensure media recovery (MRP) is running on the Site A: Secondary

6. Plugin MY_PDB on Site B: Primary

7. Check MY_PDB was replicated on Site A: Secondary

8. Open MY_PDB on Site B: Primary

9. Open MY_PDB (Read Only) on Site A: Secondary (if Active DG is running)

10. Drop MY_PDB on Site A: Primary (keep Datafiles)

These steps show that load balancing across sites is possible using a combination of Oracle Multitenant and Oracle Data Guard. When coupled with the flexibility offered by Oracle Real Application Clusters for local site management, it is an excellent example of the level agility and flexibility that enable a full-featured Database as a Service deployment.

Tuesday Jan 27, 2015

New whitepaper: Cross-Site Load Balancing: Data agility with Oracle Multitenant: A Proof of Concept

Just posted on the Private Database Cloud OTN page, a new white paper describes a configuration consisting of two separate sites running Oracle Database 12c, with data replication between the sites.  By leveraging Oracle Multitenant, the paper shows how moving a PDB from one site to the other enables a high degree of agility.  There are several scenarios where this agility can enable smoother IT operations, such as:

  • balance load across the two sites by moving competing PDBs away from each other
  • offload a site that needs maintenance
  • prepare for a burst of activity at one site by moving unassociated or lower-priority PDBs to the other site

Watch for more details and examples in upcoming blog postings.

Tuesday Dec 30, 2014

RHP Use Cases Series: Create a Gold Image from the Patched Working Copy

I. Preparation

Action 1: Check whether this is the right working copy, i.e., the patched Oracle Home (see Interim patches installed line). This working copy (my_wk1) will be used in further commands.

Action Description

Check done through Query workingcopy command

Executed on (Server / Client)

Either

Purpose

Check characteristics of my_wk1 to validate that it is the patched Oracle Home

Action 2: Find out how to use the import image command:

Action Description

Check import image command’s parameters (use -h option)

Executed on (Server / Client)

Either

Purpose

Find out how to use the import image command


II. Execution

Action: Create a gold image from the patched working copy

Action Description

Run the import image Command:

Executed on (Server / Client)

Either

Purpose

Creates a gold image:

- named my_patch_img

- from the patched working copy home …/wmy_wk1/swhome

- Create a new ACFS file system for my_patch_img

- Export file system for my_patch_img

- Copies files

- Copies home contents

- Changes home ownership

- Transfers data to 1 node

III. Results Validation

Action: Check characteristics of newly created gold image my_patch_img in order to validate that those characteristics (e.g. owner, access, path) are as expected (also the right patch name is applied).

Action Description

Validation done through Query image command

Executed on (Server / Client)

Either

Purpose

Check characteristics of newly created gold image my_patch_img in order to validate that those characteristics (e.g. owner, access, path) are as expected. In our case also to validate the right patch name is applied.



In addition to the four use cases we have presented, there are some others which can be considered, such as:

- Create a Working Copy from the Patched Image
- Switch an existing DB to the new Working Copy
- Mass Patch Apply
- Switch an unmanaged Home to a Working Copy


Stay tuned for more examples in 2015!

Monday Dec 08, 2014

RHP Use Cases Series: Switch an active database to a Patched Working Copy

Notes:

      - Prerequisite: The working copy has already been patched using oPatch

I. Preparation

Action 1: Preview the already patched Oracle Home (see Interim patches installed line). This working copy (my_wk1) will be used in further commands.

Action Description

Check done through Query workingcopy command

Executed on (Server / Client)

Either

Purpose

Check characteristics of my_wk1 to validate that it is the patched Oracle Home

Action 2: Confirm that our database (mydb) is a different working copy than the patched version above, namely, wrkghc2.

Action description

Check with Query workingcopy command

Executed on (Server / Client)

Either

Purpose

Confirm that mydb is referencing the non-patched working copy wrkghc2 (note that mydb is one of three databases using the unpatched working copy; later we will switch mydb to the patched home but leave the other two unchanged).

Action 3: [Optional] Check if DB is up and running

Action description

Use srvctl status command to check DB status

The RHP move database command is the same whether the DB is running or not (behind the scenes, if running, RHP will stop the instance in rolling fashion as the default)

Executed on (Server / Client)

Client

Purpose

Check on client whether DB is running

Action 4: Find out how to use move command:

Action Description

Check move command’s parameters (use -h option)

Executed on (Server / Client)

Either

Purpose

Find out how to use move command

II. Execution

Action: Switch DB from current home to the patched one:

Action Description

Execute move command

Executed on (Server / Client)

Either

Purpose

Switch the mydb DB from initial unpatched working copy (wrkghc2) to the patched working copy (my_wk1)

Several steps performed by the RHP command:

- Switch database from unpatched working copy (wrkghc2) to the patched one (my_wk1)

- Identify a patch is available for mydb to be applied

    -Apply the patch

Note the mention about patches applied. This is produced by the Datapatch command provided by Patch Team

III. Results Validation

Action 1: Check configuration information of mydb to validate that the DB is located in the patched home

Action Description

Validation done through srvctl config command

Executed on (Server / Client)

Client

Purpose

Check configuration information for the mydb DB in order to validate that the DB is located in the patched home

Action 2: Check status information of mydb to validate that the DB is up and running

Action Description

Validation done through srvctl status command

Executed on (Server / Client)

Client

Purpose

Check status information for the mydb DB in order to validate that the DB is up and running after the patch was applied. We want to avoid the risk that after the patch the DB does not properly work. If this happens we will take corrective actions.

Steps Comparison Table

If there are m Cluster environments, each Cluster with n databases, then in a pre-RHP approach we have to apply the patch, Cluster by Cluster, for each DB in the cluster.

Pre-RHP

RHP Provisioning

For each of the clusters:

One move command: per Cluster for all Databases in that Cluster

- Patch DB1

- Patch DB2

- Patch DBn

Wednesday Nov 19, 2014

RHP Use Cases Series: Provision a New Oracle Home plus DB Creation

I. Preparation

Action: Find out how to use add workingcopy command:

Action Description

Check add workingcopy command’s parameters (use -h option)

Executed on (Server / Client)

Either

Purpose

Find out how to use add workingcopy command


II. Execution

Action: Create a working copy, provision Oracle Home, create and start DB instance

Action Description

Run the add workingcopy command

Executed on (Server / Client)

Either

Purpose

Creates a working copy (Oracle Home)

- named my_wk1

- from the gold image 12c

- on the client rwsad0910

- for the user racusr

plus:

- database name

- ASM Diskgroup

- list of nodes on which database will be created

Then,

- Clone of my_wk working copy

- Setup Oracle Base

- Provision Oracle Home

plus:

- Create a two-node cluster

o Creating and starting Oracle instance

o Creating cluster database views

Continue…


Continue…

So far, similar to Use Case 1. But in addition, for this use case RHP also performs Database creation:

III. Results Validation

Action: Check characteristics of newly created my_wk to validate that all required parameters (e.g. client, gold image, user, owner, Oracle Home path, configured databases) are as expected

Action Description

Validation done through Query workingcopy command

Executed on (Server / Client)

Either.

Command results are the same no matter where it is launched

Purpose

Check characteristics of newly created my_wk1 to validate that all required parameters (e.g. client, gold image, user, owner, Oracle Home path, configured databases) are as expected

Steps Comparison Table

Pre-RHP

RHP Provisioning

Prepare installation media for each cluster

One command: add workingcopy per cluster

Log into every cluster to invoke OUI

Log into every node to run root.sh

Log into very node to invoke dbca (SW only)

Create an 2 nodes cluster Oracle Database:

- Creating and starting Oracle instance 1

- Creating and starting Oracle instance 2

- Install RAC

 That's all for the second use case.

Stay tuned for further use cases and connect with us through blog comments if you are interested in specific use cases !

Wednesday Nov 12, 2014

Compare and Contrast (and mix-n-match) Oracle's SPARC V12N choices

new white paper from Oracle's Elite Engineering Exchange team provides an excellent guide to the different virtualization technologies available on SPARC platforms, including guidance on when to employ each - either alone, or in combination with another technology.  PDoms, LDoms, and different flavors of Solaris Zones are evaluated in terms of

  • Security Isolation
  • Resource Isolation
  • Efficiency
  • Availability
  • Serviceability
  • Flexibility
  • Agility


Although the paper is not specific to database deployments, the key points apply to all workload tiers.  And while the discussion is on SPARC technologies, many points apply to all virtualization technologies.  For example, from our DBaaS perspective, the following quote from the paper couldn't say it better:

"When a traditional  monolithic virtualization approach is taken where machines are mapped one-to-one to virtual machines, there is no overall reduction in the operational complexity of the system, because there are still the same number of entities to be managed ... the aim should be to consolidate workloads, not simply to consolidate machines, because it is workload consolidation that will drive the operational efficiencies of the data center."

 This summary from the paper shows the full scope of the discussion - the paper looks at each of these rows in detail, and finishes with an evaluation of the combinations that make sense (and when they are indicated).  Great reading for anyone looking to consolidate workloads onto SPARC platforms.



Wednesday Nov 05, 2014

RHP Use Cases Series: Provision a New Oracle Home

New in Oracle Database 12.1.0.2., Rapid Home Provisioning (RHP) provides a standard solution for provisioning, patching and upgrading at the organizational level, in a unified manner, across all architectural layers of software infrastructure. RHP increases performance and improves efficiency in provisioning and managing templates of Oracle software, such as Oracle databases, on all nodes in a private cloud.

Rapid Home Provisioning allows the administrative tasks related to database software distribution to be performed in an automated and standardized manner, thus allowing key people in the organization to focus on innovative activities that bring the most value.

DBAs can use Rapid Home Provisioning in different use cases.  In the next several blog entries we'll explore some of these use cases.  Note that the list is not limited to those we will present.

For each of the Use Cases, the approach is structured as follows:

  • Preparation
  • Execution
  • Results Validation

Also, for each of the use cases we provide a comparison between the pre-RHP approach and the new approach using Rapid Home Provisioning.

For the commands in each of the above phases, the following structure is used:

Action Description

Describes the action performed

Executed on (Server / Client)

Describes where the command can be executed: Server, Client or Both

Purpose

Describes the purpose of the action/command

Assumption:

The use cases are all based on Oracle DB Software (Oracle DB Homes). In this case all working copies are synonymous with Oracle DB Homes.


I. Preparation

Action: Find out how to use add workingcopy command:

Action Description

Check add workingcopy command’s parameters (use -h option)

Executed on (Server / Client)

Either

Purpose

Find out how to use add workingcopy command



II. Execution

Action: Create a working copy and provision new Oracle Home

Action Description

Run the add workingcopy command

Executed on (Server / Client)

Either. This example is executed on the server, which connects to the client for some of the operations.

Purpose

Creates a working copy (Oracle Home)

- named my_wk1

- from the gold image 12c

- provisioned in Oracle Base path

- on the client rwsad0910

- for the user racusr

Sets up Oracle Base

Provisions Oracle Home


Continue…


III. Results Validation

Action: Check characteristics of newly created my_wk1 to validate that all required parameters (e.g. client, gold image, user, owner, Oracle Home path) are as expected

Action Description

Validation done through Query workingcopy command

Executed on (Server / Client)

Either.

Purpose

Check characteristics of newly created my_wk1 to validate that all required parameters (e.g. client, gold image, user, owner, Oracle Home path) are as expected


Steps Comparison Table

Pre-RHP

RHP Provisioning

Prepare installation media for each cluster

One command: add workingcopy per cluster

Log into every cluster to invoke OUI

Log into every node to run root.sh

Log into very node to invoke dbca (SW only)

Stay tuned for further use cases and connect with us through blog comments if you are interested in specific use cases !


Wednesday Oct 08, 2014

Blog: The Satisfaction Of Online Shopping -- For IT Services

Rex Wang, Vice President of Product Marketing at Oracle, posted a blog recently that explains how business service catalogs are poised to change they way consumers procure IT services.

The Satisfaction Of Online Shopping -- For IT Services

Providers take note: if you don't meet your consumers' changing expectations,  they will find a provider who does...

Tuesday Sep 30, 2014

Oracle Database Learning Steam Video - DBaaS Service Catalog

I recently had the good fortune to record a video on Service Catalogs for Oracle University's Oracle Database Learning Streams series. The video is roughly 30 minutes long and covers the basics of catalog and service definitions, and introduces our standardized service offerings for Oracle DBaaS in a private database cloud.

The video is one of many which you can view in its entirety simply by registering with Oracle University.

All the Database Streams videos are located here.

Wednesday Sep 10, 2014

A new guide to Database as a Service

A new two-part "workbook" is now available to guide your journey to delivering a private database cloud.  Insights from IDC, e-DBA, KPN and the State of Texas provide real-life counsel from seasoned experts at the forefront of the industry's shift to cloud.


Transforming Your IT Environment with a Database Cloud Delivering Database as a Service to Your Organization


Enjoy the read and if you have follow-up questions or comments, you know where to find me ...

Friday Sep 05, 2014

New whitepaper: Database as a Service Reaches New Heights of Efficiency

An IDC research vice president, senior Oracle product managers and a solution provider's technology director explain how Database as a Service Reaches New Heights of Efficiency by leveraging the latest technologies in Oracle Database 12c. 

Thursday Aug 28, 2014

Focus On Documents for DBaaS topics at Oracle OpenWorld 2014

The speaking sessions and hands-on-labs for this year's Oracle OpenWorld are now scheduled, and a good way to find the items you're interested in is to check the FODs that cover your areas of interest.  Two are especially relevant for Database as a Service in private clouds -

 Database as a Service

 and

EM 12c Private Cloud and Lifecycle Management

There is some overlap between the two lists since the topics converge at several private database cloud requirements.  But make sure to check both so you don't miss anything that can help you in your journey to cloud.


Wednesday Jul 23, 2014

Rapid Home Provisioning Simplifies Oracle Database Estate Management

Provisioning, patching and upgrading databases across an enterprise is often performed individually on each database in the estate.  As the estate grows, this becomes a time-consuming and error-prone activity. 

Rapid Home Provisioning, one of the many new features and improvements in the just-released 12.1.0.2 version of Oracle Database, addresses this problem by simplifying and streamlining database maintenance.  With RHP, you create a single standard Oracle home by applying a new patch level once. This reference home can then be used to rapidly deploy new databases and to easily update hundreds to thousands of existing databases with a single command, without the need to apply the patches to each.  Optimizations for networking and storage use make this a very fast and efficient solution.

Learn more in the Clusterware Administration and Deployment Guide and in the OOW 2014 speaking session.


Tuesday Jun 24, 2014

Database as a Service at Oracle OpenWorld 2014

It's almost that time again - to gather in San Francisco for Oracle OpenWorld, and there are many sessions which will be interesting to anyone working in the private cloud / database as a service space.    Here are just a handful of them - starting with the session I will present, and others from the team I'm part of --

Private Database Cloud: a Standardized Catalog for Delivering DBaaS

Database as a Service: Best Practices and Lessons Learned

Database as a Service: a Customer's Journey to the Cloud

Rapid Home Provisioning: Deploying and Updating Database Templates in a Cloud