Oracle Audit Vault Server 10.3 Linux
Oracle Audit Vault Server 10.3 Linux
Oracle Audit Vault Server 10.3 Linux
January 2012
Oracle Audit Vault Server Installation Guide, Release 10.3 for Linux x86-64
E23565-07
Copyright 2007, 2012, Oracle and/or its affiliates. All rights reserved.
Primary Authors:
Contributing Authors: Tammy Bednar, Namrata Bhakthavatsalam, Janet Blowney, Pat Huey, Prakash
Jashnani, K Karun, Reema Khosla, Deborah Owens, Mohammed Yunus Qureshi, Trivikrama Samudrala,
Vipul Shah
Contributors: Luis Edgardo Argote Bolio, Alan Galbreath, Diego Iglesias, Donna Keesling, Aneesh
Khandelwai, Sarma Namuduri, Gowri Suserla, Wei You
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data
delivered to U.S. Government customers are "commercial computer software" or "commercial technical data"
pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As
such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and
license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of
the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software
License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services.
Contents
Preface ................................................................................................................................................................. ix
Audience.......................................................................................................................................................
Documentation Accessibility .....................................................................................................................
Related Documents .....................................................................................................................................
Conventions .................................................................................................................................................
ix
ix
ix
x
2-2
2-2
2-2
2-4
iii
2.2.3
2.2.4
2.3
2.3.1
2.3.2
2.3.3
2.3.4
2.3.4.1
2.3.4.2
2.3.4.3
2.4
2.5
2.6
2.7
2.8
2.8.1
2.8.2
2.8.3
2.9
2.9.1
2.9.1.1
2.9.1.2
2.9.1.3
2.9.2
2.9.2.1
2.9.2.2
2.9.2.3
2.9.2.4
2.9.2.5
2.9.2.6
2.9.2.7
2.10
2.11
2.11.1
2.12
2.12.1
2.12.2
2.12.3
2.13
2.13.1
2.13.2
2.14
2.15
2.15.1
2.15.2
2.16
2.17
iv
2.17.1
Example of Creating a Udev Permissions File for Oracle Audit Vault Server ........
2.17.2
Example of Configuring Block Device Storage for Oracle Audit Vault Server .......
2.18
Configuring the oracle Users Environment ........................................................................
2.19
Setting the DISPLAY Environment Variable .......................................................................
2.20
Setting the Correct Locale .......................................................................................................
2-36
2-36
2-37
2-39
2-40
3.1
3.1.1
3.1.2
3.1.3
3.2
3.3
3.4
3.5
3.6
3.6.1
3.6.2
5-1
5-2
5-2
5-2
5-4
5-5
5-5
vi
A.3
A.3.1
A.3.2
A.4
A.5
A-3
A-3
A-4
A-5
A-6
Index
vii
List of Tables
21
41
42
43
A1
viii
2-24
4-18
4-18
4-22
A-4
Preface
The Oracle Audit Vault Server Installation Guide explains how to prepare for, install,
and configure Oracle Audit Vault Server. It provides specific instructions for the
operating system and Oracle software technology components that the Audit Vault
Server requires.
Audience
This document is intended for Oracle database administrator's (DBAs) and system
administrators and those who are involved in the installation of Oracle Audit Vault
and its related components.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle
Accessibility Program website at
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers have access to electronic support through My Oracle Support. For
information, visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are
hearing impaired.
Related Documents
For more information, see the following documents:
Oracle Real Application Clusters Installation Guide for Linux and UNIX
ix
Conventions
The following text conventions are used in this document:
Convention
Meaning
boldface
italic
monospace
1
1
Note:
This chapter provides an overview of the Oracle Audit Vault Server installation
process. This chapter includes the following sections:
Installation Considerations
Oracle Audit Vault collection agent installation (see Oracle Audit Vault Collection
Agent Installation Guide)
Oracle Universal Installer runs in silent mode if you use a response file that specifies
all required information. None of the Oracle Universal Installer screens are displayed,
and all interaction (standard output and error messages) and installation logs appear
on the command line.
You can prepare the response file by entering values for all parameters that are missing
in the response file, then save the file. For parameters that should not be changed, a
comment is included in the file to indicate that you should not change the parameter
value. Refer to Section A.3.2 for more information about saving a response file.
See Section 4.7 for specific information about performing an Audit Vault Server silent
installation.
For information about installing Oracle products using response files, see Appendix A.
Create and configure Oracle Audit Vault - Performs a full installation and
configuration of Audit Vault Server.
Install Oracle Audit Vault software only - Only lays down the software bits and
does no configuration of the Oracle Audit Vault Server software.
Basic installation Simplifies the installation process and prompts for a minimal
set of inputs from the user to perform a full installation. An Oracle RAC
installation is not supported through this option; only a single instance installation
is supported.
Advanced installation Offers the user more control and options for the
installation process, including storage options and backup options. This option
supports the installation of Audit Vault Server on a cluster and as a single
instance.
Communication at the management level between the Audit Vault Server and the
Audit Vault collection agent can be secured after the installation is complete. This is
done as part of the postinstallation configuration, in which SSL is configured for the
mutual authentication between the Oracle Audit Vault management service on the
server side and each collection agent over HTTPS.
After you check the requirements described in Section 1.6, the general steps to install
Oracle Audit Vault Server include these tasks:
1.
2.
Applying a required CPU patch that became available for the database
Applying a required Audit Vault 10.3.0.0 Bundle Patch that became available
In all cases, instead of applying these patches after the installation completes, you can
follow the steps in Section 4.6 and apply these patches as part of the installation
process. This is a more efficient and automated way to apply any required software
patches during an initial Oracle Audit Vault Server installation.
Oracle Audit Vault Server Installation Overview 1-3
Installation Considerations
See Section 4.6 for more information about the steps to follow to complete a software
only installation.
File System
Note:
to increase performance and reliability. Using this methodology, you do not need
to specify more than one file system mount point for the database storage.
If the NAS device is certified by Oracle, then you can store the database files on
them.
If you use the Advanced database creation option, then you can also use the Oracle
Managed Files feature with the new database. If you use this feature, then you must
specify only the database object name instead of file names when creating or deleting
database files.
See Also: "Specifying Oracle Managed Files at Database Creation"
in Oracle Database Administrator's Guide
Oracle ASM manages the storage of all database files, such as redo logs, control files,
and data pump export files.
Oracle ASM can manage the Oracle Audit Vault Server executable binary files and any
other non-database file by creating a file system with Oracle Automatic Storage
Management Cluster File System. Although Oracle Automatic Storage Management
Cluster File System is cluster-aware, it also works as a file system on a single-instance
database.
At a high level, implementing Oracle ASM involves allocating partitioned disks for
Oracle Audit Vault Server with preferences for striping and mirroring. Oracle ASM
manages the disk space for you. This helps avoid the need for traditional disk
management tools, such as Logical Volume Managers (LVM), file systems, and the
numerous commands necessary to manage both. The synchronization between Oracle
ASM and the database instance is handled by CSS.
The following are components of an Oracle ASM installation:
ASM-related data dictionary views. The ASMSNMP account status is set to OPEN upon
creation, and it is granted the SYSDBA privilege.
Oracle recommends that you have the Oracle ASM instance in its own Oracle home.
Oracle also recommends that you run this instance before you start a database instance
that uses Oracle ASM.
For an Oracle Audit Vault Server installation, you only need one Oracle ASM instance,
regardless of the number of database instances on the computer.
See Also: "Managing Oracle ASM Users with Oracle Enterprise
Manager" in Oracle Automatic Storage Management Administrator's
Guide for information about the ASMSNMP user
See Also: Oracle Enterprise Manager Concepts manual and the Oracle
Enterprise Manager Grid Control Basic Installation Guide on the Oracle
Enterprise Manager Grid Control installation media for more
information about Oracle Enterprise Manager
Instance name, database version, Oracle home location, media recovery options,
and other instance data
In addition, it provides you with automatic notification of security alerts and the
ability to download and apply patches for the software.
installation. If you prefer, you can use Oracle Enterprise Manager Database Control or
Grid Control to configure automated backups after you install the software and create
a database.
This section contains the following topics:
The default disk quota configured for the fast recovery area is 2 GB. For Oracle
ASM disk groups, the required disk space depends on the redundancy level of the
disk group that you choose. Section 4.10.4 describes how to choose the location of
the fast recovery area and identifies its disk space requirements.
An operating system user name and password for the backup job
Oracle Enterprise Manager uses the operating system credentials that you specify
when running the backup job. The user name that you specify must belong to the
UNIX group that identifies database administrators (the ORA_DBA group). This
user also must have Logon As A Batch Job privilege.
You can use Oracle Enterprise Manager Database Control to set up, change, or
customize email notifications after you create the database.
2
Oracle Audit Vault Preinstallation
Requirements
2
This chapter describes the tasks that you must complete before you start Oracle
Universal Installer to install Oracle Audit Vault Server (Audit Vault Server) Release
10.3. It includes information about the following tasks:
Note:
Choosing a Storage Option for Oracle Audit Vault Server and Recovery Files
Configuring Storage for Oracle Audit Vault Server Files Using Block Devices
Memory Requirements
System Architecture
Display Requirements
If the size of the RAM is less than the required size, then you must install more
memory before continuing.
The following table describes the relationship between the installed RAM and the
configured swap space recommendation:
Note:
RAM
Swap Space
Between 1 GB and 2 GB
Between 2 GB and 16 GB
More than 16 GB
16 GB
If the size of the RAM is less than the required size, then you must install more
memory before continuing.
To determine the size of the configured swap space, enter the following command:
# grep SwapTotal /proc/meminfo
If necessary, see the operating system documentation for information about how to
configure additional swap space.
To determine the available RAM and swap space, enter the following command:
# free
Note:
On the Initialization Parameters page, note the Memory Size (SGA and PGA), which
sets the initialization parameter MEMORY_TARGET or MEMORY_MAX_TARGET. Note that the
initialization parameters cannot be greater than the shared memory file system on the
operating system. For example, if the shared memory file system allocation on your
system is 1 GB, but you set Memory Size (MEMORY_TARGET) to 2 GB, then the following
error messages are displayed during database startup:
ORA-00845: MEMORY_TARGET not supported on this system
ORA-01078: Failure in processing system parameters
In addition, if you click All Initialization Parameters and the global database name is
longer than eight characters, then the database name value (in the DB_NAME parameter)
is truncated to the first eight characters, and the DB_UNIQUE_NAME parameter value is
set to the global name.
The workaround, if you encounter the ORA-00845 error, is to increase the /dev/shm
mountpoint size.
For example:
# mount -t tmpfs shmfs -o size=7g /dev/shm
To make this change persistent across system restarts, add an entry in /etc/fstab
similar to the following:
shmfs /dev/shm tmpfs size=7g 0
Verify that the processor architecture matches the Oracle software release that you
want to install. If you do not see the expected output, then you cannot install the
software on this system.
If the free space available in the /tmp directory is less than what is required, then
complete one of the following steps:
Delete unnecessary files from the /tmp directory to meet the disk space
requirement.
Set the TMP and TMPDIR environment variables when setting the oracle users
environment.
See Also:
TMPDIR
Extend the file system that contains the /tmp directory. If necessary, contact
the system administrator for information about extending file systems.
The following tables describe the disk space requirements for software files and
data files for each installation type on Linux x86-64:
Installation Type
4.45
Installation Type
2.30
To determine the amount of free disk space on the system, enter the following
command:
# df -h
Additional disk space, either on a file system or on an Oracle ASM disk group is
required for the fast recovery area if you configure automated backups.
Kernel Requirements
Package Requirements
On Linux x86-64
Starting with Oracle Audit Vault Server Release 10.3, the Security Enhanced Linux (SE
Linux) feature is supported for Oracle Linux 4, Red Hat Enterprise Linux 4, Oracle
Linux 5, and Red Hat Enterprise Linux 5.
For Asianux Server, Oracle Linux, and Red Hat Enterprise
Linux, the system requirements are identical by kernel version,
specifically:
Note:
To determine the distribution and version of Linux installed, enter the following
command:
# cat /proc/version
You can also enter the following command on some distributions of Linux:
# lsb_release -id
Note:
See Also:
On Oracle Linux 5 Update 5 with the Unbreakable Enterprise Kernel for Linux
2.6.32-100.0.19 or later
See Oracle Database Installation Guide for Linux for more information about Oracle
Unbreakable Enterprise Kernel for Linux.
On Red Hat Enterprise Linux 5 Update 5 with the Unbreakable Enterprise Kernel
for Linux
2.6.32 or later
See Oracle Database Installation Guide for Linux for more information about Oracle
Unbreakable Enterprise Kernel for Linux.
On Asianux Server 3, Oracle Linux 5 Update 2, and Red Hat Enterprise Linux 5
Update 2
2.6.18 or later
In this example, the output shows the kernel version (2.6.18) and errata level
(-128.el5PAE) on the system.
If the kernel version does not meet the requirement, then contact the operating system
vendor for information about obtaining and installing kernel updates.
Linux x86-64
Note:
Linux x86-64
IMPORTANT:
Starting with Oracle Audit Vault Server Release 10.3 which installs
a customized, specially configured release of Oracle Database 11g
Release 2 (11.2.0.3), all the 32-bit packages, except for
gcc-32bit-4.3, listed in the following table are no longer required
for installing a database on Linux x86-64. Only the 64-bit packages
are required.
If you are using Oracle Unbreakable Enterprise Kernel, then all
required kernel packages are installed as part of the Oracle
Unbreakable Enterprise Kernel installation.
Operating System
Requirement
Operating System
Requirement
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
numactl-devel-0.9.8.x86_64
sysstat-7.0.2
binutils-2.16.91.0.5
compat-libstdc++-5.0.7
gcc-4.1.0
gcc-c++-4.1.2
glibc-2.4-31.63
glibc-devel-2.4-31.63
glibc-devel-32bit-2.4-31.63
ksh-93r-12.9
libaio-0.3.104
libaio-32bit-0.3.104
libaio-devel-0.3.104
libaio-devel-32bit-0.3.104
libelf-0.8.5
libgcc-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2
make-3.80
numactl-0.9.6.x86_64
sysstat-8.0.4
Operating System
Requirement
Note:
To determine if the required packages are installed, enter commands similar to the
following:
# rpm -q package_name
If a package is not installed, then install it from the Linux distribution media or
download the required package version from the Linux vendors Web site.
Linux-PAM Library
Browser Requirements
See Also: Chapter 2, "Oracle Application Express Installation
Requirements" and "Recommended Pre-installation Tasks" in Oracle
Application Express Installation Guide
drivers. However, these are not mandatory for the database installation. Note that JDK
1.5 is installed with this release.
Firefox 2.0
Firefox 3.0.7
Firefox 3.5
Firefox 3.6
Safari 3.1
Safari 3.2
Safari 4.0.x
Checks for and sets kernel parameters to values required for successful
installation, including:
Oracle recommends that you do not modify the contents of the generated fixup script.
Using fixup scripts does not ensure that all the prerequisites
for installing Oracle Audit Vault Server are met. You must still verify
that all the preinstallation requirements are met to ensure a successful
installation.
Note:
The first file that is present is read. If a value other than 1 is present in the file, then
core files are disabled. Enabling core file creation can vary between Linux
distributions; see your Linux vendor documentation for information about how to
enable core file creation. The following example shows how to enable core file creation
on Oracle Linux 5 and Red Hat Enterprise Linux 5:
1.
Use a text editor to open the /etc/profile file of the Oracle Grid Infrastructure
installation owner and find the following line:
ulimit S c 0 > /dev/null 2>&1
Use a text editor to open /etc/sysctl.conf and find the following line:
kernel.core_uses_pid
Confirm that the file is set to 1. This setting appends the PID to the generated core
file, which allows multiple core file dumps.
If kernel.core_uses_pid is missing, then add the following line:
kernel.core_uses_pid = 1
3.
For example, with IPv4, use the following command to check your current range for
ephemeral ports:
$ cat /proc/sys/net/ipv4/ip_local_port_range
32768 61000
In the preceding example, the lowest port (32768) and the highest port (61000) are set
to the default range.
If necessary, update the UDP and TCP ephemeral port range to a range high enough
for anticipated system workloads, and to ensure that the ephemeral port range starts
at 9000 and above. For example:
# echo 9000 65500 > /proc/sys/net/ipv4/ip_local_port_range
Oracle recommends that you make these settings permanent. For example, as root,
use a text editor to open /etc/sysctl, and add or change to the following:
net.ipv4.ip_local_port_range = 9000 65500, and then restart the network (#
/etc/rc.d/init.d/network restart). Refer to your Linux distribution system
administration documentation for detailed information about how to automate this
ephemeral port range alteration on system restarts.
Note:
CV_RAW_CHECK_ENABLED=FALSE
In this example, oracle_home1 is the Oracle home directory where the
database is installed.
1.
Locate the cvuqdisk RPM package, which is in the directory rpm on the installation
media. If you already installed Oracle Grid Infrastructure, then it is in the
directory oracle_home1/cv/rpm.
2.
Log in as root.
3.
Use the following command to find if you have an existing version of the
cvuqdisk package:
# rpm -qi cvuqdisk
If you have an existing version, then enter the following command to deinstall the
existing version:
# rpm -e cvuqdisk
4.
Set the environment variable CVUQDISK_GRP to point to the group that will own
cvuqdisk, typically oinstall, for example:
# CVUQDISK_GRP=oinstall; export CVUQDISK_GRP
5.
In the directory where you have saved the cvuqdisk RPM, use the following
command to install the cvuqdisk package:
rpm -iv package
For example:
# rpm -iv cvuqdisk-1.0.9-1.rpm
In C shell:
% setenv ORACLE_HOSTNAME somehost.us.example.com
An unprivileged user
Verify that the unprivileged user nobody exists on the system. The nobody user
must own the external jobs (extjob) executable after the installation.
The following operating system group and user are required for all installations:
Note:
user.
All installations of Oracle software on the system require a single Oracle Inventory
group. After the first installation of Oracle software, you must use the same Oracle
Inventory group for all subsequent Oracle software installations on that system.
However, you can choose to create different Oracle software owner users, OSDBA
groups, and OSOPER groups (other than oracle, dba, and oper) for separate
installations. By using different groups for different installations, members of these
different groups have DBA privileges only on the associated databases, rather than on
all databases on the system.
See Also: Oracle Database Administrator's Guide for more
information about the OSDBA group and the SYSDBA and SYSOPER
privileges
Note:
If you prefer to allocate operating system user privileges so that you can use one
administrative user and one group for operating system authentication for all
administrative privileges, then you can use the oracle user as the installation owner,
and use one group as the primary group for any user requiring administrative
privileges for Oracle ASM, and Oracle Audit Vault Server administration. This group
must also be the Oracle Inventory group. To simplify using the defaults for Oracle
tools the group name should be oinstall.
You can also create custom configuration groups and users based on job role
separation. A custom configuration is a configuration with groups and users that
divide access privileges granted by membership in separate operating system groups
and users. You can create a single user (for example, oracle) to own both Oracle Audit
Vault Server, and Oracle Grid Infrastructure installations. Alternatively, you can create
a separate user (for example, grid) to own the Oracle Grid Infrastructure installation.
Note that all Oracle Audit Vault Server and Oracle Grid Infrastructure for a
standalone server installations must be owned by the Oracle software owner user
(oracle), and belong to the Oracle Inventory group (oinstall).
Creating Database Operating System Groups and Users with Job Role Separation
In Oracle documentation, a user created to own only Oracle
Grid Infrastructure software installations is called the grid user. A
user created to own either all Oracle installations, or only Oracle
database installations, is called the oracle user.
Note:
2.9.1 Creating Custom Configuration Groups and Users for Job Roles
This section provides an overview of how to create users and groups to divide access
privileges by job roles. Log in as root to create these groups and users.
You must create this group the first time you install Oracle software on the system.
This group identifies operating system user accounts that have database
administrative privileges (the SYSDBA privilege). The name used for this group in
Oracle code examples is dba.
Note:
Oracle ASM instance. By default, members of the OSASM group also have all
privileges granted by the SYSOPER for ASM privilege.
If you want to have an OSOPER group for Oracle ASM, then the Oracle Grid
Infrastructure owner must be a member of this group.
2.9.2 Creating Database Operating System Groups and Users with Job Role Separation
The following sections describe how to create the required operating system user and
groups:
Note:
Oracle recommends that you do not use the UID and GID defaults on
each node because group and user IDs likely will be different on each
node. Instead, provide common assigned group and user IDs, and
confirm that they are unused on any node before you create or modify
groups and users.
If you have an existing Oracle Inventory, then ensure that you use the same Oracle
Inventory for all Oracle software installations, and ensure that all Oracle software
users you intend to use for installation have permissions to write to this directory.
To determine if the Oracle Inventory group exist, enter the following command:
# grep oinstall /etc/group
If the oraInst.loc file exists, then the output from this command is similar to the
following:
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
An OSDBA group does not exist, for example, if this is the first installation of
Oracle software on the system
An OSDBA group exists, but you want to give a different group of operating
system users database administrative privileges for a new Oracle installation
If the OSDBA group does not exist or if you require a new OSDBA group, then create
it as follows. In the following procedure, use the group name dba unless a group with
that name already exists:
# /usr/sbin/groupadd -g 502 dba
If an OSOPER group does not exist; for example, if this is the first installation of
Oracle software on the system
If an OSOPER group exists, but you want to give a different group of operating
system users database operator privileges in a new Oracle installation
If you require a new OSOPER group (typically, oper), then create it as follows. In the
following, use the group name oper unless a group with that name already exists:
# /usr/sbin/groupadd -g 503 oper
2.9.2.4 Creating the OSASM Group for Oracle Automatic Storage Management
If the OSASM group does not exist or if you require a new OSASM group, then create
it as follows. In the following procedure, use the group name asmadmin unless a group
with that name already exists:
# /usr/sbin/groupadd -g 504 asmadmin
2.9.2.5 Creating the OSDBA Group for Oracle Automatic Storage Management
If you require a new OSDBA group for Oracle ASM, then create it as follows. In the
following procedure, use the group name asmdba unless a group with that name
already exists:
# /usr/sbin/groupadd -g 506 asmdba
2.9.2.6 Creating the OSOPER Group for Oracle Automatic Storage Management
If you require an OSOPER group, then create it as follows. In the following procedure,
use the group name asmoper unless a group with that name already exists:
# /usr/sbin/groupadd -g 505 asmoper
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 operating
system user, with different group membership, to give database administrative
privileges to those groups in a new Oracle Audit Vault Server installation.
If you have created an Oracle software owner for Oracle Grid Infrastructure, such
as grid, and you want to create a separate Oracle software owner for Oracle Audit
Vault Server software, such as oracle.
If the oracle user exists, then the output from this command is similar to the
following:
uid=501(oracle) gid=501(oinstall) groups=502(dba),503(oper)
If the grid user exists, then the output from this command is similar to the following:
uid=8001(oracle) gid=8001(oinstall)
groups=8001(oinstall),8002(asmadmin),8003(asmdba),8006(dba)
Determine if you want to use the existing user or create another user. If you want to
use the existing user, then ensure that the user's primary group is the Oracle Inventory
group (oinstall) and that it is a member of the appropriate OSDBA and OSOPER
groups. See the following sections for more information:
Note:
2.9.2.7.2 Creating an Oracle Software Owner User If the Oracle software owner user does
not exist, or if you require a new Oracle software owner user, such as oracle or grid,
then create it as described in this section (in this case to create the oracle user).
In the following procedure, use the user name oracle unless a user with that name
already exists:
1.
2.
The -u option specifies the user ID. Using this command flag is optional
because the system can provide you with an automatically generated user ID
number. You must note the oracle user ID number because you will need it
during preinstallation.
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 and ASMDBA groups, for example, dba,
asmdba, or oper.
2.9.2.7.3 Modifying an Existing Oracle Software Owner User 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, then modify it as follows:
Specify the primary group using the -g option and any required secondary group
using the -G option:
# /usr/sbin/usermod -g oinstall -G dba,asmdba[,oper] oracle
2.10 Checking Resource Limits for the Oracle Software Installation Users
For each installation software owner, check the resource limits for installation, using
the following recommended ranges:
Table 21
Resource
Soft Limit
Hard Limit
nofile
At least 1024
At least 65536
nproc
At least 2047
At least 16384
stack
2.
Check the soft and hard limits for the file descriptor setting. Ensure that the result
is in the recommended range, for example:
$ ulimit -Sn
4096
$ ulimit -Hn
65536
3.
Check the soft and hard limits for the number of processes available to a user.
Ensure that the result is in the recommended range, for example:
$ ulimit -Su
2047
$ ulimit -Hu
16384
4.
Check the soft limit for the stack setting. Ensure that the result is in the
recommended range, for example:
$ ulimit -Ss
10240
$ ulimit -Hs
32768
5.
soft
hard
soft
hard
soft
nproc
nproc
nofile
nofile
stack
2047
16384
1024
65536
10240
Note:
IMPORTANT:
Parameter
Minimum Value
File
semmsl
250
/proc/sys/kernel/sem
semmns
32000
semopm
100
semmni
128
shmall
2097152
shmmax
/proc/sys/kernel/shmall
Default: 536870912
See My Oracle Support
Note 567506.1 for
additional information
about configuring
shmmax.
shmmni
4096
/proc/sys/kernel/shmmni
Parameter
Minimum Value
File
file-max
6815744
/proc/sys/fs/file-max
aio-max-nr
Maximum: 1048576
/proc/sys/fs/aio-max-nr
/proc/sys/net/ipv4/ip_local_
port_range
262144
/proc/sys/net/core/rmem_default
rmem_max
4194304
/proc/sys/net/core/rmem_max
wmem_default
262144
/proc/sys/net/core/wmem_default
wmem_max
1048576
/proc/sys/net/core/wmem_max
If the current value for any parameter is greater than the value
listed in this table, then the Fixup scripts do not change the value of
that parameter.
Note:
See Also:
Command
semmsl, semmns,
semopm, and semmni
file-max
rmem_default
rmem_max
wmem_default
wmem_max
aio-max-nr
If the value of any kernel parameter is different from the minimum value, then
perform the following:
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. If any of the current values are larger
than the minimum value, then specify the larger value.
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
Note: The minimum value required for shmmax is 0.5 GB. However,
Oracle recommends that you set the value of shmmax to 2.0 GB for
optimum performance of the system.
By specifying the values in the /etc/sysctl.conf file, they persist when you
restart the system. However, on SUSE Linux Enterprise Server systems, enter the
following command to ensure that the system reads the /etc/sysctl.conf file
when it restarts:
# /sbin/chkconfig boot.sysctl on
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.
Enter the command /sbin/sysctl -a to confirm that the values are set correctly.
4.
On SUSE systems only, enter the following command for the system to read the
/etc/sysctl.conf file when it restarts:
# /sbin/chkconfig boot.sysctl on
5.
On SUSE systems only, you must enter the GID of the oinstall group as the value
for the parameter /proc/sys/vm/hugetlb_shm_group. Doing this grants members
of oinstall a group permission to create shared memory segments.
For example, where the oinstall group GID is 501:
# echo 501 > /proc/sys/vm/hugetlb_shm_group
Note:
6.
Ensure that the paths you select for Oracle software, such as the
Oracle home path and the Oracle base path, use only ASCII
characters. Because installation owner names are used by default
for some path, this ASCII character restriction applies to user
names, file names, and directory names.
Ensure that all paths used by the database software, such as the
Oracle home path and the Oracle base path, use characters only
from the following set: "#%&'()*+,-./:;<=>?@_A-Za-z0-9. This
includes user names, file names, and directory names. At the time
of this release, the use of other characters for an Oracle Grid
Infrastructure home or Oracle Audit Vault Server home is not
supported. The set of characters provided above is further
restricted by user and file naming rules of the operating system.
In this example:
mount_point is the mount point directory for the file system that will contain the
Oracle software.
The examples in this guide use /u01 for the mount point directory. However, you
can choose another mount point directory, such as /oracle or /opt/oracle.
You must specify the Oracle base folder that contains all Oracle products.
If you have an existing Oracle base, then you can select it from
the Use existing list. By default, the list contains the existing value for
Oracle base preselected. Refer to Section 4.3 and Section 4.5 for further
information.
Note:
If you do not have an Oracle base, then you can create one by editing
the text in the list box.
You can use the same Oracle base directory for more than one installation or you can
create separate Oracle base directories for different installations. If different operating
system users install Oracle software on the same system, then each user must create a
separate Oracle base directory. The following are examples of Oracle base directories
that can exist on the same system:
/u01/app/oracle
/u01/app/orauser
/opt/oracle/app/oracle
Refer to Section 2.13.2 for information about creating an Oracle base directory.
If you have set ORACLE_BASE for the oracle user during installation, then Oracle
Universal Installer creates the Oracle Inventory directory in the path ORACLE_
BASE/../oraInventory. For example, if ORACLE_BASE is set to /opt/oracle/11, then
the Oracle Inventory directory is created in the path /opt/oracle/oraInventory.
If you have neither created an OFA-compliant path nor set ORACLE_BASE, then the
Oracle Inventory directory is placed in the home directory of the user that is
performing the installation. For example:
/home/oracle/oraInventory
Oracle Universal Installer creates the directory that you specify and sets the correct
owner, group, and permissions for it. You do not need to create it.
Note:
Oracle Universal Installer creates the directory path that you specify under the Oracle
base directory. It also sets the correct owner, group, and permissions on it. You do not
need to create this directory.
During installation, you must not specify an existing directory
that has predefined permissions applied to it as the Oracle home
directory. If you do, then you may experience installation failure due
to file and group ownership permission errors.
Note:
Note:
Identifying an existing Oracle Inventory directory. Refer to Section 2.9.2.1 for more
information.
Oracle recommends that you do not put the oraInventory
directory under Oracle base for a new installation. However, if you
have an existing installation, then you should follow the steps
suggested in this section.
Note:
If the oratab file exists, then it contains lines similar to the following:
*:/u03/app/oracle/product/11.2.0/dbhome_1:N
*:/opt/orauser/infra_904:N
*:/oracle/9.2.0:N
The directory paths specified on each line identify Oracle home directories.
Directory paths that end with the user name of the Oracle software owner that you
want to use are valid choices for an Oracle base directory. If you intend to use the
oracle user to install the software, then you can choose one of the following
directories listed in the previous example:
/u03/app/oracle
/oracle
Note:
Before deciding to use an existing Oracle base directory for this installation, ensure
that it satisfies the following conditions:
Requirement
Up to 4 GB
Up to 6 GB
To determine the free disk space on the file system where the Oracle base
directory is located, enter the following command:
# df -h oracle_base_path
Choosing a Storage Option for Oracle Audit Vault Server and Recovery Files
To continue:
If an Oracle base directory exists and you want to use it, then refer to Section 2.14.
When you configure the oracle users environment later in this chapter, set the
ORACLE_BASE environment variable to specify the directory you chose.
If an Oracle base directory does not exist on the system or if you want to create an
Oracle base directory, then refer to the following section.
To determine the free disk space on each mounted file system use the following
command:
# df -h
2.
From the display, identify a file system that has appropriate free space.
The file system that you identify can be a local file system, a cluster file system, or
an NFS file system on a certified NAS device.
3.
Note the name of the mount point directory for the file system that you identified.
To create the Oracle base directory and specify the correct owner, group, and
permissions for it:
1.
For example:
# mkdir -p /u01/app/oracle
# chown -R oracle:oinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle
2.
When you configure the oracle users environment (see Section 2.18), set the
ORACLE_BASE environment variable to specify the Oracle base directory that you
have created.
2.14 Choosing a Storage Option for Oracle Audit Vault Server and
Recovery Files
Oracle Audit Vault Server files include data files, control files, redo log files, the server
parameter file, and the password file. For all installations, you must choose the storage
option that you want to use for Oracle Audit Vault Server files. If you want to enable
automated backups during the installation, then you must also choose the storage
option that you want to use for recovery files (the fast recovery area). You do not have
to use the same storage option for each file type.
Note: Oracle Audit Vault Server files and recovery files are
supported on file systems and Oracle ASM.
Use the following guidelines when choosing the storage options that you want to use
for each file type:
You can choose any combination of the supported storage options for each file
type.
Determine if you want to use Oracle ASM for Oracle Audit Vault Server files,
recovery files, or both. Refer to the section Section 3.6.2.
For more information about these storage options, refer to the Section 1.7.
For information about how to configure disk storage before you start the installation,
refer to one of the following sections depending on your choice:
To use a file system for database or recovery file storage, refer to Section 2.15.
To use Oracle ASM for database or recovery file storage, refer to Section 3.6.
To identify disk groups and determine the free disk space that they contain, refer
to Section 4.1.1.
2.15 Creating Directories for Oracle Audit Vault Server or Recovery Files
This section contains the following topics:
Guidelines for Placing Oracle Audit Vault Server Files on a File System
2.15.1 Guidelines for Placing Oracle Audit Vault Server Files on a File System
If you choose to place the Oracle Audit Vault Server files on a file system, then use the
following guidelines when deciding where to place them:
The default path suggested by Oracle Universal Installer for the database file
directory is a subdirectory of the Oracle base directory.
You can choose either a single file system or more than one file system to store the
database files:
If you want to use a single file system, then choose a file system on a physical
device that is dedicated to the database.
For best performance and reliability, choose a RAID device or a logical volume
on more than one physical device and implement the
stripe-and-mirror-everything (SAME) methodology.
If you want to use more than one file system, then choose file systems on
separate physical devices that are dedicated to the database.
This method enables you to distribute physical input-output operations and
create separate control files on different devices for increased reliability. It also
enables you to fully implement the OFA guidelines. You can choose the
Advanced database creation option to implement this method.
If you intend to create a preconfigured database during the installation, then the
file system (or file systems) that you choose must have at least 2 GB of free disk
space.
For production databases, you must estimate the disk space requirement
depending on the use that you want to make of the database.
For optimum performance, the file systems that you choose should be on physical
devices that are used only by the database.
The oracle user must have write permissions to create the files in the path that
you specify.
Note:
To create directories for the Oracle Audit Vault Server, or recovery files on separate file
systems to the Oracle base directory:
1.
Use the following to determine the free disk space on each mounted file system:
# df -h
2.
From the display, identify the file systems that you want to use:
File Type
Oracle Audit
Vault Server files
Choose either:
Recovery files
If you are using the same file system for more than one type of file, then add the
disk space requirements for each type to determine the total disk space
requirement.
3.
Note the names of the mount point directories for the file systems that you
identified.
4.
If you also want to use Oracle ASM for storage, then refer to Section 3.6.
2.16 Configuring Storage for Oracle Audit Vault Server Files Using Block
Devices
This section describes how to configure Oracle Audit Vault Server files on block
devices. Use the following procedure to create block device partitions:
1.
Use fdisk to create disk partitions on block devices for database files.
If you intend to configure block devices and use Oracle ASM to manage data files,
then create one partition for each disk comprising the whole disk, and go through
the section Configuring Disks for Oracle ASM with ASMLIB in Oracle Grid
Infrastructure Installation Guide.
2.
Oracle Audit Vault Server files. If you do not create this permissions file, then
permissions on disk devices revert to their default values, root:disk, and Oracle
Audit Vault Server fails to start. Use the following steps to set the permissions file
number:
On Red Hat Enterprise Linux 4 and Oracle Linux 4, you must create a permissions
file number that is lower than 50.
On Asianux Server 3, Red Hat Enterprise Linux 5, Oracle Linux 5, SUSE Enterprise
Linux 10, or SUSE Enterprise Linux 11, you must create a permissions file number
that is higher than 50.
To configure a permissions file for disk devices, complete the following tasks:
Example of Creating a Udev Permissions File for Oracle Audit Vault Server
Example of Configuring Block Device Storage for Oracle Audit Vault Server
See Also: Oracle Grid Infrastructure Installation Guide for information
about configuring storage for Oracle Audit Vault Server files on
shared storage devices.
2.17.1 Example of Creating a Udev Permissions File for Oracle Audit Vault Server
Refer to the examples in Section 2.16 for more information about creating a
permissions file.
2.17.2 Example of Configuring Block Device Storage for Oracle Audit Vault Server
The following is the procedure to create partitions for Oracle Audit Vault Server files
on block devices:
1.
Log in as root
2.
Enter the fdisk command to format a specific storage disk. For example,
/sbin/fdisk /dev/sdb
3.
Create a partition. For instance, make a partition of 280 MB for data files.
4.
Use the command similar to the following to update the kernel partition table for
the shared storage device:
/sbin/partprobe diskpath
The following is an example of how to use fdisk to create one partition on a shared
storage block disk device for a data file:
$ sudo sh
Password:
# /sbin/fdisk /dev/sdb
The number of cylinders for this disk is set to 1024.
Command (m for help): n
Command action
e
extended
P
primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-1024, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-4462, default 1)
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-1024, default 4462): using default
value 4462
2-36 Oracle Audit Vault Server Installation Guide
Set the default file mode creation mask (umask) to 022 in the shell startup file.
2.
Enter the following command to ensure that X Window applications can display
on this system:
$ xhost fully_qualified_remote_host_name
For example:
$ xhost somehost.us.example.com
3.
If you are not already logged in to the system where you want to install the
software, then log in to that system as the oracle user.
4.
If you are not logged in as the oracle user, then switch user to oracle:
$ su - oracle
5.
To determine the default shell for the oracle user, enter the following command:
$ echo $SHELL
6.
To run the shell startup script, enter one of the following commands:
Bash shell:
$ . ./.bash_profile
C shell:
Oracle Audit Vault Preinstallation Requirements 2-37
% source ./.login
7.
If you are not installing the software on the local computer, then run the following
command on the remote machine to set the DISPLAY variable:
C shell:
% setenv DISPLAY local_host:0.0
In this example, local_host is the host name or IP address of the local computer
that you want to use to display Oracle Universal Installer.
Run the following command on the remote machine to check if the shell and the
DISPLAY environmental variable are set correctly:
echo $SHELL
echo $DISPLAY
Now to enable X applications, run the following commands on the local computer:
$ xhost + fully_qualified_remote_host_name
To verify that X applications display is set properly, run a X11 based program that
comes with the operating system such as xclock:
$ xclock
If you determined that the /tmp directory has less than 1 GB of free disk space,
then identify a file system with at least 1 GB of free space and set the TMP and
TMPDIR environment variables to specify a temporary directory on this file system:
a.
To determine the free disk space on each mounted file system use the
following command:
# df -h /tmp
b.
c.
Enter commands similar to the following to set the TMP and TMPDIR
environment variables:
*
$ TMPDIR=/mount_point/tmp
$ export TMP TMPDIR
C shell:
% setenv TMP /mount_point/tmp
% setenv TMPDIR /mount_point/tmp
9.
Enter commands similar to the following to set the ORACLE_BASE and ORACLE_SID
environment variables:
C shell:
% setenv ORACLE_BASE /u01/app/oracle
% setenv ORACLE_SID sales
In this example, /u01/app/oracle is the Oracle base directory that you created or
identified earlier and sales is the name that you want to call the database
(typically no more than five characters).
10. Enter the following commands to ensure that the ORACLE_HOME and TNS_ADMIN
C shell:
% unsetenv ORACLE_HOME
% unsetenv TNS_ADMIN
See Also:
For example, for the C shell, you would enter the following command, where
myhost.us.example.com is your host name:
3
Oracle Grid Infrastructure
3
The Oracle Grid Infrastructure for a standalone server is the Oracle software that
provides system support for an Oracle database including volume management, file
system, and automatic restart capabilities. If you plan to use Oracle Restart or Oracle
Automatic Storage Management (Oracle ASM), you must install Oracle Grid
Infrastructure before installing Oracle Audit Vault Server. Oracle Grid Infrastructure
for a standalone server is the software that includes Oracle Restart and Oracle ASM.
Oracle combined the two infrastructure products into a single set of binaries that is
installed as the Oracle Grid Infrastructure home. Oracle Grid Infrastructure should be
installed before installing Oracle Audit Vault Server because Oracle Audit Vault Server
installs a customized, specially configured release of Oracle Database 11g Release 2
(11.2.0.3).
Oracle ASM is a volume manager and a file system for Oracle database files that
supports single-instance Oracle Audit Vault Server and Oracle Real Application
Clusters (Oracle RAC) configurations. Oracle ASM also supports a general purpose
file system for your application needs including Oracle Audit Vault Server binaries.
Oracle ASM is Oracle's recommended storage management solution that provides an
alternative to conventional volume managers, file systems, and raw devices.
Oracle Restart improves the availability of your Oracle database by providing the
following:
If you want to use Oracle ASM or Oracle Restart, then you must
first install Oracle Grid Infrastructure for a standalone server and
then install Oracle Audit Vault Server.
Oracle Restart is used in single-instance (non-clustered)
environments only. See Section 1.6.3 for more information about
how Oracle Audit Vault supports Oracle Restart.
3-1
Memory Requirements
If the size of the RAM is less than the required size, then you must install more
memory before continuing.
The following table describes the relationship between installed RAM and the
configured swap space requirement:
On Linux, the HugePages feature allocates non-swappable
memory for large page tables using memory-mapped files. If you
enable HugePages, then you should deduct the memory allocated to
HugePages from the available RAM before calculating swap space.
Note:
RAM
Swap Space
Between 2 GB and 16 GB
More than 16 GB
16 GB
If the size of the RAM is less than the required size, then you must install more
memory before continuing.
To determine the size of the configured swap space, enter the following command:
# grep SwapTotal /proc/meminfo
If necessary, refer to the operating system documentation for information about how to
configure additional swap space.
To determine the available RAM and swap space, enter the following command:
# free
Note:
To determine the amount of free space available in the /tmp directory, enter the
following command:
# df -k /tmp
If there is less than 1 GB of free space available in the /tmp directory, then complete
one of the following steps:
Delete unnecessary files from the /tmp directory to meet the disk space
requirement.
Set the TMP and TMPDIR environment variables to specify a temporary directory
when setting the oracle users environment.
See Also:
TMPDIR
Extend the file system that contains the /tmp directory. If necessary, contact the
system administrator for information about extending file systems.
3-3
Set the Oracle Grid Infrastructure software owner user default file mode creation
mask (umask) to 022 in the shell startup file. Setting the mask to 022 ensures that
the user performing the software installation creates files with 755 permissions.
Set ulimit settings for file descriptors and processes for the Oracle Grid
Infrastructure installation software owner.
Set the DISPLAY environment variable in preparation for installation.
If you plan to install Oracle Audit Vault Server, then you must meet additional
preinstallation requirements. See Chapter 2.
Note:
Automatic Storage Management Cluster File System (ACFS) resources are not
supported for Oracle Restart configurations on all platforms. ACFS drivers must be
manually unloaded and loaded; ACFS file systems must be manually unmounted and
mounted (after the ASM instance is running); ACFS database home file systems can be
placed into the ACFS mount registry to be mounted along with other registered ACFS
file systems.
See Also:
Oracle Database Release Notes for Linux for latest information about
supported platforms and releases
Oracle Automatic Storage Management Administrator's Guide for
more information about Oracle Automatic Storage Management
Cluster File System and Oracle Automatic Storage Management
Dynamic Volume Manager
Note:
During installation, if you chose to use Oracle ASM and Oracle ASMCA detects that
there is a prior Oracle ASM version installed in another Oracle ASM home, then after
installing the Oracle ASM 11g Release 2 (11.2) binaries, you can start Oracle ASMCA to
upgrade the existing Oracle ASM instance.
See Also:
3-5
You must complete the steps listed under Section 3.6 to prepare a disk partition to
use for the Oracle ASM disk groups.
Ensure that at least one disk is configured appropriately for use in an Oracle ASM
diskgroup before beginning the installation.
When you install Oracle ASM, Oracle Automatic Storage Management
Configuration Assistant (Oracle ASMCA) creates a separate server parameter file
(SPFILE) and password file for the Oracle ASM instance. As soon as Oracle ASM is
installed, the ASMSNMP schema and user are created. See Oracle Automatic Storage
Management Administrator's Guide for more information.
The Oracle ASM instance that manages the existing disk group will be running in
the Oracle Grid Infrastructure home directory.
Note:
2.
If you are creating a new Oracle ASM disk group, create partitions for DAS or
SAN disks.
3.
Configure the disks for use with Oracle ASM. You must provide the Oracle ASM
disk configuration information during the Oracle Grid Infrastructure installation.
Determine if you want to use Oracle ASM for Oracle Audit Vault Server files,
recovery files, or both.
You do not have to use the same storage mechanism for
Oracle Vault Server files and recovery files. You can use a file
system for one file type and Oracle ASM for the other.
Note:
You can run Oracle ASMCA in interactive mode to create and configure the
required disk groups.
During the database installation, if you select an installation method that runs
Database Configuration Assistant in interactive mode (Advanced Installation
type), then you can select the diskgroups that you created using Oracle
ASMCA.
You have the option to use the disk groups you created using Oracle ASMCA
both for database files and recovery files, or you can choose to use different
disk groups for each file type. Ideally, you should create separate Oracle ASM
disk groups for data files and for recovery files.
If you run Oracle ASMCA in noninteractive mode, then you must use the
same Oracle ASM disk group for data files and recovery files. During the
database installation (Typical Installation type), you will have to select the
same disk group for both data files and recovery files.
See Also:
2.
Choose the Oracle ASM redundancy level that you want to use for each Oracle
ASM disk group that you create.
The redundancy level that you choose for the Oracle ASM disk group determines
how Oracle 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
3-7
This option does not allow Oracle ASM to mirror the contents of the disk
group. Oracle recommends that you select this redundancy level either when
the disk group contains devices, such as RAID devices, that provide their own
data protection or when the database does not require an uninterrupted access
to data.
Normal redundancy
To optimize performance and reliability in a normal redundancy disk group,
Oracle ASM uses two-way mirroring for data files and three-way mirroring
for control files, by default. In addition, you can choose the mirroring
characteristics for individual files in a disk group. Alternatively, you can use
two-way mirroring or no mirroring.
A normal redundancy disk group requires a minimum of two failure groups
(or two disk devices) if you are using two-way mirroring. 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
The contents of the disk group are three-way mirrored by default. To create a
disk group with high redundancy, you must specify at least three failure
groups (a minimum of 3 devices).
Although high-redundancy disk groups 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 database files
and recovery files.
If an Oracle ASM instance is already running on the system, then 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 database installation.
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
Data Files
Recovery
Files
Both File
Types
External
1.8 GB
3.6 GB
5.4 GB
Normal
3.6 GB
7.2 GB
10.8 GB
High
5.4 GB
10.8 GB
16.2 GB
4.
Optionally, identify failure groups for the Oracle ASM disk group devices.
If you intend to use a normal or high redundancy disk group, then you can further
protect the database against hardware failure by associating a set of disk devices in
a custom failure group. By default, each device comprises its failure group.
However, if two disk devices in a normal redundancy disk group are attached to
the same SCSI controller, then the disk group becomes unavailable if the controller
fails. The controller in this example is a single point of failure.
For instance, to avoid failures of this type, you can 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.
If you define custom failure groups, then you must specify
a minimum of two failure groups for normal redundancy disk
groups and three failure groups for high redundancy disk groups.
Note:
5.
If you are sure that a suitable disk group does not exist on the system, then install
or identify appropriate disk devices to add to a new disk group. Apply the
following guidelines when identifying appropriate disk devices:
The disk devices must be owned by the user performing the grid installation.
See Also: Example 22 for information about creating or modifying
permissions
All the devices in an Oracle ASM disk group should be the same size and have
the same performance characteristics.
Do not specify multiple partitions on a single physical disk as a disk group
device. Oracle ASM expects each disk group device to be on a separate
physical disk.
Oracle does not recommend the use of a logical volume as a device in Oracle
ASM because the logical volume can hide the physical disk architecture which
prevents Oracle ASM from optimizing I/O across physical devices.
See Also:
3.6.3 Step 2: Creating DAS or SAN Disk Partitions for Oracle Automatic Storage
Management
In order to use a DAS or SAN disk in Oracle ASM, the disk must have a partition table.
Oracle recommends creating exactly one partition for each disk containing the entire
disk.
You can use any physical disk for Oracle ASM, as long as it is
partitioned.
Note:
3-9
associated utilities and use them to configure the devices that you want to include in
an Oracle ASM disk group.
If you choose to configure disks using the Oracle Automatic
Storage Management library driver, then you must change the default
disk discovery string to ORCLDISK:*. If the diskstring is set to
ORCLDISK:*, or is left empty (""), then the installer discovers these
disks.
Note:
This section describes how to configure storage for use with Oracle ASM.
3.6.4.1 Configuring Disks for Oracle Automatic Storage Management Using the
Automatic Storage Management Library Driver (ASMLIB)
To use the Automatic Storage Management library driver to configure Automatic
Storage Management devices, complete the following tasks:
Enter the following command to determine the kernel version and architecture of
the system:
# uname -rm
2.
You must install the following packages, where version is the version of the
Automatic Storage Management library driver, arch is the system architecture,
and kernel is the version of the kernel that you are using:
oracleasm-support-version.arch.rpm
oracleasm-kernel-version.arch.rpm
oracleasmlib-version.arch.rpm
3.
For example, if you are using the Red Hat Enterprise Linux AS 3.0 enterprise
kernel on an x86 system, then enter a command similar to the following:
3-10 Oracle Audit Vault Server Installation Guide
Enter a command similar to the following to determine the UID of the Oracle
software owner user that you are using for this installation and the GID of the
OSASM group:
# id oracle
5.
Enter the following command to run the oracleasm initialization script with the
configure option:
# /etc/init.d/oracleasm configure
6.
Enter the following information in response to the prompts that the script
displays:
Prompt
Suggested Response
Configuring the Disk Devices to Use the Automatic Storage Management Library
Driver
To configure the disk devices that you want to use in an Automatic Storage
Management disk group:
1.
If you intend to use IDE, SCSI, or RAID devices in the Automatic Storage
Management disk group, then:
a.
If necessary, install or configure the disk devices that you intend to use for the
disk group and restart the system.
b.
To identify the device name for the disks that you want to use, enter the
following command:
# /sbin/fdisk -l
Disk Type
Device Name
Format
IDE disk
/dev/hdxn
Description
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.
Disk Type
Device Name
Format
SCSI disk
/dev/sdxn
RAID disk
/dev/rd/cxdypz
/dev/ida/cxdypz
Description
Note:
c.
2.
Use either fdisk or parted to create a single whole-disk partition on the disk
devices that you want to use.
In this example, DISK1 is a name that you want to assign to the disk.
Note:
Description
configure
Option
Description
enable
disable
Use the disable and enable options to change the behavior of the
Automatic Storage Management library driver when the system starts.
The enable option causes the Automatic Storage Management library
driver to load when the system starts:
# /etc/init.d/oracleasm enable
start
stop
restart
Use the start, stop, and restart options to load or unload the
Automatic Storage Management library driver without restarting the
system:
# /etc/init.d/oracleasm restart
createdisk
Use the createdisk option to mark a disk device for use with the
Automatic Storage Management library driver and give it a name:
# /etc/init.d/oracleasm createdisk DISKNAME devicename
deletedisk
querydisk
listdisks
Use the listdisks option to list the disk names of marked Automatic
Storage Management library driver disks:
# /etc/init.d/oracleasm listdisks
scandisks
Where rules files describe the same devices, on Asianux, Red Hat, and Oracle Linux,
the last file read is the one that is applied. On SUSE 2.6 kernels, the first file read is the
one that is applied.
To configure a permissions file for disk devices, complete the following tasks:
1.
2.
Using a text editor, create a UDEV rules file for the Oracle ASM devices, setting
permissions to 0660 for the installation owner and the group whose members are
administrators of the grid infrastructure software. For example, using the
installation owner grid and using a role-based group configuration, with the
OSASM group asmadmin:
# vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sd?1", BUS=="scsi", PROGRAM=="/sbin/scsi_id",
RESULT=="14f70656e66696c00000000", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?2", BUS=="scsi", PROGRAM=="/sbin/scsi_id",
RESULT=="14f70656e66696c00000000", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?3", BUS=="scsi", PROGRAM=="/sbin/scsi_id",
RESULT=="14f70656e66696c00000000", OWNER="grid", GROUP="asmadmin", MODE="0660"
3.
Load updated block device partition tables on the server, using /sbin/partprobe
devicename. You must do this as root.
4.
Note:
2.
Start the runInstaller command from the relevant directory on the Oracle
Database 11g release 2 (11.2) installation media or download directory.
2.
3.
Verify that the server meets the installation requirements using the command
runcluvfy.bat stage -pre hacfg. Ensure that you have completed all storage
and server preinstallation requirements.
Run the roothas.pl script from Grid_home, using the following syntax:
Grid_home/perl/bin/perl -I Grid_home/perl/lib -I Grid_home/crs/install
Grid_home/crs/install/roothas.pl
For example, if your Grid home is /app/11.2.0/grid, then run the following
script:
$ /app/11.2.0/grid/perl/bin/perl -I /app/11.2.0/grid/perl/lib -I /app
/11.2.0/grid/crs/install /app/11.2.0/grid/crs/install/roothas.pl
2.
3.
For example:
$ ./runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid
-defaultHomeName
CLUSTER_NODES= CRS=TRUE
4.
Use the SRVCTL utility along with Network Configuration Assistant and Oracle
ASMCA to add the listener, the Oracle ASM instance, and all Oracle ASM disk
groups to the Oracle Restart configuration.
Note:
Start Oracle Universal Installer as the Oracle Grid Infrastructure software owner
user. Complete one of the following steps depending on the location of the
installation files:
If the installation files are on installation media, enter commands similar to the
following, where directory_path is the path of the Oracle Grid Infrastructure
directory on the installation media:
$ /directory_path/runInstaller
Note:
If the installation files are on the hard disk, change the directory to the path of
the Oracle Grid Infrastructure (clusterware) directory and enter the following
command:
$ ./runInstaller
Starting with Oracle Database 11g Release 2 (11.2.0.2), if you plan to run the
installation in a secured data center, then you can download updates before
starting the installation by starting Oracle Universal Installer on a system that
has Internet access in update download mode. To start Oracle Universal
Installer to download updates, enter the following command:
$ ./runInstaller -downloadUpdates
Provide the My Oracle Support user name and password, and provide proxy
settings if needed. After you download updates, transfer the update file to a
directory on the server where you plan to run the installation.
See Also:
Oracle Universal Installer and OPatch User's Guide for Windows and
UNIX for more information about response file formats
Section 3.1.3 for information about setting the Oracle Grid
Infrastructure software owner users environment
Note:
If Oracle Universal Installer is not displayed, refer to the sections "X Window
Display Errors" and "Remote Terminal Installation Error" in the Troubleshooting
appendix in Oracle Database Installation Guide for Linux for information about
troubleshooting.
2.
Starting with Oracle Database 11g Release 2 (11.2.0.2), you can use the Software
Updates feature to dynamically download and apply latest updates. In the
Download Software Updates screen, select one of the following options and click
Next:
3.
The Apply Software Updates screen is displayed if you select to download the
software updates or provide the pre-downloaded software updates location. If you
selected Use My Oracle Support credentials for download in the previous screen,
then select Download and apply all updates, and click Next.
If you selected Use pre-downloaded software updates in the previous screen, then
select Apply all updates, and click Next.
4.
In the Select Installation Option screen, select the Install and Configure Grid
Infrastructure for a Standalone Server option to install and configure Oracle
Restart and Oracle ASM. Click Next.
5.
In the Select Product Languages screen, select one or more languages. Move the
languages from the Available Languages list to the Selected Languages list. Click
Next.
6.
The Create ASM Disk Group screen lists all the Oracle ASM disks under
ORCLDISK:*
Click Change Disk Discovery Path to select any devices that will be used by
Oracle ASM but are not listed. In the Change Disk Discovery Path window, enter a
string to use to search for devices that Oracle ASM will use. If the diskstring is set
to ORCLDISK:* or is left empty (""), then the installer discovers these disks. Click
OK.
After you finish selecting the disks to be used by Oracle ASM, click Next.
During installation, disk paths mounted on ASM and
registered on ASMLIB with the string ORCLDISK:* are listed as default
database storage candidate disks.
Note:
Consider the following information about disk devices while performing this step:
The Disk Group Name default is DATA. You can enter a new name for the disk
group, or use the default name.
The disk devices must be owned by the user performing the grid installation.
See Also: Example 22 for information about creating or modifying
permissions
Note:
7.
In the Specify ASM Password screen, enter SYSASM password required to connect
to the Oracle ASM instance. The Oracle ASM instance is managed by a privileged
role called SYSASM, which grants full access to Oracle ASM disk groups. Oracle
recommends that you create a less privileged user, ASMSNMP, with SYSDBA privileges
to monitor the Oracle ASM instance.
Enter passwords for the SYS and ASMSNMP user accounts. The passwords should be
at least eight characters in length and include at least one alphabetic and one
numeric character.
Optionally, you can use the same password for all accounts. However, Oracle
recommends that you specify a different password for each account. You must
remember the passwords that you specify.
8.
In the Privileged Operating System Groups screen, select the name of the
operating system group you created for the OSDBA group, the OSASM group, and the
database operator group OSOPER. If you choose to create only the dba group, then
you can use that group for all three privileged groups. If you created a separate
asmadmin group, then use that value for the OSASM group. Click Next.
9.
In the Specify Installation Location screen, enter the following details, and click
Next:
Oracle Base: Enter the directory location for Oracle base. Do not include
spaces in the path name.
Software Location: This field is populated by default in concurrence with
Oracle base location.
See Also: "Naming Directories" section in the Optimal Flexible
Architecture appendix in Oracle Database Installation Guide for Linux
for directory naming conventions
10. If you have not installed any Oracle software previously on this server, the Create
requirements are met to perform the Oracle Grid Infrastructure installation. If all
the system requirements are met, then you will be directed to the Summary screen.
However, if an installation fails, you can review the error.
If you click Check Again, then you can run the prerequisite check again to see if
the minimum requirements are met to carry on with the database installation.
Click Fix & Check Again, if you want the installer to fix the problem and check
the system requirements once more.
Note: The Fix & Check Again option generates a script that you must
run as the root user. This generated script sets some of the system
parameter values. Oracle recommends that you do not modify the
contents of this script. Refer to Section 2.4 for more information about
fixup scripts.
To get a list of failed requirements, select Show Failed from the list. To get a list of
all the prerequirement checks run by the OUI, select Show All. To get a list of the
prerequirement checks that are successful, select Show Succeeded.
Oracle recommends that you use caution in checking the
Ignore All option. If you check this option, then Oracle Universal
Installer may not confirm that your system is able to install Oracle
Audit Vault Server successfully.
Note:
12. Review the contents of the Summary screen, and click Finish.
Starting with Oracle Database 11g Release 2 (11.2), you can click Save Response
File to save all the installation steps into a response file. This file can be used for a
silent installation.
13. The Setup screen displays the progress of the Oracle Grid Infrastructure
installation, then Yes to confirm that you want to exit Oracle Universal Installer.
If you encounter any problems, refer to the configuration log for information. The
path to the configuration log is displayed on the Configuration Assistants window.
15. To create additional disk groups, run the Oracle ASMCA utility. For example, you
can create another disk group named RECOVERY to store the fast recovery area.
See Also:
Note:
On the same host computer as the database, use Oracle Universal Installer to
install Oracle Grid Infrastructure, and select Install and Configure Grid
Infrastructure for a Standalone Server as the installation option.
The Oracle Grid Infrastructure components are installed in a separate Oracle
home.
Refer to Section 3.8.1 for detailed instructions to install Oracle Grid Infrastructure.
Go to the Grid homes bin directory. Use the srvctl add database command to
manually add the database, the listener, the Oracle ASM instance, all Oracle ASM
disk groups, and any database services to the Oracle Grid Infrastructure
configuration.
See Also: "srvctl add database" in Oracle Database Administrator's
Guide for more information about the srvctl add database command
Prepare the Oracle Grid Infrastructure home for modification using the following
procedure:
1.
Log in as the Oracle Grid Infrastructure software owner user and change the
directory to the path Grid_home\bin, where Grid_home is the path to the Oracle
Grid Infrastructure home:
$ cd Grid_home/bin
2.
Shut down the Oracle Restart stack using the following command:
$ crsctl stop has -f
3.
After the Oracle Restart stack is completely shut down, perform the updates to the
software installed in the Grid home.
4.
After installing Oracle Grid Infrastructure, you can also use Oracle ASMCA to create
and configure disk groups, Oracle Automatic Storage Management Dynamic Volume
Manager (Oracle ADVM) and Oracle Automatic Storage Management Cluster File
System (Oracle ACFS).
If you want to create additional disk groups or manually configure Oracle ASM disks,
then you can run the Oracle ASMCA as follows:
$ cd Grid_home/bin
$ ./asmca
Where Grid_home is the path to the Oracle Grid Infrastructure home for a standalone
server.
See Also: Oracle Automatic Storage Management Administrator's Guide
for more information on Oracle ASMCA
Open a shell window, and temporarily set the ORACLE_SID and ORACLE_HOME
environment variables to specify the appropriate values for the Oracle ASM
instance that you want to use.
For example, if the Oracle ASM SID is named +ASM and the Oracle home is located
in the grid subdirectory of the ORACLE_BASE directory, then enter the following
commands to create the required settings:
ORACLE_SID=+ASM
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
export ORACLE_HOME
C shell:
% setenv ORACLE_SID +ASM
% setenv ORACLE_HOME /u01/app/oracle/product/11.2.0/grid
2.
Use ASMCMD to list the disk groups for the Oracle ASM instance:
$ORACLE_HOME/bin/asmcmd lsdg
See Also:
4
4
Installations on a Cluster
If Oracle Clusterware and Oracle RAC are already installed on the system, Oracle
Universal Installer displays the Specify Hardware Cluster Installation page. You
must select the Local Installation option, unless you want to install Oracle RAC.
See Also: Oracle Real Application Clusters Installation Guide for
information about installing Oracle RAC
Note:
View the contents of the oratab file to determine if an Oracle ASM instance is
configured on the system:
# more /etc/oratab
If an Oracle ASM instance is configured on the system, then 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 Oracle ASM instance
and oracle_home_path is the Oracle home directory where Oracle ASM is
installed. By convention, the SID for an Oracle ASM instance should be +ASM.
2.
Open a shell prompt and temporarily set the ORACLE_SID and ORACLE_HOME
environment variables to specify the appropriate values for the Oracle ASM
instance that you want to use.
For example, if the Oracle ASM SID is named +ASM and is located in the grid
subdirectory of the ORACLE_BASE directory, then enter the following commands
to create the required settings:
ORACLE_SID=+ASM
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid/
export ORACLE_HOME
C shell:
% setenv ORACLE_SID +ASM
% setenv ORACLE_HOME /u01/app/oracle/product/11.2.0/grid
3.
By using SQL*Plus, connect to the Oracle ASM instance as the SYS user with
SYSASM privilege and start the instance if necessary:
# $ORACLE_HOME/bin/sqlplus /nolog
SQL> CONNECT SYS as SYSASM
Enter password: SYS_password
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.
If you are adding devices to an existing disk group, then
Oracle recommends that you use devices that have the same size
and performance characteristics as the existing devices in that disk
group.
Note:
The following table lists the various screens displayed and the options to select
during an Oracle Audit Vault Server Basic Installation:
Screen
Action
Select Create and configure Oracle Audit Vault, and click Next
This option installs and configures Oracle Audit Vault Server.
Screen
Action
Oracle Base
The Oracle base directory is a top-level directory for Oracle software
installations owned by an Oracle installation owner account. The default
Oracle base path is mountpoint/app/user, where user is the user account
running the installation. You can change the path based on your
requirements.
Software Location
Either accept the default value or enter or browse to the Oracle home
directory path in which you want to install Oracle Audit Vault Server.
The directory path should not contain spaces.
Ensure that the Oracle home path for the Oracle Audit Vault Server home
and the Oracle base path use only ASCII characters. At the time of this
release, the use of non-ASCII characters for a Oracle Audit Vault Server
home or Oracle base is not supported.
Password
The password for the Oracle Audit Vault administrator account.
The password entered will also be used for the standard database accounts
(sys, system, sysman, dbsnmp). The password will also be used for the
Oracle Database Vault users (Database Vault Owner and the Database Vault
Account Manager users) that are created to facilitate the separation of duties.
Confirm Password
The confirming password for the Oracle Audit Vault Administrator account.
Screen
Action
Password
The password for the Oracle Audit Vault auditor account.
Confirm Password
The confirming password for the Oracle Audit Vault Auditor account.
Create Inventory
You are prompted by the installer to specify the Inventory Directory path for the
central inventory the first time you install any Oracle software on your computer.
Select the oraInventory Group Name of the operating system group that should
own the Oracle Inventory directory (the Oracle Inventory group).
Click Next.
Note: By default, the Oracle Inventory directory is not installed under the Oracle
Base directory. This is because all Oracle software installations share a common
Oracle Inventory, so there is only one Oracle Inventory for all users, whereas
there is a separate Oracle Base for each user.
This option checks the system to verify that it is configured correctly and the
minimum requirements are met to perform the Oracle Audit Vault Server
installation. If you have completed all of the preinstallation steps in this guide, all
of the checks should pass.
If you click Check Again, then you can run the prerequisite check again to see if
the minimum requirements are met to carry on with the database installation.
Click Fix & Check Again, if you want the installer to fix the problem and check
the system requirements once more.
Note: The Fix & Check Again option generates a script that you need to run as
the root user. This generated script sets some of the system parameters to
Oracle-recommended values. Oracle recommends that you do not modify the
contents of this script. Refer to Section 2.4 for more information about fixup
scripts.
To get a list of failed requirements, select ShowFailed from the list. To get a list of
all the prerequirement checks run by the OUI, select Show All. To get a list of the
prerequirement checks that are successful, select Show Succeeded.
Note: Oracle recommends that you use caution in checking the Ignore All option.
If you check this option, then Oracle Universal Installer may not confirm that
your system is able to install Oracle Audit Vault Server successfully.
See Also: Chapter 2 for information about the system requirements
Summary
Advanced Installation Prerequisite Information for Installing in an Oracle Real Application Clusters Environment
Screen
Action
Install product
This screen states the progress of an Oracle Audit Vault Server installation. After
Oracle Audit Vault Server is installed, you are prompted to execute a root
configuration script for new inventory as the root user.
This screen displays the status information for the configuration assistants that
configure the Oracle Audit Vault Server. Finally, a message is displayed at the
end of Audit Vault Configuration Assistant process. Click Next.
Follow the steps as indicated on the Execute Configuration scripts screen to run
the root.sh, and, if required, the orainstRoot.sh configuration scripts as the
root user.
After running the scripts, click OK on the Execute Configuration scripts screen
to continue.
Finish
This screen is shown automatically when all the configuration tools are
successful.
Review the Oracle Enterprise Manager Database Control URL and the Oracle
Audit Vault Console URL information displayed in this screen and click Close.
On the Exit page, click Exit. Then, on the Confirmation message box, click Yes to
exit Oracle Universal Installer.
See Section 4.9.6 for information about logging into Oracle Audit Vault Console and
Oracle Enterprise Manager Database Control.
After you have completed the installation, proceed to Section 4.9 to perform the
postinstallation tasks.
Advanced Installation Installing Single Instance and Installing in an Oracle Real Application Clusters Environment
See "Verifying System Readiness for Installing Oracle Database with CVU " in Oracle
Real Application Clusters Installation Guide for Linux and UNIX for more information.
If the cluster verification check fails, then review and correct the relevant system
configuration steps, and run the test again. Use the system configuration checks
described in "Troubleshooting Installation Setup for Linux" in Oracle Real Application
Clusters Installation Guide for Linux and UNIX to assist you.
Note:
See Section 2.20 for important information about setting the correct locale.
Perform the following procedures to install Oracle Audit Vault.
1.
The following table lists the various screens displayed and the options to select
during an Oracle Audit Vault Server Basic Installation:
Screen
Action
Select Create and configure Oracle Audit Vault, and click Next
This option installs and configures Oracle Audit Vault Server.
Advanced Installation Installing Single Instance and Installing in an Oracle Real Application Clusters Environment
Screen
Action
Select the type of Audit Vault installation you want to perform, and click Next.
Single instance Audit Vault installation: This option installs a single instance
of Oracle Audit Vault Server.
Oracle Real Application Clusters database installation: This option installs
Oracle Audit Vault Server in an Oracle Real Application Clusters (Oracle
RAC) environment.
When you select Oracle Real Application Clusters database installation, you
must make node selections.
If you are installing on a clustered system (Oracle Clusterware is installed and
the system is already part of a cluster), the Node Selection screen appears from
which to select the nodes on which Oracle Audit Vault will be installed. Local
node will always be selected by default. If you are installing Oracle Audit Vault
single instance on this local node only, select the Local Only Installation option,
then click Next.
If you are installing on a clustered system (Oracle Clusterware is installed and
the system is already part of a cluster), select the nodes on which Oracle Audit
Vault must be installed. Oracle recommends to install software on all the cluster
nodes instead of a subset of nodes. After selecting these nodes, click Next.
See Section 4.8.2 for more information about node selection.
Select Product Languages
This option enables you to select the language in which you want to run the
product.
Select the product Language from the Available Languages list, transfer it to the
Selected Languages list. Click Next.
Create Inventory
You are prompted by the installer to specify the Inventory Directory path for the
central inventory the first time you install any Oracle software on your computer.
Select the oraInventory Group Name of the operating system group that should
own the Oracle Inventory directory (the Oracle Inventory group).
Click Next.
Note: By default, the Oracle Inventory directory is not installed under the Oracle
Base directory. This is because all Oracle software installations share a common
Oracle Inventory, so there is only one Oracle Inventory for all users, whereas
there is a separate Oracle Base for each user.
Advanced Installation Installing Single Instance and Installing in an Oracle Real Application Clusters Environment
Screen
Action
Password
The password for the Oracle Audit Vault administrator account.
Confirm Password
The confirming password for the Oracle Audit Vault Administrator account.
Password
The password for the Oracle Audit Vault auditor account.
Confirm Password
The confirming password for the Oracle Audit Vault Auditor account.
Password
The password for the Oracle Database Vault Owner account.
Confirm Password
The confirming password for the Oracle Database Vault Owner account.
Account Manager
The account name of the Oracle Database Vault Account Manager.
Password
The password for the Oracle Database Vault Account Manager account.
Confirm Password
The confirming password for the Oracle Database Vault Account Manager
account.
See Section 4.8.1.4 for more information about Audit Vault Admin and Auditor
user accounts and passwords
See Section 4.8.1.5 for more information about Database Vault Owner and
Account Manager user accounts and passwords.
Advanced Installation Installing Single Instance and Installing in an Oracle Real Application Clusters Environment
Screen
Action
Advanced Installation Installing Single Instance and Installing in an Oracle Real Application Clusters Environment
Screen
Action
See Also: Section 1.8 for more information about database management options.
Specify Database Storage
Options
Note: Installing Oracle data files on an Oracle ACFS file system is not supported.
Oracle recommends that these data files are installed in Oracle ASM disk groups.
See Also: Section 1.7 for more information about database storage options.
See Also: Section 4.1.1 for more information about using Oracle Automatic
Storage Management disk groups
Specify Recovery Options
This screen is displayed only if you select Oracle Automatic Storage Management
as your storage option.
Disk groups are created during the Oracle Grid Infrastructure installation. Disk
groups are configured with the SYSASM privilege using asmcmd or SQL create
diskgroup commands. An ASM disk group consists of multiple disk partitions.
The table in this screen displays existing disk groups created during the Oracle
Grid Infrastructure installation. Select the disk group that you want to use for
database file storage.
Enter and confirm passwords for the privileged database accounts, and click
Next.
Note: Optionally, you can use the same password for all accounts. However,
Oracle recommends that you specify a different password for each account. You
must remember the passwords that you specify.
Refer to Section 4.9.3 for information about password guidelines.
The operating system groups are selected by default. You can also manually
select the OSDBA and OSOPER groups.
Click Next.
See Also: Section 2.9 for information about operating system groups and users
Advanced Installation Installing Single Instance and Installing in an Oracle Real Application Clusters Environment
Screen
Action
This option checks if the minimum system requirements to perform the Oracle
Audit Vault Server installation are met.
If you click Check Again, then you can run the prerequisite check again to see if
the minimum requirements are met to carry on with the Oracle Audit Vault
Server installation.
Click Fix & Check Again, if you want the installer to fix the problem and check
the system requirements once more.
Note: The Fix & Check Again option generates a script that you need to run as
the root user. This generated script sets some of the system parameters to
Oracle-recommended values. Oracle recommends that you do not modify the
contents of this script. Refer to Section 2.4 for more information about fixup
scripts.
To get a list of failed requirements, select ShowFailed from the list. To get a list
of all the prerequirement checks run by the OUI, select Show All. To get a list of
the prerequirement checks that are successful, select Show Succeeded.
Note: Oracle recommends that you use caution in checking the Ignore All option.
If you check this option, then Oracle Universal Installer may not confirm that
your system is able to install Oracle Audit Vault Server successfully.
See Also: Chapter 2 for information about the system requirements
Summary
Install product
This screen states the progress of an Oracle Audit Vault Server installation. After
Oracle Audit Vault Server is installed, you are prompted to execute a root
configuration script for new inventory as the root user.
This screen displays the status information for the configuration assistants that
configure the Oracle Audit Vault Server. Finally, a message is displayed at the
end of Audit Vault Configuration Assistant process. Click Next.
Follow the steps as indicated on the Execute Configuration scripts screen to run
the root.sh, and, if required, the orainstRoot.sh configuration scripts as the
root user.
After running the scripts, click OK on the Execute Configuration scripts screen
to continue.
Finish
This screen is shown automatically when all the configuration tools are
successful.
Review the Oracle Enterprise Manager Database Control URL and the Oracle
Audit Vault Console URL information displayed in this screen and click Close.
On the Exit page, click Exit. Then, on the Confirmation message box, click Yes to
exit Oracle Universal Installer.
After you have completed the installation of Oracle Audit Vault Server, proceed to
Section 4.9 to perform the postinstallation tasks.
See Section 4.9.6 for information about logging into Oracle Audit Vault Console and
Oracle Enterprise Manager Database Control.
Prepare the Audit Vault Server response file. You must create this response file
because it is not supplied as part of the shiphome or Oracle home. Copy these
lines from the following listing to a file, fill in the password information on each
line for each configuration assistant, and then save the file to a name and directory
of your choosing, such as av_config.rsp.
# Passwords for DBCA
oracle.assistants.server|S_HOSTUSERPASSWORD= <OS password needs to be given, if
automatic backup is choosen>
oracle.assistants.server|S_SYSPASSWORD=<sys password>
oracle.assistants.server|S_SYSTEMPASSWORD=<system password>
oracle.assistants.server|S_SYSMANPASSWORD=<sysman password>
oracle.assistants.server|S_DBSNMPPASSWORD=<DBSNMP password>
oracle.assistants.server|S_ASMSNMPPASSWORD= <ASMSNMP password, if ASM storage
is choosen>
# Passwords for DVCA
oracle.av.server|s_ownerPasswd=<DV owner password>
oracle.av.server|s_mgrPasswd=<DV manager password, if DV manager account is
choosen>
# Passwords for AVCA
oracle.av.server|s_adminPasswd=<AV admin password>
oracle.av.server|s_auditPasswd=<AV audit password, if AV auditor user is
choosen>
2.
Run the Installer to install the Oracle Audit Vault Server software binaries using
the following command and option:
cd directory-containing-the-Oracle-Audit-Vault-installation-files
./runInstaller -noconfig
The -noconfig parameter indicates to install the software binaries only and do
not run the configuration assistants.
Proceed with this installation and configuration Audit Vault option. This will
install the Audit Vault Server software only and prepare the
configToolAllCommands file under $ORACLE_HOME/cfgtoollogs by saving
interview values for later configuration. When this installation process is
complete, exit the installer.
3.
Download from My Oracle Support the Audit Vault Server 10.3.0.0 patches that
must be applied before the configuration and unzip them into the $ORACLE_
HOME/av/patch directory. The /patch directory should contain only the
unarchived one-off patches and not the zip files.
https://support.oracle.com/
4.
a.
After signing in to My Oracle Support, click the Patches & Updates tab.
b.
c.
As you enter "Audit Vault" in the field that states "Type in comma separated
values or choose from the list", choose "Oracle Audit Vault" from the list.
d.
In the Select up to 10 field, select the drop down arrow and select "Audit
Vault 10.3.0.0.0. (Oracle Audit Vault)"
e.
Click Search.
f.
From the list of patches that display, select the patches and platform by
clicking only the appropriate checkboxes to the right of the patch number,
then select Download from the menu that displays. On the popup screen, click
the name of the patch zip file, click Save, and specify a directory into which to
save each patch zip file. If there are no patches available to download, the
patch list that displays will be empty.
g.
Configure the Oracle Audit Vault binaries. Execute the following command as the
installation user after setting the ORACLE_HOME environment variable and
changing the current directory to the location of the configToolAllCommands
utility. This utility installs the patches, runs the configuration assistants, and
completes the Audit Vault Server installation. Use as the response file location, the
location of the response file you prepared in Step 1.
For example:
setenv ORACLE_HOME /u01/app/oracle/product/10.3.0/av_1
cd $ORACLE_HOME/cfgtoollogs
configToolAllCommands RESPONSE_FILE=$ORACLE_HOME/av/av_config.rsp
5.
Validate that the Oracle Audit Vault Server installation is successful and that the
server is running. Issue the following command after having set the environment
variables for the Oracle Audit Vault Server home, PATH, LD_LIBRARY_PATH, and
SID. If successful, this command will indicate the server is running.
avctl show_av_status
Oracle Audit Vault 10g Database Control Release 10.3.0.0 Copyright (c) 1996,
2011 Oracle Corporation. All rights reserved.
https://hrdb.us.example.com:1158/av
Oracle Audit Vault 10g is running.
-----------------------------------Logs are generated in directory /oracle/product/10.3.0/av_1/av/log
After you have completed the installation of Oracle Audit Vault Server, proceed to
Section 4.9 to perform the postinstallation tasks.
Note:
1.
Make sure all prerequisites are met for the installation of Audit Vault Server.
2.
Prepare the Audit Vault Server response file. A template response file can be found
at AV_installer_location/response/av.rsp on the Audit Vault Server
installation media.
Prepare the response file by entering values for all parameters that are missing in
the response file, then save the file. For parameters that should not be changed, a
comment is included in the file to indicate that you should not change the
parameter value. Note that for both single instance and Oracle RAC installations,
RAW storage is not used. Also note that the CLUSTER_NODES parameter must be
specified for installing Audit Vault Server in an Oracle RAC environment. Do not
edit any values in the second part of either response file.
3.
4.
For more information about these options, see Section 1.3.2. For general information
about how to complete a database installation using response files, see Appendix A
and Oracle Real Application Clusters Installation Guide for Linux and UNIX.
4-16 Oracle Audit Vault Server Installation Guide
Basic Install Simplifies the installation process and prompts for a minimal set of
inputs, including the name of the Oracle Audit Vault database, the Oracle Audit
Vault administrator and optionally the auditor user names and passwords. An
Oracle RAC installation is not supported through the Basic Install option.
Advanced Install Offers the user more control and options for the installation
process, including storage options and backup options. The Advanced Install
option supports the installation of Audit Vault Server on a cluster.
Basic Install Configuration and Advanced Install: Specify Audit Vault Details
Screens
Advanced Install: Node Selection Screen
4.8.1 Basic Install Configuration and Advanced Install: Specify Audit Vault Details
Screens
This section describes the required fields in the Basic Install Configuration screen and
the Advanced Install Specify Audit Vault Details screen. Topics include:
Oracle Base
Software Location
Table 41
Special Characters Allowed in the Oracle Audit Vault Home Location Name
Symbol
Character Name
Backslash
Slash
hyphen
Underscore
Period
Colon
Invalid Oracle Audit Vault SID and Oracle Audit Vault Account Characters
Symbol
Character Name
Exclamation point
At sign
Percent sign
Circumflex
&
Ampersand
Asterisk
Left parenthesis
Right parenthesis
Minus sign
Plus sign
Equal sign
"
Vertical bar
grave
tilde
Left bracket
Left brace
Right bracket
Right brace
Semicolon
Colon
'
Table 42 (Cont.) Invalid Oracle Audit Vault SID and Oracle Audit Vault Account
Symbol
Character Name
<
>
Slash
Backslash
Question mark
Comma
Period
Number sign
Underscore
Dollar sign
Space character
For the advanced installation, the Specify Audit Vault Details screen includes
prompts for the Database Vault Owner account name and password and a separate,
optional Database Vault Account Manager account name and password.
The Oracle Audit Vault Auditor account is granted the AV_AUDITOR role. The user
granted the AV_AUDITOR role accesses Oracle Audit Vault Reporting and Analysis
services to monitor components, detect security risks, create and evaluate alert
scenarios, create detail and summary reports of events across systems, and manage the
reports. This role manages central audit settings. This role can use the data warehouse
services to further analyze the audit data to assist in looking for trends, intrusions,
anomalies, and other areas of interest.
The Oracle Audit Vault Administrator, Oracle Audit Vault Auditor, Database Vault
Owner, and Database Vault Account Manager user names must not be the same. For
the basic installation, the Oracle Audit Vault Administrator user name must be
between 2 and 27 characters because the characters "dvo" and "dva" are appended to
the Administrator name making the normal upper limit of 30 characters for the user
names that are allowed to be 27 characters. For the advanced installation, the Oracle
Audit Vault Administrator user name must be between 2 and 30 characters.
The length of the Oracle Audit Vault Auditor user name must be between 2 and 30
characters. Each user name must not be one of the following reserved names.
Names
Names
Names
Names
Names
ACCESS
ADD
ALL
ALTER
AND
ANONYMOUS
ANY
AQ_ADMINISTRATOR_
ROLE
AQ_USER_ROLE
ARRAYLEN
AS
ASC
AUDIT
AUTHENTICATEDUSER
AV_ADMIN
AV_AGENT
AV_ARCHIVER
AV_AUDITOR
AV_SOURCE
AVSYS
BETWEEN
BY
CHAR
CHECK
CLUSTER
COLUMN
COMMENT
COMPRESS
CONNECT
CREATE
CTXAPP
CTXSYS
CURRENT
DATE
DBA
DBSNMP
DECIMAL
DEFAULT
DELETE
DELETE_CATALOG_ROLE
DESC
DIP
DISTINCT
DM_CATALOG_ROLE
DMSYS
DMUSER_ROLE
DROP
DV_ACCTMGR
DV_ADMIN
DVF
DV_OWNER
DV_PUBLIC
DV_REALM_OWNER
DV_REALM_RESOURCE
DV_SECANALYST
DVSYS
EJBCLIENT
ELSE
EXCLUSIVE
EXECUTE_CATALOG_ROLE
EXFSYS
EXISTS
EXP_FULL_DATABASE
FILE
FLOAT
FOR
FROM
GATHER_SYSTEM_
STATISTICS
GLOBAL_AQ_USER_ROLE GRANT
GROUP
HAVING
HS_ADMIN_ROLE
IDENTIFIED
IMMEDIATE
IMP_FULL_
DATABASE
IN
INCREMENT
INDEX
INITIAL
INSERT
INTEGER
INTERSECT
INTO
IS
JAVA_ADMIN
JAVADEBUGPRIV
JAVA_DEPLOY
JAVAIDPRIV
JAVASYSPRIV
JAVAUSERPRIV
LBAC_DBA
LBACSYS
LEVEL
LIKE
LOCK
LOGSTDBY_
ADMINISTRATOR
LONG
MAXEXTENTS
MDDATA
MDSYS
MGMT_USER
MGMT_VIEW
MINUS
MODE
MODIFY
NOAUDIT
NOCOMPRESS
NOT
NOTFOUND
NOWAIT
NULL
NUMBER
OEM_ADVISOR
OEM_MONITOR
Names
Names
Names
Names
Names
OF
OFFLINE
OLAP_DBA
OLAPSYS
OLAP_USER
ON
ONLINE
ONT
OPTION
OR
ORDER
ORDPLUGINS
ORDSYS
OUTLN
OWF_MGR
PCTFREE
PRIOR
PRIVILEGES
PUBLIC
RAW
RECOVERY_
CATALOG_
OWNER
RENAME
RESOURCE
REVOKE
ROW
ROWID
ROWLABEL
ROWNUM
ROWS
SCHEDULER_ADMIN
SCOTT
SELECT
SELECT_CATALOG_ROLE
SESSION
SET
SHARE
SI_INFORMTN_
SCHEMA
SIZE
SMALLINT
SQLBUF
START
SUCCESSFUL
SYNONYM
SYS
SYSDATE
SYSMAN
SYSTEM
TABLE
THEN
TO
TRIGGER
TSMSYS
UID
UNION
UNIQUE
UPDATE
USER
VALIDATE
VALUES
VARCHAR
VARCHAR2
VIEW
WHENEVER
WHERE
WITH
WKPROXY
WKSYS
WK_TEST
WKUSER
WM_ADMIN_ROLE
WMSYS
XDB
XDBADMIN
Each account name cannot contain any of the characters shown in Table 41.
Oracle Audit Vault Administrator and Oracle Audit Vault Auditor Passwords
For the basic installation, the Oracle Audit Vault Administrator password you enter
for the Oracle Audit Vault Administrator account is also used for the standard
database accounts (sys, system, sysman, dbsnmp). For the basic installation Basic
Install Configuration screen, the Oracle Audit Vault Administrator user password is
also used for the Oracle Database Vault Owner and Oracle Database Vault Account
Manager user passwords.
For the advanced installation, the installer can choose individual passwords for each
of these database accounts (sys, system, sysman, dbsnmp) or select to use the same
password as the Oracle Audit Vault Administrator for all of these accounts. In
addition, the Specify Audit Vault Details screen includes prompts for the Database
Vault Owner user password and for a separate, optional Database Vault Account
Manager user password if that user is created.
The Oracle Audit Vault Administrator and Oracle Audit Vault Auditor password
cannot be the name of the Oracle Audit Vault Administrator, Oracle Audit Vault
Auditor, Database Vault Owner, or Database Vault Account Manager. The Oracle
Audit Vault Administrator user password is required, while the Oracle Audit Vault
Auditor user password is only required when creating the separate, optional Oracle
Audit Vault Auditor user.
There cannot be repeating characters in each password. The length of each password
must be between 8 and 30 characters. Each password must consist of at least one upper
alphabetic character, one alphabetic character, one numeric character, and one of the
special characters shown in Table 43.
Table 43
Symbol
Character
Name
Percent sign
Circumflex
Hyphen
Left bracket
Plus sign
Tilde
Comma
Number sign
Right bracket
Period
Underscore
password is only required when creating the separate, optional Database Vault
Account Manager user.
There must be no repeating characters in each password. There must be no space
characters in the password.
The length of each password must be between 8 and 30 characters.
Each password must consist of at least one upper alphabetic character, one alphabetic
character, one numeric character, and one of the special characters shown in Table 41.
All other characters are not allowed.
Each password must be identical to its corresponding password confirmation.
Note:
Download Patches
Run DVCA to Set Instance Parameters and Lock Out SYSDBA Sessions (Oracle
RAC Only)
1.
2.
3.
4.
5.
In the first Select up to ten list, expand the Oracle Audit Vault list and select Audit
Vault 10.3.0.0. Click Close.
6.
In the second Select up to five list, select your specific platform from the list, then
click Close.
7.
Click Search. In a moment, the patches associated with your selection appear.
8.
Select the patch you want from the list by clicking its Patch ID link.
9.
Click View Read Me to read about the patch details, and then click Download to
download the patch to your computer.
10. Repeat Step 8 through Step 9 for each patch listed in the Patch Search Results
section.
11. Use the unzip utility provided with Oracle Audit Vault Server 10.3 to uncompress
the Oracle patch updates that you downloaded from My Oracle Support. The
unzip utility is located in the $ORACLE_HOME/bin directory.
Do not apply any Oracle Database one-off patches to the
Oracle Audit Vault database unless directed to do so by Oracle
Support Services.
Note:
Follow Step 1 through Step 9 in Section 4.9.1 to find the critical patch updates for
Oracle Audit Vault.
2.
In the list of articles that appears, search for the phrase Oracle Critical
Patch Update.
3.
Select the most recent critical patch update article, and then read its instructions.
Download the most recent critical patch update for Oracle Audit Vault. In most
critical patch update articles, there is section entitled "Patch Download Procedure,"
which explains how to download the critical patch update.
For the latest information on whether a specific critical patch update is certified with
Oracle Audit Vault, review the certification matrix on the My Oracle Support Web site,
at:
https://support.oracle.com
See Also:
2.
Enter a command similar to the following, where password is the new password:
SQL> ALTER USER account IDENTIFIED BY password;
In this example:
The IDENTIFIED BY password clause resets the password.
See Also:
If you choose to use the same password for all the accounts, then that password
must not be change_on_install, manager, sysman, or dbsnmp.
Passwords should have at least one alphabetic, one numeric, and one special
character.
Passwords should not be simple or obvious words, such as welcome, account,
database, and user.
Passwords should not have any consecutive repeating characters.
4.9.4 Run DVCA to Set Instance Parameters and Lock Out SYSDBA Sessions (Oracle
RAC Only)
After installing Oracle Audit Vault for an Oracle Real Application Clusters (Oracle
RAC) instance, you must run Database Vault Configuration Assistant (DVCA) with the
-action optionrac switch on all other Oracle RAC nodes. This sets instance
parameters and disables SYSDBA operating system authentication.
You must run this command on all Oracle RAC nodes other than the node on which
the Oracle Audit Vault installation is performed. This step is required to enable the
enhanced security features provided by Oracle Database Vault.
The listener and database instance should be running on the
nodes on which you run DVCA.
Note:
In this example:
action is the action to perform. The optionrac utility performs the action of
updating the instance parameters for the Oracle RAC instance and optionally
disabling SYSDBA operating system access for the instance.
racnode is the host name of the Oracle RAC node on which the action is being
performed. Do not include the domain name with the host name.
oh is the Oracle home for the Oracle RAC instance. Provide the ORACLE_HOME
path.
jdbc_str is the JDBC connection string used to connect to the database. For
example, in the following JDBC connection string,
"jdbc:oracle:oci:@orcl1", orcl1 is the net service name in the
tnsnames.ora file ($ORACLE_HOME/network/admin/tnsnames.ora).
sys_password is the password for the SYS user. If you enter a cleartext password
on the command line, then you must include the nodecrypt option. If you omit
the password, then DVCA prompts you for it. For better security, Oracle strongly
recommends that you omit the password and then enter it interactively when you
are prompted.
logfile is optionally used to specify a log file name and location. You can enter
an absolute path or a path that is relative to the location of the $ORACLE_
HOME/bin directory.
After running DVCA, stop and restart the instance and database listener on all cluster
nodes. This step is also applicable to the node on which Oracle Audit Vault was
installed. Use the following commands:
srvctl stop instance -d sid -i instance_name -q
Connect String: sys as sysdba
Enter password: sysdbapassword
srvctl stop nodeapps -n node_name
srvctl start nodeapps -n node_name
srvctl start instance -d sid -i instance_name -q
Connect String: sys as sysdba
Enter password: sysdbapassword
4.9.5.1 Download SQL Server JDBC Driver Version 3.0 for SQL Server Connectivity
Oracle Audit Vault requires a JDBC connection to the SQL Server database. Audit
Vault supports the use of Microsoft SQL Server JDBC Driver version 3.0 for this
purpose. This driver provides high performance native access to Microsoft SQL Server
2000, 2005, and 2008 database data sources.
SQL Server JDBC Driver version 3.0 is not compatible with the Oracle Audit Vault
10.2.3.2.x Server and collection agents, which require version 1.2 of this driver. Version
1.2 is no longer available for download from Microsoft SQL Server.
To download SQL Server JDBC Driver version 3.0:
1.
2.
Click the Download Microsoft SQL Server JDBC Driver 3.0 link.
3.
4.
5.
6.
Verify that the sqljdbc.jar file is present in the Oracle Audit Vault collection
agent before you start the collection agent.
jConnect for JDBC (jconn3.jar) is a high performance JDBC Driver from Sybase that
communicates directly to Sybase data sources.
Copy the jconn3.jar file to the Oracle Audit Vault Server and Oracle Audit Vault
Agent home locations:
$ORACLE_HOME/jlib
4.9.5.3 Copy the IBM DB2 Data Server Driver for JDBC and SQLJ to the Audit Vault
Homes
Copy the IBM Data Server Driver for JDBC and SQLJ (db2jcc.jar) to the $ORACLE_
HOME/jlib directories in both the Audit Vault Server and Audit Vault Agent homes.
Oracle Audit Vault requires version 3.50 or later of the driver. This version of the
db2jcc.jar file is available in either IBM DB2 UDB version 9.5 or IBM DB2 Connect
version 9.5 or later.
This driver provides high performance native access to IBM DB2 database data
sources. The DB2 collector uses this driver to collect audit data from IBM DB2
databases, so the driver must be present in Oracle Audit Vault OC4J before you can
start the agent OC4J.
On the node from which you installed the database, open a Web browser to access
the Oracle Audit Vault Console URL, and use the following URL syntax:
https://host:port/av
host is the name of the computer on which you installed Oracle Audit Vault
Database.
port is the port number reserved for the Oracle Audit Vault Console during
installation.
If you do not know the correct port number to use, then perform the following
steps in the Audit Vault Server home shell:
2.
a.
b.
c.
On any system, enter this URL in a Web browser and Oracle Enterprise
Manager will display the Oracle Audit Vault Console login page.
Log in to the Oracle Audit Vault Console using the user name AV_ADMIN and the
AV_ADMIN password that you created during the installation.
For Linux and UNIX platforms only: Check and set environment variables in the
shells in which you will be interacting with the Audit Vault Server and the Oracle
Audit Vault collection agent (see the information about checking and setting Linux
and UNIX environment variables).
2.
For collecting audit records from Oracle Database audit sources, see the
information about registering Oracle Database sources and collectors.
3.
For collecting audit records from SQL Server Database audit sources, see the
information about registering Microsoft SQL Server sources and collector.
4.
For collecting audit records from Sybase ASE Database audit sources, see the
information about registering Sybase ASE database sources and collector.
5.
For collecting audit records from IBM DB2 database audit sources, see the
information about registering IBM DB2 sources and collector.
6.
To start collecting audit records from a database audit source, see the information
about starting collection agents and collectors.
7.
To perform other Oracle Audit Vault configuration tasks, see the information
about performing additional Oracle Audit Vault configuration tasks.
8.
To manage and monitor an Oracle Audit Vault system, see the information about
managing Oracle Audit Vault.
9.
Note:
1.
2.
3.
4.
4.10.4.1 About the Fast Recovery Area and the Fast Recovery Area Disk Group
The fast recovery area is a unified storage location for all Oracle Audit Vault Server
files related to recovery. Database administrators can define the DB_RECOVERY_FILE_
4-30 Oracle Audit Vault Server Installation Guide
DEST parameter to the path for the fast recovery area to enable on-disk backups, and
rapid recovery of data. Enabling rapid backups for recent data can reduce requests to
system administrators to retrieve backup tapes for recovery operations.
When you enable fast recovery in the init.ora file, all RMAN backups, archive logs,
control file automatic backups, and database copies are written to the fast recovery
area. RMAN automatically manages files in the fast recovery area by deleting obsolete
backups and archive files no longer required for recovery.
Oracle recommends that you create a fast recovery area disk group. Oracle
Clusterware files and Oracle Audit Vault Server files can be placed on the same disk
group, and you can also place fast recovery files in the same disk group. However,
Oracle recommends that you create a separate fast recovery disk group to reduce
storage device contention.
The fast recovery area is enabled by setting DB_RECOVERY_FILE_DEST. The size of
the fast recovery area is set with DB _RECOVERY_FILE_DEST. As a general rule, the
larger the fast recovery area, the more useful it becomes. For ease of use, Oracle
recommends that you create a fast recovery area disk group on storage devices that
can contain at least three days of recovery information. Ideally, the fast recovery area
should be large enough to hold a copy of all of your datafiles and control files, the
online redo logs, and the archived redo log files needed to recover your database using
the datafile backups kept under your retention policy.
Multiple databases can use the same fast recovery area. For example, assume you have
created one fast recovery area disk group on disks with 150 GB of storage, shared by
three different databases. You can set the size of the fast recovery for each database
depending on the importance of each database. For example, if database1 is your
least important database, database2 is of greater importance and database3 is of
greatest importance, then you can set different DB_FILE_RECOVERY_DEST_SIZE
settings for each database to meet your retention target for each database: 30 GB for
database1, 50 GB for database2, and 70 GB for database3.
Navigate to the Grid home bin directory, and start ASM Configuration Assistant
(ASMCA). For example:
$ cd /u01/grid/bin
$ ./asmca
2.
ASMCA opens at the Disk Groups tab. Click Create to create a new disk group.
3.
4.
The Diskgroup Creation window opens to inform you when disk group creation is
complete. Click OK.
5.
Click Exit.
See Also:
"Setting the Fast Recovery Area Location and Initial Size" section
in Oracle Database Backup and Recovery User's Guide
Oracle Automatic Storage Management Administrator's Guide
5
5
Removing Oracle Audit Vault Server Software Using the Deinstallation Tool
See Also:
Stop the Oracle Audit Vault Console using the avctl stop_av command after
setting the PATH environment variable to include $ORACLE_HOME/bin.
The first command sets the PATH environment variable and the second command
performs an emctl stop dbconsole operation. For example:
C Shell
% avctl stop_av
In an Oracle RAC environment, run that command on all nodes where Oracle
Audit Vault is installed if you are removing the Oracle Audit Vault Server from all
nodes.
2.
Note:
5.3 Removing Oracle Audit Vault Server Software Using the Deinstallation
Tool
The deinstall command removes standalone Oracle Audit Vault Server
installations, Oracle Clusterware and Oracle ASM from your server, and also Oracle
Real Application Clusters (Oracle RAC) and Oracle Audit Vault Collection Agent
installations.
The following sections describe the command, and provide information about
additional options to use the command:
Removing Oracle Audit Vault Server Software Using the Deinstallation Tool
The deinstall command uses the information you provide, plus information
gathered from the software home to create a parameter file. You can alternatively
supply a parameter file generated previously by the deinstall command using the
checkonly option, or by editing the response file template.
The command uses the following syntax, where variable content is indicated in italics:
deinstall -home complete path of Oracle home [-silent] [-checkonly] [-local]
[-paramfile complete path of input parameter property file] [-params name1=value
name2=value . . .] [-o complete path of directory for saving files] [-help | -h]
The default method for running the deinstall tool is from the deinstall directory in the
Oracle home as the installation owner:
$ $ORACLE_HOME/deinstall/deinstall
-home
Use this flag to indicate the home path of the Oracle home that you want to check
or deinstall. To deinstall Oracle software using the deinstall command in the
Oracle home you plan to deinstall, provide a parameter file in another location,
and do not use the -home flag.
If you run deinstall from the $ORACLE_HOME/deinstall path, then the -home
flag is not required because the tool knows from which home it is being run. If you
use the standalone version of the tool, then -home is mandatory.
-silent
Use this flag to run the command in silent or response file mode. If you use the
-silent flag, then you must use the -paramfile flag, and provide a parameter
file that contains the configuration values for the Oracle home that you want to
deinstall or deconfigure.
You can generate a parameter file to use or modify by running deinstall with
the -checkonly flag. The deinstall command then discovers information
from the Oracle home that you want to deinstall and deconfigure. It generates the
properties file, which you can then use with the -silent option.
You can also modify the template file deinstall.rsp.tmpl, located in the
response folder.
-checkonly
Use this flag to check the status of the Oracle software home configuration.
Running the command with the -checkonly flag does not remove the Oracle
configuration. The -checkonly flag generates a parameter file that you can use
with the deinstall command.
-local
Use this flag on a multinode environment to deinstall Oracle software in a cluster.
Removing Oracle Audit Vault Server Software Using the Deinstallation Tool
When you run deinstall with this flag, it deconfigures and deinstalls the Oracle
software on the local node (the node where deinstall is run). On remote nodes,
it deconfigures Oracle software, but does not deinstall the Oracle software.
-help | -h
Use the help option (-help or -h) to obtain additional information about the
command option flags.
For the Oracle Grid Infrastructure home, use the deinstall script in the Oracle Grid
Infrastructure for a standalone server home, which in this example is
/u01/app/oracle/product/10.3.0/grid:
$ cd /u01/app/oracle/product/10.3.0/grid/deinstall
$ ./deinstall -paramfile /home/usr/oracle/my_grid_paramfile.tmpl
5-4 Oracle Audit Vault Server Installation Guide
Removing Oracle Audit Vault Server Software Using the Deinstallation Tool
5.3.3 Example of a Deinstallation Parameter File for Oracle Audit Vault Server
You can run the deinstall command on a standalone Oracle Audit Vault Server
with the -paramfile option to use the values you specify in the parameter file. The
following is an example of a parameter file, in which the Oracle Audit Vault Server
binary owner is oracle, the Oracle Audit Vault Server home (Oracle home) is in the
path /u01/app/oracle/product/10.3.0/av_1/, the Oracle base (where other
Oracle software is installed) is /u01/app/oracle/, the central Oracle Inventory
home (oraInventory) is /u01/app/oraInventory, the virtual IP address (VIP) is
192.0.2.1, the local node (the node where you run the deinstallation session from) is
myserver, and the OSDBA group is dba:
#Copyright (c) 2005, 2011 Oracle Corporation. All rights reserved.
#Mon Jul 18 06:48:39 UTC 2011
DISK_GROUPS.sidb=
ASM_HOME=
ASM_LOCAL_SID=
LOGDIR=/u01/app/oracle/product/10.3.0/av_1/oraInventory/logs/
ORACLE_BASE.sidb=/u01/app/oracle/
RECOVERY_LOC.sidb=
STORAGE_TYPE.sidb=FS
ORACLE_BASE=/u01/app/oracle/
INVENTORY_LOCATION=/u01/app/oraInventory
DB_TYPE.sidb=SI_DB
NODE_LIST.sidb=myserver
ARCHIVE_LOG_DESTINATION_LOC.sidb=
LOCAL_SID.sidb=sidb
DB_UNIQUE_NAME_LIST=sidb
ASM_FILES.sidb=
HOME_TYPE=SIDB
CRS_HOME=false
RAW_MAPPING_FILE.sidb=
SID_LIST.sidb=sidb
ORACLE_BINARY_OK=true
DATAFILE_LOC.sidb=/u01/app/oracle/oradata
local=false
LOCAL_NODE=myserver
CREATION_MODE.sidb=y
CONFIGFILE_LOC.sidb=
DIAG_DEST.sidb=/u01/app/oracle/
silent=false
ORACLE_HOME=/u01/app/oracle/product/10.3.0/av_1/
SPFILE_LOC.sidb=
Removing Oracle Audit Vault Server Software Using the Deinstallation Tool
A
A
Typically, Oracle Universal Installer runs in interactive mode, which means that it
prompts you to provide information in graphical user interface (GUI) screens. When
you use response files to provide this information, you run Oracle Universal Installer
at a command prompt using either of the following modes:
Silent mode
If you include responses for all of the prompts in the response file and specify the
-silent option when starting Oracle Universal Installer, then Oracle Universal
Installer runs in silent mode. During a silent-mode installation, Oracle Universal
Installer does not display any screens. Instead, it displays progress information in
the terminal that you used to start it.
A-1
response file. The advantage is that you can validate the values in the screens for
which you have already provided the information in the response file and
continue with the installation.
You define the settings for a silent or response file installation by entering values for
the variables listed in the response file. For instance, to specify the Oracle home
location for Oracle Audit Vault Server, you would supply the appropriate value for the
ORACLE_HOME variable, as follows:
ORACLE_HOME=/u01/app/oracle/product/11.2.0/av_1
Another way of specifying the response files variable settings is to pass them as
command line arguments when you run Oracle Universal Installer. For example:
-silent directory_path
In this command, directory_path is the path of the Audit Vault directory on the DVD
or on the hard drive.
This method is particularly useful if you do not want to embed sensitive information,
such as passwords, in the response file. For example:
-silent "s_dlgRBOPassword=password" ...
Ensure that you enclose the variable and its setting in quotes.
See Also: My Oracle Support Web site for more information on
response files:
https://support.oracle.com/
Uses
Silent
Note:
2.
3.
4.
Use a text editor to create the oraInst.loc file, containing the following lines:
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
In this example, inventory_loc is the location of the Oracle inventory; and the
inst_group parameter shows the name of the Oracle inventory group (in this
example, oinstall).
5.
Enter the following commands to set the appropriate owner, group, and
permissions on the oraInst.loc file:
# chown oracle:oinstall oraInst.loc
# chmod 664 oraInst.loc
A-3
Table A1 lists the response files provided with Oracle Audit Vault Server.
Table A1
Response Files
Response File
Description
av.rsp
Copy the response file from the response file directory to a directory on your
system:
$ cp /directory_path/response/response_file.rsp local_directory
In this example, directory_path is the path to the Audit Vault directory on the
installation media. If you have copied the software to a hard drive, then you can
edit the file in the response directory if you prefer.
2.
Remember that you can specify sensitive information, such as passwords, at the
command line rather than within the response file. Section A.1 explains this
method.
3.
4.
Note:
You can save all the installation steps into a response file during installation. You can
click the Save Response File button on the Summary page to do this. Later, this file
can be used for a silent installation.
When you save the response file, you can either complete the installation, or you can
exit from Oracle Universal Installer on the Summary page, before it starts to copy the
software to the system.
If you save a response file during a silent installation, then Oracle Universal Installer
saves the variable values that were specified in the original source response file into
the new response file.
Oracle Universal Installer does not save passwords in the
response file.
Note:
2.
If you have not installed Oracle software on this system previously, create the
oraInst.loc file as described in Section A.2.
3.
Ensure that the Oracle software owner user has permissions to create or write to
the Oracle home path that you will specify when you run Oracle Universal
Installer.
4.
5.
When Oracle Universal Installer displays the Summary screen, perform the
following:
1.
Click Save Response File and specify a file name and location for the response
file. Then, click Save to save the values to the file.
2.
6.
Before you use the saved response file on another system, edit the file and make
any required changes.
Use the instructions in the file as a guide when editing it.
A-5
$ directory_path/runInstaller -help
2.
3.
If you are completing a response file mode installation, set the DISPLAY
environment variable.
Note: You do not have to set the DISPLAY environment variable if
you are completing a silent-mode installation.
4.
To start Oracle Universal Installer in silent or response file mode, enter a command
similar to the following:
$ /directory_path/runInstaller [-silent] [-noconfig] \
-responseFile responsefilename
Note:
In this example:
5.
directory_path is the path of the Audit Vault directory on the DVD or on the
hard drive.
-silent runs Oracle Universal Installer in silent mode.
-noconfig suppresses running the configuration assistants during installation,
and a software-only installation is performed instead.
responsefilename is the full path and file name of the installation response
file that you configured.
When the installation completes, log in as the root user and run the root.sh
script:
$ sudo sh
password:
# /oracle_home_path/root.sh
If necessary, refer to Section 2.12.2 for information about determining the location of
the oraInventory directory.
A silent installation fails if:
For example, a common problem is that while all the product-specific data is filled
out correctly, the staging area location may be incorrect. If this is the case, check
the FROM_LOCATION variable and ensure that it points to the products.xml file in
the installation media. In the installation media, this products.xml is in the stage/
directory.
Oracle Universal Installer or configuration assistant validates the response file at run
time. If the validation fails, the silent-mode installation or configuration process ends.
Oracle Universal Installer treats values for parameters that are of the wrong context,
format, or type as if no value was specified in the file.
A-7
Index
A
ACFS, 1-6
requirements, 3-4
ADVM
requirements, 3-4
aio-max-nr file, 2-26
aliases, multiple on computers, 2-16
asm groups
creating, 2-22
ASM See Oracle Automatic Storage Management
asmcmd utility, 3-22
asmdba groups
creating, 2-22
Automatic Memory Management, 2-3
B
base directory
See Oracle base directory
block devices
creating permissions file, 3-13
C
certification, hardware and software, 1-4
checking distribution of the operating system, 2-6
checking version of the operating system, 2-6
chmod command, 2-32, 2-34
chown command, 2-32, 2-34
Cluster Synchronization Services (CSS)
Oracle Automatic Storage Management, 1-7
Cluster Verification Utility
verifying readiness for database installation, 4-7
clusters
installation guidelines, 4-2
Clusterware
installed before Oracle Database, 4-2
Clusterware. See Oracle Clusterware
commands
fdisk, 2-35, 3-13
partprobe, 3-14
runcluvfy.bat, 3-15
setup.exe, 3-15
useradd, 2-23
usermod, 2-23
D
DAS (direct attached storage) disks, 3-9
data files
creating separate directories for, 2-34
managing with Oracle ASM, 1-6
minimum disk space for, 2-34
options for placing on file system, 2-33
recommendations for file system, 2-33
setting permissions on data file directories, 2-34
data loss
minimizing with Oracle Automatic Storage
Management, 3-8
databases
naming, 4-11
Oracle Automatic Storage Management
requirements, 3-8
dba group
creating, 2-21
description, 2-16, 2-18, 2-19
SYSDBA privilege, 2-18
SYSDBA privilege and, 2-16
dba groups
creating, 2-22
default file mode creation mask
setting, 2-37
Deinstallation Tool, 5-2
description
database restart, 3-1
Oracle Restart, 3-1
device names
IDE disks, 3-11
RAID, 3-12
SCSI disks, 3-12
Index-1
E
environment
configuring for oracle user, 2-37
environment variables
DISPLAY, 2-37
ORACLE_BASE, 2-32, 2-37
ORACLE_HOME, 2-37, 2-39
ORACLE_HOSTNAME, 2-15
ORACLE_SID, 2-37
PATH, 2-37
SHELL, 2-37
TMP and TMPDIR, 2-4, 2-38, 3-3
TNS_ADMIN, 2-39
errata
Linux kernel errata, 2-7
errors
response file installation, A-6
silent mode, A-6
/etc/security/limits.so file, 2-24
/etc/sysctl.conf file, 2-27
examples
Oracle Automatic Storage Management failure
groups, 3-8
Oracle base directories, 2-29
external jobs
operating system user required for, 2-16
Index-2
external redundancy
Oracle Automatic Storage Management
redundancy level, 3-7
extjob executable file
operating system user required for, 2-16
F
failure group
examples of Oracle Automatic Storage
Management failure groups, 3-8
failure groups
characteristics of Oracle Automatic Storage
Management failure group, 3-8
examples in Oracle Automatic Storage
Management, 3-8
in Oracle ASM, 1-7
Fast Recovery Area, 4-30
fdisk command, 3-11
file mode creation mask
setting, 2-37
file sets, 2-5
file system
appropriate for Oracle base directory, 2-32
data file and recovery file placement
options, 2-33
requirements for Oracle base directory, 2-32
using for data files, 2-33
file-max file, 2-26
file-max parameter
recommended value on Linux x86, 2-26
files
av.rsp, A-4
/etc/security/limits.so, 2-24
/etc/sysctl.conf, 2-27
oraInst.loc, 2-21
oraInst.loc file, A-3
oratab, 2-31
/proc/sys/fs/file-max, 2-25
/proc/sys/kernel/sem, 2-25
/proc/sys/kernel/shmall, 2-25
/proc/sys/kernel/shmmax, 2-25
shmmax file, 2-25
/proc/sys/kernel/shmmni, 2-25
/proc/sys/net/ipv4/ip_local_port_range, 2-25
response files, A-3
Flash Recovery Area
See Fast Recovery Area
For, 2-32
free
UNIX command, 2-3, 3-3
G
Global Database Name
about, 4-11
groups
checking for existing oinstall group, 2-20
creating the asm group, 2-22
creating the asmdba group, 2-22
H
hardware and software certifications, 1-4
hardware certification, 1-4
hardware requirements, 2-2, 3-2
disk space, 2-4
display, 2-5
memory, 2-2
system architecture, 2-4
high redundancy
Oracle Automatic Storage Management
redundancy level, 3-7
home directory
See Oracle home directory
host name, setting before installation, 2-16
I
IDE disks
device names, 3-11
installation
clusters, installation guidelines, 4-2
computer aliases, multiple, 2-16
errors
silent mode, A-6
noninteractive, 4-16
Oracle Automatic Storage Management
requirements, 3-8
response file
oraInst.loc file, A-3
response files, A-1, A-3
preparing, A-3, A-4
silent mode, A-6
templates, A-3
responsefile
error handling, A-7
silent mode, A-6
Installing
Oracle restart, 3-16
instance
instance identifier (SID), 2-37
IP addresses, multiple, 2-15
ip_local_port_range file, 2-26
ip_local_port_range parameter
recommended value on Linux x86, 2-26
J
JDK requirements, 2-5
K
Kernel
requirements, 2-7
kernel
Linux errata, 2-7
kernel parameters
changing, 2-27
L
limits.so file, 2-24
Linux
kernel errata, 2-7
local device
using for data files, 2-34
logical volume manager
See LVM
lsdev command, 3-11
LVM
recommendations for Oracle Automatic Storage
Management, 3-7
M
mask
setting default file mode creation mask, 2-37
memory requirements, 2-2, 3-2
MEMORY_MAX_TARGET, 2-3
MEMORY_TARGET, 2-3
mirroring Oracle Automatic Storage Management
disk groups, 3-7
mkdir command, 2-32, 2-34
mode
setting default file mode creation mask, 2-37
mount point
for Oracle base directory, 2-28
multihomed computers, installing on, 2-15
multiple aliases, computers with, 2-16
multiple databases and Oracle ASM, 2-19
multiple Oracle homes, 1-4
N
network adapters
computers with multiple aliases, 2-16
primary, on computers with multiple
aliases, 2-16
See also loopback adapters, primary network
adapters
network cards, multiple, 2-15
Network Information Services
alternative to local users and groups, 2-20
Network Information Services.See NIS
network setup
about, 2-15
computers with multiple aliases, 2-16
network topics
DHCP computers, 2-15
multiple network cards, 2-15
nobody user
description, 2-16
noninteractive mode
See also response files, response file mode, A-1
Index-3
O
OEM
See Oracle Enterprise Manager
oinstall group
checking for existing, 2-20
description, 2-16
oinstall groups
creating, 2-20
oper group
creating, 2-21
description, 2-16, 2-19
SYSOPER privilege and, 2-16
oper groups
creating, 2-22
operating system
checking distribution and version, 2-6
operating system groups
creating the oinstall group, 2-20
oinstall, 2-16
OSDBA, 2-16
OSOPER, 2-16
osoper, 2-16
operating system requirements, 2-5
operating system users
nobody, 2-16
oracle, 2-17
unprivileged user, 2-16
Optimal Flexible Architecture
recommendations for Oracle base directory, 2-28
recommended path for Oracle base
directory, 2-28
recommended path for Oracle home
directory, 2-30
recommended path for Oracle Inventory
directory, 2-29
Oracle ACFS, 1-6, 3-4
requirements, 3-4
Oracle ADVM, 3-4
requirements, 3-4
Oracle ASM, 1-6
Oracle ASM disk groups
about, 1-7
Oracle ASM failure groups
about, 1-7
Oracle ASM instance
about, 1-7
Oracle Automatic Storage Management, 1-6
asmcmd utility, 3-22
characteristics of failure groups, 3-8
checking disk availability, 3-11
configuring disks, 3-6 to ??, 4-3
configuring disks for Automatic Storage
Management, 3-9
considerations before installing, 3-5
DAS disks, 3-9
disk devices, 1-7
Index-4
description, 2-29
pointer file, 2-21
Oracle Inventory directory
description, 2-29
recommended path, 2-29
Oracle Inventory group
creating, 2-21
description, 2-16
Oracle Inventory groups
checking for existing, 2-20
creating, 2-20
Oracle Real Application Clusters (RAC)
installed before Oracle Database, 4-2
Oracle Restart
description, 3-1
Installing, 3-16
OSDBA group description, 2-19
user, 2-19
Oracle Software Owner user
creating, 2-22
oracle user, 2-23
Oracle software owner user
configuring environment for, 2-37
description, 2-17
determining default shell, 2-37
relationship with Oracle base directory, 2-28
Oracle Unbreakable Enterprise Kernel
requirements, 2-7
Oracle Universal Installer
guidelines for using, 4-1
installation guidelines, 4-1
response files, A-1
list of, A-4
oracle user
configuring environment for, 2-37
creating, 2-22
description, 2-17
determining default shell, 2-37
relationship with Oracle base directory, 2-28
ORACLE_BASE environment variable, 2-32
setting, 2-37
ORACLE_HOME environment variable
unsetting, 2-39
ORACLE_HOSTNAME, 2-15
ORACLE_HOSTNAME environment variable
computers with multiple aliases, 2-16
multihomed computers, 2-15
setting before installation, 2-16
ORACLE_SID environment variable
setting, 2-37
oraInst.loc file
location, 2-21
location of, 2-21
oraInventory directory
See Oracle Inventory directory
oratab file, 2-31
formats, 2-31
location of, 2-31
OSASM groups
creating, 2-22
P
package requirements, 2-7
Linux x86-64, 2-8
packages, checking, 2-11
partition
using with Oracle Automatic Storage
Management, 3-7
partitions
creation for Oracle Automatic Storage
Management disks, 3-9
password file for Oracle Automatic Storage
Management, 3-6
passwords
specifying for response files, A-2
See also security
patches for Oracle Audit Vault
downloading, 4-23
PATH environment variable
setting, 2-37
permissions
for data file directories, 2-34
for Oracle base directory, 2-32
postinstallation
recommended tasks
root.sh script, backing up, 4-30
preconfigured database
Oracle Automatic Storage Management disk space
requirements, 3-8
requirements when using Oracle Automatic
Storage Management, 3-8
/proc/sys/fs/file-max file, 2-26
/proc/sys/kernel/sem file, 2-25
/proc/sys/kernel/shmall file, 2-25
/proc/sys/kernel/shmmni file, 2-25
/proc/sys/net/core/rmem_default file, 2-26
/proc/sys/net/core/rmem_max file, 2-26
/proc/sys/net/core/wmem_default file, 2-26
/proc/sys/net/core/wmem_max file, 2-26
/proc/sys/net/ipv4/ip_local_port_range file, 2-26
Index-5
R
RAID
device names, 3-12
using for Oracle data files, 2-33
RAM requirements, 2-2, 3-2
recommendations
on perfomring software-only installations, 3-15
reconfiguring CSS, 5-2
recovery files
options for placing on file system, 2-33
Red Hat compatible kernel
requirements, 2-7
Red Hat Package Manager
See RPM
redundancy level
and space requirements for preconfigured
database, 3-8
for Oracle Automatic Storage Management, 3-7
redundant array of independent disks
See RAID
removing, Oracle Software, 5-1
requirements
hardware, 2-2, 3-2
response file installation
oraInst.loc file, A-3
response files
preparing, A-3, A-4
templates, A-3
silent mode, A-6
errors, A-6
response file mode
about, A-1
reasons for using, A-2
response files, A-1
about, A-1
av.rsp, A-4
creating with template, A-3
passing values at command line, A-2
passwords, A-2
security, A-2
specifying with Oracle Universal Installer, A-5
response files installation
about, A-1
rmem_default file, 2-26
rmem_default parameter
recommended value on Linux, 2-26
rmem_max file, 2-26
rmem_max parameter
recommended value on Linux, 2-26
root user
logging in as, 2-2
root.sh script
backing up, 4-30
RPM
checking, 2-11
rpm command, 2-11
S
SAN (storage area network) disks,
Index-6
3-9
SYSDBA privilege
associated operating system group, 2-16
associated UNIX group, 2-18, 2-19
SYSOPER privilege
associated operating system group, 2-16
associated UNIX group, 2-19
X
X Window system
enabling remote hosts, 2-2
xhost command, 2-2
T
temporary disk space
requirements, 2-2, 3-2
TMP environment variable, 2-4, 3-3
setting, 2-38
TMPDIR environment variable, 2-4, 3-3
setting, 2-38
TNS_ADMIN environment variable
unsetting, 2-39
U
umask command, 2-37
UNIX commands
chmod, 2-32, 2-34
chown, 2-32, 2-34
fdisk, 3-11
free, 2-3, 3-3
lsdev, 3-11
mkdir, 2-32, 2-34
rpm, 2-11
sysctl, 2-26
umask, 2-37
unset, 2-39
unsetenv, 2-39
xhost, 2-2
UNIX groups
checking for existing oinstall group, 2-20
OSDBA (dba), 2-18
OSDBA (dba) for Oracle Restart, 2-19
OSOPER (oper), 2-19
using NIS, 2-20
UNIX users
using NIS, 2-20
UNIX workstation
installing from, 2-2
unset command, 2-39
unsetenv command, 2-39
useradd command, 2-23
users
creating the oracle user, 2-22
operating system nobody user, 2-16
Oracle Restart, 2-19
Oracle software owner user, 2-17
users and groups, 2-16
W
wmem_default file, 2-26
wmem_default parameter
recommended value on Linux, 2-26
wmem_max file, 2-26
wmem_max parameter
Index-7
Index-8