Building out a new HCM 9.2 Update Image 9 DEMO

As mentioned here an updated version of  the PeopleSoft HCM media was released in late 2014.  I’ve done a few Demo installs of this on both Linux and Windows now, and here are my notes from a Linux install.  As in the past, these are rough notes I take when I do any install and not a how-to guide.  This install requires PeopleTools 8.54.03 patch as that is the level of PeopleTools within the database.  The media available on Oracle Software Delivery Cloud is only 8.54.00.  This install includes all PeopleSoft HCM patches through Update Image 9, a great thing for those using it to upgrade. Continue reading

Remastered 9.2 Application media

Some of you may have noticed this already but I recently saw that some of the PeopleSoft 9.2 Application media had been remastered.

  • HCM 9.2 was updated on E-delivery at the end of October.  It includes patches from Update Image 9.  Image 9 was also released as a certified Upgrade Demo Image.
  • FSCM 9.2 was updated at the end of September.  It includes patches from Update Image 5 which also released as a certified Upgrade Demo Image.
  • ELM 9.2 was updated in early October and contains patches from Update Image 6.  As with the others it also is a certified upgrade image.
  • CRM 9.2 looks updated at the end of September as well, but it does not indicate if any patches from an Update Image are included.  Since there is not currently a supported Upgrade Image other than CRM 9.2.000 it would not make sense that this media include the patches.  This may indicate it was updated because PeopleTools 8.53 was pulled and 8.54 added to the collection.  I have not downloaded it to look.

In addition the other change I noticed was that all PeopleTools 8.53 media has been pulled.  If you need something from the 8.53 media set you will need to open a non-tech SR.  This seems to be a change from the previous strategy of keeping the current plus one previous Tools set available for download.  I’m not on E-delivery all that often so who knows, maybe they changed that a while ago.

Either way, those looking to start upgrades or may have recently started the process using media they downloaded prior to end of September should evaluate where they are and possibly grab this new media.  Jumping straight to a Update Image would be beneficial.  Those looking to avoid PeopleTools 8.54 for some reason may want to avoid these though because at least HCM, FSCM, and ELM will already be 8.54 PeopleTools in the database.

HCM 9.2 and 8.53 Demo Install Notes

These are my notes from a recent HCM 9.2 / 8.53.02 setup I did.   I tried out the database wizard again this time.  Had a few hiccups but it seemed to work.  I still think it’s easier and quicker to create the database manually, especially when the java process ran at 100% on one cpu for about 20 to 30 minutes as the notes indicate below.  All said, it was an easy build and I didn’t see any significant issues/problems.

Update:  See the notes for HCM 9.2 / 8.54.03 / Patch Image 9

Install web componenents on web server

Things needed:
  1. wls1036_generic.jar
  2. jdk-7u17-linux-x64.tar.gz  or jdk-7u9-linux-x64.rpm (actually anything jdk7u2 +)
  3. License key for PeopleTools Oracle Install:
  4. PeopleTools 8.53.02 patch
  • Weblogic Media location: /opt/media/media/8.53/ptools.weblogic
  • Weblogic/JDK Install location: /opt/apps/
  • PeopleTools Media location: /opt/media/media/8.53/ptools
  • PeopleTools Install location: /opt/apps/psoft/pt853
  • HCM Application Install location: /opt/apps/psoft/hcm92

The Install

$ cd /opt/apps
$ tar zxvf /opt/media/media/8.53/ptools.weblogic/jdk-7u17-linux-x64.tar.gz
$ export JAVA_HOME=/opt/apps/jdk1.7.0_17
$ $JAVA_HOME/bin/java -jar /opt/media/media/8.53/ptools.weblogic/wls1036_generic.jar -log=./logs/wls1036HcmInstall.log

Weblogic Install prompts
Middleware Home= /opt/apps/wls1036.hcm92
Typical Install
JDK detected fine
Default product install directories

$ cd /opt/apps/psoft
$ /opt/media/media/8.53/ptools/Disk1/setup.sh

