PeopleTools 8.52 Upgrade

Here are my notes on a recent PeopleTools 8.52.07 Upgrade from 8.51.03 on Finance 9.1 This was on Linux

====== PREP WORK======

Download Tools media
unzip all media
chmod 755 tuxedo10gR3_64_Linux_01_x86.bin & jrockit-jdk1.6.0_20-R28.1.0-4.0.1-linux-x64.bin
* tuxedo for 8.52 is same version as 8.51
* jrockit for 8.52 is older than version I used for 8.51
* weblogic goes from 10.3.3 to 10.3.4
install Tools 8.52 on Change Assistant system
install Tools 8.52.07 patch on Change Assistant system
* password for zip file is *************** (Oracle probably doesn’t want me giving that out)
we will create a new $PS_HOME on all linux servers
* /opt/apps/psoft/fin852

====== WEB SERVER ======

mkdir /opt/apps/wls1034
export JAVA_HOME=/opt/apps/jrockit-jdk1.6.0_29-R28.1.5-4.0.1
cd /opt/media/8.52/weblogic
$JAVA_HOME/bin/java -jar ./wls1034_generic.jar -mode=console -log=/opt/apps/logs/wls1034install.log
“Middleware Home” = [/opt/apps/wls1034]
Choose Install Type:
——————–
->1|Typical
|  Install the following product(s) and component(s):
| – WebLogic Server
| – Oracle Coherence

Congratulations! Installation is complete.

#Install PTools web components
cp /opt/apps/psoft
cp -av fin851 fin852
cd /opt/media/8.52/ptools/Disk1
./setup.sh -i console
#PeopleTools  will be installed in the following location:
#/opt/apps/psoft/fin852
Congratulations. PeopleTools has been successfully installed to:
/opt/apps/psoft/fin852

#Install Verity
cd /opt/media/8.52/verity/Disk1
./setup.sh
$PS_HOME = /opt/apps/psoft/fin852
->1- Verity Development Kit
* Install

#Install Tools patch 07
cd /opt/media/8.52/patch.07/cd85207/Disk1
./setup.sh

====== APP SERVER ======

#Install PTools app components
cd /opt/apps/psoft
cp -av fin851 fin852
cd /opt/media/8.52/ptools/Disk1
./setup.sh -i console
#PeopleTools  will be installed in the following location:
#/opt/apps/psoft/fin852
Congratulations. PeopleTools has been successfully installed to:
/opt/apps/psoft/fin852

#Install Verity
cd /opt/media/8.52/verity/Disk1
./setup.sh
$PS_HOME = /opt/apps/psoft/fin852
->1- Verity Development Kit
* Install

#Install Tools patch 07
cd /opt/media/8.52/patch.07/cd85207/Disk1
./setup.sh

====== UPGRADE ======

Start Change Assistant
PeopleTools Only Upgrade
File -> Import Template
File -> New Environment
Name -> FIN91
NEW PS_HOME -> D:\PT8.52\
PRODUCTS -> ALL
LANGUAGES -> ENG
DATABASE TYPE -> ORACLE
SQL EXEC -> C:\oracle\product\11.2.0\client_2\BIN\sqlplus.exe

DATABASE NAME -> FIN91
USER ID -> VP1
USER PASS -> VP1
ACCESS ID -> SYSADM
ACCESS PASS -> *******

File -> New Job
PeopleTools_Only_Upgrade -> OK
FIN91 -> OK
Initial Upgrade -> OK

Right Click Job Title -> Set Documentation Directory
D:\PSCA\fin91\docs
Right Click Job Title -> Finalize Documentation

