Thursday, April 24, 2008

PeopleSoft HCM9.0 Installation troubleshooting

Peoplesoft installation notes
Order of Installation
1.Oracle Database Software
2.Tuxedo
3.PeopleTools on Linux
4.PeopleTools on Windows
5.Create Oracle Database then PeopleSoft Database
6.Web Server
7.PIA
8.People Books
Database installation
1. Error message when run installer: 
Exception java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-08-19_03-55-00PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory occurred..
java.lang.UnsatisfiedLinkError: /tmp/OraInstall2007-08-19_03-55-00PM/jre/1.4.2/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at sun.security.action.LoadLibraryAction.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.NativeLibLoader.loadLibraries(Unknown Source)
at sun.awt.DebugHelper.(Unknown Source)
at java.awt.Component.(Unknown Source)

Fix:
Download from http://download.fedora.redhat.com/pub/fedora/linux/core/6/i386/os/Fedora/RPMS/
Apply the patch.
[root@apps paches]# rpm -Uvh libXp-1.0.0-8.i386.rpm

Tuxedo installation
Error:
Installing...

awk: error while loading shared libraries: libdl.so.2: cannot open shared object file: No such file or directory
dirname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/bin/ls: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
basename: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
dirname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
basename: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
hostname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
grep: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/tmp/install.dir.3940/Linux/resource/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
Tuxedo 9.1 base installation complete

Fix:
-bash-3.1$ cd linux/sles9/base
-bash-3.1$ cp tuxedo91_32_SLES_9_x86.bin tuxedo91_32_SLES_9_x86.bin.bak
-bash-3.1$ cat tuxedo91_32_SLES_9_x86.bin.bak sed "s/export LD_ASSUME_KERNEL/#xport LD_ASSUME_KERNEL/" >tuxedo91_32_SLES_9_x86.bin
-bash: tuxedo91_32_SLES_9_x86.bin: Permission denied
-bash-3.1$ cat tuxedo91_32_SLES_9_x86.bin.bak sed "s/export LD_ASSUME_KERNEL/#xport LD_ASSUME_KERNEL/" >tuxedo91_32_SLES_9_x86.bin

Linux patches: http://rpmfind.net/linux/rpm2html/search.php?query=unixODBC-devel&submit=Search+...&system=&arch=

-bash-3.1$ sh install.sh

01) ibm/aix53 02) linux/sles9 03) setup/5045158435a38b48dea252fdca98f9b3
04) setup/9f00655a86fb2b6696a2082837e1820805) sun/sol9

Please select a platform? [1-5, q to quit, l for list]: 2

Installing for linux/sles9

Is this correct? [y,n,q]: y
cp: cannot create regular file `/tmp/lic.txt': Permission denied

If you wish to quit the installation at any point
press the interrupt key or .
BEA Home being defaulted to /bea (y/n)
n
Please supply alternative BEA Home:
/psft/bea
Tuxedo 9.1 will be installed to /psft/bea/tuxedo91 (y/n):
y
Accept default TListen password 'password' (y/n):
y
Continue with installation of Tuxedo 9.1 (y/n):
y
Installing...

awk: cmd. line:6: warning: escape sequence `\.' treated as plain `.'
Tuxedo 9.1 base installation complete
Installing patch at /psft/bea/tuxedo91
using /bin/gunzip to uncompress archive
Installing server and client files...
Enter owner for patch files:
psofthr
Enter group for patch files:
psoft

The patch installation finished successfully.
-bash-3.1$

People tools installation
Error:
Fix: use command unzip –t zipfilename to check which file is broken during download. Download the broken files and reinstall.
Web Logic installation.

Stuck on
Installing PeopleSoft license for WebLogic Server 9.2 (Step 1 of 2)
Please wait and do not interrupt ....

Done!

Updating license registry. (Step 2 of 2)

Fix: haven’t found out the fix yet. But instead, use Oracle Application Server.
HRMS installation

When launching the installation, get the following error:
Running InstallShield Wizard...
The installer is unable to run in graphical mode. Try running the installer with the -console or -silent flag.

Fix: Just run it in nongraph mode.

Installing Peopletools on Windows

Errors occurred during the installation.

One or more errors occurred during the copying of files (eel_complat_comp_files) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (bean459) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (complat_emf_files) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (nt_emf_files) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (bean260) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (langpack_appbatch_files) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (langpack_batchfile_files) . Please refer to the install log for additional information.
One or more errors occurred during the copying of files (bean542) . Please refer to the install log for additional information.

Fix: Check downloaded files and redownload corrupted files.

Install HRMS
Errors occurred during the installation.

One or more errors occurred during the copying of files
(bean_hcsys_ComPlat_DBFile_bse) . Please refer to the install log
for additional information.
One or more errors occurred during the copying of files
(bean_hcdmo_ComPlat_DBFile_bse) . Please refer to the install log
for additional information.

Fix: Check the downloaded file and the extracted file. Some file are broken.

Creating the database:

Hanging

Fix:

1. Kill the process.
2. Delete all tables of SYSADM.
3. Delete the record of ps.psdbowner
4. Start over again.

Upgrading PeopleSoft Database
While connect to the database using data mover and user PS/PS,
Fix:
grant connect to ps;
revoke connect from ps;

Starting Application Server
While starting app server, get
9 processes started.
Checking process startup status. Please wait.

Some processes failed to complete initialization. tmshutdown -qy



==============ERROR!================
Boot attempt encountered errors!. Check the TUXEDO log for details.
==============ERROR!================

Do you wish to see the error messages in the APPSRV.LOG file? (y/n) [n] :

Fix:
Check app server log and it says
PSADMIN.20354 (0) [10/25/07 09:06:44](0) Begin boot attempt on domain psdmo
PSWATCHSRV.20364 (0) [10/25/07 09:06:53] Checking process status every 120 seconds
PSWATCHSRV.20364 (0) [10/25/07 09:06:53] Server started
PSSAMSRV.20368 (0) [10/25/07 09:06:59](0) PeopleTools Release 8.49 (Linux) starting
PSSAMSRV.20368 (0) [10/25/07 09:06:59](0) Cache Directory being used: /psft/PT8.49/appserv/psdmo/CACHE/PSSAMSRV_100/
PSSAMSRV.20368 (0) [10/25/07 09:06:59](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
PSSAMSRV.20368 (0) [10/25/07 09:06:59](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PSDMO with user PS.
PSSAMSRV.20368 (0) [10/25/07 09:06:59](0) Server failed to start
PSAPPSRV.20366 (0) [10/25/07 09:07:01](0) PeopleTools Release 8.49 (Linux) starting
PSAPPSRV.20366 (0) [10/25/07 09:07:01](0) Cache Directory being used: /psft/PT8.49/appserv/psdmo/CACHE/PSAPPSRV_2/
PSAPPSRV.20366 (0) [10/25/07 09:07:01](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
PSAPPSRV.20366 (0) [10/25/07 09:07:01](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PSDMO with user PS.
PSAPPSRV.20366 (0) [10/25/07 09:07:01](0) Server failed to start
PSAPPSRV.20365 (0) [10/25/07 09:07:01](0) PeopleTools Release 8.49 (Linux) starting
PSAPPSRV.20367 (0) [10/25/07 09:07:01](0) PeopleTools Release 8.49 (Linux) starting
PSAPPSRV.20367 (0) [10/25/07 09:07:01](0) Cache Directory being used: /psft/PT8.49/appserv/psdmo/CACHE/PSAPPSRV_3/
PSAPPSRV.20367 (0) [10/25/07 09:07:01](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
PSAPPSRV.20367 (0) [10/25/07 09:07:01](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PSDMO with user PS.
PSAPPSRV.20367 (0) [10/25/07 09:07:01](0) Server failed to start
PSAPPSRV.20365 (0) [10/25/07 09:07:01](0) Cache Directory being used: /psft/PT8.49/appserv/psdmo/CACHE/PSAPPSRV_1/
PSAPPSRV.20365 (0) [10/25/07 09:07:01](1) GenMessageBox(200, 0, M): PS General SQL Routines: Missing or invalid version of SQL library libpsora (200,0)
PSAPPSRV.20365 (0) [10/25/07 09:07:01](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database PSDMO with user PS.
PSAPPSRV.20365 (0) [10/25/07 09:07:01](0) Server failed to start
PSWATCHSRV.20364 (0) [10/25/07 09:07:02] Shutting down
PSADMIN.20354 (0) [10/25/07 09:07:08](0) End boot attempt on domain psdmo

Check stderr under /psft/PT8.49/appserv/psdmo and it shows
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory
dlopen in libpscompat failed for 'libpsora.so': libclntsh.so.9.0: cannot open shared object file: No such file or directory

Login as user oracle and go to $PS_HOME/bin. Make a soft link as
-bash-3.1$ ln -s /u01/app/oracle/product/10.2.0/db/lib/libclntsh.so.10.1 libclntsh.so.9.0

Another issue:

Tuxedo log says:
013438.lserv!PSANALYTICSRV.26625.3086825152.0: LIBTUX_CAT:681: ERROR: Failure to create message queue
013438.lserv!PSANALYTICSRV.26625.3086825152.0: LIBTUX_CAT:248: ERROR: System init function failed, Uunixerr = : msgget: No space left on device
013535.lserv!tmboot.26647.3086337728.-2: 10-28-2007: Tuxedo Version 9.1, 32-bit
013535.lserv!tmboot.26647.3086337728.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 60 seconds
013535.lserv!tmboot.26647.3086337728.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected
013536.lserv!PSRENSRV.26648.3086419648.-2: 10-28-2007: Tuxedo Version 9.1, 32-bit
013536.lserv!PSRENSRV.26648.3086419648.-2: LIBTUX_CAT:681: ERROR: Failure to create message queue
013536.lserv!PSRENSRV.26648.3086419648.-2: LIBTUX_CAT:248: ERROR: System init function failed, Uunixerr = : msgget: No space left on device
013536.lserv!tmboot.26647.3086337728.-2: CMDTUX_CAT:825: ERROR: Process PSRENSRV at lserv failed with /T tperrno (TPEOS - operating system error)
013536.lserv!tmboot.26647.3086337728.-2: tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler
013536.lserv!tmshutdown.26649.3086218944.-2: 10-28-2007: Tuxedo Version 9.1, 32-bit
013536.lserv!tmshutdown.26649.3086218944.-2: LIBTUX_CAT:681: ERROR: Failure to create message queue
013536.lserv!tmshutdown.26649.3086218944.-2: FATAL: internal error: CMDTUX_CAT:764: ERROR: can't attach to BB
013536.lserv!tmboot.26647.3086337728.-2: FATAL: CMDTUX_CAT:828: ERROR: Cannot create error process - fork() failed

Fix:

Edit /etc/sysctl.conf and add the parameter
kernel.msgmin = 50
run command sysctl –p .

Installing Oracle Application Server
07/10/28 11:51:12 Start process
--------
/psft/product/10.1.3.1/OracleAS_1/Apache/Apache/bin/apachectl startssl: execing httpd
/psft/product/10.1.3.1/OracleAS_1/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

Fix: Download and apply the patch db1-1.85-0.3.i386.rpm
http://www.megaloman.com/~hany/RPM/doors2.4/jr/db1-1.85-0.3.i386.html

No comments: