Initial Database Setup

Creating an Oracle user for the application server is unnecessary. Redcell’s installation scripts create all required schema objects for the application server. Follow these steps to configure your database for use with Redcell.

1. After the Redcell Installer finishes, source the oware environment in a shell to execute the following commands.

Windows: oware

Linux or Solaris: . /etc/.dsienv

2. To successfully install against an Oracle server running on a Windows Server Operating System you must create a user with DBA privileges on the Oracle server:

sqlplus system/<system password>@SID

create user foo identified by foo;

grant dba to foo;


You can then run loaddb from application server as described below.

Running Loaddb

3. Before running the loaddb script, you can optionally replace the occurrences of the literal values OWARE_DEFAULT_SIZE and OWARE_ORADATA_PATH in the tablespace creation script with your desired tablespace size and location. If you do not modify this script, your data files will be created under your $ORACLE_HOME directory. The tablespace creation script is in:

$OWARE_USER_ROOT/oware/dbscript/oracle/owaredba/ create_oware_tablespaces.sql

You must modify this script if you are running Oracle RAC, otherwise altering it is optional.

You will need your DBA password to run the loaddb script. The user and password you select must be able to perform user, role, and tablespace creation tasks. You must run this as system user. The -w option is required for the password:

loaddb -u system -w <system password> -s

With the -s it creates the Redcell Synergy tablespace: OWSYNERGY01 and the portal tablespace. Without -s it creates Redcell tablespaces: owdata01 and owidx01. Here are the options:

loaddb -u system -w <system password>


• tablespace owdata01

• tablesapce owidx01

• role owrole

• user redcell

(assuming you specify the user "redcell" during installation or in the file)

loaddb -u system -w <system password> -s


• tablespace OWSYNERGY01--Includes user credentials, multitenancy information.



• tablespace OWPORTAL01 (portal information)


• user NETVIEW

Running oraclepostinstall

4. After running loaddb, you must seed the database with all required information. This is based on what software is installed with your package. Running he oraclepostinstall command examines your package and seeds all appropriate information. To see options available with this script, run oraclepostinstall -?

Encrypting the Oracle Password

5. By default, the JDBC username and password are stored in clear text, during installation, in the following file:


The username and password properties must be clear text to run the loaddb script. This script creates/re-creates the database schema. Once the schema is created, you may encrypt the database password stored in the file.

A utility script, owjdbcutil, supports changing the username and/or password used for database access. This script also supports encryption of the database password:

owjdbcutil -u <database user> -p <database password> -e