Demo Install
This section describes how to install the demo database components for Oracle Utilities Smart Grid Gateway, including:
Note that the Oracle Utilities Meter Data Management Database Component is a cumulative package comprising of data used by all the Oracle Utilities Smart Grid Gateway and Oracle Utilities Service Order Management adapters.
Copying and Decompressing Install Media
To copy and decompress the Oracle Utilities Smart Grid Gateway database:
1. Download the Oracle Utilities Meter Data Management V2.5.0.1.1 Demo from Oracle Software Delivery Cloud for the following adapters:
• Oracle Utilities Smart Grid Gateway Adapter Development Kit
• Oracle Utilities Smart Grid Gateway Adapter for Networked Energy Services
• Oracle Utilities Smart Grid Gateway Adapter for Itron OpenWay
• Oracle Utilities Smart Grid Gateway Adapter for Landis+Gyr
• Oracle Utilities Smart Grid Gateway Adapter for Sensus
• Oracle Utilities Smart Grid Gateway Adapter for Silver Spring Networks
• Oracle Utilities Smart Grid Gateway Adapter MV-90 Adapter for Itron
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. It includes the following:
Note: When implementing Oracle Utilities Smart Grid Gateway with Oracle Utilities Meter Data Management, both the Smart Grid Gateway and Meter Data Management database components should be installed in the same database.
Creating the Demo Database on Unix or Windows
Follow the steps below to create the demo database:
1. Create the database using the Database Configuration Assistant (DBCA).
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. 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
To configure the security, follow these instructions:
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 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
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 user documentation section “Defining Background Processes.” 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.
Populating the CI_INSTALL_PROD Table
After completing the Oracle Utilities Smart Grid Gateway database installation, run the scripts based on the adapter being upgraded.
Navigate to ..\MDM.V2.5.0.1.1\Post-Upgrade, connect to the CISADM schema, and run the relevant script.