PeopleSoft 9.2 Application Installation for Microsoft SQL ...

PeopleSoft 9.2 Application Installation for Microsoft SQL Server (PeopleSoft PeopleTools 8.57)

January 2019

PeopleSoft 9.2 Application Installation for Microsoft SQL Server (PeopleSoft PeopleTools 8.57) Copyright ? 2019, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable: U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government. This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle. Documentation Accessibility For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at . Access to Oracle Support Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Contents

Preface About This Documentation ................................................................................................................................. 15 Understanding This Documentation ...................................................................................................................... 15 Audience ................................................................................................................................................................ 15 Typographical Conventions ................................................................................................................................... 16 Products .................................................................................................................................................................. 17 Related Information ............................................................................................................................................... 18 Comments and Suggestions ................................................................................................................................... 18

Part I ...................................................................................................................................................................... 19 Mandatory Installation ........................................................................................................................................... 19

Chapter 1 Preparing for Installation .................................................................................................................................... 21 Understanding the PeopleSoft Installation ............................................................................................................. 21 Understanding the PeopleSoft Installation Using Deployment Packages .............................................................. 23

Understanding the PeopleSoft Deployment Packages Required for Installation .............................................. 23 Reviewing the PeopleSoft PeopleTools DPKs ................................................................................................. 24 Reviewing the PeopleSoft Application Images ................................................................................................ 25 Reviewing the Installation Choices .................................................................................................................. 27 Reviewing the DPK Installation Process (Microsoft Windows) ...................................................................... 27 Understanding the PeopleSoft Upgrade Source Deployment Packages ................................................................ 27 Reviewing the PeopleSoft Upgrade Source Image Usage ................................................................................ 28 Reviewing the PeopleSoft Upgrade Source Image ........................................................................................... 28 Reviewing the PeopleSoft Upgrade Source Image Installation ........................................................................ 30 Reviewing Hardware Requirements ...................................................................................................................... 31 Reviewing Hardware Requirements for Microsoft Windows .......................................................................... 31 Reviewing Software Requirements ........................................................................................................................ 32 Reviewing Software Requirements on Microsoft Windows ............................................................................ 32 Reviewing Requirements for the Puppet Software on Microsoft Windows ..................................................... 33 Using Oracle Software Delivery Cloud to Obtain Installation Files ...................................................................... 34 Considering Project Planning ................................................................................................................................. 34 Planning Your Initial Configuration ...................................................................................................................... 34 Understanding Workstations ............................................................................................................................. 35

Copyright ? 2019, Oracle and/or its affiliates. All Rights Reserved.

3

Contents

Understanding PeopleSoft Servers and Clients ................................................................................................ 36 Defining the PeopleTools Client ....................................................................................................................... 36 Defining the File Server .................................................................................................................................... 37 Defining the Database Server ........................................................................................................................... 37 Defining the Application Server ....................................................................................................................... 37 Defining the Process Scheduler (Batch) Server ................................................................................................ 38 Defining Installation Locations ......................................................................................................................... 38 Defining the Web Server .................................................................................................................................. 41 Planning Database Creation ................................................................................................................................... 41 Understanding Database Creation ..................................................................................................................... 41 Determining Databases and Database Names ................................................................................................... 42 Defining Microsoft SQL Server and PeopleSoft Databases ............................................................................. 42 Planning Multilingual Strategy .............................................................................................................................. 43 Understanding Multilingual Issues ................................................................................................................... 43 Choosing a Base Language ............................................................................................................................... 45 Selecting Additional Languages ....................................................................................................................... 46 Selecting a Database Collation ......................................................................................................................... 46 Installing Supporting Applications ........................................................................................................................ 47 Installing Microsoft SQL Server 2014 on the Database Server ............................................................................. 48 Starting and Stopping Microsoft SQL Server 2014 ............................................................................................... 75 Installing Microsoft SQL Server 2014 -- Client Only .......................................................................................... 76 Understanding the Client-Only Microsoft SQL Server 2014 Installation ........................................................ 77 Installing Microsoft SQL Server 2014 on a Client ........................................................................................... 77 Configuring the Connection to Use SNAC for Microsoft SQL Server 2014 ........................................................ 92 Configuring an ODBC Data Source for Microsoft SQL Server 2014 ................................................................... 93 Increasing the Size of Tempdb ............................................................................................................................... 94 Installing Client Connectivity ................................................................................................................................ 94 Performing Backups ............................................................................................................................................... 94

