Demo Install

This section describes how to install the demo database components for Oracle Utilities Market Settlements 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 Market Settlements 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 steps to create the database and import the demo data dump file, including:

• 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, demo data can also be imported by following these steps:

1. Set the correct ORACLE_SID and ORACLE_HOME.

2. 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

• Applying Patch 29049452

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 the following command with the defined parameters on 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

Please note that this database contains data in the ENGLISH language only. If you use any other supported language, you can 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 Defining Background Processes section in Oracle Utilities Market Settlements Management user documentation. You can also install the language specific demo data packages (if available) into the database. Please contact your Oracle representative to receive information on these packages.

Applying Patch 29049452

After completing the Oracle Utilities Market Settlements Management database installation, download the Patch 29049452 from My Oracle Support and apply it to the application. For more information, refer to the ReadMe included the patch installation package.