Table of Contents

1. Preface

  • 1.1 Pre-requisites
  • 1.2 Audience
  • 1.3 Conventions Used

    • 2. Setup and Configuration of the Database Server

  • 2.1 Creating Database
  • 2.1.1 Creating the Database Server Users and Groups
  • 2.1.2 Creating the Database
  • 2.2 Installing the Application Database
  • 2.2.1 Running the installation script
  • 2.2.2 Selecting the Install Type
  • 2.2.3 Setting up the Installation Environment
  • 2.2.4 Creating Application Home directory
  • 2.2.5 Creating Application Tablespaces
  • 2.2.6 Creating the Application Owner User and Grant Tablespace Quotas
  • 2.2.7 Installing Database Objects and Seed Data
  • 2.2.8 Installing Library Objects
  • 2.2.9 Installing Directory Objects
  • 2.3 Modifying Application System Parameters
  • 2.4 After Creating the Application Database
  • 2.5 Set the Oracle JVM File Permissions
  • 2.6 Advanced Queues
  • 2.7 Fine-Grained Access to Network Services in Oracle Database
  • 2.8 Installing Upgrade
  • 2.9 Enabling Transparent Data Encryption to Secure Stored Data
  • 2.10 Data Redaction
  • 2.11 Optimize PS_TXN
  • 2.12 Configure EBR for OFSLL Schema