Chapter 2 Installing the PeopleSoft Homes ......................................................................................................................... 95 Obtaining the PeopleSoft Application Images and PeopleTools DPKs ................................................................. 95 Obtaining the PeopleSoft Upgrade Source Images ................................................................................................ 96 Reviewing the DPK Setup Script Options ............................................................................................................. 97

Using the DPK Setup Script Options ................................................................................................................ 97 Preparing to Run the DPK Setup Script ............................................................................................................ 99 Running the DPK Setup Script to Install PS_HOME and PS_APP_HOME ....................................................... 100 Understanding the PS_HOME and PS_APP_HOME Installation .................................................................. 100 Installing PS_HOME and PS_APP_HOME on Microsoft Windows ............................................................. 101 Reviewing the Deployment Results ................................................................................................................ 104 Running the DPK Setup Script to Install All Software ........................................................................................ 105

4

Copyright ? 2019, Oracle and/or its affiliates. All Rights Reserved.

Contents

Understanding the DPK Setup Deploying All Software ................................................................................. 105 Installing on Microsoft Windows ................................................................................................................... 106 Reviewing the Installed Software ................................................................................................................... 109 Obtaining Operating System Packages Required by Puppet ............................................................................... 110 Removing a Deployed PeopleSoft Environment ................................................................................................. 111 Understanding the Removal Process .............................................................................................................. 111 Using the DPK Setup Script to Remove the PeopleSoft Environment on Microsoft Windows ..................... 111 Using Puppet to Remove the PeopleSoft Environment on Microsoft Windows ............................................ 112 Troubleshooting the Removal Process on Microsoft Windows ..................................................................... 112

Chapter 3 Completing the DPK Initialization with Customizations ............................................................................... 115 Understanding PeopleSoft Environment Customizations .................................................................................... 115 Preparing the Customization File for PeopleSoft Domain Definitions ................................................................ 119

Preparing the psft_customizations.yaml file ................................................................................................... 119 Reviewing the Domain Definitions in psft_configuration.yaml ..................................................................... 120 Reviewing the Customization File for a Single Application Server Domain ................................................. 124 Reviewing the Customization File for an Application Server Domain with Custom PS_CFG_HOME ........ 125 Reviewing the Customization File for a PIA Domain on a Separate Host ..................................................... 126 Reviewing the Customization File for Multiple Domains .............................................................................. 127 Preparing the Customization File to Create PeopleSoft Domains Without Configuration .................................. 132 Preparing the Customization File for Component Software Locations ............................................................... 133 Preparing the Customization File for Unicode ..................................................................................................... 134 Preparing the Customization File for the PeopleSoft Homes .............................................................................. 135 Preparing the Customization File for the PS_HOME Location ...................................................................... 135 Preparing the Customization File for the PS_APP_HOME Location ............................................................ 136 Preparing the Customization File for the PS_CFG_HOME Location ............................................................ 137 Preparing the Customization File for Jolt SSL and WSL SSL Ports ................................................................... 137 Preparing the Customization File for Oracle HTTP Server ................................................................................. 139 Preparing the Customization File for Mid-Tier Connection to a Microsoft SQL Server Database ..................... 141 Completing the Customized Deployment ............................................................................................................ 143

Chapter 4 Setting Up the Install Workstation ................................................................................................................... 145 Understanding the Install Workstation ................................................................................................................. 145 Prerequisites ......................................................................................................................................................... 145 Starting Configuration Manager .......................................................................................................................... 146 Setting Startup Options ........................................................................................................................................ 146 Editing the Default Profile ................................................................................................................................... 147 Running Client Setup ........................................................................................................................................... 149

Copyright ? 2019, Oracle and/or its affiliates. All Rights Reserved.

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download