Technical data

Oracle Database Installation
2-6 Oracle Utilities Meter Data Management Database Administrator’s Guide
Post-Install Tasks:
Refer to Populating Language Data on page 2-11 if the application is to run in another
language other than English.
Database Statistics Generation
During an install process, new database objects may be added to the target database. Before
starting to use the database, generate the complete statistics for these new objects using the
DBMS_STATS package.
Upgrade Install
The following section assumes an existing Oracle Utilities Meter Data Management V2.0
installation on top of an Oracle Utilities Application Framework V4.0.2 installation.
Install
Install Oracle Utilities Application Framework V4.1.0 prior to Oracle 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 the Install-Upgrade folder under
FW410.
2. Apply prerequisite Framework DB single fixes. See the Oracle Utilities Meter Data Management
Installation Guide for more details.
The files for the Upgrade Install of Oracle Utilities Meter Data Management 2.0.1 are located in
the Install-Upgrade folder under MDF and MDM.
The installation process prompts you for the names of three database users during this process:
• 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).
• The location for jar files. (The Jar files are bundled with the database package.)
• Java Home (For example, C:/Java/jdk1.6.0_18)
To upgrade the database, follow these steps:
1. Review and edit the Storage.xml file in the MDF/Install-Upgrade folder to set the various
options discussed previously. The instructions for editing the file are included in the file itself.
2. Run CDXDBI.exefrom the MDF/Install-Upgrade folder. 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