Friday Aug 21, 2015

Make Your Nominations: Oracle Database Developer Choice Awards

I Did.  You Should. Here's the Nomination Form.  Here's Why:

The Oracle Database Developer Choice Awards celebrate and recognize technical expertise and contributions in the Oracle Database community. We all have an expert in our lives. Here's your chance to nominate them for an award. Who is that expert? Sometimes we're inspired by a technical presentation at an Oracle User Group event or SIG; but more often it's that person who is on the discussion space with an answer or suggestion just when you need it. Either way, it's easier to develop great solutions when we "know" someone in our community...and they are is rooting for us, and even helping us along.

Here's my nomination:  John Stegeman.  And he will be embarrassed and might send me a howler for nominating him. 

John Stegeman is a regular in the Oracle Database Community. When he's not answering questions in the Oracle Database General Questions space, he's commenting on social discussions around the Watercooler. He's a Grand Titan with 243,225 points on the Oracle Community platform and an Oracle ACE. He might not be digging in coding an app, but he's clearly got SQL chops. And, while he may not realize it, he's been a tremendous help to me as a community manager because his activities help me keep a pulse on what's going on in the community :)

Who are you going to Nominate?  Get your nominations in about NOW?  

Ciao for now,


Monday Jun 01, 2015

NEWS: Oracle Database Migration Assistant for Unicode 2.1

Oracle has released the Database Migration Assistant for Unicode (DMU) 2.1.

Here's what you need to know:

DMU provides an end-to-end solution for migrating your databases from legacy encodings to Unicode. Its user-interface greatly simplifies the migration process and lessens the need for character set migration expertise by guiding the DBA through the entire migration process as well as automating many of the migration tasks. Oracle DMU is the officially supported method for migrating Oracle 12c Pluggable Databases (PDBs) to the Unicode character set. Oracle DMU also supports migrating selected prior releases of Oracle Database 10.2, 11.1 and 11.2.

NOTE: The DMU repository schema has been updated in release 2.1. If you have an old repository installed with the 2.0 release, you will need to upgrade the repository using DMU 2.1 before you can perform any migration tasks with the DMU 2.1 software.


Here's what's interesting:  Migration to the Unicode character set is an intricate process that involves many time-consuming and resource intensive operations. Any misstep along the way can lead to data loss. Oracle DMU provides an end-to-end workflow that guides the DBA through a detailed and customizable migration process with real-time progress updates. Additional recovery and diagnostic mechanisms enable a fault-tolerant migration in the event of runtime contingencies.

New features in Oracle DMU 2.1 include:

  • DMU 2.1 offers a solution to achieve a near-zero downtime migration to Unicode by leveraging the DMU migration functionality in conjunction with the Oracle GoldenGate replication technology.
  • A DMU migration profile can be exported from one database instance and imported into another database instance created as a clone of the original instance.
  • Problem Data Report feature has been introduced to allow the detailed information about the data in the database objects containing convertibility issues to be generated into a spreadsheet file.
  • DMU 2.1 can detect and upgrade any existing DMU 2.0 repository in the database to the DMU 2.1 format and preserve the migration information so that the upgrade process is mostly transparent to the user without having to re-install the repository again.

Anything else you need to know about Oracle DMU 2.1?  Go to the Oracle DMU page on OTN

Ciao for now!


Tuesday May 19, 2015

Deploying a Database Cloud--And the Value of DBaaS Implementations

Hey, Hey DBAs--Do you have a plan for implementing a Database Cloud?

Here's what you need to know:

DBaaS is a cloud model that enables users to request database environments by choosing from a pre-defined service catalog using a self-service provisioning framework.

The key benefits of these database clouds are agility and faster deployment of database services.

Organizations are looking at DBaaS because it can simplify IT infrastructures and automate provisioning processes. So it makes it possible to deliver database functionality to many users and multiple divisions from the same hardware and software infrastructure.  

What's the ideal Oracle DBaaS configuration?

Start with Oracle Database 12c Its multitenant architecture option makes it possible to enable DBaaS as part of a comprehensive cloud strategy. It allows collections of pluggable databases to be easily managed as a single entity, which maximizes consolidation density and simplifies administration.

The next key element:  Oracle Enterprise Manager 12c. It's designed to manage the entire database cloud deployment lifecycle, from planning, testing and deployment to ongoing operations and performance monitoring.

Finally, the exceptional deployment platform for DBaaS:  Oracle Exadata.  A fully integrated and sophisticated engineered system from Oracle that supports multiple deployment models, multiple workloads and multiple service levels from one integrated, optimized platform.

So, start thinking about the Database Cloud, deploying DBaaS and the value it can bring to your environment.

Here are some expert resources to help you come up to speed.

Ciao for Now!

Friday May 15, 2015

Securing the Big Data Lifecycle

Let's talk about Securing the Big Data Lifecycle. 

We all have seen demos or attended tutorials with extraordinary examples of integrating, analyzing and making business decisions based on Big Data. And I always wonder...who's data is that anyway? Consider the nature and character of Big Data for a moment. What we have here is ubiquitous and indiscriminate data collection from a wide range of devices. Add to that unexpected uses of collected data, especially without customer consent. And that could possibly lead to unintended data breach risks with larger consequences.

It will be a great challenge.

You need a plan.

MIT Technology Review just released this whitepaper addressing these issues.

Give it a read to set your mind at ease about how to secure your data, no matter how big.

Ciao for Now!

Thursday May 14, 2015

Installing ODB12c on Oracle Solaris 11 in 5 Steps

Hey Hey DBAs:  You know you can  install and run Oracle Database 12c on different platforms, but if you install it on an Oracle Solaris 11 zone, you can take advantage of these capabilities:

  • Isolation - Database processes that execute in one zone have no access to database processes running in another zone. This isolation simplifies database consolidation, allowing multiple instances and versions to coexist safely on a single physical machine.
  • Independently Managed and Autonomous Environments - A non-global zone can be booted, patched, and shut down independently. A failure or reboot of one zone has no impact on other zones (unless, of course, a failure is due to a shared component). A zone reboot is faster than a full server reboot (seconds versus minutes), so a database in a rebooted zone is available more quickly.
  • Distinctive Identity - You can define virtual network interfaces for a zone, so you can give the database instance installed on that zone its own independent host name and IP address. You can also apply networking resource controls to zones, aligning network bandwidth consumption with service level targets.
  • Easy Database Instance Migration - If a database needs more CPU power, you can add CPUs to an Oracle Solaris Zone and reboot the zone. If a database needs more compute capacity than what's available in the physical server, you can migrate the zone to a larger server.
  • Hard Partitioning - Assigning a resource pool or capping CPU cores can configure Oracle Solaris Zones as hard partitions for Oracle Database licensing purposes. This can potentially lower database licensing costs.

So, you want to install Oracle Database 12c in an Oracle Solaris 11 zone...with hard partitioning?  This article from good friends Ginny Henningsen and Glynn Foster on the Oracle Solaris product management team shows you how to do it.  

Tech Article: 5 Steps to Installing Oracle Database 12c on Oracle Solaris 11

Ciao for Now!


The OTN DBA/DEV Watercooler is your official source of news covering Oracle Database technology topics and community activities from throughout the OTN Database and Developer Community. Find tips and in-depth technology information you need to master Oracle Database Administration or Application Development here. This Blog is compiled by @oracledbdev, the Oracle Database Community Manager for OTN, and features insights, tech tips and news from throughout the OTN Database Community.


« October 2015