2 Pre-installation Tasks

Checking the Software Requirements on AIX

Check that the required software and patches are installed on the system.

Depending on the products that you intend to install, verify that the following software is installed on the system. The procedure following the table describes how to check these requirements.

bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools

X11.motif.lib

mqm.Client.Bnd
mqm.Server.Bnd

To ensure that the system meets these requirements, follow these steps:

1. To determine which version of AIX is installed, enter the following command:

   # oslevel -r
   
   

   If the operating system version is lower than AIX 5.2.0.0 Maintenance Level 1 (5200-01), upgrade your operating system to this level. AIX 5L version 5.2 maintenance packages are available from the following Web site:

   https://techsupport.services.ibm.com/server/aix.fdc
   
   

2. To determine whether the required filesets are installed and committed, enter a command similar to the following:

   # lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat \ bos.perf.libperfstat bos.perf.proctools
   
   

   If a fileset is not installed and committed, then install it. See your operating system or software documentation for information about installing filesets.

Depending on the products that you intend to install, verify that the following patches are installed on the system. The procedure following the table describes how to check these requirements.

To ensure that the system meets these requirements, follow these steps:

1. To determine whether an APAR is installed, enter a command similar to the following:

   # /usr/sbin/instfix -i -k "IY22854 IY26778 ..."
   
   

   If an APAR is not installed, download it from the following Web site and install it:

   https://techsupport.services.ibm.com/server/aix.fdc
   
   

2. To determine whether a PTF is installed, enter a command similar to the following:

   # lslpp -l -B U489726 U485561 ...
   
   

   If a PTF is not installed, download it from the following Web site and install it:

   https://techsupport.services.ibm.com/server/aix.fdc
   
   

3. If you require a CSD for WebSphere MQ, see the following Web site for download and installation information:

   http://www.ibm.com/software/integration/mqfamily/support/summary/aix.html
   
   

4. To continue completing pre-installation tasks, go to the "Create Required UNIX Groups and User" section.

Checking the Software Requirements on HP-UX

Check that the required software and patches are installed on the system.

Depending on the products that you intend to install, verify that the following software is installed on the system. The procedure following the table describes how to check these requirements.

X11MotifDevKit

MQSERIES.MQM-CL-HPUX
MQSERIES.MQM-SERVER

C-ANSI-C

ACXX

DCE-C-Tools
DCE-CDS-Server
DCE-Core
DCE-CoreAdmin
DCE-CoreTools
DCE-SEC-Server

To ensure that the system meets these requirements, follow these steps:

1. To determine which version of HP-UX is installed, enter the following command:

   # uname -a
   HP-UX hostname B.11.11 U 9000/800 109444686 unlimited-user license
   
   

   In this example, the version of HP-UX 11i is 11.11.

2. To determine whether a bundle, product, or fileset is installed, enter a command similar to the following, where level is bundle, product, or fileset:

   # /usr/sbin/swlist -l level | more
   
   

   If a required bundle, product, or fileset is not installed, you must install it. See your operating system or software documentation for information about installing products.

Depending on the products that you intend to install, verify that the following patches are installed on the system. The procedure following the table describes how to check these requirements.

GOLDAPPS11i
GOLDBASE11i

http://www.hp.com/products1/unix/java/patches/index.html

To ensure that the system meets these requirements, follow these steps:

1. To determine whether the HP-UX 11i Quality Pack is installed, enter the following command:

   # /usr/sbin/swlist -l bundle | grep GOLD
   
   

   If the Quality Pack is not installed, or if the date is before June 2003, download the latest Quality Pack from the following Web site and install it:

   http://www.software.hp.com/SUPPORT_PLUS/qpk.html
   
   

2. To determine whether a patch is installed, enter a command similar to the following:

   # /usr/sbin/swlist -l patch | grep PHSS_28880
   
   

   Alternatively, to list all installed patches, enter the following command:

   # /usr/sbin/swlist -l patch | more
   
   

   If a required patch is not installed, download it from the following Web site and install it:

   http://itresourcecenter.hp.com
   
   

   If the Web site shows a more recent version of the patch, download and install that version.

3. If you require a CSD for WebSphere MQ, see the following Web site for download and installation information:

   http://www.ibm.com/software/integration/mqfamily/support/summary/hpx.html
   

To allow you to successfully relink Oracle products after installing this software, enter the following commands to create required X library symbolic links in the /usr/lib directory:

# cd /usr/lib
# ln -s libX11.3 libX11.sl
# ln -s libXIE.2 libXIE.sl
# ln -s libXext.3 libXext.sl
# ln -s libXhp11.3 libXhp11.sl
# ln -s libXi.3 libXi.sl
# ln -s libXm.4 libXm.sl
# ln -s libXp.2 libXp.sl
# ln -s libXt.3 libXt.sl
# ln -s libXtst.2 libXtst.sl

To continue completing pre-installation tasks, go to the "Create Required UNIX Groups and User" section.

Checking the Software Requirements on Linux

Check that the required software and patches are installed on the system.

Depending on the products that you intend to install, verify that the following software is installed on the system. The procedure following the table describes how to check these requirements.

make-3.79
binutils-2.11.90.0.8-12

gcc-2.96.108.1
openmotif-2.1.30-11

gcc-3.2.3-2
compat-db-4.0.14.5
compat-gcc-7.3-2.96.122
compat-gcc-c++-7.3-2.96.122
compat-libstdc++-7.3-2.96.122
compat-libstdc++-devel-7.3-2.96.122
openmotif-2.2.2-16
setarch-1.3-1 

gcc-3.2.2-38
openmotif-2.2.2-124

MQSeriesClient
MQSeriesServer
MQSeriesRuntime

To ensure that the system meets these requirements, follow these steps:

1. To determine which distribution and version of Linux is installed, enter the following command:

   # cat /etc/issue
   
   

   
   

   Note: Only the distributions and versions listed in the previous table are supported. Do not install the software on other versions of Linux.

   
   

2. On UnitedLinux 1.0 systems only, enter the following command to determine whether Service Pack 3 is installed:

   # uname -r
   2.4.21-138-default
   
   

   This command shows the kernel version (2.4.21-138) and type (default). If the kernel version is less than 2.4.21-138, contact your UnitedLinux vendor for information about obtaining and installing Service Pack 3.

3. To determine whether the required packages are installed, enter a command similar to the following:

   # rpm -q package_name
   
   

   If a package is not installed, install it from your Linux distribution media.

Depending on the products that you intend to install, verify that the following patches are installed on the system. The procedure following the table describes how to check these requirements.

To ensure that the system meets these requirements, follow these steps:

1. On Red Hat Enterprise Linux 2.1 systems only, follow these steps:

   1. To determine whether kernel update RHSA-2003:195-06 or later is installed, enter the following command:

      # uname -r
      2.4.9-e.25
      
      

      This command shows the kernel version (2.4.9) and errata level (e.25). If the errata level is less than 25, install the latest kernel update. See the following Web site for information about kernel update RHSA-2003:195-06:

      https://rhn.redhat.com/errata/RHSA-2003-195.html
      
      

   2. To determine whether fix RHSA-2003:022-09 is installed, enter the following command:

      # rpm -q glibc
      glibc-2.2.4-31
      
      

      If the version shown is less than 2.2.4-31, see the following Web site for information about fix RHSA-2003:022-09:

      https://rhn.redhat.com/errata/RHSA-2003-022.html
      
      

2. If you require a CSD for WebSphere MQ, see the following Web site for download and installation information:

   http://www.ibm.com/software/integration/mqfamily/support/summary/lin.html
   
   

3. To continue completing pre-installation tasks, go to the "Create Required UNIX Groups and User" section.

Checking the Software Requirements on Solaris

Check that the required software and patches are installed on the system.

Depending on the products that you intend to install, verify that the following software is installed on the system. The procedure following the table describes how to check these requirements.

SUNWarc
SUNWbtool
SUNWhea
SUNWlibm
SUNWlibms
SUNWsprot
SUNWsprox
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt

http://java.sun.com/j2se/1.4.2/font-requirements.html

mqm

To ensure that the system meets these requirements, follow these steps:

1. To determine which version of Solaris is installed, enter the following command:

   # uname -r
   
   

   If the operating system version is lower than Solaris 8 (5.8), upgrade your operating system to this level.

2. To determine whether the required packages are installed, enter a command similar to the following:

   # pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot \ SUNWsprox SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt
   
   

   If a package is not installed, then install it. See your operating system or software documentation for information about installing packages.

Depending on the products that you intend to install, verify that the following patches are installed on the system. The procedure following the table describes how to check these requirements.

To ensure that the system meets these requirements, follow these steps:

1. To determine whether an operating system patch is installed, enter a command similar to the following:

   # /usr/sbin/patchadd -p | grep patch_number
   
   

   If an operating system patch is not installed, download it from the following Web site and install it:

   http://sunsolve.sun.com
   
   

2. If you require a CSD for WebSphere MQ, see the following Web site for download and installation information:

   http://www.ibm.com/software/integration/mqfamily/support/summary/sun.html
   
   

3. To continue completing pre-installation tasks, go to the "Create Required UNIX Groups and User" section.

Checking the Software Requirements on Tru64 UNIX

Check that the required software and patches are installed on the system.

Depending on the products that you intend to install, verify that the following software is installed on the system. The procedure following the table describes how to check these requirements.

OSFCMPLRS
OSFLIBA
OSFPGMR
OSFSER
OSFX11

DCECDS
DECRTS
DCESEC

