This topic describes the user privileges, and environment discovery requirements, that are required for Oracle and Oracle RAC target hosts and databases, collectively referred to a target environments.
Target Host Requirements
- Create an operating system user (delphix_os). This user is easily created by the createDelphixOSUser.sh script.
Profile and privileges should be the same as the Oracle user (oracle) on the host.
For example, delphix_os should have the same environment variable settings ($PATH
, $ORACLE_HOME
, etc.) and ulimit
settings, as oracle.
- Group memberships:
The user's primary group must be the UNIX group that is mapped to OSDBA by the Oracle installation. This is typically the dba group on the host.
- If the Oracle install group (typically oinstall), exists on the host, it should be set as a secondary group for the user.
If the Oracle ASM groups (typically asmadmin and asmdba) exist on the host, they should be assigned to the user as secondary groups.
- There must be a directory on the target host where the Delphix Engine Toolkit can be installed, for example:
/var/opt/delphix/Toolkit
.
- The delphix_os user must own the directory.
- The directory must have permissions
-rwxrwx---
(0770), but you can also use more permissive settings. - The directory should have 1.5GB of available storage: 400MB for the toolkit and 400MB for the set of logs generated by each client that runs out of the toolkit.
There must be an empty directory (e.g. /delphix or /mnt/provision/ ) that will be used as a container for the mount points that are created when provisioning a VDB to the target host. The group associated with the directory must be the primary group of the delphix_os user (typically dba). Group permissions for the directory should allow read, write, and execute by members of the group.
- The following permissions are usually granted via sudo authorization of the commands. See Sudo Privilege Requirements for further explanation of the commands, and Sudo File Configurations for examples of the /etc/lsudoers file on different operating systems.
- Permission to run
mount, umount, mkdir, rmdir, ps
as super-user. - Permission to run
pargs
on Solaris hosts and ps
on AIX, HP-UX, Linux hosts, as super-user. - If the target host is an AIX system, permission to run the
nfso
command as super-user.
Write permission to the $ORACLE_HOME/dbs
directory
An Oracle listener process should be running on the target host. The listener's version should be equal to or greater than the highest Oracle version that will be used to provision a VDB.
- NFS client services must be running on the target host.
- The Delphix Engine must be able to make an SSH connection to the target host (typically port 22)
OS Specific Requirements
AIX, HP-UX
None
Linux
On 64-bit Linux environments, there must be a 32-bit version of glibc
.
Solaris
On a Solaris host, gtar must be installed. Delphix uses gtar
to handle long file names when extracting the toolkit files into the toolkit directory on a Solaris host. The gtar
binary should be installed in one of the following directories:
Auto-Discovery Requirements (Highly Recommended)
Delphix can automatically discover your Oracle Homes and Databases by examining the oratab and/or inventory files, and by examining the listener setup to determine connection information. Successful auto-discovery requires read access to these and related files.
1.The ORATAB file must exist (typically in /etc/oratab
or /var/opt/oracle/oratab
) and be readable by delphix_os.
2. Read access to either /etc/orainst.loc
or /var/opt/oracle/orainst.loc
.
3. Read access to the Oracle inventory file (inventory.xml
) identified by the contents of orainst.loc
(for example, $INVENTORY_HOME/ContentsXML/inventory.xml).
Oracle Target Container Databases Requirements
To provision an Oracle pluggable database, there must be a running Oracle multitenant container database in the target environment. In the multitenant container database, there must be a common database user (c##delphix_db) created by the createDelphixDBUser.sh script. This script is part of the HostChecker bundle, and grants SELECT privileges on specific system tables for the user. See the topics Using HostChecker to Validate Oracle Source and Target Environments for more about using the HostChecker bundle.
Additional requirements for RAC sources
If the source host is a node in a RAC cluster, Delphix will attempt to use all nodes and crsctl
for it's operations.
- delphix_os must exist on all nodes in the cluster.
- delphix_os must have the same configuration on all nodes in the cluster, including profile, ulimits, user id, group membership, etc.
- The Delphix Toolkit must be installed in the same directory on each of the nodes in the source cluster
delphix_os must have execute permission on crsctl
and srvctl
on each node in the cluster.
Example: This shows that the group dba has read/write/execute permission on the database resources
$ crsctl getperm resource ora.trois.db
Name: ora.trois.db
owner:ora112:rwx,pgrp:dba:rwx,other::r--
- All datafiles and archive logs must be located on storage shared by all of the cluster nodes. Each node in the cluster must be able to access archive logs from all other nodes. This is an Oracle Best Practice, and a requirement for Delphix.
2 Comments
Stephanie Burks
2. Read access to either
/etc/orainst.loc
or/var/opt/oracle/orainst.loc
.3. Read access to the Oracle inventory file (
inventory.xml
) identified by the contents oforainst.loc
(for example,$INVENTORY_HOME/ContentsXML/inventory.xml).
Should read oraInst.loc (with a capital I)
Anonymous
Yes