Users Guide

Installing Oracle | Oracle Database Management
OMNM 6.5.3 Installation Guide 169
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>
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
NOTE:
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 a user
with DBA privileges or the
system user. The -w option is required for the password.
The -d option creates the database user specified during installation and the -s option creates
the OpenManage Network Manager tablespace: OWSYNERGY01 and the portal tablespace.
Without
-s it creates OpenManage Network Manager tablespaces: owdata01 and owidx01.
Here are the options:
loaddb -u system -w <system password> -d
Creates:
• tablespace owdata01
• tablespace owidx01
• role owrole
• user omnm
(assuming you specify the user “omnm” during installation or in the
install.properties file)
loaddb -u system -w <system password> -s
Creates:
• tablespace OWSYNERGY01—Includes user credentials, multitenancy information.
• role OWSYNERGYROLE
• user SYNADMIN
• tablespace OWPORTAL01 (portal information)
• role OWPORTALROLE
• user NETVIEW