Step By Step: PeopleTools 8.51 Upgrade (Part 4)

This is a continuation of my PeopleTools 8.51 posts.  Now, we will use Change Assistant.

Please see my Step by Step page for more articles like this, or you can start at the beginning of this series with Part 1.

Task 3-3-1: Setting Up Change Assistant

First, you need to download the template from Oracle support.  You can find it on the Enterprise PeopleTools 8.51 Upgrade Home Page [ID 1196626.1].  You will need to download PeopleTools_Only_Upgrade.exe.  It actually downloaded as a zip file for me.  I just extracted it into a directory that I called install.  You will need it later on.

You will also need to download and extract the documentation for the template.  That comes from the same location, and you can download it by clicking on the link “Enterprise_PeopleTools_851_Upgrade_HTML”.

Now, open Change Assistant from your Start Menu.  To start the install, go to Tools > Options…

Then, select PeopleTools Only Upgrade:

You will also have to set the Staging and Output directories.  For these, I created these directories.  I normally create a directory called psca at the root and I add three directories: download, staging, and output.  They don’t need anything in them right now.

Next, you can leave the Options dialog, and you will need to use the File > Import Template … option

Choose the file you downloaded from Oracle support.

Now, add a new environment: File > New Environment

Now, give it a name.  I just chose the name of the database.

You may also have to enter the path to your PeopleSoft Home:

Then, it asked more questions about the environment.  I had to look up in PeopleBooks for some of these answers.  The database tool is osql.exe for SQL Server and I found it in Microsoft SQL Server\90\Tools\Binn\OSQL.EXE.

Then, supply the user name and passwords needed to connect (note: the “User ID” is a PeopleSoft User Profile and “Access ID” is a database user account):

At first, when I clicked the Test Connection, it failed.

Then, I realized that I had the database shutdown when I had stopped all the services.  So, I just had to start the database service back up.

After starting the service, it worked.

Now, we just review:

And, we are done!

Now, that the environment is setup, you need to create the job.  You can do this with the File > New Job menu option:

Choose the template name that we imported earlier:

Choose the new environment that we just created:

Choose the upgrade type:

Now, you are done, and you should see your new job with all of the steps:

Now, you need to set the documentation directory.  You can do so by right clicking on the top level name of the job and clicking on Set Documentation Directory.

Now, you simply browse to where you extracted the directory at the beginning of this part:

Now, when you look at the first step in the job, you should see the documentation and instructions:

Task 3-3-2: Setting Configuration Manager Profile

Now, you need to open up Configuration Manager from the Start menu.  Then, go to the Profile tab to edit the default profile:

Then, on the Common tab, you need to check the Data Mover settings.  My input and output directories were fine, but I changed the log directory to the change assistant directory.

Task 3-3-3: Finalizing the Documentation

Now, just right click on the top level job name and click on the Finalize Documentation option.

This is the dialog you get when it is done:

To Continue, go to Part 5.


PeopleSoft Change Assistant for Upgrades and Updates

10 thoughts on “Step By Step: PeopleTools 8.51 Upgrade (Part 4)

  1. Hi Friend,

    Wow, What a wonderful article, I am really thankful to you..Very Nice step by step document. May Allah, shower his blessings on you.

    Abdul kather

  2. We would like to upgrade from PeopleTools 8.48 to PeopleTools 8.54. I have read PeopleSoft PeopleTools 8.54 Upgrade Home Page (Doc ID 1915618.1) and all documents referenced within it. But all upgrade documents and the change assistant deal with upgrading of the database. What about upgrading of the file system (in PS Home)? Also, none of the upgrade documentation mentions upgrading app servers, web servers, JVM, net express, etc?

    Main question: Do we install the new PS HOME with 8.54 fresh install and then reference that in the change assistant or do we copy our current PS HOME and reference that in the change assistant?

    Per my read of the upgrade documents here is the flow of high level steps? But I am not sure about these.

    1. Copy PS_HOME to be upgraded (HRDM990). We would like to upgrade our demo first. So we will copy our HR DEMO PS HOME to the new server with the new operating system and new sql server database version. But I am not sure of this step. Should we copy/install the new PS HOME from PeopleTools 8.54 disks and then reference that in our change assistant. How do the file systems of the two PS HOMEs get merged (the old and the new PS HOME)?

    2. Install PeopleTools

    a. Disks have been downloaded.
    b. Location TBD??

    3. Install Change assistant from 8.54 binaries (new one)

    a. Steps in the 900 page install manual.
    b. …

    4. Down load change assistant package

    5. Load Change Assistant Template/package –

    6. Start steps in the PeopleTools 8.54 Upgrade Manual and complete all of them per the change assistant flow

    7. Install Net Express (COBOL)

    a. Not yet downloaded – PACK6

    8. Compile COBOL

    9. Install new/upgraded JVM:

    10. Install new/upgraded App Server & Webserver:

    a. AppServer
    b. Webserver

    11. Install new/upgraded other components

    a. Coherence (Verity replacement)…
    b. Others??

    12. Redefine/rebuild APP and PRCS schedulers servers via PSADMIN

    13. Start Services

    14. Login
    Mansoor Khan
    Thales Defense and Security Inc.

    1. Mansoor,

      I am sorry for the late reply. I hope you have been able to find information that has helped you through these steps.

      Upgrading the file system is done with the PeopleTools installer. That’s the easy part. Just install on top of your existing PS_HOME directory and the installer will overwrite the files that need to upgrade.

      Also, note that if you have multiple machines involved in your environment, you will need to run the installer on each of those. So, run it on your application server and your web server and your batch server. You will need to run it once for each PS_HOME directory involved in your environment.

      If you want, you can copy your PS_HOME directory if you want to keep your old one. Run the installer on top of the copy of the PS_HOME directory. Then, you will have an upgraded directory and a non-upgraded directory. As you get the database upgraded, you can change the configuration to point to the new PS_HOME.

      Now, all of that assumes that you are running with the a single PS_HOME. If you are running with a PS_APP_HOME and a PS_CFG_HOME, it changes things a little. You can run the installer to create a brand new fresh install directory because the PS_HOME in that case is just the tools stuff. Again, you will need to point the configuration (app server, etc) to the new home directory.

      Looking through your steps, they look pretty good to me. One thing I don’t think that I saw was installing the patch. You will want to run the installer to install tools 8.54 and then run the patch installer to bring it up to 8.54.04 or whatever the latest is. Also, do you need install Oracle SES (Secure Enterprise Search)?

      I hope that helps.



  3. Hello Team,

    Can you please provide me Doc related to installation of 8.17 Application designer. How to do that Please revert. i need urgent

    1. I’m sorry: you would have to get that from Oracle Support. I suspect that with a version that old, you would have to open a ticket. I don’t think that they publish old versions to install. If I’m not mistaken, I think that version is even prior to Oracle’s purchase of PeopleSoft.

  4. Hi Digitaleagle,

    Oracle also does not have the doc . Do you have any Upgrade related to doc 8.17 to 8.22 . or else like we can consider 8.51 will be same work . Please suggest..

    1. Suhail, I don’t have any documentation. The more I think about, I think that is prior to Change Assistant.

      I think you should step back and see why you are trying to go with something that old. So, much has changed between now and then. If you are putting time into upgrading, you should be going to the latest in my opinion.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.