2 Setting Up Oracle Flow Builder

This chapter explains how to get started using Oracle Flow Builder. This chapter contains the following sections:

• Getting Started

• System Requirements

• Prerequisites

• Installing Oracle Flow Builder

• Initial Setup for Administrators

• Initial Setup for Users

2.1 Getting Started

The following table provides an overview of the Oracle Flow Builder application setup tasks.

Table 2-1 Getting Started with Oracle Flow Builder

Step	Task	Role
1	Verify the system requirements. See Section 2.2, "System Requirements"	Administrator
2	Verify the Prerequisites have been meet. See Section 2.3, "Prerequisites"	Administrator
3	Install the application. See Section 2.4, "Installing Oracle Flow Builder"	Administrator
4	Perform the initial set up. See Section 2.5, "Initial Setup for Administrators"	Administrator
5	Perform the initial set up. See Section 2.6, "Initial Setup for Users"	Users

2.2 System Requirements

Oracle Flow Builder has the following system requirements:

• OS: Oracle Enterprise Linux version 5.

• CPU: P4 or higher @ 2GHz (Intel Dual core recommended, Intel Xeon Quad core preferred).

• Memory: 4GB or higher (8GB preferred).

• Free Disk space: 20 GB (50 GB recommended, 200 GB preferred).

• Browser: Firefox 17 ESR.

2.3 Prerequisites

Oracle Flow Builder installer has the following prerequisites:

• An installed and functioning Oracle Database 11g Enterprise Edition (v. 11.2.0.3.0).

• Oracle Enterprise Linux version 5.

2.4 Installing Oracle Flow Builder

This section describes the basic installation procedures required for setting up the database and installing the application.

Oracle Flow Builder requires a functioning database which:

• Is running Oracle Database 11g Enterprise Edition (v. 11.2.0.3.0), which can be accessed from:

  https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530
  

• Can be accessed from a remote machine (i.e., connect using the machine hostname instead of using localhost).

Note:

This section provides basic summary steps for installing Oracle Database 11g Enterprise Edition and remote access configuration for use with the Oracle Flow Builder application. These steps are not intended to provide complete database installation instructions. For detailed database installation instructions, see the "Installing Oracle Database" chapter of the Oracle Database Installation Guide 11g Release 2 (11.2) for Linux at the following location:

http://docs.oracle.com/cd/E11882_01/install.112/e47689/toc.htm

2.4.1 Installing Oracle Database 11g Enterprise Edition

The Oracle Flow Builder application requires an installed and functioning Oracle Database 11g Enterprise Edition (v. 11.2.0.3.0). If necessary, download and install the database prior to installing the Oracle Flow Builder application.

To download and install Oracle Database 11g Enterprise Edition (v. 11.2.0.3.0):

1. Download the seven zip files from:

   https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530
   

2. Extract all seven zip files: p10404530_112030_Linux-x86-64_1of7 through p10404530_112030_Linux-x86-64_7of7.

3. Run ./database/runInstaller.

4. Clear the I wish to receive security updates checkbox and click Next.

5. Click Skip software updates.

6. Select Create and configure a database and click Next.

7. Select Desktop Class and click Next.

8. Specify the Install Configuration as follows:

   • Oracle base: /scratch/<username>/oracle/oee/app

   • Software location: /scratch/<username>/oracle/oee/app /product/11.2.0/dbhome_1 (auto populated).

   • Database file location: /scratch/<username>/oracle/oee/app /oradata (auto populated).

   • Database edition: Enterprise Edition (4.5GB).

   • Character Set: Unicode (AL32UTF8).

   • OSDBA Group: dba.

   • Global database name: orcl.us.oracle.com.

   • Administrative password: oracle123.

9. Click Yes on the "Admin password entered does not conform to the Oracle standards" dialog box.

10. On Prerequisite Checks, if there are errors, click Ignore All and click Next.

11. Click Yes on the "You have chosen to ignore some of the prerequisites" dialog box.

12. On the Summary page, confirm your entries and click Install.

13. If installing the database for the first time, execute the orainstRoot.sh script when prompted by the installer then click OK, as follows:

    > sudo <Path to oraInventory>/orainstRoot.sh
    

    for example:

    > sudo /scratch/${USER}/oracle/oee/oraInventory/orainstRoot.sh
    

