Oracle Utilities Operational Device Management Database Administrator’s Guide
Oracle Utilities Operational Device Management Database Overview
Supported Database Platforms
Support for Software Patches and Upgrades
Database Maintenance Rules
Permitted Database Changes
Non-Permitted Database Changes
Oracle Utilities Operational Device Management Database Installation Overview
Installation Overview
Prerequisites
Creating the Database
Installation Types
Initial Install
Upgrade Install
Demo Install
Installation Notes
Installing the Oracle Utilities Operational Device Management Database - Initial Installation
Copying and Decompressing Install Media
Creating the Database
Creating the Database on Linux/UNIX
Creating the Database on Windows
Database Globalization Support Consideration
Installing the ODM Schema
Installing the Oracle Utilities Application Framework Database Component using OraDBI.jar
Installing Oracle Utilities Application Framework Prerequisite Database Single Fixes
Installing Oracle Utilities Operational Device Management Database Component using OraDBI.jar
Tasks Performed by ORADBI
Generating Database Statistics
Enable USER_LOCK Package
Upgrading the Oracle Utilities Operational Device Management Database
Copying and Decompressing Install Media
Upgrading the Schema
Upgrading the Oracle Utilities Application Framework Database Component using OraDBI.jar
Installing Oracle Utilities Application Framework Prerequisite Database Single Fixes
Upgrading Oracle Utilities Operational Device Management Database Component using OraDBI.jar
Generating Database Statistics
Enable USER_LOCK package
Installing the Database- Demo Environment
Copying and Decompressing Install Media
Creating the Database
Importing the ODM Demo Dump File
Configuring Security
Database Design
Database Object Standard
Categories of Data
Naming Standards
Column Data Type and Constraints
User Defined Code
System Assigned Identifier
Date/Time/Timestamp
Number
Fixed Length/Variable Length Character Columns
Null Column Support
XML Type Support
Cache and Key Validation Flags
Table Classification and Table Volume Flags
Default Value Setting
Foreign Key Constraints
Standard Columns
Owner Flag
Version
Database Implementation Guidelines
Configuration Guidelines
Index
Table Partitioning Recommendations
Transparent Data Encryption Recommendations
Data Compression Recommendations
Database Vault Recommendations
Oracle Fuzzy Search Support
Storage Recommendations
Database Configuration Recommendations
Database Syntax
Database Initialization Parameters
Oracle Database Implementation Guidelines
Oracle Partitioning
Database Statistic
Materialized View
Upgrades to the Oracle Utilities Operational Device Management 2.4.0.0.0 Database
Oracle Utilities Operational Device Management V2.2.0.6.0 to V2.4.0.0.0
New Tables
Dropped Tables
New Fields
Updated Fields
Dropped Fields
New Indexes
Updated Indexes
Dropped Indexes
New Views
New Materialized Views
Oracle Utilities Operational Device Management V2.3.0.0.0 to V2.4.0.0.0
New Tables
Dropped Tables
New Fields
Updated Fields
Dropped Fields
New Indexes
Updated Indexes
Dropped Indexes
New Views
New Materialized Views
Upgrades to the Oracle Utilities Application Framework Database
Upgrades to Oracle Utilities Application Framework v4.3.0.3.0
Upgrades to Oracle Utilities Application Framework v4.3.0.4.0
Upgrades to Oracle Utilities Application Framework v4.3.0.5.0
Upgrades to Oracle Utilities Application Framework v4.3.0.6.0
Upgrades to Oracle Utilities Application Framework v4.4.0.0.0
Upgrades to Oracle Utilities Application Framework v4.4.0.2.0
Upgrades to Oracle Utilities Application Framework v4.4.0.3.0
Upgrades to Oracle Utilities Application Framework v4.5.0.0.0
Oracle Application Framework System Table Guide
About the Application Framework System Tables
System Table Standards
Guidelines for System Table Updates
Business Configuration Tables
Development and Implementation System Tables
System Table List
Oracle Utilities Operational Device Management Database Administrator’s Guide
Oracle Utilities Operational Device Management Release 2.4.0.0.0 Database Administrator’s Guide