OSFXDEVX
OSFXINCLUDE
OSFXLIBA

MQS_CLIENT
MQS_SERVER

MQS_MQJAVA

DTCCMPLR

CXXBASE
CXXLIB
CXXOLD

To ensure that the system meets these requirements, follow these steps:

1. To determine which version of Tru64 UNIX is installed, enter the following command:

   # /usr/sbin/sizer -v
   Compaq Tru64 UNIX V5.1B (Rev. 2650); Mon Nov  3 10:13:28 PST 200 
   
   

   In this example, the version shown is V5.1B. If necessary, see your operating system documentation for information about upgrading the operating system.

2. To determine whether Java SDK 1.4.2 is installed, enter the following command:

   # /usr/sbin/setld -i JAVA142 | more
   
   

   If Java SDK 1.4.2 is installed, this command displays the paths to all of the installed files. Note the path of the Java home directory. You must specify this value during the installation. The default path is:

   /usr/opt/java142
   
   

   If this command returns the message Unknown subset, Java SDK 1.4.2 is not installed. Download Java SDK 1.4.2.01 or higher from the following Web site and install it:

   http://www.compaq.com/java/download/index.html
   
   

3. To determine whether the required software subsets are installed, enter one of the following commands:

   • To view the list of all software subsets installed on the system, enter the following command:

     # /usr/sbin/setld -i | more
     
     

   • To determine whether a particular software subset is installed, enter a command similar to the following:

     # /usr/sbin/setld -i | grep subsetname
     
     

   If necessary, install the required software subset. If you require the Compaq C Compiler V6.5-207 (dtk), you can download it from the following Web site:

   http://www.tru64unix.compaq.com/dtk/
   
   

4. If you intend to use Oracle Messaging Gateway and require MQSeries classes for Java and MQSeries classes for Java Message Service (SupportPac MA88), download it from the following Web site:

   http://www.ibm.com/software/integration/support/supportpacs/individual/ma88.html
   

Depending on the products that you intend to install, verify that the following patches are installed on the system. The procedure following the table describes how to check these requirements.

T64V51BB22AS0002-20030415

T64KIT0020879-V51BB22-E-20031125

To determine whether the required patch kits are installed, enter the following command:

# /usr/sbin/dupatch -track -type kit

If this command does not display the identifiers shown in the previous table for the required patch kits (or the identifier for a higher patch kit level), download the latest patch kit from the following Web site and install it (registration is required to access this Web site):

http://itrc.hp.com/service/patch/mainPage.do

If you require a CSD for MQSeries, see the following Web site for download and installation information:

http://www.ibm.com/software/integration/mqfamily/support/summary/dig.html

Creating the Oracle Inventory Group

You must create the Oracle Inventory group if it does not already exist. The following subsections describe how to determine the Oracle Inventory group name, if it exists, and how to create it if necessary.

When you install Oracle software on the system for the first time, the Installer creates the oraInst.loc file. This file identifies the name of the Oracle Inventory group and the path of the Oracle Inventory directory. To determine whether the Oracle Inventory group exists, enter the following command:

• AIX or Linux:

  # more /etc/oraInst.loc
  
  

• Other operating systems:

  # more /var/opt/oracle/oraInst.loc
  
  

If the oraInst.loc file exists, the output from this command is similar to the following:

inventory_loc=/u01/app/oracle/oraInventory
inst_group=oinstall

The inst_group parameter shows the name of the Oracle Inventory group (oinstall).

If the oraInst.loc file does not exist, create the Oracle Inventory group as follows, depending on your operating system:

• AIX:

  1. Enter the following command:

     # smit security
     
     

  2. Choose the appropriate menu items to create the oinstall group.

  3. Press F10 to exit.

• Other operating systems:

  Enter the following command to create the oinstall group:

  # /usr/sbin/groupadd oinstall
  
  

Creating the OSDBA Group

You must create an OSDBA group in the following circumstances:

• An OSDBA group does not exist, for example, if this is the first installation of Oracle Database software on the system

• An OSBDA group exists, but you want to give a different group of UNIX users database administrative privileges in a new Oracle installation

If the OSDBA group does not exist or if you require a new OSDBA group, create it as follows, depending on your operating system. In the following procedure, use the group name dba unless a group with that name already exists.

• AIX:

  1. Enter the following command:

     # smit security
     
     

  2. Choose the appropriate menu items to create the dba group.

  3. Press F10 to exit.

• Other operating systems:

  Enter the following command to create the dba group:

  # /usr/sbin/groupadd dba
  

Creating an OSOPER Group (Optional)

Create an OSOPER group only if you want to identify a group of UNIX users with a limited set of database administrative privileges (SYSOPER operator privileges). For most installations, it is sufficient to create only the OSDBA group. If you want to use an OSOPER group, you must create it in the following circumstances:

• If an OSOPER group does not exist, for example, if this is the first installation of Oracle Database software on the system

• If an OSOPER group exists, but you want to give a different group of UNIX users database operator privileges in a new Oracle installation

If you require an new OSOPER group, create it as follows, depending on your operating system. In the following procedure, use the group name oper unless a group with that name already exists.

• AIX:

  1. Enter the following command:

     # smit security
     
     

  2. Choose the appropriate menu items to create the oper group.

  3. Press F10 to exit.

• Other operating systems:

  Enter the following command to create the oper group:

  # /usr/sbin/groupadd oper
  
  

Creating the Oracle Software Owner User

You must create an Oracle software owner user in the following circumstances:

• If an Oracle software owner user does not exist, for example, if this is the first installation of Oracle software on the system

• If an Oracle software owner user exists, but you want to use a different UNIX user, with different group membership, to give database administrative privileges to those groups in a new Oracle Database installation

To determine whether an Oracle software owner user named oracle exists, enter one of the following commands:

• Solaris:

  # id -a oracle
  
  

• Other operating systems:

  # id oracle
  
  

If the oracle user exists, the output from this command is similar to the following:

uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)

If the user exists, determine whether you want to use the existing user or create a new user. If you want to use the existing user, ensure that the user’s primary group is the Oracle Inventory group and that it is a member of the appropriate OSDBA and OSOPER groups. See one of the following sections for more information:

• If you want to use the existing Oracle software owner user, and the user’s primary group is the Oracle Inventory group, see one of the following sections:

  • HP-UX Only: Creating an Unprivileged User

  • Verifying That the UNIX User nobody Exists

• To modify an existing user, see the "Modify an Existing Oracle Software Owner User" section.

• To create a new user, see the following section.

If the Oracle software owner user does not exist or if you require a new Oracle software owner user, create it as follows, depending on your operating system. In the following procedure, use the user name oracle unless a user with that name already exists.

• AIX:

  1. Enter the following command:

     # smit security
     
     

  2. Choose the appropriate menu items to create the oracle user, specifying the following information:

     • In the Primary GROUP field, specify the Oracle Inventory group, for example oinstall.

     • In the Group SET field, specify the OSDBA group and if required, the OSOPER group, for example dba or dba,oper.

     
     

     Note: The UID for the oracle user must be less than 65536.

     
     

  3. Press F10 to exit.

  4. Set the password of the oracle user:

     # passwd oracle
     
     

• Other operating systems:

  1. To create the oracle user, enter a command similar to the following:

     # /usr/sbin/useradd -g oinstall -G dba[,oper] oracle
     
     

     In this command:

     • The -g option specifies the primary group, which must be the Oracle Inventory group, for example oinstall

     • The -G option specifies the secondary groups, which must include the OSDBA group and if required, the OSOPER group, for example dba or dba,oper

  2. Set the password of the oracle user:

     # passwd oracle
     
     

See one of the following sections to continue:

• HP-UX Only: Creating an Unprivileged User

• Verifying That the UNIX User nobody Exists

If the oracle user exists, but its primary group is not oinstall or it is not a member of the appropriate OSDBA or OSOPER groups, you can modify it as follows depending on your operating system:

• AIX:

  1. Enter the following command:

     # smit security
     
     

  2. Choose the appropriate menu items to modify the oracle user.

  3. In the Primary GROUP field, specify the Oracle Inventory group, for example oinstall.

  4. In the Group SET field, specify the secondary groups, for example dba and oper.

  5. Press F10 to exit.

• Other operating systems:

  Enter a command similar to the following, specifying the primary group using the -g option and any required secondary groups using the -G option:

  # /usr/sbin/usermod -g oinstall -G dba[,oper] oracle
  
  

HP-UX Only: Creating an Unprivileged User

You must create an new unprivileged local user to own the extjob executable. You can use any user name for this user, but this document uses the name extjob. To create the extjob user, enter the following command on all cluster nodes:

# /usr/sbin/useradd extjob

To continue, see the "HP-UX Only: Grant Privileges to the OSDBA Group" section.

Verifying That the UNIX User nobody Exists

Before installing the software, verify that the UNIX user nobody exists on the system:

1. To determine whether the user exists, enter the following command:

   # id nobody
   
   

   If this command displays information about the nobody user, you do not have to create that user.

2. If the nobody user does not exist, enter the one of the following commands to create it:

   • AIX:

     # smit security
     
     

     Specify the appropriate options to create an unprivileged nobody user, then press F10 to exit.

   • Other operating systems:

     # /usr/sbin/useradd nobody
     
     

HP-UX Only: Grant Privileges to the OSDBA Group

To enhance the performance of the software on HP-UX systems, you must grant several system privileges to the OSDBA group. Complete the following steps if you are installing the software on HP-UX:

1. Using any text editor, open the /etc/privgroup file, or create it if necessary.

