Oracle Primavera P6 EPPM Microsoft SQL Server Database Installation Guide

This document describes how to manually install Oracle Primavera P6 EPPM and use a Microsoft SQL Server database


Oracle Primavera P6 EPPM Microsoft SQL Server Database Installation Guide - cover page
Brand
Oracle
Category
Other
Document type
Installation Guide
Language
English
Pages
16
File format
PDF
File size
136 KB
Published
27 October, 2023
Updated
27 October, 2023
MD5 checksum
CB706C6BDC90567E1082E4BF10BC467D

About this manual

This guide provides instructions for database administrators to manually install Oracle Primavera P6 EPPM using Microsoft SQL Server. It covers creating the database structure, copying scripts, setting up users and tables, installing sample data, and configuring security settings. The guide assumes familiarity with SQL Server administration and command-line tools. It also includes tips for optimizing SQL Server settings and securing database credentials.

What's inside

  • Creating the Database Structure for Microsoft SQL Server and Loading Application Data
  • Prerequisites for SQL Server Configuration
  • Creating the P6 EPPM Database Structure for Microsoft SQL Server
  • Copying the Script Files to a Local Drive for Microsoft SQL Server
  • Creating the Database for Microsoft SQL Server
  • Creating Users and Tables for Microsoft SQL Server
  • Installing Sample Data and Creating Your P6 Admin Superuser Password for Microsoft SQL Server
  • Creating Remaining Database Objects for Microsoft SQL Server
  • Dropping P6 EPPM Database Objects for Microsoft SQL Server
  • Changing the Database Base Currency

Specifications

Database NamePMDB
Default Admin Superuseradmin
Default Usersadmuser, privuser, pubuser, bgjobuser, and PxRptUser
Password Requirements8 to 20 characters, at least one numeric and one alpha character, mixture of upper and lower case letters
SQL Server Setting: ANSI_PADDINGOff
SQL Server Setting: Max Worker ThreadsDefault (255) or lower
SQL Server Setting: MemoryDynamic
SQL Server Setting: Open ObjectsDynamic
SQL Server Setting: User Connections0
SQL Server Setting: Network Packet Size16384
SQL Server Setting: FILESTREAMEnabled

Frequently asked questions

What is the default database name for P6 EPPM?

The default database name is PMDB.

What are the default database users in P6 EPPM?

The default database users are admuser, privuser, pubuser, bgjobuser, and PxRptUser.

What are the password requirements for P6 EPPM?

Passwords must be between 8 and 20 characters, include at least one numeric and one alpha character, and use a mixture of upper and lower case letters.

What SQL Server setting should be set to Off for P6 EPPM?

The ANSI_PADDING setting should be set to Off to prevent duplicate values due to leading or trailing spaces.

Download PDF (136 KB)

More Oracle Manuals


View all Oracle manuals →