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!

Thursday Apr 30, 2015

What's Planned for the FREE Virtual Technology Summit on May 5th

The Oracle Technology Network is hosting a phenomenal agenda at the Virtual Technology Summit on May 5, 2015 (9:00 am PT to 12:30 pm PT). You should go. Here's why:

Just wait until you see the presentations we’ve put together for our event. We have a dedicated track on Big Data, where we’ll be showcasing the new Big Data Lite virtual machine. We have exercises designed to help you learn how to use Oracle Big Data SQL, and the Oracle Data Loader for Hadoop + Oracle Connectors for HDFS to get your Big Data implementations rolling.  Plus the team will be showcasing new functionality in the Oracle Advanced Analytics  and Oracle R Enterprise.  It's going to be a Really Big Show. 

And the Developer Track is huge too.  Check out the 2 full tracks covering hot Applications Development topics.  We’ll  cover our traditional database Application development tools like SQL Developer and Application Express…both of which have big announcements…So watch this space for news on that on MONDAY MAY 4th...

And it's not all work. Get ready for some Fun…Fun with Functions that is. Steven Feuerstein makes it so easy to master PL/SQL.  And don’t miss the SQL Magic show hosted by our SQL magician and developer advocate, Chris Saxon… He says Presto and Ta-DAA at least 4 times during his session! 

Did you say FUN?

So here's what I want you to do:

% Register NOW for the Free OTN Virtual Technology Summit. And you can invite as many friends and coworkers as you'd like.  

% Install the Virtual Machine and the scripts so you can follow along on all the exercises.

% Type "See you there!" in the comments below to receive special recognition when you log in to the event.

Ciao for Now!


Wednesday Dec 31, 2014

Top 5 Oracle Database Tech Releases of 2014

It was a great year for Oracle Technology...with so many great new features and products for Oracle DBAs, Data Scientists and Developers. Here's the Top 5 new technologies that we rolled out, with the resources you need to get started...from your friends here at the OTN Watercooler.

  • Oracle Database 12c -- ...with the long awaited In-Memory option, plus 21 new features. Oracle Database 12c Release supports Linux and Oracle Solaris (SPARC and x86 64 bit). See the full list of features with direct links to docs and resources. 
And if you're ready to start your upgrade journey to Oracle Database 12c, be sure to check out this Upgrade Starter's Guide and follow the Oracle Upgrade NOW blog
    • Oracle Database In-Memory -- Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with virtually any existing Oracle Database compatible application is as easy as flipping a switch--no application changes are required. It is fully integrated with Oracle Database's scale-up, scale-out, storage tiering, availability and security technologies making it the most industrial-strength offering in the industry.

      This whitepaper Oracle Database In-Memory gives you more detail about the new option available only in Oracle Database 12c, and if you want to get started, check out this article series:

    • Oracle Key Vault is a software appliance designed to securely manage encryption keys and credential files in the enterprise data center. It provides secure, centralized management of encryption keys and credential files including Oracle wallet files, Java KeyStores, Kerberos keytab files and SSH key files and SSL certification files.  Want to get started?  Here's what you need to know.

    • Oracle Big Data SQL -- Oracle's unique approach to providing unified query over data in Oracle Database, Hadoop, and select NoSQL datastores. Read more about why SQL is becomming the "GoTo" language for Big Data Analysis.

    • Oracle Oracle Zero Loss Recovery Appliance --Launched in October at OOW2014, The Oracle Zero Data Loss Recovery Appliance is a terrific addition to the Oracle Engineered Systems Portfolio. With its support for real-time redo transport, the appliance is designed to bring "Data Guard-like",  robust data protection for all the Oracle Databases in the data center. It's a sweet ride... Get the full story here.

      But as with most "Top" lists, there are many more items to include. So Special Mention goes to:

        JSON Support in Oracle 12c -- Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views. You can project JSON data relationally, making it available for relational processes and tools. You can also query, from within the database, JSON data that is stored outside the database, in an external table. Get more information about JSON support in Oracle Database 12c. You can start with the XML DB Developer's Guide.

      • Happy New Year and

        Ciao for Now!


      Wednesday Sep 17, 2014

      w00t! OOW 2014 RAC ATTACK Set Up Instructions

      Going to the RAC ATTACK at OOW 2014? We're meeting on Sunday 9/28 starting at 9:00 am at the Oracle Technology Lounge in the Moscone South Lobby. Here's the FIRST, NEXT and FINALLY information you need to be ready to learn more about Oracle 12c and Real Application Clusters.

      FIRST --The T-shirt:

      NEXT -- What to expect:

      Experienced RAC ATTACK volunteers will walk you through an installation of the Oracle 12c RAC environment on your laptop, explore advanced RAC related setup scenarios or work on solving more advanced RAC related challenges.

      During the workshop you will learn how to setup one of the most complex infrastructures on your laptop. You will learn how to configure and clone virtual machines, how to create and setup internal and external virtual networks, create different storage types, setup a local DNS server and other challenging components.

      After this workshop you will know how to setup a test/sandbox environment for virtually any product.

      Attendees have 3 options for exercises during the RAC ATTACK:

        1. RAC 12c installation - participants install Oracle Virtualbox, Oracle Linux, Oracle 12c RAC and configure those components to work together.
        2. RAC 12c advanced tasks - for those who have 12c RAC on their laptops already the workshop has to offer to go through a set of advanced scenarios. Each scenario focused on a particular RAC 12c features to learn and explorer.
        3. RAC freestyle - join in groups to work on RAC related challenges.

      FINALLY: Set up your laptop

      To participate in the workshop, participants need to bring their own laptop. Recommended specification:
        a) any 64 bit OS that supports Oracle Virtual Box.
        b) 8GB RAM, 45GB free HDD space.

      To save time we suggest that you pre-download Oracle Database 12c ( and Grid Infrastructure ( for Linux x86-64 from the Oracle Technology Network. GET IT HERE.

      Want to know more about the Oracle RACSIG? HIT THIS

      Ciao for Now,


      Monday Sep 08, 2014

      What, you don't have a RAC implementation?

      ...but you need business continuity, high availability, scalability, combined with automatic management for your IT infrastructure and cloud deployments. Oracle Database with the Real Application Clusters (RAC) option is probably what you're looking for.

      Originally focused on providing improved database services, Oracle RAC has evolved over the years and is now based on a comprehensive high availability (HA) stack that can be used as the foundation of a database cloud system as well as a shared infrastructure that can ensure high availability, scalability, flexibility and agility for any application in your data center.

      Features in the Oracle 12c RAC option including Application Continuity and Oracle Flex ASM (plus noteworthy enhancements in the area of policy including managed database and cluster management, comprehensive database consolidation and Oracle Multitenant support) make Oracle RAC a compelling approach to database virtualization.

      And there's a lot more to RAC implementations. This technical paper gives a quick overview of key enhancements in each layer of the Oracle RAC stack that contribute to an even higher level of application availability using an Oracle RAC database.

      Find out how Oracle RAC delivers:

      • Business Continuity and High Availability
      • Scalability and Agility
      • Cost-Effective Workload Management
      • Standardized Deployment and System Management

      Check it out, and if you'll be at Oracle OpenWorld in San Francisco, OTN will be hosting a RAC ATTACK hands on lab session on Sunday from 9:00 am -2:00 pm at the OTN Lounge. Come meet the Ninjas and learn all about the Oracle RAC Stack.

      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.


      « July 2016