14. Execute the root.sh script when prompted by the installer then click OK to complete the installation, as follows:

    > sudo /scratch/<username>/oracle/oee/app/product/11.2.0/dbhome_1/root.sh
    

    During the root.sh file execution, if you get '/usr/local/bin is read only', then continue without copy.

2.4.2 Configuring Oracle Database for Remote Access

The Oracle Database must be configure for remote access to be used with the Oracle Flow Builder application.

To configure Oracle Database for remote access:

1. Modify tnsnames.ora and change localhost to the fully qualified domain name (FQDN) of the machine where the Database is installed. For example:

   > sed -i -e 's/localhost/machineName.company.com/g' $ORACLE_HOME/network/admin/tnsnames.ora 
   

   Note:

   If you receive an "Undefined variable" error, verify the $ORACLE_HOME environment variable is set or manually enter the full path to Oracle's home directory in place of $ORACLE_HOME.

2. Modify listener.ora and change localhost to the fully qualified domain name (FQDN) of the machine where the Database is installed. For example:

   > sed -i -e 's/localhost/machineName.company.com/g' $ORACLE_HOME/network/admin/listener.ora 
   

3. Stop the Listener and then Start it back up so that the new changes are in effect, as follows:

   > $ORACLE_HOME/bin/lsnrctl stop 
   > $ORACLE_HOME/bin/lsnrctl start
   

4. Restart the database (optional), as follows:

   $> sqlplus
   $> username: SYS AS SYSDBA 
   $> password: oracle123 
   $> shutdown immediate 
   $> startup 
   

2.4.3 Installing the Oracle Flow Builder Application

The Oracle Flow Builder application is installed using the setup script included in the downloaded application zip file.

To install the Oracle Flow Builder application:

1. Download the Oracle Flow Builder zip file from Oracle Technology Network (OTN):

   http://www.oracle.com/technetwork/oem/downloads/index-084446.html
   

2. Extract the Oracle Flow Builder Zip, as follows:

   > unzip ./OFB_MAIN_GENERIC_xxxxxx.xxxx.S.zip -d /tmp/OFB_MAIN
   

3. Add execute permission to setup.sh, as follows:

   > chmod 744 /tmp/OFB_MAIN/setup.sh
   

   Note:

   You may need to add execute permission to other .sh script files also if you receive a "Permission denied" message when running the script.

4. Start the Oracle Flow Builder setup, as follows:

   > /tmp/OFB_MAIN/setup.sh install
   

5. Enter the configuration information as prompted by the setup script. For example:

   • Enter the Oracle Flow Builder installation directory: /scratch/username/oracle/OracleOFB

   • Enter the Administrator Password: oracle123 (or any other password you wish to use as the default administrator account password).

   • Enter the Oracle Flow Builder Server host-name (press enter to accept [auto-detected-hostname]): machineName.company.com

   • Enter Database port (press enter to accept [1521]): 1521.

   • Enter database SID (press enter to accept [orcl]): orcl.

   • Enter database admin user name: system.

   • Enter database admin Password: oracle123.

   After a successful installation, the Oracle Flow Builder will be left in a running state.

6. Open a browser and start the Oracle Flow Builder application using the URL:

   http://machineName.company.com:9090 
   

7. Log in to the application using the default administrator username and password (administrator/password-entered-during-product-installation is the default).

   See the Section 2.5, "Initial Setup for Administrators" section for initial setup tasks for the Oracle Flow Builder application. See the Section 2.4.4, "Oracle Flow Builder Server Maintenance" section for additional server options.

2.4.4 Oracle Flow Builder Server Maintenance

The following maintenance functions are available to start, stop, or check the running status of an Oracle Flow Builder application.

• Starting the Oracle Flow Builder Application Server

  Run <ofb-install-dir>/scripts/control.sh start. For example:

  > /scratch/username/oracle/ofb/scripts/control.sh start 
  

• Stopping the Oracle Flow Builder Application Server

  Run <ofb-install-dir>/scripts/control.sh stop. For example:

  > /scratch/username/oracle/ofb/scripts/control.sh stop 
  

• Getting the Oracle Flow Builder Application Server running status

  Run <ofb-install-dir>/scripts/control.sh status. For example:

  > /scratch/username/oracle/ofb/scripts/control.sh status 
  

2.4.5 Deinstalling the Oracle Flow Builder Application

The Oracle Flow Builder application can be completely removed by running the deinstall script located under the scripts folder.

To deinstall the Oracle Flow Builder application:

