How to Virtualize Oracle Database 11g with Oracle VM
Copyright © 2009 - 2011 Roddy Rodstein. All rights reserved.
This chapter will review how to rapidly deploy a virtualized Oracle 11g Database using Oracle VM templates with Oracle VM Manager.
Note: Oracle does not patch the Oracle VM template operating systems. There is a known kernel bug with Enterprise Linux that will not allow an unpatched kernel to boot on an Oracle VM server with more than 60 G or RAM. If your Oracle VM server has more than 60 G of RAM and a template will not start, edit the grub.conf file on the Oracle VM server to add the memory parameter to kernel line that loads the Xen hypervisor, i.e.
kernel /xen-64bit.gz dom0_mem=1024M mem=50G
After adding the mem=50G entry, reboot the Oracle VM server. With the addition of the mem=50G entry, the Oracle VM template will be able to operate on the Oracle VM server. Once the Oracle VM template is running, patch the kernel, and remove the the mem=50G entry on the Oracle VM server.
Oracle VM Templates are self-contained and pre-configured virtual machines with key Oracle technologies. Each Oracle VM Template is packaged using Oracle best practices, which eliminates installation and configuration costs, reduces risk and dramatically shortens deployment time. Oracle VM Templates are available from the Linux Oracle eDelivery portal. There is no other vendor in the virtualization market that can offer this level of in-depth knowledge, integration, management and pre-packaging of applications with an operating system.
The use of Oracle VM Templates for the deployment of applications in Oracle VM guest virtual machines eliminates the need for a user to install and configure the operating system or applications. The virtual machines created using Oracle VM Templates can be started either from the Oracle VM Manager or the Oracle VM Management Pack (an Oracle Enterprise Manager plug-in).
Oracle VM Templates include a free download and free trial license with the option to purchase a product license. Oracle VM Templates do not have time limits or feature limitations, e.g. Oracle VM Templates are full featured and do not have expiration dates. Oracle VM Templates can be quickly transitioned from evaluation into production by purchasing Oracle technology licenses.
List 1 shows Oracle’s current Oracle VM templates collection:
Virtualization and Management
* Oracle Enterprise Manager Grid Control 10g R5 (10.2.0.5)
* Oracle VM Manager 2.2 and 2.1.5
* Oracle VM Template Builder 2.1
* Oracle VM Server 2.2.1 and 2.1.5 SDK
* Sun Ray Software 5
* Oracle Secure Global Desktop
Applications
* Siebel CRM SIA 8.1.1 and 8.0
* PeopleSoft CRM 9.1 Bundle #2 with PeopleTools 8.50.09
* PeopleSoft Portal Solutions 9.1 and PeopleTools 8.50.09
* PeopleSoft HCM 9.1 and PeopleTools 8.50.02
* JD Edwards EnterpriseOne 9.0 Update 1 with ESUs and JD Edwards EnterpriseOne Tools 8.98 Update 3
* JD Edwards EnterpriseOne 9.0 Update 1 and JD Edwards EnterpriseOneTools 8.98 Update 2
* E-Business Suite 12.1.1
Middleware
* Oracle WebLogic Server 10g Release 3
* Oracle Business Intelligence Enterprise Edition 10.1.3.4
* Oracle Application Server 10g Release 3 WebCenter
* Oracle Identity Management 10g Release 2
* Oracle Fusion Middleware Service Oriented Architecture (SOA) 10.1.3.4 and 10.1.3.3
Database & Real Application Clusters (RAC)
* Oracle Real Application Clusters (RAC) 11g Release 2
* Oracle Real Application Clusters (RAC) 11g Release 1
* Oracle Database 11g and Oracle Database 10g Release 2
Operating System
* Oracle Enterprise Linux 4 and 5
* Oracle Solaris 10
3rd Party Software
* Zeus Traffic Manager
Oracle offers three unique options for accelerating application deployment: . Oracle VM Templates, Oracle Virtual Assembly Builder and Oracle VM Template Builder.
-
Oracle VM Templates - Download from Oracle and deploy
-
Oracle Virtual Assembly Builder - Package software components into virtual appliances
-
Oracle VM Template Builder - Do it your self appliance templating
This chapter covers deploying the Oracle 11g Database using Oracle VM Templates.
Figure 1
b) Complete the Registration form, accept the license agreement and the export agreement. Next, click the Continue button to proceed to the Search page.
Figure 2
c) From the Media Pack Search page you can select the a) Oracle VM Templates b) Enterprise Linux c) Oracle VM search options.
Select the Oracle VM Templates search option from the Select a Product Pack drop down list. Next, select ether x86 32 bit or the x86 64 option from the Platform drop down list. Click the Go button to proceed to the Oracle VM Templates Media Pack Search page.
Figure 3
d) From the Media Pack Search page, locate and click on the Oracle VM Template for Oracle Database Media Pack link.
Figure 4
d) Review the Oracle VM Templates on the Oracle VM Template for Oracle Database Media Pack Download pages and select and download the desired Oracle VM Template for Oracle Database template.
Figure 5
e) Next, click the Readme button and review the Readme for the Oracle VM Template for Oracle Database Media Pack template.
f) Copy the zip file to your Oracle VM server's /OVS/running_pool directory. Unzip and untar the files in the /OVS/running_pool directory.
a) Access the Oracle VM Manager GUI by typing the Oracle VM Manager URL in your browser. Enter your username and password in to the Username and Password text boxes. Then, press the Login button to access the Oracle VM Manager GUI.
Figure 6
b) Click the Resources tab. From the Resources tab click the Virtual Machine Image link.
From the Virtual Machine Images page click the Import Button.
Figure 7
d) From the Source page select the Select from Server Pool (Discover and register) radio button and click Next to proceed.
Figure 8
d) From the General Information page complete the form for the Oracle VM 11g Template's properties. Once all the data is complete click Next to proceed.
Server Pool Name:
Required Sharing:
Required Virtual Machine Image Name:
Enable High Availability
Required Operating System: Oracle Enterprise Linux 5 (either x86 or x86_64)
Virtual Machine System Username:
Virtual Machine System Password:
Required Console Password:
Required Confirm Console Password:
Description:
Figure 9
e) Click the Confirm button.
Figure 10
f) From the Virtual Machine Images page click the Refresh button. The status will change from Importing to Pending. Next, click the Approve button.
Figure 11
g) From the View Imported Virtual Machine page click the Approve button.
Figure 12
h) Aftrer the Virtual Machine Image is approved click the Virtual Machines tab.
The Virtual Machines page is the virtual infrastructure dashboard.
The dashboard offers visibility in to the virtual machine's status and properties, i.e. memory allocation, status, owner, group name, server name, server pool name. For example, click the the virtual machine's +Show option to list the virtual machine properties dashboard.
The Select and feature allow you to Power On, access the virtual machine's Console, Power Off, and Configure a virtual machine's properties, i.e. resource allocations and policies.
The More Actions drop down list offers the following virtual machine administrative features: Deploy, Live Migration, Clone, Save as Template, Pause, Unpause, Suspend, Resume, Delete and Reset.
a) From the Virtual Machine page start your virtual machine by pressing the Power On button. The virtual machine status will change from Powered Off to Initializing to Running.
Figure 13
b) Once the status is Running click the Console button to access the virtual machine's console.
Note: If you receive any Java Warnings, click the Always trust content from the publisher check box and click Run.
c) Enter the VNC Authentication Password and click the OK button to access the virtual machine's console.
Figure 14
d) When a virtual machine created from Oracle Database template boots up for the first time, the boot up process gathers database configuration information from the user and configures the database automatically, please follow the prompts in the Oracle VM Manager virtual machine VNC console to complete the process.
1) System configuration
User will be asked if a static IP address should be configured. Answer no “y” to use DHCP.
Configuring network for Oracle Database.
Current network is using DHCP. Using static IP address is recommended.
Use DHCP? y/n [n]
Configuring static IP.
Starting network...
2) Oracle database configuration (ACCEPT THE DEFAULTS, JUST PRESS ENTER)
Starting Oracle database reconfiguration.
Do you want to relink binaries? (y/n) [n]
Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts. Note that the same
password will be used for SYS, SYSTEM and ADMIN for APEX. Oracle recommends
the use of different passwords for each database account. This can be done
after initial configuration:
Confirm the password:
Do you want Oracle Database to be started on boot (y/n) [y]:
Running orainstRoot.sh and root.sh...
Changing permissions of /u01/app/oraInventory to 770.
Changing groupname of /u01/app/oraInventory to dba.
The execution of the script is complete
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Starting CSS.
Starting Oracle Net Listener...Done
ASM instance started
ORACLE instance started.
Configuration Completed Successfully.
To access the Oracle Application Express go to
"http://myhost.mydomain.com:8080/apex"
d) The Oracle Database 11g Template is configured, on the network and 100% operational.
Notes:
-
The system image contains a minimal install of Oracle Linux. Only basic RPM packages are installed.
-
The default root password is 'ovsroot'.
-
A database instance 'orcl' is created in the templates.
-
The database user is named “oracle” and belongs to groups 'orainstall' and 'dba'. The password is 'oracle'.
-
The oracle-validated package is installed. This package verifies and sets system parameters based on Oracle validated configuration recommendations for Oracle Enterprise Linux.
-
The database storage is managed by Automatic Storage Management (ASM). Two ASM disks 'VOL1' and 'VOL2' are created, and the default ASM group name is 'DATA'.