Users Guide

Installing Oracle | Oracle Database Management
170 OMNM 6.5.3 Installation Guide
Running dbpostinstall
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 the
dbpostinstall
command on the (primary) application server examines your package and seeds all
appropriate information. To see options available with this script, run
dbpostinstall -?
If you get an “ORA-12519, TNS:no appropriate service handler found” error, set the Oracle
processes limit to 300. See
Initial Oracle Settings Configuration on page 167.
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
Oracle Server Settings and Parameters
The following are general recommendations for Oracle installations:
Oracle Server Initialization Parameters Recommendations
The following sections describe how to configure the application's initialization parameters with an
Oracle database. Modifying Oracle initialization parameters in the init<InstanceSid>.ora file.
Refer to recommendations provided with your Oracle installation's default init.ora (located in
$ORACLE_HOME/ srvm/admin/ typically)
Shared_pool_size Minimum size 150M
Shared_pool_reserved_size Minimum size 15M
Open_cursors Minimum 1500
Processes Minimum 100
Job_queue_processes Minimum 2
Sort_area_size = 1048576
Sort_area_retained_size= 1048576