Patch Installation

Step 1: Download the Patch
Step 2: Shut down the all servers(application servers, web servers, Process Scheduler servers, and EM Agents that are currently running)
Step 3: Back up your existing PSHOME folders
Step 4: Install Patch Files Run \pt85016\cd85016\Disk1\setup.bat (Example)
Step 5: Update Your Database with Patch Version Information. Using People Tools 8.50.16 launch
Data Mover and logon to your database as a PeopleSoft User Run the script
<PS_HOME>\scripts\PTPATCH.DMS
Step 6: Install Database Changes Included in this Patch
6.1. Using People Tools 8.50.16, launch Application Designer, and sign on to the database as a PeopleSoft User.
6.2. Select  <Tools>, <Copy Project>, <From File>
6.3. Enter <PS_HOME>\projects and select
PATCH850 from the list of projects.
6.4. Select <Options> and highlight the languages  <Common> and <English> ONLY.
6.5. Select <Copy> to begin copying updated
People Tools objects to your database.
Step 7: Load People Tools Messages and Data Project
7.1. Logon to Data Mover in bootstrap mode as the database owner using PT 8.50.16
7.2. Run <PS_HOME>\scripts\MSGTLSUPG.DMS to load the updated messages into your
Database
7.2.1. Note: If message catalog changes have not been made in PT 8.50 by the time this
Patch is released, the MSGTLSUPG.DMS script may not exist in the
<PS_HOME>\scripts folder and this entire step can be skipped.
7.3. Close Data Mover.
Step 8: Completing Installation and configuring this People Tools Patch9.1. Reinstall any products in
use from the following folders:
8.1.1. Change Assistant: <PS_HOME>\setup\PsCA 9.1.2.
People Soft Internet Architecture (PIA): <PS_HOME>\setup\ PsMpPIAInstall9.1.2.1. Choose
'Redeploy PeopleSoft Internet Architecture' when prompted
Step 9: Purge all App Server and Web Server cache. Re-start your Application server(s), Batch
server(s), Web Server(s), and EM Agents
-----------------------------

Step By Step: PeopleTools 8.51.0 to 8.51.11

July 14, 2011 — digitaleagle

I had hoped to be able to get the PeopleTools Testing Framework posts complete before I proceeded to installing the latest update patch for PeopleTools. After constantly reading that you need to update to the latest for PTF, I decided I was being silly, and I broke down and went through the update.

Here’s what I did:

First, I downloaded the update from Oracle Support:

Update: 866843

At this point, I probably could have done the Change Assistant package. I chose to do the full install version because it would complement the instructions that I already have.

So, I downloaded 85111.zip from the PT85111UserDoc.htm page:

Stop the Services

Next, I stopped the services. For me, (since I am on a single-instance, single-user system) I just pulled my start up script out of the start up folder.

When I rebooted, everything should be stopped. To avoid rebooting, make sure that you have stopped all:

• App Servers
• Process Schedulers
• Web Servers
• PSEM Agents

Just a thought: I would clear the cache on your servers – app, batch, and web – to make sure that everything stopped as it should.  You might visually scan task manager also.

Backup

Now, keep in mind that I don’t take any responsibility for mistakes that you make or problems with anything. Hey, this is free information. So, your on your honor — back up just in case. I have a VM Instance, and I just backed up the whole machine.

Installer

Next step is to copy the install files to the machine, unzip them, and run the setup.bat file.

This brings you to the welcome screen:

Next, you have accept the license to continue:

When it asks for the license code, enter it in the blanks. If you are like me and didn’t write down the code, look up the PeopleTools license code for your platform here.

Next, you have to choose which database you currently have installed:

Then, you choose which pieces of the system you want in this particular install. For me, because it is a single server installation, I need all of the pieces.

Now, choose your current PeopleSoft home directory:

If you wish, enter your email for security updates:

I just chose all of the features:

Now, review your selections …

And, you should be off to installing:

After a short amount of time, you should see the completion screen:

Stamping New Version in Database

Next, you need to stamp the database with the new PeopleTools version to show the file system and database are in sync. You simply run the ptpatch.dms data mover script in the scripts directory of your PeopleSoft Home. (I just logged in as PS, not boot strap mode).

Then, I opened the script: \scripts\ptpatch.dms

Now, click the green light run button to execute the script.

Database Changes/App Designer Project

The next major step is to install the App Designer project. This is copying the meta data into the database.

So, log into App Designer and choose Copy Project from File — Tools > Copy Project > From File:

Next, I accepted the default options here, and proceeded to copying the project:

Once it is loaded, Build the project. You should be able to use the Build > Project option.

For some reason, that option wouldn’t work for me. So, I just built each record manually. Here are the records I had to build:

• PRCSDEFN
• PSDSSECMAPMAIN
• PSGATEWAY
• PSPMSYSDEFAULTS
• PSTRIGGERDEFN
• QUERY_RUN_CNTRL
• SCHDLITEM

Note: if you select Build project, you should see the full list of records in the Scope.

Loading Messages

Messages from the message catalog do not copy via a project when copying from a file. So, we have to use this data mover script.

The instructions say to use bootstrap mode. So, you need to login as your database owner:

Then, open <PS Home>\scripts\msgtlsupg.dms.

Finally, click the green light run button to execute the script.

Reinstalling Tools

First, I unstinstalled Change Assistant:

PIA: I had just deleted the whole PIA Home thinking that I was going to reinstall.  I wish I had just deleted the cache and used the re-deploy option.  Oh, well.

Next, I uninstalled and re-installed the PeopleTools Test Framework.

Clear Rowset Cache with <PS Home>\scripts\clear_rowset_cache.dms

Then, clear App Server cache. Since I did that at the beginning, I don’t have to worry about that.

Finally, I placed my boot script back in the Startup directory, and I was good to go after a reboot.

Now, I have a 8.51.11 instance!

------------------------

Method 1:

Go to PeopleTools > Utilities > Administration, in that navigation you will see two links
1. Updates - View All
2. Updates by Release Label

Method 2:

Ctrl+J on a page

Method 3:

PSRELEASE,

PS_MAINTENANCE_LOG,

PSSTATUS tables

Method 4:

From Appdesigner or Datamover, go to Help > About