1. Run <ofb-install-dir>/scripts/deinstall.sh. For example:

   > /scratch/username/oracle/ofb/scripts/deinstall.sh
   

Deinstalling Oracle Flow Builder only deletes the application files, any user data created on the file system and in the database will not be deleted by the deinstaller.

To remove user files and data:

Caution:

The following steps remove user data from the machine. Be sure you wish to do this before proceeding.

• User created files on the file system can be removed by simply deleting the product installation folder.

• User created data in the database can be removed by running the following query as a database admin user:

  > Drop user OFB cascade;
  

2.5 Initial Setup for Administrators

This section explains the initial setup procedures for a newly installed Oracle Flow Builder. See Chapter 9, "Administering Oracle Flow Builder" for additional information about the administrator tasks and procedures.

Table 2-2 Initial Setup Tasks

Step	Task	Role
1	Set up the Email Server. See Section 9.2.8, "Setting Up Email"	Administrator
2	Review and customize Releases. See Section 9.2.1, "Setting Up Releases"	Administrator
3	Review and customize Product Families. See Section 9.2.2, "Setting Up Product Families"	Administrator
4	Review and customize Products. See Section 9.2.3, "Setting Up Products"	Administrator
5	Review and customize product Features. See Section 9.2.4, "Setting Up Features"	Administrator
6	Review and customize user roles. See Section 9.2.5, "Setting Up Roles"	Administrator
7	Add users and specify application roles. Note: Users can also request registration from the login screen. An administrator or other user with an "approver" role would then approve the user registration request. See Section 2.6, "Initial Setup for Users" and Section 9.2.6, "Setting Up Users"	Administrator/users
8	Optional. Review and customize function libraries. See Section 9.2.7, "Setting Up Function Libraries"	Administrator

2.6 Initial Setup for Users

This section explains the basic steps to get started using the Oracle Flow Builder application. The following are the basic steps new users must do to get started using the application:

• Starting the Application

• Registering User Credentials

• Changing Passwords

• Requesting Product Family Access

2.6.1 Starting the Application

To start the Oracle Flow Builder application:

1. Launch a Web browser.

2. Enter the URL:

   http://<machineName>:9090
   

   Where machineName is the name of the machine where Oracle Flow Builder is installed, such as machine.company.com.

2.6.2 Registering User Credentials

New users can request access to the application by registering a user name and password at the main log in screen. A request will be sent to the specified approver to authorize the user registration and login credentials.

To register user credentials:

1. Start the application to get to the log in screen.

   Figure 2-1 Login Screen

   
   Description of "Figure 2-1 Login Screen"
   
   

2. Click the Register link.

   Figure 2-2 Register User Options Screen

   
   Description of "Figure 2-2 Register User Options Screen"
   
   

3. Enter the user details, select the Approver, and click Register. The User Name must be between 4 and 8 characters. The Confirmation message appears upon successful registration. Once the Approver approves the request, the user can log into the application from the main login screen.

2.6.3 Changing Passwords

Users who are added to the application by an administrator rather than through the Register screen will receive an initial system-generated password via Email to log in to the application. You can change the system-generated password to a new password.

To change a user password:

1. Log in to the application using the username and system-generated password provided.

2. Click the Change Password link at the top of the page.

3. Enter a new password.

4. Confirm the new password.

5. Click OK.

2.6.4 Requesting Product Family Access

First time users must request access rights to specific product families defined within the application.

To request access rights to a product family:

1. Start the application and login with your user credentials.

2. If necessary click the Home link at the top of the page.

3. Select a product family from the Request Access Rights list.

   Figure 2-3 Request Access Rights Options

   
   Description of "Figure 2-3 Request Access Rights Options"
   
   

4. Click Request Access. An Access Request notice appears indicating that the request has been sent to the designated approver.

   Figure 2-4 Request Access Rights Confirmation Notice

   
   Description of "Figure 2-4 Request Access Rights Confirmation Notice"
   
   

5. Click OK.

6. Repeat steps 3 through 5 to request access to additional product families. You can request access to more than one product family available in the application. However, only one can be requested at a time.

7. Log out of the application until notified by the designated approver that the access rights have been approved. After the designated approver approves the access rights, the Access Rights list shows the Product Families with the Application role assigned to the user after the next log in.

   Figure 2-5 Approved Access Rights to Product Families List

   
   Description of "Figure 2-5 Approved Access Rights to Product Families List"