Users Guide

Installing Oracle | Oracle Database Management
OMNM 6.5.3 Installation Guide 167
In the portal-ext.properties file located in ../oware/synergy/tomcat-7.0.40/webapps/ROOT/
WEB-INF/classes, search for jdbc.default.url and set the property in this format
jdbc:oracle:thin:@address:port/pdbname.
In the installed.properties file located in ../owareapps/installprops/lib, search for
com.dorado.jdbc.database_name.oracle and set the property in this format @address:port/
pdbname.
Where address is the ip address or hostname of the database server, port is the listener port,
and pdbname is the pluggable database name.
For examples:
jdbc.default.url=jdbc:oracle:thin:@192.168.54.58:1521/pdborcl
com.dorado.jdbc.database_name.oracle=@192.168.54.58:1521/pdborcl
5 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 on page 169). 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.
6 Run dbpostinstall on the (primary) application server. (See Running dbpostinstall on
page 170)
7 Restart application server.
The following steps only apply if you did not choose the option for the server to start automatically:
8 Open a shell and set the environment with oware (Windows) or . /etc/.dsienv
(Linux). Enter
pmstartall to start the application server.
NOTE:
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.
Important Hardware Considerations
Refer to the Oracle Installation guides for minimum requirements. Note that OpenManage
Network Manager uses the Oracle database in a highly transactional way. This means that there will
be significant IO to the Redo logs. Some basic recommendation to optimize IO for the Oracle
server would be to increase the number of physical disks available to the server which will help to
eliminate lock contentions.
Initial Oracle Settings Configuration
Run the following as the Oracle system user before running loaddb and before starting the
application server to configure Oracle settings required by the OpenManage Network Manager:
1 Login to Oracle system:
sqlplus system/<system password>