Demo Install

This section describes how to install the demo database components for Oracle Utilities Meter Data Management, including:

• Copying and Decompressing Install Media

• Creating the Database and Importing the Dump File

• Post-installation Tasks

Copying and Decompressing Install Media

To copy and decompress the Oracle Utilities Meter Data Management database:

1. Download Oracle Utilities Meter Data Management V2.5.0.1.1 Demo from Oracle Software Delivery Cloud.

2. Unzip the downloaded file. It is extracted to the Demo directory.

Creating the Database and Importing the Dump File

This section describes the steps to create the database and import the demo data dump file.

• Creating the Demo Database on Unix or Windows

• Importing the Demo Dump File

Creating the Demo Database on Unix or Windows

To create the demo database:

1. Create the database using the Database Configuration Assistant (DBCA).
Refer to Creating the Database for steps to create the database.

2. Make sure to set character set for database as AL32UTF8.

3. Create a directory in the database with the name ‘data_pump_dir’.

4. Copy the demo dump file from ../Demo/ folder to the physical location on the disk that is mapped to data_pump_dir.

5. Unzip the demo dump file.

Importing the Demo Dump File

After a successful database creation, import the demo data:

1. Set the correct ORACLE_SID and ORACLE_HOME.

2. Run the following command to import the demo dump:

impdp directory= data_pump_dir dumpfile= exp_demo.dmp logfile=exp_demo.log schemas=CISADM

Post-installation Tasks

This section describes the following post installation tasks:

• Configuring Security

• Populating Language Data

Configuring Security

To configure security:

1. Set PATH.

export JAVA_HOME=<Java Install location>/jdk1.8.0

export PATH=$JAVA_HOME/bin:$PATH

2. Set CLASSPATH.

export CLASSPATH=<TEMPDIR>/DB/FW_V4.5.0.1.1/jarfiles/*

3. Run this command with defined parameters at the command prompt.

java com.oracle.ouaf.oem.install.OraGenSec -d <DBUSER>,<DBPASS>,jdbc:oracle:thin:@<DB_Server>:1521/ <SERVICE_NAME> -a A -r <RW_USER_ROLE>,<R_USER_ROLE> -u <RWUSER>,<RUSER> -p <RWUSER_PASS>,<RUSER_PASS>

Populating Language Data

Note that this database contains data in the ENGLISH language only. To use any other supported language, run the F1-LANG batch program to duplicate the entries for new language records.

For more information on running this batch program, refer to the Background Processes section in the Oracle Utilities Meter Solution Administrative User Guide included in this release. You can also install the language specific demo data packages (if available) into the database. Contact your Oracle representative to receive information on these packages.