Tuesday Aug 18, 2015

Building Bridges to the Hybrid Cloud

As their on-premises database clouds grow and mature, enterprises are exploring how to integrate these solutions with public clouds.  Oracle's public cloud has been adding new offerings which create diverse opportunities for exploiting hybrid cloud use cases.  

Learn more about what's new in this webcast series.

And if you aren't using Oracle's Database Cloud service, there's a great new way to get started: click Try It >  for a 30-day trial!


Saturday Aug 15, 2015

Upcoming Conference in CEE region - Architects' Club discussing Hybrid Cloud

The next session of the Architects' Club will take place 18 August in Bucharest, Romania, CEE Region. 

Hybrid Cloud is the topic of interest which will be under discussions with architects from partners and customers

Agenda and full details here.

The progressive adoption of public cloud offerings alongside on premises installations creates a sophisticated hybrid cloud environment which relies on integration for its effectiveness. During this workshop Hybrid Cloud approaches will be presented and discussed. You will have an opportunity to explore the following domains: Overview of Hybrid Cloud, Integration Cloud Service, Hybrid Cloud - Example Use Cases.

Friday May 01, 2015

New data sheet for Rapid Home Provisioning

If you're a busy DBA you might not have the time to read a detailed whitepaper about a feature that may or may not be important to you.  If that's why you haven't read the whitepaper covering the Oracle Database 12c feature Rapid Home Provisioning, then you'll be pleased to know we've posted a data sheet that will quickly take you through the key benefits and capabilities, and also provides architectural and operational highlights.

 From there, the white paper and online docs await.  Oh and we've also got several blog entries on common use cases.  Is it all worth your attention?  Check out the data sheet to see.


Tuesday Mar 31, 2015

Upcoming Conferences

IOUG COLLABORATE 15

This annual conference will take place April 12-16 in Las Vegas.  Full details here.

If you cannot attend in-person, join in virtually through Plug-in to Vegas

Either way, finish filing your taxes early so you don't miss the speaking session on one of my favorite topics - Service Catalogs for delivering Oracle Database as a Service.  The session is part of the Cloud Computing Track.  It is scheduled the morning of Wednesday April 15 from 10:45-11:45.


Oracle OpenWorld 2015

Speaking of conferences, it's hard to believe but it's already time to start thinking about OpenWorld.  Join us in The City by the Bay from October 25-28.  Watch for details on this year's On-Premises Database Cloud topics.  In the meantime, if you have any ideas on speaking topics, don't hesitate to submit your proposals before April 29th.


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