PeopleTools Install Prompts
PS_HOME=/opt/apps/psoft/pt853

$ /opt/media/media/hcm92/Disk1/setup.sh

HCM Application Install Prompts
PS_APP_HOME=/opt/apps/psoft/hcm92

$ /opt/media/media/8.53/patch.02/cd85302/Disk1/setup.sh

Patch Install Prompts
PS_HOME=/opt/apps/psoft/pt853


Install app components on app/prcs server:

Things needed:
  1. tuxedo111130_64_Linux_01_x86.bin
  2. COBOL Compiler ?
  3. License key for Oracle Install:
  4. HCM license key for Oracle:
  5. PeopleTools 8.53.02 patch
  • Weblogic Media location: /opt/media/media/8.53/ptools.tuxedo
  • Tuxedo Install location: /opt/apps/
  • PeopleTools Media location: /opt/media/media/8.53/ptools
  • PeopleTools Install location: /opt/apps/psoft/pt853
  • HCM Application Install location: /opt/apps/psoft/hcm92

The Install

$ cd /opt/apps

$ /opt/media/media/8.53/ptools.tuxedo/tuxedo111130_64_Linux_01_x86.bin -i console

Tuxedo Install Prompts
FULL INSTALL
Use existing ORACLE_HOME=/opt/apps
Use default TUXDIR=/opt/apps/tuxedo11gR1
Install Samples = Y
tlisten password = ********
Install SSL Support = N
$ cd tuxedo11gR1
$ . tux.env
$ tmadmin -v
INFO: Oracle Tuxedo, Version 11.1.1.3.0, 64-bit, Patch Level (none)

$ cd /opt/apps/psoft
$ /opt/media/media/8.53/ptools/Disk1/setup.sh

PeopleTools Install Prompts
PS_HOME=/opt/apps/psoft/pt853
$ /opt/media/media/hcm92/Disk1/setup.sh
HCM Application Install Prompts
PS_APP_HOME=/opt/apps/psoft/hcm92
$ /opt/media/media/8.53/patch.02/cd85302/Disk1/setup.sh
Patch Install Prompts
PS_HOME=/opt/apps/psoft/pt853

On Change Assistant VM

Install all tools options to D:\PT.853
Install application to D:\HCM92

Install 8.53.02 patch to D:\PT.853


Try out DB wizard for 8.53

Install 8.53 and 8.53.02 patch to /u01/psoft/pt853
Install HCM 9.2 to /u01/psoft/hcm92
Install Tuxdo Full Install to /u01/tux

# mkdir /u01/tux
# chown oracle:oracle /u01/tux/
$ export PS_HOME=/u01/psoft/pt853; export PS_APP_HOME=/u01/psoft/hcm92
$ . $PS_HOME/psconfig.sh
$ . /u01/tux/tuxedo11gR1/tux.env

Database prereqs
$ mkdir /u01/app/oracle/oradata/HCM92
$ mkdir /u01/app/oracle/admin/HCM92
$ mkdir /u01/app/oracle/admin/HCM92/pfile
$ mkdir /u01/app/oracle/admin/HCM92/adump
$ mkdir /u01/app/oracle/fast_recovery_area/HCM92
$ orapwd file=$ORACLE_HOME/dbs/orapwHCM92 entries=5
$ vi $PS_HOME/scripts/unix/createdb10.sql
:1,$s/oradata/app\/oracle\/oradata/g
$ vi $PS_HOME/scripts/unix/utlspace.sql
:1,$s/u03/u01\/app\/oracle/g
$ vi $PS_APP_HOME/scripts/unix/hcddl.sql
:1,$s/u04/u01\/app\/oracle/g
$ vi $ORACLE_HOME/network/admin/tnsnames.ora
add HCM92 entry
$ export ORACLE_SID=HCM92
$ cd $PS_HOME/setup/PsMpDbInstall
$ ./setup.sh

