X

Oracle Linux, virtualization , Enterprise and Cloud Management Cloud technology musings

  • August 7, 2013

Oracle VM templates for Database 12c 12.1.0.1.0 both single instance and rac

Today we made available a few new Oracle VM templates on edelivery. A set of VM templates for database 12c and another set for database 11g 11.2.0.3.7.

You can find more information on the otn pages here.

A very important new feature added is the ability to deploy single instance database. In the past the database templates were focused on RAC deployments (Real Application Cluster) but because of popular demand, we also added support for Single Instance. With Single Instance you can really create a new VM with the database up and running in a matter of a few (very few) minutes, and with a very simple config file.

Example config file for single instance :

$ cat netconfig.ini 
NODE1=dbsingle1
NODE1IP=192.168.1.72
PUBADAP=eth0
PUBMASK=255.255.255.0
PUBGW=192.168.1.1
DOMAINNAME=wimmekes.net # May be blank
DNSIP=8.8.8.8 # Starting from 2013 Templates allows multi value
CLONE_SINGLEINSTANCE=yes # Setup Single Instance

That's literally it. You don't need to do anything other than run a few Oracle VM CLI or UI commands and run deploycluster and you're all set. After a few minutes, the VM will be pingable and you can run sqlplus against the database running inside the VM.

If you use the CLI, here is a sample workflow :

  • import the template

  • - importtemplate repository name=[reponame] url=[http://myurl/template.tbz] server=[servername]
  • create vm from template

  • - clone vm name=[templatename] destType=Vm destName=[vmname] serverpool=[serverpoolname]
  • Create new vnic

  • - create vnic name=[macaddress] network=[network] (list network, will show you the various networks)
  • remove old vnics (you could rename one or alter one but to simplify I just remove the old vnics of the cloned vm and add the newly created

  • - remove vnic name=[macaddr] from vm name=[vmname]

    - show vm name=[vmname] to see the attached vnics

    And that's it, now you can use that netconfig.ini example, edit it for your environment and run deploycluster:

    On top of single instance, the templates also expose or give you the ability to easily configure and enable many of the new rdbms 12c functionality :

    - Oracle Flex Cluster and/or Flex ASM, Hub/Leaf nodes

    - Container Database with x number of pluggable databases

    - Database Express

    - ACFS filesystem

    - Oracle Restart (single instance database with HA)

    - local or shared filesystem installs, including OCFS2 and ACFS

    - Admin Managed or Policy managed database creation with serverpools

    - OS kernel updated to the latest uek 2 version 2.6.39-400

    And all of the above are simple parameters in the config files. This can be 100% automated, 100% reproducible and you don't need to know how to configure them all yourself. As always, high quality work by Saar Maoz.

    Production ready, not trial, not using a random OS, all ready to go. Production-ready virtual appliances.

    Join the discussion

    Comments ( 8 )
    • guest Friday, August 9, 2013

      Thanks Wim, great stuff - will save us lot of time!

      Can you please confirm those templates can be used with OVM2 - I'm having difficulties ... https://forums.oracle.com/thread/2568128


    • Ranko Mosic Friday, August 9, 2013

      There is no 12c RAC Oracle VM Template on edelivery web site.

      Please post the link to it.


    • guest Friday, August 9, 2013

      Actually if you click on the link in the blog it takes you to edelivery.oracle.com/linux (note the /linux) and if you log in you get to "product pack". set that to oracle vm templates. click on go and look for Oracle VM Templates for Oracle Database Media Pack for x86 (64 bit)

      inside of that .... you see Oracle VM Templates for Oracle Database - Single Instance and RAC 12cR1 (12.1.0.1.0) - Oracle Linux (64 bit) (part 1 of 2)


    • guest Friday, August 9, 2013

      should work - you might not be on the latest 2.x? I will ask Saar to look at it.


    • Ranko Mosic Friday, August 9, 2013

      Got it, thank you Wim.


    • guest Friday, August 9, 2013

      re : ovm2. make sure you run on ovm2.2.2 at least. it's confirmed to work.


    • Jagjeet Singh Saturday, August 10, 2013

      Thanks Wim - Great stuff

      I got below error while deploying 4 node flex cluster, however doc/pdf does not talk about GNS IP or have no parameter to be defined.

      Am I missing something ?

      ERROR (node:ovm): Since Flex Cluster is chosen via FLEX_CLUSTER=yes, GNS IP is required to be set in GNS_ADDRESS in netconfig.ini. Set the GNS IP or disable Flex Cluster.


    • guest Saturday, August 10, 2013

      Jagjeet,

      utils/netconfig.ini does talk about it : (in deploycluster)

      Cluster Related parameters (not needed for Single Instance):

      Parameter : Description : Req/Optional

      ------------------------------------------

      RACCLUSTERNAME: Cluster name: Required (A name for the Cluster)

      SCANNAME : SCAN Name : Required (preferably registered in DNS with 3 IPs)

      SCANIP : IP of SCAN : Optional (Required if DNSIP is omitted)

      GNS_ADDRESS : GNS IP : Required (if GNS setup is desired.)

      GNS_DOMAIN : GNS Domain : Required (if GNS setup is desired & non-Flex Cluster)

      Note: Although GNS is configured, the current automation still requires

      the cluster members themselves to have a fixed/statis IP.


    Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha