Oracle Utilities Work and Asset Management Database Administrator’s Guide
Preface
Audience
Related Documents
Updates to this Documentation
Conventions
Acronyms
Additional Resources
Database Overview
Supported Database Platforms
Support for Software Patches and Upgrades
Database Maintenance Rules
Permitted Database Changes
Non-Permitted Database Changes
Installing the Database
Privileges to Modify OUAF V25.4 Database
Installation Overview
Prerequisites
Creating the Database
Installing the Oracle Database
Database Scripts and Utilities
Initial Install (Installing V25.4 for the First Time)
Installing the CISADM Schema
Upgrade Install
Demo Install
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
<<pDefault 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
Conversion Tools
Database Configuration
Installing the Script
Preparing the Production Database
Preparing the Staging Database
1. Set JAVA_HOME, PATH, and CLASSPATH.
1. Set JAVA_HOME, PATH, and CLASSPATH.
2. Run Conversion from any directory making sure Step 1 is complete. Run the command as necessary.
Linux/UNIX:
• On-premises:
Upgrading the Production Database
Upgrading the Staging Database
1. Extract ConvSetup.tar from the ..\WAM\Conversion\ folder.
2. On the Staging schema, execute the following script:
3. Upgrade the staging schema (example: STGADM). For instructions, refer to the Upgrade Install section in Installing the Database.
4. To set up conversion again, follow the instructions in the Preparing the Staging Database section.
Upgrades to the Oracle Utilities Work and Asset Management 25.4 Database
Oracle Utilities Work and Asset Management V2.3.0.0.0 to V2.4.0.1.1
Oracle Utilities Work and Asset Management V2.4.0.0.0 to V2.4.0.1.1
Oracle Utilities Work and Asset Management V2.4.0.1.1 to V25.4
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
Upgrades to Oracle Utilities Application Framework v4.5.0.1.1
Upgrades to Oracle Utilities Application Framework v25.4
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 Work and Asset Management Database Administrator’s Guide
Oracle Utilities Work and Asset Management Release 25.4 Database Administrator’s Guide