Technical data

Oracle Database Installation
Database Installation 2-11
• For the Demo Install use the dump file exp_demo.dmp. The data_pump_dir must
exist in the database created above before continuing with the import. You should
also copy the exp_demo.dmp file to the data_pump_dir.
• Update the oratab, tnsnames.ora and listener.ora files for the new database and
check the connectivity to this database from another server and from your desktop.
After importing the demo install data, the demo install of the database is complete. You can now
install the application server as described in the installation guide.
Security Configuration
The configuration utility and scripts are located in the Security folder.
To configure security, execute the OraGenSec.exe utility.
The script will prompt you for parameter values:
Enter the application read-only user or Schema Owner in the
database (e.g CISADM or CISREAD):
Enter the password for the user:
Enter the name of the Oracle Database: database name
Enter a comma-separated list of Oracle users in which synonyms need
to be created (e.g. cisuser,cisread): cisuser,cisread
Select the following options:
(A/a): Generate security for All objects in the Database (e.g. A or
a for all objects)
(O/o): Generate security for specific Objects inputted in this
terminal (e.g. CI_ACCT,CI_ACCT_K)
Generate security for specific objects generated from an input File
(e.g. Security_Objects.txt)
The utility configures security for the CISADM schema objects
Note: If you run Oragensec in Interactive Mode (without using the command
line options), it will by default grant permissions to CIS_USER and
CIS_READ Role. If you prefer to use site-specific roles then execute
Oragensec after providing command line options.
For example:
(Oragensec.exe -d [Schema Owner],[Schema Owner's
Password],[Database Name] -u [Read/Write User],[Read Only User] -r
[Read Only Role],[Read Write Role] -a A -l [Logfile Name)
Note: Database vault must be disabled before running
Populating Language Data
At this point, the Oracle Utilities Meter Data Management demo database is ready for use. 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