Monday, May 02, 2011

Peoplesoft OVM FSCM9.1 Feature Pack 1 Peopletools 8.51.07

As promised, Peoplesoft team keeps the Peoplesoft OVM templates up-to-date. After The latest HCM 9.1 template based on Feature Pack 1 and Peopletools 8.51.02 (Dec-2010), last week has been released the second OVM template for FSCM (first was delivered earlier in Sept-2010).
This one is based on FSCM 9.1 Feature Pack 1 (up to Bundle #9/maintenance Pack #5) and Peopletools 8.51.07. Latest application version and Peopletools pach (well, the patch 08 has been released since then).

1. The database server
After importing the template, start the VM.
Do not use DHCP, but rather a static IP address :
PSOVM_FSCMFP1_001
Whatever you entered to start automatically the database, it won’t work (as documented in the readme file) :
PSOVM_FSCMFP1_002
As usual now in the PSOVM, CSS fails to start but it won’t harm anything later on :
PSOVM_FSCMFP1_003
For testing purpose, following up a previous post on an older PSOVM, I used a lower case database name.
PSOVM_FSCMFP1_004
If given a lower case database, you must update the table PS.PSDBOWNER, the deployment script are not doing it properly to make it upper :
PSOVM_FSCMFP1_006
And eventually, you’ll have your running database and listener (domain is .us.oracle.com) :
PSOVM_FSCMFP1_007      
Note :
1. SYSADM’s password upper case :
[oracle@psovmfscmfp1db ~]$ sqlplus sysadm/sysadm

SQL*Plus: Release 11.1.0.7.0 - Production on Mon May 2 06:32:43 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
[oracle@psovmfscmfp1db ~]$ sqlplus sysadm/SYSADM

SQL*Plus: Release 11.1.0.7.0 - Production on Mon May 2 06:32:50 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2. Installed language is English only :
SQL> select language_cd from pslanguages where installed=1;

LANGUAGE_CD
------------
ENG

3. Unlike the first PSOVMs released, there’s no issue with the profile :
SQL> conn / as sysdba
Connected.
SQL> select username,account_status,expiry_date,profile
from   dba_users
where username in ('PEOPLE','SYSADM') ;
  2    3
USERNAME                       ACCOUNT_STATUS                   EXPIRY_DATE        PROFILE
------------------------------ -------------------------------- ------------------ ------------------------------
PEOPLE                         OPEN                                                DEFAULT
SYSADM                         OPEN                                                DEFAULT

SQL> l
  1* select * from dba_profiles where profile='DEFAULT'
SQL> /

PROFILE                        RESOURCE_NAME                    RESOURCE_TYPE                    LIMIT
------------------------------ -------------------------------- -------------------------------- ----------------------------
-
DEFAULT                        PASSWORD_GRACE_TIME              PASSWORD                         UNLIMITED
DEFAULT                        PASSWORD_LOCK_TIME               PASSWORD                         UNLIMITED
DEFAULT                        PASSWORD_VERIFY_FUNCTION         PASSWORD                         NULL
DEFAULT                        PASSWORD_REUSE_MAX               PASSWORD                         UNLIMITED
DEFAULT                        PASSWORD_REUSE_TIME              PASSWORD                         UNLIMITED
DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD                         UNLIMITED
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD                         UNLIMITED
DEFAULT                        PRIVATE_SGA                      KERNEL                           UNLIMITED
DEFAULT                        CONNECT_TIME                     KERNEL                           UNLIMITED
DEFAULT                        IDLE_TIME                        KERNEL                           UNLIMITED
DEFAULT                        LOGICAL_READS_PER_CALL           KERNEL                           UNLIMITED
DEFAULT                        LOGICAL_READS_PER_SESSION        KERNEL                           UNLIMITED
DEFAULT                        CPU_PER_CALL                     KERNEL                           UNLIMITED
DEFAULT                        CPU_PER_SESSION                  KERNEL                           UNLIMITED
DEFAULT                        SESSIONS_PER_USER                KERNEL                           UNLIMITED
DEFAULT                        COMPOSITE_LIMIT                  KERNEL                           UNLIMITED

16 rows selected.

2. The App/Batch/PIA server
After importing the template, start the VM.
Do not use DHCP, but rather a static IP address : 
PSOVM_FSCMFP1_011 PSOVM_FSCMFP1_012 PSOVM_FSCMFP1_009 PSOVM_FSCMFP1_014  PSOVM_FSCMFP1_016 PSOVM_FSCMFP1_017 PSOVM_FSCMFP1_018 PSOVM_FSCMFP1_019 PSOVM_FSCMFP1_020
Once again, that works great.
PSOVM_FSCMFP1_021 PSOVM_FSCMFP1_022  PSOVM_FSCMFP1_024 PSOVM_FSCMFP1_025   PSOVM_FSCMFP1_028

3. Peopletools 8.51.07 zipped file for Windows client
[root@psovmfscmfp1 ~]# su - psadm2
cd [psadm2@psovmfscmfp1 ~]$ cd $PS_HOME
[psadm2@psovmfscmfp1 tools]$ ls
FSCM                        cblbin    log                     src
FSCM_InstallLog.log         class     peopletools.properties  tmp
PSEMAgent                   data      psconfig.sh             toolsadmin.sh
PSEMViewer                  dict      scripts                
toolsclient.zip <--
PeopleTools_InstallLog.log  etc       sdk                     utility
SecurityAddIns              fonts     secvault                verity
appserv                     jre       setup                   web
bin                         jre1.6.0  sqr                     webserv
[psadm2@psovmfscmfp1 tools]$ ls -lrt toolsclient.zip
-rwxr-xr-x 1 psadm1 oracle 61191937 Mar 23 21:57 toolsclient.zip
[psadm2@psovmfscmfp1 tools]$

Copy the file and unzip it onto your local desktop. In 2-tier, you’ll need an Oracle client, in 3-tier, no need Oracle client, but you’ll have to configure a WSL listener on the AppServer domain.
*******************************************************************************************************************************************************
NOTES :
1. The SELINUX errors/warnings I have reported a while ago here have been fixed.
2. The missing SETSPACE sqr I reported here has also been fixed.
3. The scripts under $PS_HOME/scripts I was requesting here have been added.
Nice to see they are listening and trying to keep these templates alive as much as possible.

PS: if for some reasons you need to mount a nfs point, that will work fine from the PSOVM database server but not from App/Batch/PIA server. You’ll need to install a couple of additional RPMs, please read more in the Peoplesoft OVM forum’s thread I created here.

Enjoy it,

Nicolas.