Prompts
Installation Location: (DEFAULT: /u01/psoft/pt853):
PS_APP_HOME: /u01/psoft/hcm92
database platform: ->1- Non-Unicode Database
Character Set: ->1- Western European ISO 8859-1
Database type: ->1- Demo
PeopleSoft Application: ->1- PeopleSoft HCM Database – US English
sqlplus path: [/u01/app/oracle/product/11.2.0/dbhome_1/bin]:
ORACLE_HOME: [/u01/app/oracle/product/11.2.0/dbhome_1]:
Location of modified scripts: /u01/psoft/hcm92/modifiedscripts
Create or use existing SID: ->1- Create new SID
Oracle SID: HCM92
DatabaseName; HCM92
Mount Point 1: u01
Mount Point 2: u01
Mount Point 3: u01
Enable AutoExtend: ->1- Yes
Peoplesoft owner ID: SYSADM
Peoplesoft owner password: ********
Peoplesoft connect ID: people
Peoplesoft connect password: ********
Peoplesoft default tablespace: [PSDEFAULT]:
Location of init.ora file complete path: [/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initHCM92.ora]:
Appserver User []: PSAPPS
Password []: ********
Webserver User : PTWEBSERVER  * Webserver User name was not a prompt.
Password []: ********
enable or disable all other user profiles: ->2- Enable
Password for other OPRIDs: ->2- I would like to set a different password
Password []: ********
Base Language: ->1- ENG – US English

Failure 1:  ORACLE_SID not set, so hung on runCreatedb10.sh
Failure 2:  had undo_tablespace=UNDOTBS1 in initHCM92.ora which did not match psundo name
Failure 3:  tried to do install with only tux client installed, needed full install
Failure 4:  didn’t shutdown running instance from Failure 3

Java process ran at 100% for a while after utlspace, probably parsing output.

SQL> select toolsrel from sysadm.psstatus;

TOOLSREL
——————–
8.53
SQL> select count(*) from sysadm.ps_maintenance_log;
  COUNT(*)
———-
0

Update HCM92 database to 8.53.02

Overall steps, some already complete  As always, read the README file as these steps could change
  1.  Backup pristine database
    1.  Shutdown immediate
    2.  startup mount
    3.  rman target /
    4.  configure controlfile autobackup on;
    5.  configure device type disk parallelism 2 backup type to compressed backupset;
    6.  backup database;
    7.  SQL> alter database open;
  2.  Download and extract patch
  3.  Shutdown all processes for ENV to patch
  4.  Backup existing Tools directories
  5.  Install patch files
  6.  Update database patch version (PS_MAINTENANCE_LOG entry)
    1.  run %PS_HOME%\scripts\ptpatch.dms
  7.  Apply patch project
    1.  Launch patched App Designer
    2.  Tools -> Copy Project -> From File
    3.  %PS_HOME%\projects select PATCH853
    4.  select Common and English language only
    5.  Copy the project
    6.  Build project
      1.  Build Options: create tables/view, alter tables, create script only
      2.  Create Settings: Skip table, recreate view, recreate index only if modified
      3.  Alter Settings: Drop Column, truncate data, add/change/rename/delete, alter by rename
      4.  Script settings: write alter comments, split scripts and change path if desired
    7.  Edit generated SQL script if needed
    8.  Run Script
  8.  Load Messages and Data Project (Skipped, no new script delivered)
    1.  run %PS_HOME%\scripts\msgtlsupg.dms via Data Mover in bootstrapmode
  9.  Multilingual steps (Skipped, not running ML)
    1.  Load Translations: Copy PATCH853ML to Database via App Designer
    2.  Load Messages: Run %PS_HOME%\scripts\msgtl<lang_cd>.dms via Data Mover
  10.  Reinstall needed apps and reconfigure
    1.  Change Assistant
    2.  PIA -> Redeploy
    3.  PeopleSoft Test Framework
    4.  Client tools
    5.  Clear rowset cache; run %PS_HOME%\scripts\clear_rowset_cache.dms
    6.  Purge App/Web cache
    7.  Re-create app domains (you may miss new options if ony only reconfigure)
    8.  restart processes
  11. Take database backup