Few weeks ago a new Peoplesoft OVM HCM9.1 has been released. This one is based on Peopletools 8.51.02, and includes a couples of new features :
1. Option for Cobol installation within 30-days trial
2. Peoletools 8.51.02
3. Server consolidation, 1 database server, 1 App/Batch/PIA server
4. And a good one, a zip for the Peopletools 8.51.02 Windows client
It is available on http://edelivery.oracle.com/linux – check for the templates 64bits, : Peoplesoft VM Templates for HCM 9.1 Release Media Pack v1 for x86 (64 bit).
There are two templates, one for the database, one for the app/batch/PIA.
I’ll skip all the steps regarding Oracle VM Manager, Oracle VM Server configuration, uncompress and import of the template since this is the same exercise I did last year for HCM9.1, please if you want to know more, have a look to the tutorial on the top-right of the main blog page. I’ll start the description below from the starting of the new VM.
1. The database server
Select the VM and click on “Power On” 
Then on console (be fast otherwise it will be configured as DHCP that you certainly don’t want). 
Give all what it needs, IP address and so on : 
Here below, (as usual on Peoplesoft template, I do not know if that’s the same for all Oracle template containing database software), we got the CSS error (this step takes quite a while). Whether it fails that is not an issue for the next steps : 
It continues, give the database name, it will create new controlfiles. 
It is finished for the database server.
Few notes :
1.1 I choose the database to start on server boot, but it won’t (same for all previous templates).
[oracle@psovmhcmdb ~]$ more /etc/oratab
...
orcl:/u01/app/oracle/product/11.1.0/db_1:N
1.2 Note, the service is your_db_name.us.oracle.com :
[oracle@psovmhcmdb ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 23-JAN-2011 06:21:08
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=psovmhcmdb.phoenix.nga)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 23-JAN-2011 06:11:49
Uptime 0 days 0 hr. 9 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.1.0/db_1/log/diag/tnslsnr/psovmhcmdb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=psovmhcmdb.phoenix.nga)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "H91TMPLT.us.oracle.com" has 1 instance(s).
Instance "H91TMPLT", status READY, has 1 handler(s) for this service...
Service "H91TMPLT_XPT.us.oracle.com" has 1 instance(s).
Instance "H91TMPLT", status READY, has 1 handler(s) for this service...
Service "XDB.us.oracle.com" has 1 instance(s).
Instance "H91TMPLT", status READY, has 1 handler(s) for this service...
The command completed successfully
1.3 SYSADM’s password is in upper case :
[oracle@psovmhcmdb ~]$ export ORACLE_SID=H91TMPLT
[oracle@psovmhcmdb ~]$ sqlplus sysadm/sysadm
SQL*Plus: Release 11.1.0.7.0 - Production on Sun Jan 23 06:21:31 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
[oracle@psovmhcmdb ~]$ sqlplus sysadm/SYSADM
SQL*Plus: Release 11.1.0.7.0 - Production on Sun Jan 23 06:21:37 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
SQL>
1.4 Language installed is only English :
SQL> select language_cd from pslanguages where installed=1;
LANGUAGE_CD
------------
ENG
1.5 The default profile of SYSADM and PEOPLE users does not expire anymore like it was for all the previous PSOVM. All the limits are unlimited, much better to avoid bad surprise as I explained here.
SQL> select username,account_status,expiry_date,profile
2 from dba_users
3* where username in ('PEOPLE','SYSADM')
SQL> /
USERNAME ACCOUNT_STATUS EXPIRY_DATE PROFILE
------------------------------ -------------------------------- ------------------ -----------PEOPLE OPEN DEFAULT
SYSADM OPEN DEFAULT
SQL> select * from dba_profiles where profile='DEFAULT';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
------------------------------ -------------------------------- -------------------------------- -------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_GRACE_TIME PASSWORD UNLIMITED
16 rows selected.
2. The App/Batch/PIA server
Select the VM and click on “Power On” 
Give all what it needs, IP address and so on : 
Here, we can see an OS audit message with access denied. Despite that message, everything will be done
successfully. 
After AppServer and Batch server started, it is now time for MicroFocus (optional - 30-days trial license). It is quite new in template for that option during deployment. Thanks to Peoplesoft team for that, that safe a lot of time and pain (see how I did for the first version of PSOVM HCM when it was not available here) 
Once it is done, PIA deployment : 
And you also can configure posting reports repository : 
Done.
It has again been greatly improved compared to the first template released earlier in 2009 (PSOVM HCM). Looks like many of the remarks have been taken in account. Thanks to the team for that.
Now, connect to the front end application : 
Note : you’ll get some OS audit warning like for CRM, you can read the footnote here how you can get rid of them.
3. Peopletools 8.51.02 zip file for Windows client
Last but not least, for the first time ever, Peoplesoft is providing the binaries for Application Designer and DataMover for Windows in version 8.51.02. Under $PS_HOME of App/Batch/PIA server.
[psadm2@psovmhcm tools]$ pwd
/opt/oracle/psft/pt/tools
[psadm2@psovmhcm tools]$ ls
HR dict setup
HR_InstallLog.log etc sqr
PSEMAgent fonts sqrfonts
PSEMViewer jre src
PeopleTools_InstallLog.log jre1.6.0 tmp
SecurityAddIns log toolsadmin.sh
appserv peopletools.properties toolsclient.zip <---
bin psconfig.sh utility
cblbin scripts verity
class sdk web
data secvault webserv
Copy to your Windows client, unzip, enjoy AppDesigner 8.51.02 ! 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.
***
We have now a complete working and consistent Peoplesoft solution relatively easy to install. Moreover, providing a client is very useful for students, developers, functional people who want to learn.
Stay tuned, I’ll probably set the Integration Broker in between.
Enjoy !
Nicolas.
1 comment:
thanks Nicolas...it helped me a lot...i am totally new to this peoplesoft VM concept
Post a Comment