0.  Backup Database
1.  Update Stats
2.  Run DDD Audit (online)
3   Run SYS Audit (online)
4   Run SYSAUD01 Audit (doesn’t exist)
5.  Run Initial Alter Audit
6.  Review Initial Audit
7.  Review Table Row Counts (\bin\client\winx86\psae -CT ORACLE -CD FIN91 -CO VP1 -CP VP1 -R UPG -AI UPGCOUNT
* log found at $PS_SERVDIR/files  which was /home/psoft/PS_CACHE/files
* need to set PS_SERVER_CFG=/opt/apps/psoft/domains/appserv/prcs/FIN91/psprcs.cfg
8.  Verify Upgrade User
* Added PeopleSoft Administrator to VP1
9.  Verify Database Integrity (dbv)
* cd /u01/app/oracle/oradata/FIN91
for file in ls; do dbv FILE=$file >> log.txt; done
10. Run APPMSGPURGEALL.DMS
11. Drop PS_PSMCFQUEUESLAN & PSOPTSTATUS
* neither exist as tables to drop
12. Cleaning up PeopleTools Data
* SELECT OPRID, RUN_CNTL_ID, COUNT(RUN_CNTL_ID) AS NUMBER_OF_DUPLICATE_ROWS FROM PSCUBRUNCNTL GROUP BY OPRID, RUN_CNTL_ID HAVING COUNT(RUN_CNTL_ID) > 1;
13. Shrinking Images
* did nothing
14. Deleting Pagelet Wizard Data
15. Shutdown all web/app/prcs
16. Save Customized config file (not needed due to installing to new $PS_HOME)
17. Backup PeopleTools Software (not needed due to installing to new $PS_HOME)
18. Install PeopleTools Software (Software previously installed)
19. Install PeopleTools Patch (Software previously installed)
20. Setting up New PeopleTools Release
* Skipped until later
21. Setting up Change Assistant
* Previously installed
22. Setting Configuration Manager profile
23. Finalize Documentation
* Previously done
24. Run DBTSFIX Report
25. Edit DBTSFIX output
* No changes needed
26. Edit Grant script
27. Edit DDL Parameters
* No changes neeed
28. Preparing for PeopleTools Patch
29. Updating PeopleTools System Tables
30. Granting Priv to Connect ID
31. Updating PeopleTools Patch Info
32. Rerunning update stats
* skipped
33. Saving Transparent Data Encryption Info
* TDE not used in this case
34. Turn off Change Control
35. Loading Model Definitions
36. Loading Message Data
37. Reviewing PeopleTools Objects
* Took about 2 hours to run the compare
38. Copying the PPLTLS84CUR Project
39. Copying the PPLTLS84CURDEL Project
40. Copying the PATCH85X Project
41. Populating Updated Tablespace Data
42. Generating the Updated PeopleTools Script
* 2 Warnings
Warning: MCF_IM_DEMO_REC.MCF_IMUSERID – Default record.field MCF_IM_DEMO_REC.USER_OPRID has no rows, field type default used. (76,66)
Warning: PSPTTSTANLRULES – Field PTTST_ANALYSISPRI to be deleted has data present.  Record processed. (76,23)
43. Editing the Updated PeopleTools Script
* No changes needed
44. Running the Updated PeopleTools Script
45. Copying the PT84TBLSPC Project
46. Loading Base Data
47. Populating the Language Table
48. Loading Noncomparable Objects
49. Loading English Messages
50. Loading English String Data
51. Loading Stored Statements Data
52. Loading PeopleTools Definition Group
53. Loading Conversion Data
54. Reporting Conversion Details
55. Running PeopleTools Data Conversion
56. Completing the PeopleTools Conversion
57. Creating All Views
* Database crashed, restarted and started the job over
* Database hit very hard around 25 views left, load average went to 27
58. Converting Integration Broker Objects
59. Creating All Triggers
60. Regenerating Sync IDs
61. Clearing the Rowset Cache
62. Updating Object Version Numbers
63. Backup after PeopleTools Upgrade
64. Running the TSRECPOP Script
65. Booting Servers
* Install new PIA, Rebuild App/PRCS domains
66. Synchronizing CREF Permissions
67. Review PeopleTools Functionality
68. Enable Oracle TDE
69. Running the Final DDDAUDIT Report
70. Running the Final SYSAUDIT Report
71. Running the Final SYSAUD01 Report
72. Creating the Final Alter AUDIT project
73. Running the Final Alter Audit
74. Reviewing the Final Alter Audit
* Ran FNLALTAUD_alttbl.sql and FNLALTAUD_crtidx.sql
75. Reviewing Change Control
* Nothing to do, didn’t have Change Control on

****** Upgrade Complete! ******

Leave a Reply

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