2. Add or edit the following line, which begins with the name of the OSDBA group, specifying the privileges MLOCK, RTPRIO, and RTSCHED, that you want to grant to this group every time the system reboots:

   dba MLOCK RTPRIO RTSCHED
   
   

3. Save the file and exit from the text editor.

4. Enter the following command to grant the privileges to the OSDBA group:

   # /usr/sbin/setprivgrp -f /etc/privgroup
   
   

5. Enter the following command to verify that the privileges are set correctly:

   # /usr/sbin/getprivgrp dba
   
   

Configuring Shell Limits and System Configuration Parameters on AIX

On AIX systems, you do not need to configure kernel parameters. However, Oracle recommends that you set shell limits and system configuration parameters as described in this section.

Verify that the shell limits shown in the following table are set to the values shown. The procedure following the table describes how to verify and set the values.

To view the current value specified for these shell limits, and to change them if necessary, follow these steps:

1. Enter the following command:

   # smit chuser
   
   

2. In the User NAME field, enter the user name of the Oracle software owner, for example oracle.

3. Scroll down the list and verify that the value shown for the soft limits listed in the previous table is -1.

   If necessary, edit the existing value.

4. When you have finished making changes, press F10 to exit.

Verify that the maximum number of processes allowed per user is set to 2048 or greater. The procedure following the table describes how to verify and set the value.

1. Enter the following command:

   # smit chgsys
   
   

2. Verify that the value shown for Maximum number of PROCESSES allowed per user is greater than or equal to 2048.

   If necessary, edit the existing value.

3. When you have finished making changes, press F10 to exit.

Configuring Kernel Parameters on HP-UX

Verify that the kernel parameters shown in the following table are set either to the formula shown, or to values greater than or equal to the recommended value shown. The procedure following the table describes how to verify and set the values.

To view the current value or formula specified for these kernel parameters, and to change them if necessary, follow these steps:

1. Optionally, set the DISPLAY environment variable to specify the display of the local system:

   • Bourne, Bash, or Korn shell:

     $ DISPLAY=local_host:0.0 ; export DISPLAY
     
     

   • C shell:

     % setenv DISPLAY local_host:0.0
     
     

2. Start System Administration Manager (SAM):

   # /usr/sbin/sam
   
   

3. Choose the Kernel Configuration area, then choose the Configurable Parameters area.

4. Check the value or formula specified for each of these parameters and, if necessary, modify that value or formula.

   If necessary, see the SAM online help for more information about completing this step.

5. Exit from SAM.

   If you modified the value specified for any static parameter, you must rebuild the kernel and reboot the system.

6. If necessary, when the system restarts, log in and switch user to root.

7. To continue completing pre-installation tasks, go to the "Identify Required Software Directories" section.

Configuring Kernel Parameters on Linux

Verify that the kernel parameters shown in the following table are set to values greater than or equal to the recommended value shown. The procedure following the table describes how to verify and set the values.

To view the current value specified for these kernel parameters, and to change them if necessary, follow these steps:

1. Enter the commands shown in the following to view the current values of the kernel parameters:

   
   

   Note: Make a note of the current values and identify any values that you must change.

   
   

   Parameter	Command
   semmsl, semmns, semopm, and semmni	# /sbin/sysctl -a | grep sem This command displays the value of the semaphore parameters in the order listed.
   shmall, shmmax, and shmmni	# /sbin/sysctl -a | grep shm
   file-max	# /sbin/sysctl -a | grep file-max
   ip_local_port_range	# /sbin/sysctl -a | grep ip_local_port_range This command displays a range of port numbers.

   
   

2. If the value of any kernel parameter is different to the recommended value, complete the following steps:

   1. Using any text editor, create or edit the /etc/sysctl.conf file and add or edit lines similar to the following:

      
      

      Note: Include lines only for the kernel parameter values that you want to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the recommended value, specify the larger value.

      
      

      kernel.shmall = 2097152
      kernel.shmmax = 2147483648
      kernel.shmmni = 4096
      kernel.sem = 250 32000 100 128
      fs.file-max = 65536
      net.ipv4.ip_local_port_range = 1024 65000
      
      

      By specifying the values in the /etc/sysctl.conf file, they persist when you reboot the system.

   2. Enter the following command to change the current values of the kernel parameters:

      # /sbin/sysctl -p
      
      

      Review the output from this command to verify that the values are correct. If the values are incorrect, edit the /etc/sysctl.conf file, then enter this command again.

   3. On UnitedLinux only, enter the following command to cause the system to read the /etc/sysctl.conf file when it reboots:

      # /sbin/chkconfig boot.sysctl on
      
      

To improve the performance of the software on Linux systems, you must increase the following shell limits for the oracle user:

To increase the shell limits:

1. Add the following lines to /etc/security/limits.conf file:

   *               soft    nproc   2047
   *               hard    nproc   16384
   *               soft    nofile  1024
   *               hard    nofile  65536
   
   

2. Add the following line to the /etc/pam.d/login file, if it does not already exist:

   session    required     /lib/security/pam_limits.so
   
   

3. Depending on the oracle user's default shell, make the following changes to the default shell start-up file:

   • For the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile file (or the /etc/profile.local file on UnitedLinux systems):

     if [ $USER = "oracle" ]; then
             if [ $SHELL = "/bin/ksh" ]; then
                   ulimit -p 16384
                   ulimit -n 65536
             else
                   ulimit -u 16384 -n 65536
             fi
     fi
     
     

   • For the C or tcsh shell, add the following lines to the /etc/csh.login file (or the /etc/csh.login.local file on UnitedLinux systems):

     if ( $USER == "oracle" ) then
             limit maxproc 16384
             limit descriptors 65536
     endif
     
     

4. To continue completing pre-installation tasks, go to the "Identify Required Software Directories" section.

Configuring Kernel Parameters on Solaris

Verify that the kernel parameters shown in the following table are set to values greater than or equal to the recommended value shown. The procedure following the table describes how to verify and set the values.

To view the current value specified for these kernel parameters, and to change them if necessary, follow these steps:

1. To view the current values of these parameters, enter the following commands:

   # grep noexec_user_stac /etc/system
   # /usr/sbin/sysdef | grep SEM
   # /usr/sbin/sysdef | grep SHM
   
   

2. If you must change any of the current values, follow these steps:

   1. Create a backup copy of the /etc/system file, for example:

      # cp /etc/system /etc/system.orig
      
      

   2. Open the /etc/system file in any text editor and, if necessary, add lines similar to the following (edit the lines if the file already contains them):

      set noexec_user_stack=1
      set semsys:seminfo_semmni=100
      set semsys:seminfo_semmns=1024
      set semsys:seminfo_semmsl=256
      set semsys:seminfo_semvmx=32767
      set shmsys:shminfo_shmmax=4294967295
      set shmsys:shminfo_shmmin=1
      set shmsys:shminfo_shmmni=100
      set shmsys:shminfo_shmseg=10
      
      

   3. Enter the following command to reboot the system:

      # /usr/sbin/reboot
      
      

   4. When the system restarts, log in and switch user to root.

3. To continue completing pre-installation tasks, go to the "Identify Required Software Directories" section.

Configure Kernel Subsystem Attributes on Tru64 UNIX

Verify that the kernel subsystem attributes shown in the following table are set to values greater than or equal to the recommended value shown. The procedure following the table describes how to verify and set the values.

To view the current value specified for these kernel subsystem attributes, and to change them if necessary, follow these steps:

1. To view the current values of the subsystem attributes, enter commands similar to the following:

   # /sbin/sysconfig -q subsystem
   
   

   For example, to view attribute values for the ipc subsystem, enter the following command:

   # /sbin/sysconfig -q ipc
   
   

2. If you must change any of the current values, follow these steps:

   1. Create a backup copy of the /etc/sysconfigtab file, for example:

      # cp /etc/sysconfigtab /etc/sysconfigtab.orig
      
      

   2. Using any text editor, create a file similar to the following, specifying the subsystems and attributes that you want to modify:

      ipc:
           shm_max = 4278190080
           shm_min = 1
           shm_mni = 256
           shm_seg = 128
      
      proc:
           per_proc_stack_size = 8388608
           max_per_proc_stack_size = 33554432
           per_proc_data_size = 201326592
           max_per_proc_data_size = 201326592
           max_per_proc_address_space = 4294967296
           per_proc_address_space = 4294967296
      
      

   3. Enter a command similar to the following to add the subsystem attributes to the /etc/sysconfigtab file:

      # /sbin/sysconfigdb -m -f filename
      
      

      In this example, filename is the name of the file you created in step b.

   4. Enter the following command to reboot the system:

      # /sbin/shutdown -r now
      
      

   5. When the system restarts, log in and switch user to root.

Identifying Storage Requirements for ASM

To identify the storage requirements for using ASM, you must determine how many devices and the amount of free disk space that you require. To complete this task, follow these steps:

1. Determine whether you want to use ASM for Oracle database files (datafiles), recovery files, or both.

   
   

   Note: You do not have to use the same storage mechanism for database files and recovery files. One can use the file system, while the other uses ASM.

   
   

   If you enable automated backups during the installation, you can choose ASM as the storage mechanism for recovery files by specifying an ASM disk group for the flash recovery area. Depending how you choose to create a database during the installation, you have the following options:

   • If you select an installation method that runs DBCA in interactive mode, by choosing the Advanced database configuration option for example, you can decide whether you want to use the same ASM disk group for datafiles and recovery files, or you can choose to use different disk groups for each file type.

     The same choice is available to you if you use DBCA after the installation to create a database.

   • If you select an installation type that runs DBCA in non-interactive mode, you must use the same ASM disk group for database files and recovery files.

