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;

exit

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

[spacer]

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>

Running Ocpinstall

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 ocpinstall -s command examines your package and seeds all appropriate information. This is the command as it appears in the shell:

ocpinstall -s

Encrypting the Oracle Password

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

<install_root>/owareapps/installprops/lib/installed.properties

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 installed.properties 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