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
- wls1036_generic.jar
- jdk-7u17-linux-x64.tar.gz or jdk-7u9-linux-x64.rpm (actually anything jdk7u2 +)
- License key for PeopleTools Oracle Install:
- 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
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:
- tuxedo111130_64_Linux_01_x86.bin
- COBOL Compiler ?
- License key for Oracle Install:
- HCM license key for Oracle:
- 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
$ /opt/media/media/8.53/ptools.tuxedo/tuxedo111130_64_Linux_01_x86.bin -i console
FULL INSTALL
Use existing ORACLE_HOME=/opt/apps
Use default TUXDIR=/opt/apps/tuxedo11gR1
Install Samples = Y
tlisten password = ********
$ cd /opt/apps/psoft
$ /opt/media/media/8.53/ptools/Disk1/setup.sh
On Change Assistant VM
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;
0
Update HCM92 database to 8.53.02
- Backup pristine database
- Shutdown immediate
- startup mount
- rman target /
- configure controlfile autobackup on;
- configure device type disk parallelism 2 backup type to compressed backupset;
- backup database;
- SQL> alter database open;
- Download and extract patch
- Shutdown all processes for ENV to patch
- Backup existing Tools directories
- Install patch files
- Update database patch version (PS_MAINTENANCE_LOG entry)
- run %PS_HOME%\scripts\ptpatch.dms
- Apply patch project
- Launch patched App Designer
- Tools -> Copy Project -> From File
- %PS_HOME%\projects select PATCH853
- select Common and English language only
- Copy the project
- Build project
- Build Options: create tables/view, alter tables, create script only
- Create Settings: Skip table, recreate view, recreate index only if modified
- Alter Settings: Drop Column, truncate data, add/change/rename/delete, alter by rename
- Script settings: write alter comments, split scripts and change path if desired
- Edit generated SQL script if needed
- Run Script
- Load Messages and Data Project (Skipped, no new script delivered)
- run %PS_HOME%\scripts\msgtlsupg.dms via Data Mover in bootstrapmode
- Multilingual steps (Skipped, not running ML)
- Load Translations: Copy PATCH853ML to Database via App Designer
- Load Messages: Run %PS_HOME%\scripts\msgtl<lang_cd>.dms via Data Mover
- Reinstall needed apps and reconfigure
- Change Assistant
- PIA -> Redeploy
- PeopleSoft Test Framework
- Client tools
- Clear rowset cache; run %PS_HOME%\scripts\clear_rowset_cache.dms
- Purge App/Web cache
- Re-create app domains (you may miss new options if ony only reconfigure)
- restart processes
- Take database backup
Leave a Reply