2. Choose the ASM redundancy level that you want to use for the ASM disk group.

   The redundancy level that you choose for the ASM disk group determines how ASM mirrors files in the disk group and determines the number of disks and amount of disk space that you require, as follows:

   • External redundancy

     An external redundancy disk group requires a minimum of one disk device. The effective disk space in an external redundancy disk group is the sum of the disk space in all of its devices.

     Because ASM does not mirror data in an external redundancy disk group, Oracle recommends that you use only RAID or similar devices that provide their own data protection mechanisms as disk devices in this type of disk group.

   • Normal redundancy

     In a normal redundancy disk group, ASM uses two-way mirroring by default, to increase performance and reliability. A normal redundancy disk group requires a minimum of two disk devices (or two failure groups). The effective disk space in a normal redundancy disk group is half the sum of the disk space in all of its devices.

     For most installations, Oracle recommends that you use normal redundancy disk groups.

   • High redundancy

     In a high redundancy disk group, ASM uses three-way mirroring to increase performance and provide the highest level of reliability. A high redundancy disk group requires a minimum of three disk devices (or three failure groups). The effective disk space in a high redundancy disk group is one-third the sum of the disk space in all of its devices.

     While high redundancy disk groups do provide a high level of data protection, you must consider the higher cost of additional storage devices before deciding to use this redundancy level.

3. Determine the total amount of disk space that you require for the datafiles and recovery files.

   Use the following table to determine the minimum number of disks and the minimum disk space requirements for the installation:

   Redundancy Level	Minimum Number of Disks	Datafiles	Recovery FIles	Both File Types
   External	1	1.15 GB	2.3 GB	3.45 GB
   Normal	2	2.3 GB	4.6 GB	6.9 GB
   High	3	3.45 GB	6.9 GB	10.35 GB

   
   

   If an existing ASM instance exists on the system, you can use an existing disk group to meet these storage requirements. If necessary, you can add disks to an existing disk group during the installation.

   The following section describes how to identify existing disk groups and determine the free disk space that they contain.

4. Optionally identify failure groups for the ASM disk group devices.

   
   

   Note: You need to complete this step only if you intend to use an installation method that runs DBCA in interactive mode, for example, if you intend to choose the Custom installation type or the Advanced database configuration option. Other installation types do not enable you to specify failure groups.

   
   

   If you intend to use a normal or high redundancy disk group, you can further protect your database against hardware failure by associating a set of disk devices in a custom failure group. By default, each device comprises its own failure group. However, if two disk devices in a normal redundancy disk group are attached to the same SCSI controller, the disk group becomes unavailable if the controller fails. The controller in this example is a single point of failure.

   To avoid failures of this type, you could use two SCSI controllers, each with two disks, and define a failure group for the disks attached to each controller. This configuration would enable the disk group to tolerate the failure of one SCSI controller.

   
   

   Note: If you define custom failure groups, you must specify a minimum of two failure groups for normal redundancy disk groups and three failure groups for high redundancy disk groups.

   
   

5. If you are sure that a suitable disk group does not exist on the system, install or identify appropriate disk devices to add to a new disk group. Use the following guidelines when identifying appropriate disk devices:

   • All of the devices in an ASM disk group should be the same size and have the same performance characteristics.

   • Do not specify more than one partition on a single physical disk as a disk group device. ASM expects each disk group device to be on a separate physical disk.

   • Although you can specify a logical volume as a device in an ASM disk group, Oracle does not recommend their use. Logical volume managers can hide the physical disk architecture, preventing ASM from optimizing I/O across the physical devices.

   For information about completing this task, see the "Configuring Disks for ASM" section.

Using an Existing ASM Disk Group

If you want to use ASM as the storage option for either database or recovery files, and an existing ASM disk group exists, you have the following choices, depending on the installation method that you select:

• If you select an installation method that runs DBCA in interactive mode, by choosing the Advanced database configuration option for example, you can decide whether you want to create a new disk group or use an existing one.

  The same choice is available to you if you use DBCA after the installation to create a database.

• If you select an installation type that runs DBCA in non-interactive mode, you must choose an existing disk group for the new database; you cannot create a new disk group. However, you can add disk devices to an existing disk group if it has insufficient free space for your requirements.

To determine whether an existing ASM disk group exists, or to determine whether there is sufficient disk space in a disk group, you can use Oracle Enterprise Manager Database Grid Control or Database Control. Alternatively, you can use the following procedure:

1. View the contents of the oratab file to determine whether an ASM instance is configured on the system:

   • Solaris:

     # more /var/opt/oracle/oratab
     
     

   • Other operating systems:

     # more /etc/oratab
     
     

   If an ASM instance is configured on the system, the oratab file should contain a line similar to the following:

   +ASM:oracle_home_path:N
   
   

   In this example, +ASM is the system identifier (SID) of the ASM instance and oracle_home_path is the Oracle home directory where it is installed. By convention, the SID for an ASM instance begins with a plus sign.

2. Set the ORACLE_SID and ORACLE_HOME environment variables to specify the appropriate values for the ASM instance that you want to use.

3. Connect to the ASM instance as the SYS user with SYSDBA privilege and start the instance if necessary:

   # $ORACLE_HOME/bin/sqlplus "SYS/SYS_password as SYSDBA"
   SQL> STARTUP
   
   

4. Enter the following command to view the existing disk groups, their redundancy level, and the amount of free disk space in each one:

   SQL> SELECT NAME,TYPE,TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;
   
   

5. From the output, identify a disk group with the appropriate redundancy level and note the free space that it contains.

6. If necessary, install or identify the additional disk devices required to meet the storage requirements listed in the previous section.

   
   

   Note: If you are adding devices to an existing disk group, Oracle recommends that you use devices that have the same size and performance characteristics as the existing devices in that disk group.

   
   

Configuring Disks for ASM

The following sections describe how to configure the disks that you want to use in an ASM disk group. It includes information about the following:

• Configuring Disks for ASM on AIX

• Configuring Disks for ASM on HP-UX

• Configuring Disks for ASM on Linux

• Configuring Disks for ASM on Solaris

• Configuring Disks for ASM on Tru64 UNIX

Configuring Disks for ASM on AIX

To configure disks for use with ASM on AIX, follow these steps:

1. If necessary, install the disks that you intend to use for the ASM disk group and reboot the system.

2. To make sure that the disks are available, enter the following command:

   # /usr/sbin/lsdev -Cc disk
   
   

   The output from this command is similar to the following:

   hdisk0 Available 1A-09-00-8,0  16 Bit LVD SCSI Disk Drive
   hdisk1 Available 1A-09-00-9,0  16 Bit LVD SCSI Disk Drive
   hdisk2 Available 17-08-L       SSA Logical Disk Drive
   
   

3. If a disk is not listed as available, enter the following command to configure the new disks:

   # /usr/sbin/cfgmgr
   
   

4. To determine which disks are configured in a volume group, enter the following command:

   # /usr/sbin/lspv
   
   

   The output from this command is similar to the following:

   hdisk0     0000078752249812   rootvg
   hdisk1     none               none
   
   

   For each disk, this command shows:

   • The disk device name

   • Either the 16 character physical volume identifier (PVID) if the disk has one, or none

   • Either the volume group to which the disk belongs, or none

   The disks that you want to use might have a PVID, but they must not belong to a volume group.

5. If the disks that you want to use for the disk group do not have PVIDs, enter a command similar to the following for each disk that you want to use:

   # /usr/sbin/chdev -l hdiskn -a pv=yes
   
   

6. Enter commands similar to the following to change the owner, group, and permissions on the character raw device file for each disk that you want to add to the disk group:

   # chown oracle:dba /dev/rhdiskn
   # chmod 660 /dev/rhdiskn
   
   

Configuring Disks for ASM on HP-UX

To configure disks for use with ASM on HP-UX, follow these steps:

1. If necessary, install the disks that you intend to use for the ASM disk group.

2. To make sure that the disks are available, enter the following command:

   # /usr/sbin/ioscan -fun -C disk
   
   

   The output from this command is similar to the following:

   Class  I  H/W Path    Driver S/W State   H/W Type     Description
   ==========================================================================
   disk    0  0/0/1/0.6.0 sdisk  CLAIMED     DEVICE       HP   DVD-ROM 6x/32x
                          /dev/dsk/c0t6d0   /dev/rdsk/c0t6d0
   disk    1  0/0/1/1.2.0 sdisk  CLAIMED     DEVICE      SEAGATE ST39103LC
                          /dev/dsk/c1t2d0   /dev/rdsk/c1t2d0
   
   

   This command displays information about each disk attached to the system, including the block device name (/dev/dsk/cxtydz) and the character raw device name (/dev/rdsk/cxtydz).

   If this command does not display device name information, enter the following command to install the special device files:

   # /usr/sbin/insf -e
   
   

3. For each disk that you want to add to a disk group, enter the following command to verify that it is not already part of an LVM volume group:

   # /sbin/pvdisplay /dev/dsk/cxtydz
   
   

   If this command displays volume group information, the disk is already part of a volume group. The disks that you choose must not be part of an LVM volume group.

   
   

   Note: If you are using different volume management software, for example VERITAS Volume Manager, see the appropriate documentation for information about verifying that a disk is not in use.

   
   

