Technical data
Oracle Database Installation
2-10 Oracle Utilities Meter Data Management Database Administrator’s Guide
Do you want to import a demo database dump into this database (Y/
N)?
• For an initial install, select N to exit the database utility. Follow the steps in Initial
Install on page 2-3 to complete the database installation.
• For a demo install, select Y to import the demo database.
For the Demo Install use the dump file exp_demo.dmp.
Do you want to import a demo database dump into this database (Y/
N)? Y
• Enter the name of the dump file (exp_demo.dmp):
• Enter the name of the dump file directory (data_pump_dir):
• Enter the name of the log file (exp_demo.log):
Ready to import the CISADM schema into the database, do you want to
continue (Y/N)? Y
Notes:
• 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.
Windows
The files are located in MDM\DatabaseCreation\Windows. You should be logged in as a user
who is a member of local ORA_DBA group on that server. The ORA_DBA group should have
“administrator” privileges assigned to it.
1. To create a database, run the utility CDXDBA.exe located in the Windows folder.
The utility will display a list with the following options:
E - Export a schema from the database
R - Refresh a schema with a database dump.
C - Create/Recreate a local database.
H - See help for the command line options.
Q - Quit.
2. Select option C to create an empty database on your machine.
Follow the prompts to complete the creation of the database.
3. Once the database has been created you can exit the utility or select “R - Refresh a schema
with a database dump file” to load the Demo Install data.
Note: Do not load the demo install data for an initial install. Follow the steps in Initial
Install on page 2-3 to complete the initial install of the database.
Option R causes the utility to drop all the objects from the schema and import the schema
from a database dump file.
Notes: