Technical data

Oracle Database Installation
2-8 Oracle Utilities Meter Data Management Database Administrator’s Guide
• Verifies whether the tablespace names already exist in Storage.xml file (the process aborts, if
not).
• Upgrades the schema, upgrades the system data, and configures security.
• Maintains upgrade log tables in the database.
• Updates release id when the upgrade is completed successfully.
• If an error occurs while executing a SQL script or another utility, it logs and displays the error
message and allows you to re-execute the current step. Log files CDXDBI###.log are
created in the same folder as CDXDBI and contains all the SQL commands executed against
the database along with the results. The log files are incremental so that the results are never
overwritten. If warning messages are generated during the upgrade, CDXDBI prompts the
user at the end of the process. Users should check the log files to verify the warning messages.
Warning messages are only alerts and do not necessary mean a problem exists.
• Stores the Schema owner and password in feature configuration table. The password will be
stored in encrypted format.
Post-Install
Refer to the Populating Language Data on page 2-11 if the application is to run in another
language other than English.
Database Statistics Generation
During an install process, new database objects may be added to the target database. Before
starting to use the database, generate the complete statistics for these new objects using the
DBMS_STATS package.
Environment Registration
Note: If the target database is registered as a configuration laboratory or
archiving database in another database, or another database has been registered
as a configuration laboratory or archiving database in this database, it is
required that you upgrade the registration at this stage.
The detailed instructions for environment registration can be found in the Oracle Utilities Meter
Data Management user documentation. Please refer to this documentation before executing the
environment registration utility EnvSetup.exe included in the post-install folder.
Demo Install
Before the installation can be started:
• A database must be created. Site standard techniques or tools may be used to create the
database. The templates for creating the database are located under the relevant database
version subdirectory of the MDM/DatabaseCreation directory under:
• createdb.sql - Create Database
• createdbcatalog.sql - Build database catalog tables.
• createdbfiles.sql - Create data files for tablespaces
• init.ora - Sample initialization parameters for the database
• createcdxusers.sql - Create Users
• restartdb.sql - restart database
• The users and roles for the product. Templates for this activity are located under the relevant
database version subdirectory of the DatabaseCreation directory as createcdxusers.sql.
Note: Please alter a copy of the above files for site specific changes.