4. Enter commands similar to the following to change the owner, group, and permissions on the character raw device file for each disk that you want to add to a disk group:

   # chown oracle:dba /dev/rdsk/cxtydz
   # chmod 660 /dev/rdsk/cxtydz
   
   

   
   

   Note: If you are using a multi-pathing disk driver with ASM, ensure that you set the permissions only on the correct logical device name for the disk.

   
   

Configuring Disks for ASM on Linux

On Linux systems, Oracle provides an ASM library driver that you can use to improve the I/O performance of databases that use ASM for storage management. If you intend to use ASM for database storage on Linux, Oracle recommends that you install the ASM library driver and associated utilities and use them to configure the devices that you want to include in an ASM disk group. If you do not use the ASM library driver, you must bind each disk device that you want to use to a raw device. The following sections describe how to configure disks using both methods:

• Configuring Disks for ASM Using the ASM Library Driver

• Configuring Disks for ASM Using Raw Devices

configure

# /etc/init.d/oracleasm configure

enable
disable

# /etc/init.d/oracleasm enable

start
stop
restart

# /etc/init.d/oracleasm restart

createdisk

# /etc/init.d/oracleasm createdisk diskname devicename

deletedisk

# /etc/init.d/oracleasm deletedisk diskname

querydisk

# /etc/init.d/oracleasm querydisk {diskname | devicename}

listdisks

# /etc/init.d/oracleasm listsdisks

scandisks

# /etc/init.d/oracleasm scandisks

Configuring Disks for ASM on Solaris

To configure disks for use with ASM on Solaris, follow these steps:

1. If necessary, install the disks that you intend to use for the disk group and reboot the system.

2. To make sure that the disks are available, enter the following command:

   # /usr/sbin/format
   
   

   The output from this command is similar to the following:

   AVAILABLE DISK SELECTIONS:
          0. c0t0d0 <ST34321A cyl 8892 alt 2 hd 15 sec 63>
             /pci@1f,0/pci@1,1/ide@3/dad@0,0
          1. c1t5d0 <SUN9.0G cyl 4924 alt 2 hd 27 sec 133>
             /pci@1f,0/pci@1/scsi@1/sd@5,0
   
   

   This command displays information about each disk attached to the system, including the device name (cxtydz).

3. From the list, identify the device names for the disk devices that you want to add to a disk group, then press Ctrl/D to exit from the format utility.

4. Enter the following command to verify that the device you identified is not mounted as a file system:

   # df -k
   
   

   This command displays information about the partitions (slices) on disk devices that are mounted as file systems. The device name for a slice includes the disk device name, followed by the slice number, for example cxtydzsn, where sn is the slice number. Slice 6 (s6) represents the entire disk. The disk devices that you choose must not be shown as mounted partitions.

5. Enter the following commands to verify that the device you identified is not already part of an logical volume manager (LVM) disk group:

   
   

   Note: The following command displays information about VERITAS Volume Manager disks. If you use a different LVM, see the appropriate documentation for information about determining which disk devices it is managing.

   
   

   # vxdiskconfig
   # /usr/sbin/vxdisk list
   
   

   If this command displays disk group information associated with a disk device, the disk is already part of a disk group. The disks that you choose must not be part of a disk group.

6. Enter commands similar to the following to change the owner, group, and permissions on the character raw device file for each disk that you want to add to a disk group:

   # chown oracle:dba /dev/rdsk/cxtydzs6
   # chmod 660 /dev/rdsk/cxtydzs6
   
   

   In this example, the device name specifies slice 6, which represents the entire disk.

   
   

   Note: If you are using a multi-pathing disk driver with ASM, ensure that you set the permissions only on the correct logical device name for the disk.

   
   

Configuring Disks for ASM on Tru64 UNIX

To configure disks for use with ASM on Tru64 UNIX, follow these steps:

1. If necessary, install the disks that you intend to use for the disk group and reboot the system.

2. To make sure that the disks are available, enter the following command:

   # file /dev/rdisk/dsk*c
   
   

   The output from this command is similar to the following:

   /dev/rdisk/dsk0c:       character special (19/38) SCSI #1 "RZ1CB-CA" disk #2
              (SCSI ID #1) (SCSI LUN #0)
   /dev/rdisk/dsk10c:   character special (19/218) SCSI #2 "RZ1DB-CS" disk #4
              (SCSI ID #2) (SCSI LUN #0)
   /dev/rdisk/dsk11c:   character special (19/234) SCSI #2 "RZ1DB-CS" disk #5
              (SCSI ID #3) (SCSI LUN #0)
   /dev/rdisk/dsk12c:   character special (19/250) SCSI #2 "RZ1DB-CS" disk #6
              (SCSI ID #4) (SCSI LUN #0) 
   
   

   This command displays information about each disk attached to the system, including the raw character device name for partition c, which represents the entire disk (/dev/rdisk/dsknc).

3. From the list, identify the device names for the disk devices that you want to add to a disk group.

4. To determine whether the disk is unused, enter a command similar to the following:

   # /sbin/disklabel dskn
   
   

   This command displays information about the partitions on the disk, and identifies whether they are in use.

5. Enter the following command to verify that the device you identified is not used in an AdvFS domain:

   # ls /etc/fdmns/*/*
   
   

   This command displays information about the devices included in AdvFS domains in the following format, identifying the domains and the disks associated with each domain:

   /etc/fdmns/domain_name/dsknp
   
   

   In this example, domain_name is the name of the domain, n is the disk number, and p is the partition letter.

6. Enter the following command to verify that the device is not mounted as a UFS file system:

   # /sbin/mount
   
   

   The device you want to add to the ASM disk group must not be listed in the output.

7. Enter the following command to verify that the device you identified is not already part of a Tru64 UNIX Logical Storage Manager (LSM) disk group:

   # /sbin/voldisk list
   
   

   Disks listed without DISK and GROUP names, and with a status of unknown are not LSM disks.

8. Enter commands similar to the following to change the owner, group, and permissions on the character raw device file for each disk that you want to add to a disk group:

   # chown oracle:dba /dev/rdisk/rdsknc
   # chmod 660 /dev/rdisk/rdsknc
   
   

   In this example, the device name specifies partition c, which represents the entire disk.

   
   

   Note: If you are using a multi-pathing disk driver with ASM, ensure that you set the permissions only on the correct logical device name for the disk.

   
   

Configuring Raw Logical Volumes on AIX

The following subsections describe how to configure raw logical volumes on AIX.

To create a volume group for the Oracle database files, follow these steps:

1. If necessary, install the disks that you intend to use.

2. To make sure that the disks are available, enter the following command:

   # /usr/sbin/lsdev -Cc disk
   
   

   The output from this command is similar to the following:

   hdisk0 Available 1A-09-00-8,0  16 Bit LVD SCSI Disk Drive
   hdisk1 Available 1A-09-00-9,0  16 Bit LVD SCSI Disk Drive
   hdisk2 Available 17-08-L       SSA Logical Disk Drive
   
   

3. If a disk is not listed as available, enter the following command to configure it:

   # /usr/sbin/cfgmgr
   
   

4. To determine whether the disks are configured in a volume group, enter the following command:

   # /usr/sbin/lspv
   
   

   The output from this command is similar to the following:

   hdisk0     0000078752249812   rootvg
   hdisk1     none               none
   hdisk4     00034b6fd4ac1d71   ccvg1
   
   

   For each disk, this command shows:

   • The disk device name

   • Either the 16 character physical volume identifier (PVID) if the disk has one, or none

   • Either the volume group to which the disk belongs, or none

   The disks that you want to use might have a PVID, but they must not belong to existing volume groups.

5. If the disks that you want to use for the volume group do not have PVIDs, enter a command similar to the following for each disk that you want to use:

   # /usr/sbin/chdev -l hdiskn -a pv=yes
   
   

6. To identify used device major numbers, enter the following command:

   # ls -la /dev | more
   
   

   This command displays information about all configured devices, similar to the following:

   crw-rw----   1 root     system    45,  0 Jul 19 11:56 vg1
   
   

   In this example, 45 is the major number of the vg1 volume group device.

7. Identify an appropriate major number that is unused.

8. To create a volume group, enter a command similar to the following, or use SMIT (smit mkvg):

   # /usr/sbin/mkvg -y VGname -B -s PPsize -V majornum \
   -C PhysicalVolumes
   
   

   The following table describes the options and variables used in this example. See the mkvg man page for more information about these options.

   Command Option	SMIT Field	Sample Value and Description
   -y VGname	VOLUME GROUP name	oracle_vg1 Specify the name for the volume group. The name you specify could be a generic name, as shown, or it could specify the name of the database that you intend to create.
   -B	Create a big VG format Volume Group	Specify this option to create a big VG format volume group. Note: If you are using SMIT, choose yes for this field.
   -s PPsize	Physical partition SIZE in megabytes	32 Specify the size of the physical partitions for the database. The sample value shown allows you to include a disk up to 32 GB in size (32 MB * 1016).
   -V Majornum	Volume Group MAJOR NUMBER	46 Specify the device major number for the volume group that you identified in Step 7.
   -C	Create VG Concurrent Capable	Specify this option to create a concurrent capable volume group. Note: If you are using SMIT, choose yes for this field.
   PhysicalVolumes	PHYSICAL VOLUME names	hdisk3 hdisk4 Specify the device names of the disks that you want to add to the volume group.

   
   

To create the required raw logical volumes in the new volume group, follow these steps:

1. Choose a name for the database that you want to create.

   The name that you choose must start with a letter and have no more than four characters, for example, orcl.

2. From the following table, identify the logical volumes that you must create:

   Number	Partition Size (MB)	Purpose and Sample Logical Volume Name
   Raw Logical Volumes for Oracle Database
   1	500	SYSTEM tablespace: dbname_system_raw_500m
   1	500	SYSAUX tablespace: dbname_sysaux_raw_500m
   1	500	UNDOTBS1 tablespace: dbname_undotbs1_raw_500m
   1	160	EXAMPLE tablespace: dbname_example_raw_160m
   1	120	USERS tablespace: dbname_users_raw_120m
   2	120	Two online redo log files for each instance (where n is the number of the instance and m is the log number, 1 or 2): dbname_redon_m_raw_120m
   2	110	First and second control files: dbname_control[1|2]_raw_110m
   1	250	TEMP tablespace: dbname_temp_raw_250m
   1	5	Server parameter file (SPFILE): dbname_spfile_raw_5m
   1	5	Password file: dbname_pwdfile_raw_5m

   
   

3. To create each required logical volume, enter a command similar to the following (or use smit mklv):

   # /usr/sbin/mklv -y LVname -T O -w n -s n -r n VGname NumPPs
   
   

   In this example:

   • LVname is the name of the logical volume that you want to create

   • The -T O option specifies that the device subtype should be z, which causes Oracle to use a zero offset when accessing this raw logical volume.

   • VGname is the name of the volume group where you want to create the logical volume

   • NumPPs is the number of physical partitions to use

     To determine the value to use for NumPPs, divide the required size of the logical volume by the size of the physical partition and round the value up to an integer. For example, if the size of the physical partition is 32 MB and you want to create a 500 MB logical volume, you should specify 16 for the NumPPs (500/32 = 15.625).

   The following example shows the command used to create a logical volume for the SYSAUX tablespace of the test database in the oracle_vg1 volume group with a physical partition size of 32 MB (500/32 = 15.625):

   # /usr/sbin/mklv -y test_sysaux_500m -T O -w n -s n -r n oracle_vg1 16
   
   

4. Change the owner, group, and permissions on the character device files associated with the logical volumes that you created, as follows:

   # chown oracle:dba /dev/rdbname*
   # chmod 660 /dev/rdbname*
   
   

To allow Database Configuration Assistant (DBCA) to identify the appropriate raw device for each database file, you must create a raw device mapping file, as follows:

1. Set the ORACLE_BASE environment variable to specify the Oracle base directory that you identified or created previously:

   • Bourne, Bash or Korn shell:

     $ ORACLE_BASE=/u01/app/oracle ; export ORACLE_BASE
     
     

   • C shell:

     % setenv ORACLE_BASE /u01/app/oracle
     
     

2. Create a database file subdirectory under the Oracle base directory and set the appropriate owner, group, and permissions on it:

   # mkdir -p $ORACLE_BASE/oradata/dbname
   # chown -R oracle:oinstall $ORACLE_BASE/oradata
   # chmod -R 775 $ORACLE_BASE/oradata
   
   

   In this example, dbname is the name of the database that you chose previously.

3. Change directory to the $ORACLE_BASE/oradata/dbname directory.

4. Enter the following command to create a text file that you can use to create the raw device mapping file:

   # find /dev -user oracle -name ’r*’ -print > dbname_raw.conf
   
   

5. Edit the dbname_raw.conf file in any text editor to create a file similar to the following:

   system=/dev/rdbname_system_raw_500m
   sysaux=/dev/rdbname_sysaux_raw_500m
   example=/dev/rdbname_example_raw_160m
   users=/dev/rdbname_users_raw_120m
   temp=/dev/rdbname_temp_raw_250m
   undotbs1=/dev/rdbname_undotbs1_raw_500m
   redo1_1=/dev/rdbname_redo1_1_raw_120m
   redo1_2=/dev/rdbname_redo1_2_raw_120m
   control1=/dev/rdbname_control1_raw_110m
   control2=/dev/rdbname_control2_raw_110m
   spfile=/dev/rdbname_spfile_raw_5m
   pwdfile=/dev/rdbname_pwdfile_raw_5m
   
   

   In this example, dbname is the name of the database.

   Use the following guidelines when creating or editing this file:

   • Each line in the file must have the following format:

     database_object_identifier=logical_volume
     
     

     The logical volume names suggested in this manual include the database object identifier that you must use in this mapping file. For example, in the following logical volume name, redo1_1 is the database object identifier:

     /dev/rac_redo1_1_raw_120m
     
     

   • For a single instance database, the file must specify one automatic undo tablespace data file (undotbs1), and at least two redo log files (redo1_1, redo1_2).

   • Specify at least two control files (control1, control2).

   • To use manual instead of automatic undo management, specify a single RBS tablespace datafile (rbs) instead of the automatic undo management tablespaces.

6. Save the file and note the file name that you specified.

7. When you are configuring the oracle user’s environment later in this chapter, set the DBCA_RAW_CONFIG environment variable to specify the full path to this file.

Configuring Raw Logical Volumes on HP-UX

The following subsections describe how to configure raw logical volumes on HP-UX.

To create a volume group, follow these steps:

1. If necessary, install the disks that you intend to use for the database.

2. To make sure that the disks are available, enter the following command:

   # /sbin/ioscan -fun -C disk
   
   

   The output from this command is similar to the following:

   Class  I  H/W Path    Driver S/W State   H/W Type     Description
   ==========================================================================
   disk    0  0/0/1/0.6.0 sdisk  CLAIMED     DEVICE       HP   DVD-ROM 6x/32x
                          /dev/dsk/c0t6d0   /dev/rdsk/c0t6d0
   disk    1  0/0/1/1.2.0 sdisk  CLAIMED     DEVICE      SEAGATE ST39103LC
                          /dev/dsk/c1t2d0   /dev/rdsk/c1t2d0
   disk    2  0/0/2/0.2.0 sdisk  CLAIMED     DEVICE       SEAGATE ST118202LC
                          /dev/dsk/c2t2d0   /dev/rdsk/c2t2d0
   
   

   This command displays information about each disk attached to the system, including the block device name (/dev/dsk/cxtydz) and the character raw device name (/dev/rdsk/cxtydz).

   If this command does not display device name information for a disk, enter the following command to install the special device files:

   # /usr/sbin/insf -e
   
   

3. For each disk that you want to add to the volume group, enter the following command to verify that it is not already part of a volume group:

   # /sbin/pvdisplay /dev/dsk/cxtydz
   
   

   If this command displays volume group information, the disk is already part of a volume group.

4. For each disk that you want to add to the volume group, enter a command similar to the following:

   # /sbin/pvcreate /dev/rdsk/cxtydz
   
   

5. To create a directory for the volume group in the /dev directory, enter a command similar to the following, where vg_name is the name you want to use for the volume group:

   # mkdir /dev/vg_name
   
   

6. To identify used device minor numbers, enter the following command:

   # ls -la /dev/*/group
   
   

   This command displays information about the device numbers used by all configured volume groups, similar to the following:

   crw-r-----   1 root    sys        64 0x000000 Mar  4  2002 /dev/vg00/group
   crw-r--r--   1 root    sys        64 0x010000 Mar  4  2002 /dev/vg01/group
   
   

   In this example, 64 is the major number used by all volume group devices and 0x000000 and 0x010000 are the minor numbers used by volume groups vg00 and vg01 respectively. Minor numbers have the format 0xnn0000, where nn is a number in the range 00 to the value of the maxvgs kernel parameter minus 1. The default value for the maxvgs parameter is 10, so the default range is 00 to 09.

7. Identify an appropriate minor number that is unused.

8. To create the volume group and activate it, enter commands similar to the following:

   # /sbin/mknod /dev/vg_name/group c 64 0xnn0000
   # /sbin/vgcreate /dev/vg_name /dev/dsk/cxtydz . . .
   # /sbin/vgchange -a y vg_name
   
   

   In this example:

   • vg_name is the name you want to give the volume group

   • 0xnn0000 is a minor number that is unused.

   • /dev/dsk/cxtydz... is a list of one or more block device names for the disks that you want to add to the volume group.

To create the required raw logical volumes in the new volume group, follow these steps:

1. Choose a name for the database that you want to create.

   The name that you choose must start with a letter and have no more than four characters, for example, orcl.

2. From the following table, identify the logical volumes that you must create:

   Number	Partition Size (MB)	Purpose and Sample Logical Volume Name
   Raw Logical Volumes for Oracle Database
   1	500	SYSTEM tablespace: dbname_system_raw_500m
   1	500	SYSAUX tablespace: dbname_sysaux_raw_500m
   1	500	UNDOTBS1 tablespace: dbname_undotbs1_raw_500m
   1	160	EXAMPLE tablespace: dbname_example_raw_160m
   1	120	USERS tablespace: dbname_users_raw_120m
   2	120	Two online redo log files (where m is the log number, 1 or 2): dbname_redo1_m_raw_120m
   2	110	First and second control files: dbname_control[1|2]_raw_110m
   1	250	TEMP tablespace: dbname_temp_raw_250m
   1	5	Server parameter file (SPFILE): dbname_spfile_raw_5m
   1	5	Password file: dbname_pwdfile_raw_5m

   
   

3. To create each required logical volume, enter a command similar to the following:

   # /sbin/lvcreate -n LVname -L size /dev/VGname
   
   

   In this example:

   • LVname is the name of the logical volume that you want to create

     Oracle recommends that you use the sample names shown in the previous table for the logical volumes. Substitute the dbname variable in the sample logical volume name with the name you choose for the database in step 1.

   • VGname is the name of the volume group where you want to create the logical volume

   • size is the size of the logical volume in megabytes

   The following example shows a sample command used to create a 500 MB logical volume in the oracle_vg volume group for the SYSAUX tablespace of a database named test:

   # /sbin/lvcreate -n test_sysaux_500m -L 500 /dev/oracle_vg
   
   

4. Change the owner, group, and permissions on the character device files associated with the logical volumes that you created, as follows:

   # chown oracle:dba /dev/vg_name/r*
   # chmod 755 /dev/vg_name
   # chmod 660 /dev/vg_name/r*
   
   

To allow Database Configuration Assistant (DBCA) to identify the appropriate raw device for each database file, you must create a raw device mapping file, as follows:

1. Set the ORACLE_BASE environment variable to specify the Oracle base directory that you identified or created previously:

   • Bourne, Bash or Korn shell:

     $ ORACLE_BASE=/u01/app/oracle ; export ORACLE_BASE
     
     

   • C shell:

     % setenv ORACLE_BASE /u01/app/oracle
     
     

2. Create a database file subdirectory under the Oracle base directory and set the appropriate owner, group, and permissions on it:

   # mkdir -p $ORACLE_BASE/oradata/dbname
   # chown -R oracle:oinstall $ORACLE_BASE/oradata
   # chmod -R 775 $ORACLE_BASE/oradata
   
   

   In this example, dbname is the name of the database that you chose previously.

3. Change directory to the $ORACLE_BASE/oradata/dbname directory.

4. Enter a command similar to the following to create a text file that you can use to create the raw device mapping file:

   # find /dev/vg_name -user oracle -name ’r*’ -print > dbname_raw.conf
   
   

5. Edit the dbname_raw.conf file in any text editor to create a file similar to the following:

   system=/dev/vg_name/rdbname_system_raw_500m
   sysaux=/dev/vg_name/rdbname_sysaux_raw_500m
   example=/dev/vg_name/rdbname_example_raw_160m
   users=/dev/vg_name/rdbname_users_raw_120m
   temp=/dev/vg_name/rdbname_temp_raw_250m
   undotbs1=/dev/vg_name/rdbname_undotbs1_raw_500m
   redo1_1=/dev/vg_name/rdbname_redo1_1_raw_120m
   redo1_2=/dev/vg_name/rdbname_redo1_2_raw_120m
   control1=/dev/vg_name/rdbname_control1_raw_110m
   control2=/dev/vg_name/rdbname_control2_raw_110m
   spfile=/dev/vg_name/rdbname_spfile_raw_5m
   pwdfile=/dev/vg_name/rdbname_pwdfile_raw_5m
   
   

   In this example:

   • vg_name is the name of the volume group

   • dbname is the name of the database

   Use the following guidelines when creating or editing this file:

   • Each line in the file must have the following format:

     database_object_identifier=logical_volume
     
     

     The logical volume names suggested in this manual include the database object identifier that you must use in this mapping file. For example, in the following logical volume name, redo1_1 is the database object identifier:

     /dev/oracle_vg/rac_redo1_1_raw_120m
     
     

   • For a single instance database, the file must specify one automatic undo tablespace data file (undotbs1), and at least two redo log files (redo1_1, redo1_2).

   • Specify at least two control files (control1, control2).

   • To use manual instead of automatic undo management, specify a single RBS tablespace datafile (rbs) instead of the automatic undo management tablespaces.

6. Save the file and note the file name that you specified.

7. When you are configuring the oracle user’s environment later in this chapter, set the DBCA_RAW_CONFIG environment variable to specify the full path to this file.

Configuring Raw Partitions on Linux

The following subsections describe how to configure raw partitions or raw logical volumes on Linux.

The following procedures contained in this section describe how to create raw partitions for Oracle database file storage. This procedure works on all supported Linux distributions.

However, on Red Hat Enterprise Linux 3 and UnitedLinux 1.0 you can use Logical Volume Manager (LVM) to create logical volumes of the required size and use them instead of raw partitions. Using LVM can provide benefits when used as a the method for storing Oracle database files on raw devices. For example, LVM enables you to overcome the limitations on the number of partitions that you can create on a single physical disk.

If you want to use logical volumes instead of raw partitions, follow these steps:

1. Create a separate volume group for the Oracle database files.

   You can use a name such as oracle_vg or dbname_vg for the volume group.

2. Create the required number of logical volumes using the sizes listed in the "Create Raw Partitions" section.

   Use a naming convention similar to the following when creating the logical volumes:

   dbname_objectname_raw_sizem
   
   

   For example, you might name the logical volume for the SYSTEM table space (500 MB) in the sales database as follows:

   sales_system_raw_500m
   
   

3. Bind the logical volumes to raw devices as described in the "Bind the Partitions to Raw Devices" section, using the logical volume device name in place of the partition device name.

4. Create the raw device mapping file as described in the "Create the DBCA Raw Device Mapping File" section.

To create the required raw partitions, follow these steps:

1. If necessary, install the disks that you intend to use for the database and reboot the system.

   
   

   Note: Because the number of partitions that you can create on a single device is limited, you might need to create the required raw partitions on more than one device.

   
   

2. To identify the device name for the disks that you want to use for the database, enter the following command:

   # /sbin/fdisk -l
   
   

   Depending on the type of disk, the device name can vary:

   Disk Type	Device Name Format	Description
   IDE disk	/dev/hdxn	In this example, x is a letter that identifies the IDE disk and n is the partition number. For example, /dev/hda is the first disk on the first IDE bus.
   SCSI disk	/dev/sdxn	In this example, x is a letter that identifies the SCSI disk and n is the partition number. For example, /dev/sda is the first disk on the first SCSI bus.
   RAID disk	/dev/rd/cxdypz /dev/ida/cxdypz	Depending on the RAID controller, RAID devices can have different device names. In the examples shown, x is a number that identifies the controller, y is a number that identifies the disk and z is a number that identifies the partition. For example, /dev/ida/c0d1 is the second logical drive on the first controller.

   
   

   You can create the required raw partitions either on new devices that you added or on previously partitioned devices that have unpartitioned free space. To identify devices that have unpartitioned free space, examine the start and end cylinder numbers of the existing partitions and determine whether the device contains unused cylinders.

3. To create raw partitions on a device, enter a command similar to the following:

   # /sbin/fdisk devicename
   
   

   Use the following guidelines when creating partitions:

   • Use the p command to list the partition table of the device.

   • Use the n command to create a new partition.

   • After you have created all the required partitions on this device, use the w command to write the modified partition table to the device.

   • See the fdisk man page for more information about creating partitions.

   The following table lists the number, size, and purpose of the partitions that you must create:

   Number	Partition Size (MB)	Purpose
   Raw Partitions for Oracle Database
   1	500	SYSTEM tablespace
   1	500	SYSAUX tablespace
   1	500	UNDOTBS1 tablespace
   1	160	EXAMPLE tablespace
   1	120	USERS tablespace
   2	120	Two online redo log files
   2	110	First and second control files
   1	250	TEMP tablespace
   1	5	Server parameter file (SPFILE)
   1	5	Password file

   
   

After you have created the required partitions, you must bind the partitions to raw devices. However, you must first determine what raw devices are already bound to other devices. The procedure that you must follow to complete this task varies, depending on the distribution that you are using:

• Red Hat:

  1. To determine what raw devices are already bound to other devices, enter the following command:

     # /usr/sbin/raw -qa
     
     

     Raw devices have device names in the form /dev/raw/rawn, where n is a number that identifies the raw device.

  2. Open the /etc/sysconfig/rawdevices file in any text editor and add a line similar to the following for each partition that you created:

     /dev/raw/raw1 /dev/sdb1
     
     

     Specify an unused raw device for each partition.

  3. For each raw device that you specified in the rawdevices file, enter commands similar to the following to set the owner, group, and permissions on the device file:

     # chown oracle:oinstall /dev/dev/rawn
     # chmod 660 /dev/raw/rawn
     
     

  4. To bind the partitions to the raw devices, enter the following command:

     # /sbin/service rawdevices restart
     
     

     By editing the rawdevices file, the system binds the partitions to the raw devices when it reboots.

• UnitedLinux:

  1. To determine what raw devices are already bound to other devices, enter the following command:

     # /usr/sbin/raw -qa
     
     

     Raw devices have device names in the form /dev/raw/rawn, where n is a number that identifies the raw device.

  2. Open the /etc/raw file in any text editor and add a line similar to the following to associate each partition with an unused raw device:

     raw1:sdb1
     
     

  3. For each raw device that you specified in the /etc/raw file, enter commands similar to the following to set the owner, group, and permissions on the device file:

     # chown oracle:dba /dev/raw/rawn
     # chmod 660 /dev/raw/rawn
     
     

  4. To bind the partitions to the raw devices, enter the following command:

     # /etc/init.d/raw
     
     

  5. To ensure that the raw devices are bound when the system reboots, enter the following command:

     # /sbin/chkconfig raw on
     
     

To allow Database Configuration Assistant (DBCA) to identify the appropriate raw partition for each database file, you must create a raw device mapping file, as follows:

1. Set the ORACLE_BASE environment variable to specify the Oracle base directory that you identified or created previously:

   • Bourne, Bash or Korn shell:

     $ ORACLE_BASE=/u01/app/oracle ; export ORACLE_BASE
     
     

   • C shell:

     % setenv ORACLE_BASE /u01/app/oracle
     
     

2. Create a database file subdirectory under the Oracle base directory and set the appropriate owner, group, and permissions on it:

   # mkdir -p $ORACLE_BASE/oradata/dbname
   # chown -R oracle:oinstall $ORACLE_BASE/oradata
   # chmod -R 775 $ORACLE_BASE/oradata
   
   

   In this example, dbname is the name of the database that you chose previously.

3. Change directory to the $ORACLE_BASE/oradata/dbname directory.

4. Edit the dbname_raw.conf file in any text editor to create a file similar to the following:

   system=/dev/raw/raw1
   sysaux=/dev/raw/raw2
   example=/dev/raw/raw3
   users=/dev/raw/raw4
   temp=/dev/raw/raw5
   undotbs1=/dev/raw/raw6
   redo1_1=/dev/raw/raw8
   redo1_2=/dev/raw/raw9
   control1=/dev/raw/raw12
   control2=/dev/raw/raw13
   spfile=/dev/raw/raw14
   pwdfile=/dev/raw/raw15
   
   

   Use the following guidelines when creating or editing this file:

   • Each line in the file must have the following format:

     database_object_identifier=raw_device_path
     
     

   • For a single instance database, the file must specify one automatic undo tablespace datafile (undotbs1), and at least two redo log files (redo1_1, redo1_2).

   • Specify at least two control files (control1, control2).

   • To use manual instead of automatic undo management, specify a single RBS tablespace datafile (rbs) instead of the automatic undo management tablespaces.

5. Save the file and note the file name that you specified.

6. When you are configuring the oracle user’s environment later in this chapter, set the DBCA_RAW_CONFIG environment variable to specify the full path to this file.

Configuring Raw Logical Volumes on Solaris

This section describes how to configure raw logical volumes on Solaris.

To create a disk group, follow these steps:

1. If necessary, install the disks that you intend to use for the disk group and reboot the system.

2. To make sure that the disks are available, enter the following command:

   # /usr/sbin/format
   
   

   The output from this command is similar to the following:

   AVAILABLE DISK SELECTIONS:
          0. c0t0d0 <ST34321A cyl 8892 alt 2 hd 15 sec 63>
             /pci@1f,0/pci@1,1/ide@3/dad@0,0
          1. c1t5d0 <SUN9.0G cyl 4924 alt 2 hd 27 sec 133>
             /pci@1f,0/pci@1/scsi@1/sd@5,0
   
   

   This command displays information about each disk attached to the system, including the device name (cxtydz).

3. From the list, identify the device names for the disk devices that you want to add to a disk group, then press Ctrl/D to exit from the format utility.

4. Enter the following command to verify that the devices you identified are not mounted as file systems:

   # df -k
   
   

   This command displays information about the partitions (slices) on disk devices that are mounted as file systems. The device name for a slice includes the disk device name, followed by the slice number, for example cxtydzsn, where sn is the slice number. Slice 2 (s2) represents the entire disk. The disk devices that you choose must not be shown as mounted partitions.

5. Enter the following commands to verify that the devices you identified are not already part of a disk group:

   
   

   Note: The following command displays information about VERITAS Volume Manager disks. If you use a different LVM, see the appropriate documentation for information about determining which disk devices it is managing.

   
   

   # /usr/sbin/vxdiskconfig
   # /usr/sbin/vxdisk list
   
   

   The vxdisk list command identifies the disk devices that are already configured in a disk group. The word online in the STATUS column also identifies disks that have been initialized and placed under VxVM control. The word error in the STATUS column identifies disks that are not initialized.

   The disk devices that you choose must not be in an existing disk group.

6. If the disk devices that you want to use are not initialized, enter a command similar to the following to initialize each disk:

   # /usr/sbin/vxdiskadd cxtydz
   
   

7. To create a disk group, enter a command similar to the following, specifying all of the disks that you want to add to the group:

   # /usr/sbin/vxdg init diskgroup diskname=devicename ...
   
   

   In this example:

   • diskgroup is the name of the disk group that you want to create, for example, oradg

   • diskname is an administrative name that you assign to a disk, for example orad01

   • devicename is the device name, for example, c1t0d0

To create the required raw logical volumes in the new disk group, follow these steps:

1. Choose a name for the database that you want to create.

   The name that you choose must start with a letter and have no more than four characters, for example, orcl.

2. From the following table, identify the logical volumes that you must create:

   Number	Partition Size (MB)	Purpose and Sample Logical Volume Name
   Raw Logical Volumes for Oracle Database
   1	500	SYSTEM tablespace: dbname_system_raw_500m
   1	500	SYSAUX tablespace: dbname_sysaux_raw_500m
   1	500	UNDOTBS1 tablespace: dbname_undotbs1_raw_500m
   1	160	EXAMPLE tablespace: dbname_example_raw_160m
   1	120	USERS tablespace: dbname_users_raw_120m
   2	120	Two online redo log files (where m is the log number, 1 or 2): dbname_redo1_m_raw_120m
   2	110	First and second control files: dbname_control[1|2]_raw_110m
   1	250	TEMP tablespace: dbname_temp_raw_250m
   1	5	Server parameter file (SPFILE): dbname_spfile_raw_5m
   1	5	Password file: dbname_pwdfile_raw_5m

   
   
   
   

   Note: The following example shows how to create a basic logical volume. See the VERITAS Volume Manager documentation for information about how to create more complex logical volumes using striping, mirroring, or both.

   
   

3. To create the other required logical volumes, enter a command similar to the following:

   # /usr/sbin/vxassist -g diskgroup make volume size user=oracle \
    group=dba mode=660
   
   

   In this example:

   • diskgroup is the name of the disk group you created previously, for example, oradg.

   • volume is the name of the logical volume that you want to create.

     Oracle recommends that you use the sample names shown in the previous table for the logical volumes. Substitute the dbname variable in the sample logical volume name with the name you choose for the database in step 1.

   • size is the size of the logical volume, for example, 500m represents 500 MB.

   • user=oracle group=dba mode=660 specifies the owner and permissions on the volume. Specify the Oracle software owner user and the OSDBA group for the user and group values (typically oracle and dba).

   The following example shows a sample command used to create a 500 MB logical volume in the oradg disk group for the SYSAUX tablespace of a database named test:

   # /usr/sbin/vxassist -g oradb make test_sysaux_500m 500m \
   user=oracle group=dba mode=660
   
   

To allow Database Configuration Assistant (DBCA) to identify the appropriate raw device for each database file, you must create a raw device mapping file, as follows:

1. Set the ORACLE_BASE environment variable to specify the Oracle base directory that you identified or created previously:

   • Bourne, Bash or Korn shell:

     $ ORACLE_BASE=/u01/app/oracle ; export ORACLE_BASE
     
     

   • C shell:

     % setenv ORACLE_BASE /u01/app/oracle
     
     

2. Create a database file subdirectory under the Oracle base directory and set the appropriate owner, group, and permissions on it:

   # mkdir -p $ORACLE_BASE/oradata/dbname
   # chown -R oracle:oinstall $ORACLE_BASE/oradata
   # chmod -R 775 $ORACLE_BASE/oradata
   
   

   In this example, dbname is the name of the database that you chose previously.

3. Change directory to the $ORACLE_BASE/oradata/dbname directory.

4. Enter the following command to create a text file that you can use to create the raw device mapping file:

   # find /dev/vx/rdsk/diskgroup -user oracle -name dbname* \
   -print > dbname_raw.conf
   
   

5. Edit the dbname_raw.conf file in any text editor to create a file similar to the following:

   system=/dev/vx/rdsk/diskgroup/dbname_system_raw_500m
   sysaux=/dev/vx/rdsk/diskgroup/dbname_sysaux_raw_500m
   example=/dev/vx/rdsk/diskgroup/dbname_example_raw_160m
   users=/dev/vx/rdsk/diskgroup/dbname_users_raw_120m
   temp=/dev/vx/rdsk/diskgroup/dbname_temp_raw_250m
   undotbs1=/dev/vx/rdsk/diskgroup/dbname_undotbs1_raw_500m
   redo1_1=/dev/vx/rdsk/diskgroup/dbname_redo1_1_raw_120m
   redo1_2=/dev/vx/rdsk/diskgroup/dbname_redo1_2_raw_120m
   control1=/dev/vx/rdsk/diskgroup/dbname_control1_raw_110m
   control2=/dev/vx/rdsk/diskgroup/dbname_control2_raw_110m
   spfile=/dev/vx/rdsk/diskgroup/dbname_spfile_raw_5m
   pwdfile=/dev/vx/rdsk/diskgroup/dbname_pwdfile_raw_5m
   
   

   In this example:

   • diskgroup is the name of the volume group

   • dbname is the name of the database

   Use the following guidelines when creating or editing this file:

   • Each line in the file must have the following format:

     database_object_identifier=logical_volume
     
     

     The logical volume names suggested in this manual include the database object identifier that you must use in this mapping file. For example, in the following logical volume name, redo1_1 is the database object identifier:

     /dev/vx/rdsk/oradg/rac_redo1_1_raw_120m
     
     

   • For a single instance database, the file must specify one automatic undo tablespace datafile (undotbs1), and at least two redo log files (redo1_1, redo1_2).

   • Specify at least two control files (control1, control2).

   • To use manual instead of automatic undo management, specify a single RBS tablespace datafile (rbs) instead of the automatic undo management tablespaces.

6. Save the file and note the file name that you specified.

7. When you are configuring the oracle user’s environment later in this chapter, set the DBCA_RAW_CONFIG environment variable to specify the full path to this file.