Go to primary content
Oracle Agile Engineering Data Management Server Installation Guide on Windows and UNIX
Release e6.2.1.0
E69109-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

6 Oracle Database Prerequisites


Note:

This chapter describes prerequisites for installing the Oracle Database 12c R1 (12.1.0.2) client and server on all supported operating systems.

6.1 Windows

Create the directories/drives for the distribution of the data files depending on the number of disks prepared for the Oracle installation.

For instance, if you have prepared 3 disks -

  • E:\

  • F:\

  • H:\

The drive letters E:\, F:\, and H:\ are just examples. Subdirectories will be created later in these directories by either:

  • Manual installation

    • Installing Oracle Database Server

    • Installing Oracle Database Client

  • Automatic installation

    • Installation with the Agile e6 Installer

6.2 UNIX

6.2.1 Setting Up an Oracle Operating System User

Several operating system groups and users might have to be installed, depending on:

  • If Oracle software is installed on this system the first time

  • Installed products

For complete information on how to set up an Oracle Operating System User, refer to the Oracle Database Software documentation.

To create an Oracle account:

  1. Create the dba group for the machine on which Oracle is being installed:

    groupadd -g 502 dba


    Note:

    On AIX you have to use the following command instead:

    mkgroup id=502 dba


  2. Create an Oracle user "oracle" with the following parameter and execute the following command.

    • Home directory "/opt/oracle"


    Note:

    This is also value for ORACLE_BASE. The directory must be created first.

    • Login shell "/bin/csh"

    • Member of the group "dba"

    useradd -u 502 -g dba -d /opt/oracle -s /bin/csh oracle

  3. Log into Oracle and create the subdirectories:

    • /opt/oracle/bin

    • /opt/oracle/product

    • /opt/oracle/product/11.2


    Note:

    If ORACLE_BASE is not set to /opt/oracle, the above mentioned subdirectories have to be created in the designated directory.

  4. Create the directory, links, and mount points for distribution of the data files, depending on the number of disks prepared for the Oracle installation.

    For instance, if you have prepared 3 disks:

    • …/data1

    • …/data2

    • …/data3

    The names data1, data2, and data3 are just examples.

    Subdirectories will be created later in these directories by the database:

    • Manual installation

      • § Installing Oracle Database Server

      • § Installing Oracle Database Client

    • Automatic installation

      • § Installation with the Agile e6 Installer


      Note:

      For recommended disk layout, please check the Hardware Sizing Guide for Agile e6.2.1.0

6.2.2 Setting Up the Shell Environment Variables for Oracle 12c

To set up the shell environment variables, do the following:

  1. Download and uncompress the Oracle Agile Engineering Data Management Application (Release e6.2.1.0) from the Oracle Software Delivery Cloud website.

    Under Oracle Agile Applications > Oracle Agile Engineering Data Management (Release e6.2.1.0) Media Pack.

  2. Copy the script csh_ORA12.1 from the folder addon/db/unix/scripts to /opt/oracle/bin

    If ORACLE_BASE is not set to /opt/oracle, open the script with an editor and change the value for ORACLE_BASE. Then source the script to set the environmental variables.

    chmod 754 csh_ORA12.1

    source $HOME/csh_ORA12.1

  3. Set the file creation permissions with the "umask" command:

    umask 022

  4. Verify the environment.

  5. Log off and log in as the Oracle user to ensure all environment settings are active.

  6. Type env | sort in the UNIX prompt to view all environment variables.

Software Item Requirements
DISPLAY Set it to the machine name and monitor the station from which you are connecting to the server machine (setenv DISPLAY hostname: 0.0).
LD_LIBRARY_PATH

SHLIB_PATH (HP-UX)

LIBPATH (AIX)

Required for Oracle products using shared libraries. Must include:

$ORACLE_HOME/lib.

ORACLE_BASE Not required, but recommended as part of an OFA-compliant installation.
ORACLE_HOME Must be set to the directory where the Oracle software will be installed.
ORACLE_SID Specifies the instance name, or SID of the Oracle Server. Must be unique for Oracle instances running on the same machine. Oracle Corporation recommends using four characters or less.
ORACLE_TERM Required by all character mode and Motif mode Oracle products. 386 386x 386u 386s dgd2 dgd4 hftc hft hpterm 3151 ncd220 sun sun5 vt100 vt220 wy50 wy150 xsun xsun5.
ORA_NLS10 Required when creating a database with characters set other than US7ASCII. Set to $ORACLE_HOME/nls/data
PATH The search path must include: $ORACLE_HOME/bin, /bin, /usr/bin, and /usr/local/bin.
TMPDIR A directory with free space where the Oracle account has write permission. The default location on UNIX is /usr/tmp.

6.2.3 Free Up Disk Space in the /tmp Directory

The Oracle Installer needs some temporary disk space during the installation in /tmp. Check the required space in tmp directory under Hardware Requirements for the relevant operating system.


Note:

For disk space requirements check the specific Quick Installation Guide Section provided with the Operating System.

To determine the amount of free disk space available in the /tmp directory, enter the following command in a command shell:

df /tmp

If the space available in the /tmp directory is less than required, complete one of the following steps:

  1. Delete unnecessary files from the /tmp directory to achieve the required disk space.

  2. Set the TEMP and TMPDIR environment variables when setting the Oracle user's environment (described later).

  3. Extend the file system that contains the /tmp directory. If necessary, contact your system administrator for information about extending file systems.

If you have determined that the /tmp directory had insufficient free disk space when checking the hardware requirements, enter the following commands to set the TEMP and TMPDIR environment variables. Specify a directory on a file system with sufficient free disk space.

  • In a Bourne, Bash, or Korn shell:

    TEMP=/directory
    
    TMPDIR=/directory
    
    export TEMP TMPDIR
    
  • In a command shell:

    setenv TEMP /directory
    
    setenv TMPDIR /directory
    

6.2.4 Copying the Database Start and Stop Scripts for the Oracle Server

Copy the start and stop scripts from folder addon/db/unix/scripts to the directory /opt/oracle/bin.

  • start_plm62

  • stop_ plm62

  • stop_ plm62_immediate

  • stop_ plm62_transactional