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!


      Monday Oct 20, 2014

      Oracle Critical Patch Advisory -- October 15, 2014

      ATTN: Oracle DBAs: Oracle has published its Critical Patch Advisory Dated Oct 15, 2014.  Get the advisory here

      Here's what you need to know:

      This Critical Patch Update covers 154 new security fixes across a wide range of product families including: Oracle Database, Oracle Fusion Middleware, Oracle Java SE, Oracle Linux and Virtualization, Oracle MySQL, Oracle Hyperion, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, and Oracle Business Applications and more.

      REMEMBER: Critical Patch Update fixes are intended to address significant security vulnerabilities in Oracle products and also include code fixes that are prerequisites for the security fixes. As a result, Oracle recommends that this Critical Patch Update be applied as soon as possible. 

      Customers of affected Oracle products are strongly advised to apply the fixes that were announced in the Security Alert for CVE-2014-7169.

      ALSO NOTE: On September 26, 2014, Oracle released a Security Alert for CVE-2014-7169 "Bash" and other publicly disclosed vulnerabilities affecting GNU Bash. Read the GNU Bash Security Alert here.

      Get the list of Oracle products that include the Bash program here .

      Read the Oracle Security Blog here.

      Ciao for Now!


      Monday Sep 22, 2014

      OOW 2014 #CLONEATTACK Comes to OTN Lounge

      Yes, Monday, 9/29 from 3:30 - 5:00 We'll be hosting a #CLONEATTACK at the OTN Lounge in Moscone South Lobby.

      #CloneAttack is your chance to install a complete Delphix lab environment on your Windows or Mac laptop for you to play with and experiment at any time. Experts Kyle Hailey, Steve Karam, Adam Bowen, Ben Prusinski, and Tim Gorman will help attendees install virtual machine OVA files for the lab environment, and will work one-on-one with you to help get everything up and running, then to show you basic use-cases for cloning with Delphix.

      Bring your laptop, bring your VMware, and get some data virtualization into your virtual life!

      At the same time, #CloneAttack will be joined by #RepAttack by Dbvisit, where Arjen Visser, Jan Karremans, and the team will be helping you replicate Oracle to Oracle for zero downtime upgrades.

      If you want to learn more about "Living La Vida Oracle", read this blog from Oracle Ace Director, Tim Gorman.

      And if you want to get ready for #CLONEATTACK...Here's what you need:

        Mac: VMware Fusion (free trial version download)
        Win: VMware Workstation (free trial version download)
        Minimum 8 GB RAM onboard
        Minimum 2 Ghz CPU, preferably dual-core or better

      C'mon out!

      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.


      « March 2015