book.book Page 1 Wednesday, August 4, 2010 11:57 AM Dell PowerEdge Systems Oracle Database on Enterprise Linux x86_64 Database Setup and Installation Guide Version 1.
book.book Page 2 Wednesday, August 4, 2010 11:57 AM Notes, Cautions, and Warnings NOTE: A NOTE indicates important information that helps you make better use of your computer. CAUTION: A CAUTION indicates potential damage to hardware or loss of data if instructions are not followed. WARNING: A WARNING indicates a potential for property damage, personal injury, or death. ____________________ Information in this publication is subject to change without notice. © 2009–2010 Dell Inc. All rights reserved.
book.book Page 3 Wednesday, August 4, 2010 11:57 AM Contents 1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . Required Documentation for Deploying the Dell|Oracle 11g R2 Database . . . . . . . . . . . . . . . 5 . . . . . . . . . . . 6 . . . . . . . . . . . . . . . . . . . . . . . 6 Terminology Used in this Document Getting Help . Dell Support . . . . . . . . . . . . . . . . . . . . . Oracle Support 2 5 . . . . . . . . . . . . . . . . . . .
book.book Page 4 Wednesday, August 4, 2010 11:57 AM 3 Installing Oracle 11g R2 Database (Single Node) . . . . . . . . . . . . . Configuring the Public Network . . . . . . . . . . . . . Configuring the Database Storage . . . . . . . . . . . . 21 . . . . . . . . . 21 Configuring the Database Storage Disks for ASM . . . . . . . . . . . . . . . . . . . . 22 . . . . . . . Installing Oracle 11g R2 Standalone Database Using the ext3 File System . . . . . . . . . . . Configuring the Listener 23 . .
book.book Page 5 Wednesday, August 4, 2010 11:57 AM 1 Overview This document applies to Oracle Database 11g R2 running on Red Hat Enterprise Linux 5.5 AS x86_64 or Oracle Enterprise Linux 5.5 AS x86_64.
book.book Page 6 Wednesday, August 4, 2010 11:57 AM Terminology Used in this Document • This document uses the terms logical unit number (LUN) and virtual disk. These terms are synonymous and can be used interchangeably. The term LUN is commonly used in a Dell/EMC Fibre Channel storage system environment and virtual disk is commonly used in a Dell PowerVault SAS and iSCSI (Dell PowerVault MD3000 and Dell PowerVault MD3000i with Dell PowerVault MD1000 expansion) storage environment.
book.book Page 7 Wednesday, August 4, 2010 11:57 AM Installing Oracle 11g R2 Database RAC 2 This section describes the steps required to install Oracle 11g R2 Real Application Clusters (RAC), which involves installing Oracle Grid Infrastructure for a cluster and the Oracle Database 11g R2 software. It is recommended that you create a seed database to verify that the cluster works correctly before you deploy it in a production environment.
book.book Page 8 Wednesday, August 4, 2010 11:57 AM Installing Oracle 11g R2 Grid Infrastructure for a Cluster To install Oracle 11g R2 grid infrastructure for a cluster: 1 Log in as root. 2 Start the X Window System by typing: start x 3 Open a terminal window and type: xhost + 4 Mount the Oracle Grid Infrastructure media. 5 Log in as Grid user. 6 Run the cluster verify script in the Oracle Grid Infrastructure media using the following command: /runcluvfy.
book.book Page 9 Wednesday, August 4, 2010 11:57 AM 11 Before providing the inputs in the Grid Plug and Play information window, you must decide whether to use Grid Naming Service (GNS) or not. If you are not using GNS: NOTE: Configure the Single Client Access Name (SCAN) addresses for client access to the cluster on the domain naming service (DNS).
book.book Page 10 Wednesday, August 4, 2010 11:57 AM b • SCAN Port—Retain the default port number, 1521. • Configure GNS—Check this option. • GNS sub-domain—Enter the configured GNS sub domain name. For example, clusterdomain.example.com. See the DNS server configurations for the sub-domain delegation in the Oracle Database on Enterprise Linux x86_64 Storage and Networking Guide. • GNS VIP address—Enter the GNS VIP address. For example, 192.0.2.2.
book.book Page 11 Wednesday, August 4, 2010 11:57 AM 13 In the Specify Network Interface Usage window, ensure that the correct interface types are selected for the interface names. To modify an interface type: a From the Interface Type drop-down list, select the required interface type. The available options are Private, Public, and Do not use. b Click Next.
book.book Page 12 Wednesday, August 4, 2010 11:57 AM 18 In the Privileged Operating System Groups window, select the following options and click Next: • ASM Database Administrator—asmdba group. • ASM Instance Administration Operator—asmoper group. • ASM Instance Administrator—asmadmin group. 19 In the Specify Installation Location window, enter the following information and click Next: • In the Oracle Base field, enter: /opt/app/grid • In the Software Location field, enter: /opt/app/11.2.
book.book Page 13 Wednesday, August 4, 2010 11:57 AM 24 The Installation of Oracle Grid Infrastructure for a Cluster was Successful window is displayed. Click Close. 25 On all nodes, perform the following: a Verify the Oracle Grid Infrastructure installation by typing the following command: olsnodes -n -v This command lists the host names of all nodes in the cluster. b Type the following command to check the status of all the grid services: /opt/app/11.2.
book.book Page 14 Wednesday, August 4, 2010 11:57 AM b Select the external redundancy, and then select the ASM stamped disk that you want to use for the shared database home. c Click OK. d Right-click the disk group you have created for the shared oracle home, and select Create ACFS for Database Home. 4 The Create ACFS Hosted Database Home Volume option is displayed. Click Create. a Enter a name for the volume. For example, ORAHOME. b Enter a name for the mount point for Database Home.
book.book Page 15 Wednesday, August 4, 2010 11:57 AM 4 Check the pre-requisites by typing the following cluster verification command: /bin/cluvfy stage -pre dbinst fixup -n Node1 , Node2 -r 11gR2 -osdba dba -verbose Where node1 and node2 are the host names of the public IP addresses, n represents the list of nodes, and r represents the Database release. cluvfy is a cluster verification utility available in the Grid Infrastructure Home.
book.book Page 16 Wednesday, August 4, 2010 11:57 AM 9 In the Select Product Languages window, select the Language Option as English, and click Next. 10 In the Select Database Edition window, select Enterprise Edition, and click Next. 11 In the Specify Installation Location window, select one of the following options and specify path information accordingly: • • If you are planning to configure and non-shared oracle home, provide the following information and click Next.
book.book Page 17 Wednesday, August 4, 2010 11:57 AM At the end of the installation process, the Execute Configuration Scripts window is displayed. Log in as root user and run the root.sh script sequentially on all nodes. 16 The Finish Option window displays a message stating that the installation of Oracle database was successful. Click Close. Creating Server Pools for Policy-Managed Database Configuration NOTE: Perform the procedure in this section before creating the database.
book.book Page 18 Wednesday, August 4, 2010 11:57 AM Creating ASM Disk Group This section contains procedures to create the ASM disk group for the database files and Flash Recovery Area (FRA). To create the ASM disk groups: 1 Log in as Grid user. 2 Start the asmca utility: $/bin/asmca 3 In the ASM configuration Assistant window, select the Disk Groups tab. 4 Click Create. 5 Enter the Disk Group Name as databaseDG. 6 Configure the redundancy level to External redundancy.
book.book Page 19 Wednesday, August 4, 2010 11:57 AM If your system is configured correctly, the following message is displayed: Pre-check for successful. Database installation was 2 From Oracle home, run the DBCA Utility, and start the Oracle Database configuration Assistant. 3 In the Welcome window, select the Oracle Database Real Application Cluster Database, and click Next. 4 In the Operations window, select Create Database, and click Next.
book.book Page 20 Wednesday, August 4, 2010 11:57 AM 9 In the Database File Location window, select the following options: • Storage Type—Automatic Storage Management (ASM). • Storage Location—Use Oracle-Managed Files. • Database Area—Browse and select the disk group that you created to store the database files (databaseDG). 10 In the Recovery Configuration window: a Click Specify Flash Recovery Area. b Browse and select the ASM Disk Group that you created for Flash recovery (flashbackDG).
book.book Page 21 Wednesday, August 4, 2010 11:57 AM 3 Installing Oracle 11g R2 Database (Single Node) This section provides information about completing the initial setup or completing the reinstallation procedures as described in the Oracle Database on Enterprise Linux x86_64 Operating System and Hardware Installation Guide. Configuring the Public Network Ensure that your public network is functioning and that an IP address and host name are assigned to your system.
book.book Page 22 Wednesday, August 4, 2010 11:57 AM Use the fdisk utility to create a partition to store your recovery files.
book.book Page 23 Wednesday, August 4, 2010 11:57 AM Configuring Disks for ASM Using the ORACLEASM Library Driver To configure disks for ASMusing the ORACLEASM library driver: 1 Open a terminal window and log in as root.
book.book Page 24 Wednesday, August 4, 2010 11:57 AM Installing Oracle 11g R2 Standalone Database Using the ext3 File System Installing Oracle Database 11g R2 NOTE: This section assumes that your Oracle Base is /opt/oracle. If not, ensure that you change the software base and location values accordingly. To install Oracle Database 11g R2: 1 Log in as root. 2 Mount the Oracle Database 11g R2 media.
book.book Page 25 Wednesday, August 4, 2010 11:57 AM 12 In the Installation Location window, enter the following information and click Next: • Oracle Base—/opt/app/oracle • Software Location— /opt/app/oracle/product/11.2.0/dbhome_1 13 In the Specify Inventory directory and credentials window, ensure that the full path of the inventory directory is: /opt/oracle/oraInventory In the Specify Operating System group name window, retain the default value, oinstall. Click Next.
book.book Page 26 Wednesday, August 4, 2010 11:57 AM Configuring the Listener To configure the listener: 1 Log in as root user. 2 Start the X Window system by typing: startx 3 In a terminal window, type xhost +. 4 Log in as Oracle user and run the NETCA utility by using the below command: $/bin/netca 5 Accept the default settings and click Next on all the screens to complete the listener configuration.
book.book Page 27 Wednesday, August 4, 2010 11:57 AM 9 In the Database File Locations window, select the following information and click Next: • Storage Type—File System • Storage Location—Use Common Location for all Database files • Database Area—Browse to the location created for database files. For example, /opt/oracle/oradata. 10 In the Recovery Configuration window select the following options and click Next: a Select Specify Flash Recovery Area.
book.book Page 28 Wednesday, August 4, 2010 11:57 AM Installing Oracle 11g R2 Database Using ASM Installing Oracle 11g R2 Grid Infrastructure To install Oracle 11g R2 Grid Infrastructure on a stand-alone server supporting ASM disk groups with stand-alone database installation: 1 Login as root user. 2 Mount the Oracle 11g R2 Grid media. 3 Start the X Window system by typing: Startx 4 Open a terminal window and type xhost +. 5 Log in as Grid user. 6 Start the Oracle Universal Installer.
book.book Page 29 Wednesday, August 4, 2010 11:57 AM • ASM Instance Administrator—asmadmin group. 12 In the Installation Location window, enter the following location information and click Next: • In the Oracle Base field, type: /opt/app/grid • In the Software Location field, type: /opt/app/11.2.
book.book Page 30 Wednesday, August 4, 2010 11:57 AM Installing Oracle Database 11g R2 To install Oracle database 11g R2: NOTE: This section assumes that your Oracle Base is /opt/oracle. If not, ensure that you change the software base and location values accordingly. 1 Log in as root. 2 Mount the Oracle Database 11g R2 media. 3 Start the X Window System by typing: startx 4 Open a terminal window and type: xhost + 5 Log in as oracle. 6 Start the Oracle Universal Installer.
book.book Page 31 Wednesday, August 4, 2010 11:57 AM • Software Location— /opt/app/oracle/product/11.2.0/dbhome_1 13 In the Privileged Operating System Groups window, use the default dba for all two groups and click Next. 14 The Perform Prerequisites checks window displays the minimum required prerequisites checks that have failed. To run the Fixup Scripts: a Log in as root user. b Run the fixup script. c Click OK. 15 In the Summary window, click Finish.
book.book Page 32 Wednesday, August 4, 2010 11:57 AM • Member disks—ORCL:ASM2, where ASM2 is the disk device assigned for database files 6 Repeat step 4 and step 5 to create another disk group named flashbackDG for FRA using ORCL:ASM3. 7 Click Exit to exit the ASM Configuration Assistant.
book.book Page 33 Wednesday, August 4, 2010 11:57 AM c Flash Recovery Area Size—Change the value to the required size. d Select Enable Archiving. 11 In the Database Content window, click Next. 12 In the Initialization Parameters window, select Typical and click Next. 13 In the Database Storage window, click Next. 14 In the Creation Options window, select Create Database, and click Finish. 15 In the Confirmation window, click OK to create the database.
book.