Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Copyright © 2013, Oracle and/or its affiliates. All rights reserved L Oracle Da

Copyright © 2013, Oracle and/or its affiliates. All rights reserved L Oracle Database 12c Real Application Clusters Lab Guide Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 2 TABLE OF CONTENTS THE WORKSHOP ENVIRONMENT.................................................... 3 Hardware and Software ............................................................................................... 3 Importing and Configuring the Virtual Machine ............................................................ 6 REAL APPLICATION CLUSTERS .................................................... 29 About Real Application Clusters (RAC) ........................................................................ 29 Oracle Grid Infrastructure Installation and Memory Configuration ............................. 29 Oracle RAC Database 12c Installation ......................................................................... 54 Enterprise Manager 12c Database Express.................................................................. 71 Storage Management ................................................................................................. 80 WORKLOAD EXECUTION ............................................................... 86 Swingbench Sample Schema ...................................................................................... 86 Run Swingbench Workload ........................................................................................ 91 Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 3 THE WORKSHOP ENVIRONMENT Hardware and Software The workshop environment consists of a cluster database with two nodes: RAC1 and RAC2 (active on both nodes at the same time). The configuration uses VirtualBox Host-Only network for both Public and Private connections, with static IP addresses, which is completely virtual, connecting also both virtual machines with the host computer. Apart from the cluster configuration, I added a third Bridged network card on each node for Internet access, with dynamic IP address allocation. Automatic Storage Management (ASM) uses VirtualBox shared disks, which are fixed size and shareable, which means they can be accessed by both nodes at the same time. Before importing the ova files, make sure you have at least one VirtualBox Host-Only Ethernet Adapter on your VirtualBox installation. To check it, click File > Preferences in the main menu. First check if Oracle VM VirtualBox Extension Pack is installed. If not, go to www.virtualbox.org, download, and install it. Next step is to check if you have a VirtualBox Host-Only Ethernet Adapter, and the configuration should be similar to the one I have: IPv4 address 192.168.56.1,and IPv4 Network Mask 255.255.255.0 (this is the default configuration). Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 4 If you don’t have one, click on Add icon on the right side. Once you add a VirtualBox Host-Only Ethernet Adapter, a virtual network interface is created on your host machine, and on a Windows OS it should look like this. Open Network Connections and see the Status of this adapter, click Details to see the IPv4 configuration details. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 5 PURPOSE USERNAME PASSWORD OS oracle oracle root oracle Database sys oracle system oracle Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 6 Importing and Configuring the Virtual Machine Click File > Import Appliance and import both virtual machines, RAC1 and RAC2, into your Oracle VM VirtualBox Manager. Click Choose and select the ova file. Leave all Settings by default, as they are in the import file. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 7 After both virtual machines are successfully imported, select RAC1, and click Settings. Note: This step is optional. Although you have to refresh MAC Address for the Bridged Adapter if you plan to run more than one RAC configuration in the same Network (for example if you and a colleague from the same office are running this workshop simultaneously). If this is not the case, please jump over the next three screenshots, to Storage Settings. Open Network settings, make sure Adapter 1 tab is selected, expand Advanced settings, and click the Refresh icon for the Mac Address. This is the Network Adapter that will be used to connect to Internet, for yum updates, and we have to refresh it’s configuration and make sure it receives a new DHCP configuration using a bridged connection through the physical interface on the host machine. In my case, the physical interface on the host machine that I use to connect to internet is Intel® 82577LM Gigabit Network Connection. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 8 When finished, click OK. Then select the second virtual machine, RAC2, and click Settings. Refresh the Mac Address for Adapter 1 on this machine too. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 9 Open Storage settings on one of the virtual machines. Select the SATA Controller, and click Add Hard Disk icon. Click Create new disk. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 10 Select VDI (VirtualBox Disk Image), and click Next. Select Fixed size, and click Next. This attribute is mandatory because we have to make this disk Shareable. That means all the space will be allocated when disk is created, so make sure you have the necessary space on your hard drive. All ASM disks have to be Fixed sized and Shareable. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 11 Specify the Location, and set 3GB as Size. Click Next. Review the Summary, and click Create. Repeat these steps to create minimum 4 identical disks. We’ll temporary remove all disks we just added, so their attributes can be changed. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 12 After removing all ASM disks we just created, click OK. We’ll use Virtual Media Manager to change the attributes for the new disks. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 13 Select the disks one by one, click Modify, and select medium type Shareable. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 14 When finished, Close Virtual Media Manager. Then re-add the new disks to both nodes, selecting Choose existing disk at the first step. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 15 This is the final result. Storage Settings should look like this for both virtual machines. Now we can Start both virtual machines. Note: Every time you click in a running virtual machine window, VirtualBox captures the mouse pointer. To release it you need to press Right Ctrl key. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 16 Note: The following step is mandatory only if you refreshed the MAC Address for Adapter 1. If this is not the case, please jump over the next nine screenshots, to Software Download from Oracle Website. Because we refreshed the Mac Address for Adapter 1, Linux operating system detects it as a new network adapter, leaving the old adapter (Mac Address) in the configuration files. We have to delete configuration file 70-persistent-net.rules in folder /etc/udev/rules.d/ as root user on both virtual machines, and reboot them, so the Adapter 1 with new Mac Address takes its place as eth0 on the system. Password for root is oracle. After reboot, login as root and locate the configuration file for eth0. It may have different names, but there are some rules to identify it: it is located in /etc/sysconfig/network-scripts, file name starts with ifcfg, and contains eth0. Edit the file on both virtual machines, and modify the parameter HWADDR with the new Mac Address of Adapter 1. If you don’t remember the Mac Address of Adapter 1, click Devices > Network Adapters. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 17 When copying the Mac Address to the configuration file, add ‘:’ between every two hexadecimal digits. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 18 Save the file, and reboot both machines. Note: On RAC2 we can see the configuration file has a different name. These names are generated automatically when Linux is installed. After both machines are rebooted, check the configuration for all network interfaces, as root, using the command ifocnfig | more eth0 should get an dynamic IP configuration from the DHCP server. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 19 Before we begin with the installation, we need to download Oracle Grid Infrastructure and Oracle Daabase 12c software from Oracle website. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. All rights reserved 20 To access the download section, you need to create an account. Click Sign In/Register for Account at the top of the page, and create an account. Once your account is ready, Sign In, and click Downloads > Oracle Database. Click See All link for Linux x86-64. Accept OTN License Agreement, and download both zip archives for Oracle Database 12c Release 1, and both zip archives for Oracle Database 12c Release 1 Grid Infrastructure. Oracle Database 12c Real Application Clusters Copyright © 2013, Oracle and/or its affiliates. uploads/s3/ rac12-c-lab-guide.pdf