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 12.1.0.2 -- ...with the long awaited In-Memory option, plus 21 new features. Oracle Database 12c Release 12.1.0.2 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!

        LKR

      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 (12.1.0.2) and Grid Infrastructure (12.1.0.2) 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,

      LKR

      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!
      LKR

      Monday Aug 25, 2014

      Oracle Key Vault Option is Here.

      Finally, a centralized way to manage all the encryption keys and credential files in the data center.   

      Critical credential files such as Oracle wallet files, Java KeyStores, Secure Shell (SSH) key files, and Secure Sockets Layer (SSL) certificate files are often widely distributed across servers and server clusters that use error-prone synchronization and backup mechanisms. As organizations increasingly encrypt data at rest and on the network, securely managing all the encryption keys and credential files in the data center has become a major challenge.

      How do you comply with stringent regulatory requirements for managing keys and certificates and ensure that keys are routinely rotated, properly destroyed, and accessed solely by authorized entities?

      Oracle Key Vault  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 in the data center, including Oracle wallet files, Java KeyStores, Kerberos keytab files, SSH key files, and SSL certificate files.

      Want to get started?  Here's what you need to know:

      Q: Where can I download the software for Oracle Key Vault?

      A: Oracle Key Vault can be downloaded from Oracle Software Delivery Cloud.

      Go to https://edelivery.oracle.com;

      Select Product Pack: Oracle Key Vault (12.1.0.0.0) Media Pack v1.

      Q: What are the recommended hardware specifications?

      A: CPU: Minimum 2x86-64 cores, Recommended: 2+cores with cryptographic acceleration support (IntelĀ® AES-NI) Memory: Minimum 4 GB of RAM Disk: Minimum 500 GB hard disk.

      Hardware Compatibility: Refer to the hardware compatibility list (HCL) for Oracle Linux Release 5 Update 10. The HCL is available at https://linux.oracle.com/hardware-certifications.

      Q: How does the software appliance install work?

      A: Oracle Key Vault is packaged as a software appliance, which means it contains everything, including the operating system, needed to install the product on bare hardware.

      During installation, the installer completely takes over the hardware. In addition to partitioning and formatting the disks, it installs the base OS, user-space libraries, Oracle Database, Oracle Key Vault software, etc. It configures all of the software (OS, networking, database) automatically and with minimal user involvement. It hardens the operating system, network, database, and more according

      to hardening best practices. It removes unnecessary packages and software and disables unused services and ports.

      Q: Can I deploy the Oracle Key Vault software appliance on Windows or Solaris?

      A: Oracle Key Vault can only be deployed on bare metal. Any existing OS including Windows or Solaris and software will be removed by the install process. Note that this applies only to the Oracle Key Vault appliance and is independent of the OS for the server endpoint.

      Q: Can I run Oracle Key Vault on Oracle Virtual Machine?

      A: For testing or proof of concept purposes, Oracle Key Vault can be run in Oracle VM or Oracle VirtualBox. However, for production deployment, Oracle Key Vault should be installed on dedicated physical hardware; otherwise VM administrators may be able to gain access to underlying keys and secrets stored inside Oracle Key Vault.

      Q: Can I install Oracle Key Vault on Oracle Database Appliance (ODA) or Exadata?

      A: No, at this time Oracle Key Vault is not certified with the Oracle Database Appliance or Exadata. Oracle Key Vault can however be used to manage keys used by ODA or Exadata.

      Find out more on the Oracle Key Vault page on OTN.

      Ciao for Now!

      LKR 

      Thursday Aug 14, 2014

      Did You Say "JSON Support" in Oracle 12.1.0.2?

      Yes, We did.   Here's why:

      JSON is practically a subset of the object literal notation of JavaScript, so it can be used to represent JavaScript object literals. This means JSON can serve as a data-interchange language. Although it was defined in the context of JavaScript, JSON is in fact a language-independent data format. A variety of programming languages can parse and generate JSON data.

      Additionally, JSON can often be used in JavaScript programs without requiring parsing or serializing. It is a text-based way of representing JavaScript object literals, arrays, and scalar data. JSON is easy for software to parse and generate. It is often used for serializing structured data and exchanging it over a network, typically between a server and web applications.

      JSON data has often been stored in NoSQL databases such as Oracle NoSQL Database and Oracle Berkeley DB. These allow for storage and retrieval of data that is not based on any schema, but they do not offer the rigorous consistency models of relational databases. You can get around this by using a relational database in parallel with a NoSQL database, but applications using JSON data stored in the NoSQL database must then ensure data integrity themselves.

      So for these reasons (and maybe a few more) Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views. Oracle Database queries are declarative, so you can join JSON data with relational data. And 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.

      And, it's good to know you can access JSON data stored in the database the same way you access other database data, including using OCI, .NET, and JDBC.

      Get more information about JSON support in Oracle Database 12c. You can start with the XML DB Developer's Guide (I DID!).

      Ciao for Now!

      LKR 

      About

      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.

      Search

      Archives
      « March 2015
      SunMonTueWedThuFriSat
      1
      2
      3
      4
      5
      6
      7
      8
      9
      10
      11
      12
      13
      14
      15
      16
      17
      18
      19
      20
      21
      22
      23
      24
      25
      26
      27
      28
      29
      30
      31
          
             
      Today