Oracle Database Management

12

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_U­SER_ROOT/owareapps/installprops/installed.properties file. Before running loaddb, change the following parameters:

com.dorado.jdbc.user=<user>

com.dorado.jdbc.password=<password>

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, selecting Oracle as the database, and filling in the user, password, IP address of the server, and so on. Note that the following steps may be useful in installing Redcell Synergy:

a. Open command prompt/terminal and source environ­ment using oware (Windows) or ./etc/.dsienv (Linux).

b. Test database connectivity with the command: pingdb -u <dba user> -p <dba password> to test connectivity. For example: pingdb -u system -p manager. Without these parameters, pingdb consults the installed.properties file for the user / password.

4. Run the following on a fresh installation to create the database schema and users (system / manager are the database user and password for this example).

loaddb -u system -w manager

loaddb -u system -w manager -s.

Run this only with the Oracle system user (See Running Loaddb). This creates and loads the portal database. The user running this must have dba privileges--more specifically, this user must have permission to create or delete users, roles, tablespaces, tables, and so on.

if loaddb -u system -w password does not work the first time then add -d.

5. Running this automatically creates a user oware with password dorado in the database.

6. Create synergy database with this command:

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

This automatically creates user netview with password dorado in the database.

7. Run oraclepostinstall (See Running oraclepostinstall)

8. Restart application server.

The following steps only apply if you did not choose the option for the server to start automatically:

9. Open a shell and set the environment with oware (Windows) or ./etc/.dsienv (Linux). Enter pmstartall to start the application server.

10. (Linux) To start the web portal, enter

/opt/dorado/oware/synergy/tomcat-6.0.32/bin/startportal.sh start

Use the Start menu in Windows to start RC Synergy.

In a clustered application server environment, you need to run this only once from one application server. Mediation servers do not need to have database connectivity, so you do not have to run this on distributed mediation servers.

See Upgrading Oracle Databases for instructions about updating an existing Oracle installation. Also, see Oracle Database Connections for information about configuring those.