Technical data

Oracle Database Installation
2-4 Oracle Utilities Meter Data Management Database Administrator’s Guide
The CDXDBA utility provided in the DatabaseCreation folder may be used to automate the
process. See Creating the Database on page 2-9 for more details. For an initial install, do not
import the demo install data when you create the database.
Install the Database
Install Oracle Utilities Application Framework V4.1.0 prior toOracle Utilities Meter Data
Management 2.0.1.
The files for Oracle Utilities Application Framework installation are located in the FW410 folder:
1. Install base FW V4.1.0 by running the CdxDBI.exe from under the FW410/Install-Upgrade
folder.
2. Apply prerequisite Framework DB single fixes. See the Oracle Utilities Meter Data Management
Installation Guide for more details.
The files for the Initial Install of Oracle Utilities Meter Data Management 2.0.1 are located in the
Install-Upgrade folder under MDF and MDM.
The process prompts you for the names of three database users:
• A user that will own the application schema (for example, CISADM).
• A user that has read-write (select/update/insert/delete) privileges to the objects in the
application schema. The application will access the database as this user. (for example,
CISUSER).
• A user with read-only privileges to the objects in the application schema. (for example,
CISREAD).
• A database role that has read-write (select/update/insert/delete) privileges to the objects in
the application schema. The application will access the database as this user. (for example,
CIS_USER).
• A database role with read-only privileges to the objects in the application schema. (for
example, CIS_READ).
• Location for jar files. (The Jar files are bundled with the database package.)
• Java Home (For example, C:/Java/jdk1.6.0_18)
To install the Oracle Utilities Meter Data Management database, follow these steps:
1. Run CDXDBI.exe from MDF/Install-Upgrade. The utility prompts you to enter values for
the following parameters:
• The name of the target database.
• The password for the SYSTEM user account in the database (in silent mode).
• The name of the owner of the Database Schema.
• The location of Java Home.
• The location of TUGBU JAR files.
• The password for the user (in silent mode).
• The Oracle user with read-write privileges to the Database Schema.
• The Oracle user with read-only privileges to the Database Schema.
• The Oracle database role with read-write privileges to the Database Schema.
• The Oracle database role with read-only privileges to the Database Schema.
2. If you chose to continue, CDXDBI first checks for the existence of each of the users
specified and prompts for their password, default tablespace, and temporary tablespace, if
they do not exist.