Oracle Database Management
Oracle Database Sizing
Database Recovery Procedures
Before running this application’s Oracle setup, you must first install Oracle and create the database instance. The following is a set of basic guidelines for installing Oracle. This may not describe the optimum configuration for every environment, but it provides a simple example of how to install Oracle in a basic configuration. We highly recommend the services of a trained Oracle DBA to either assist or manage the installation and ongoing maintenance required to keep your application performing properly.
Username / Password Considerations
We do not support using sys or system user as the user for the Redcell application. If you entered one of these during installation, modify the $OWARE_USER_ROOT/owareapps/installprops/installed.properties file. Before running loaddb, change the following parameters:
The following assumes that a database instance has been created and configured properly. If you wish to use Oracle RAC for high availability of, then consult your Oracle resource for proper practices on configuring the RAC environment. See also Encrypting the Oracle Password.
An Outline of Installation Steps
Before installing Redcell, your Oracle DBA needs to do the following tasks:
1. Install Oracle according to its installation instructions.
2. Perform the Initial testing of the Oracle installation.
The following are done by the Redcell installer:
3. Install Redcell.
4. Run pingdb -u <dba user> -w <dba password> to test connectivity. For example: pingdb -u system -w manager
5. Run loaddb -u system -w manager. Run this only with the Oracle system user (See Running Loaddb).
In a clustered application server environment, you need to run this and the following step only once from one application server. Mediation servers do not need to have database connectivity, so this does not apply if you have distributed the mediation server(s).
The user must have dba privileges--more specifically, this user needs to be able to create or delete users, roles, tablespaces, tables, and so on.
6. Run ocpinstall -s (See Running Ocpinstall).
See Upgrading Oracle to 6.1.11+ for instructions about updating an existing Oracle installation.