Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview of Agile Database Installation

• 1.1 Task Overview
• 1.2 Obtaining Software from Oracle Software Delivery Cloud
• 1.3 Obtaining Software from Oracle Support
  • 1.3.1 Downloading the Agile PLM Software

2 Agile System Requirements

3 Installing Oracle Database Server

• 3.1 Related Documentation
• 3.2 Before Installing Oracle Database Server on Windows
  • 3.2.1 Network Check
  • 3.2.2 Confirming Computer Name and Host Name
  • 3.2.3 Confirming the Server Date
  • 3.2.4 Checking the Windows File System
  • 3.2.5 For Servers Configured with DHCP

4 Installing the Agile Database on Windows

• 4.1 Installation Notes
• 4.2 Creating the Agile Database on Windows

5 Installing the Agile Database on UNIX

• 5.1 Preparing the Host Computer
• 5.2 Creating the Agile Database on UNIX

6 Creating an Oracle RAC Database and Schema for Agile PLM

• 6.1 Creating an Oracle RAC Database Instance for Agile PLM
• 6.2 Creating an Agile PLM Schema in an Existing Oracle RAC or Standalone Database Instance
• 6.3 Database Postinstallation Tasks
  • 6.3.1 Adding and Configuring a Listener
  • 6.3.2 Adding and Configuring a Net Service
  • 6.3.3 Setting Up Automatic Shutdown and Startup for the Database on UNIX
  • 6.3.4 Setting Up Optional Oracle Functionality
    • 6.3.4.1 Setting Up Oracle Net Manager
    • 6.3.4.2 Configuring Oracle Enterprise Manager
  • 6.3.5 Setting Lexer Preference
  • 6.3.6 Setting up Enterprise Data Quality Product Integration

7 Database Management

• 7.1 Database Maintenance
  • 7.1.1 Monthly Maintenance
  • 7.1.2 Checking Database Space Allocation
  • 7.1.3 Dynamic Versus Static IP Addresses
• 7.2 Database Backup
  • 7.2.1 Backup and Recovery Strategy
  • 7.2.2 Implementing Backup Procedures
  • 7.2.3 Types of Backups
    • 7.2.3.1 Performing System Backups
  • 7.2.4 Using Standby Databases
  • 7.2.5 Performing Cold Backups
  • 7.2.6 Performing Database Backups
  • 7.2.7 Performing Hot Backups
• 7.3 Database Import and Export
  • 7.3.1 Creating the Agile Schema and Importing the Database
    • 7.3.1.1 Import Parameters
    • 7.3.1.2 Deleting an Instance and the Database Files
  • 7.3.2 Running SQL Scripts Against the Agile PLM Schema
  • 7.3.3 Exporting the Database
    • 7.3.3.1 Exporting the Agile Schema from Oracle
    • 7.3.3.2 Exporting the Full Oracle Database
    • 7.3.3.3 Export Parameters
• 7.4 Database Recovery
  • 7.4.1 Using Oracle Recovery Manager