Chapter 8: Virtualizing Oracle Database 10g/11g
Oracle Database 10g/11g Virtualization
Copyright © 2009 - 2012 Roddy Rodstein. All rights reserved.
This chapter will review how to rapidly deploy a virtualized Oracle 10g/11g Database using Oracle VM Templates with Oracle VM Manager.
Note: As of this writing, the Oracle 10g/11g Database Oracle VM Templates will not boot on an Oracle VM server with more than 60 G or RAM. Oracle VM templates using Oracle Linux 5.3 and below ship with a known kernel bug that will not allow the Oracle VM template 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 an Oracle VM template will not boot, 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
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 boot on the Oracle VM server. Once the Oracle VM template is running, patch the kernel to resolve the kernel bug, and then remove the the mem=50G entry on the Oracle VM server.
Oracle VM Templates Overview
Oracle VM Templates are self-contained and pre-configured virtual machines with key Oracle technologies that can be downloaded and rapidly deployed in to production or test environments. Each Oracle VM Template is packaged using Oracle best practices, which eliminates operating system and application 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 a production ready 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:
Oracle Virtualization and Management
-
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
-
Oracle Enterprise Manager Grid Control 10g R5 (10.2.0.5)
-
Oracle Enterprise Manager Grid Control 11g R1 (10.2.0.5)
Oracle Applications
-
E-Business Suite 12.1.3
-
E-Business Suite 12.1.1
-
E-Business Suite 12.X Sparse Middle Tier
-
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
-
PeopleSoft ELM 9.1 Bundle #2 with PeopleTools 8.50.09
-
PeopleSoft FSCM 9.1 Bundle #4 (includes Maintenance Pack 2) with PeopleTools 8.50.10
-
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
-
Siebel CRM SIA 8.1.1
-
Siebel CRM SIA 8.0
Oracle Middleware
-
Oracle WebLogic Server on JRockit Virtual Edition 11g R1 (10.3.2)
-
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
Oracle Database & Oracle 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
Oracle Operating Systems
-
Oracle Linux 4 and 5
-
Oracle Solaris 10
3rd Party Software
-
Zeus Traffic Manager
How to Download Oracle VM Templates
This chapter covers how to download Oracle VM templates.
Note: The Oracle VM Templates are only available from the Linux Oracle eDelivery site at http://edelivery.oracle.com/linux. The Oracle VM templates are not available from the root http://edelivery.oracle.com/ eDelivery URL.
How to Download Oracle VM Templates
a) Enter http://edelivery.oracle.com/linux in to a Web browser. Click the Continue button to proceed to the Registration form.
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.
Figure 3
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 4
d) From the Media Pack Search page, locate and click on the desired Oracle VM Template link.
Figure 5
d) Review the Oracle VM Templates on the desired <Oracle VM Template Name> Media Pack Download pages and select and download the zip files.
Figure 6 shows the Oracle VM Template for Oracle Database Media Pack Download page. To download the Oracle Database Media Pack, select and download both files.
e) Next, click the Readme button and review the Readme for the Oracle VM Template template.
f) Once the Oracle VM template files have been downloaded, copy the zip files to your Oracle VM server's /OVS/running_pool directory or the /OVS/seed_pool directory. Next, unzip and untar the files in the directory.
Note: Use the running_pool directory if you would like to deploy the Oracle VM template as a running virtual machine. Use the seed_pool directory if you would like to deploy the Oracle VM template as a reusable template that can be re-deployed an unlimited number of times.
How to Import the Oracle Database 11g Template with Oracle VM Manager
This chapter will review how to import the Oracle Database 11g template using Oracle VM Manager.
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 authenticate to access the Oracle VM Manager GUI.
Figure 1
b) From the Virtual Machines home page click the Resources tab. From the Resources tab click the Virtual Machine Image link. From the Virtual Machine Images page click the Import Button.
Note: The example assumes that the Oracle Database 11g template has been unzipped and untarred in the /OVS/running_pool directory. If the Oracle database 11g template was unzipped and untarred in the /OVS/seed_pool directory, click the Virtual Machine Templates tab to import the template.
Figure 2
d) From the Source page select the Select from Server Pool (Discover and register) radio button and click Next to proceed.
Note: The Select from Server Pool (Discover and register) requires that the Oracle Database 11g template has been staged, i.e. unzipped and untarred in the /OVS/running_pool directory.
Figure 3
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 4
e) Click the Confirm button to proceed.
Figure 5
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 6
g) From the View Imported Virtual Machine page click the Approve button.
Figure 7
h) After the Virtual Machine Image is approved click the Virtual Machines tab. From the Virtual Machines page you will see the Oracle Database 11g template in the list of Virtual Machines in the Powered Off status.
Figure 8
How to Start, Configure and Deploy the Oracle Database 11g Template using Oracle VM Manager
This chapter show how to start, configure and how to deploy the Oracle Database 11g template.
The Virtual Machines page is the Oracle VM 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 1
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 in the Password text box and click the OK button to access the virtual machine's console.
Figure 2
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.
Current network is using DHCP. Using static IP address is recommended.
Use DHCP? y/n [n]
Configuring static IP.
Starting network...
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:
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...
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
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 ...
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.
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"
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. The virtual machine is accessible via ssh using the IP address select during the configuration process with the default user name root and the default root password ovsroot. The virtual machine's console can be accessed using the console password that was selected during the configuration process using the console button in Oracle VM Manager.
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'.
-