Oracle 11gR1 PS/PS login error...

From: Waldemar Vega <wvega_at_grandecom.net>
Date: Tue, 20 Oct 2009 00:09:09 -0500
Message-ID: <X7-dnS393ZRr2EDXnZ2dnUVZ_qWdnZ2d_at_posted.grandecom>

Hi everyone.

I am working on setting up an environment under Oracle Enterprise Linux 5.4 (64 bit) running Oracle 11gR1 (11.0.6), Peopletools 8.50 (64 bit), Tuxedo 10gR3, Weblogic, Peoplesoft HRMS 9.1 (64 bit). Both Peopletools 8.50 and Peoplesoft HRMS 9.1 are relatively new. We are probably one of the first to set this up and we have an issue.

All of the software has been installed and configured. All database sql, datamover, and other scripts have been executed. Also, the database is fully populated.

We encounter an error when going into psadmin and trying to boot the domain HC:

CMDTUX_CAT:1685: ERROR: Application initialization failure CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler

We also receive the following errors:

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

PSADMIN.3612 (0) [10/19/09 15:48:31](0) Begin boot attempt on domain HC

PSAPPSRV.3643 (0) [10/19/09 15:48:42](0) PeopleTools Release 8.50 (Linux) 
starting. Tuxedo server is APPSRV(99)/1
PSAPPSRV.3643 (0) [10/19/09 15:48:42](0) Cache Directory being used: 

/home/oracle/psft/pt/8.50/appserv/HC/CACHE/PSAPPSRV_1/ PSAPPSRV.3643 (0) [10/19/09 15:48:43](3) File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 - ORA-01017: invalid username/password; logon denied
PSAPPSRV.3643 (0) [10/19/09 15:48:43](1) GenMessageBox(200, 0, M): SQL Access Manager: File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 - ORA-01017: invalid username/password; logon denied
PSAPPSRV.3643 (0) [10/19/09 15:48:43](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database HC with user PS. PSAPPSRV.3643 (0) [10/19/09 15:48:43](0) Server failed to start PSADMIN.3612 (0) [10/19/09 15:48:49](0) End boot attempt on domain HC

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

155108.sa2tech47.domain.com!PSADMIN.3722: Begin attempt on domain HC 155112.sa2tech47.domain.com!tmadmin.3743.3663685232.-2: TMADMIN_CAT:1330: INFO: Command: boot -A
155114.sa2tech47.domain.com!tmboot.3744.925238816.-2: 10-19-2009: Tuxedo Version 10.3.0.0, 64-bit
155114.sa2tech47.domain.com!tmboot.3744.925238816.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds
155114.sa2tech47.domain.com!tmboot.3744.925238816.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected
155116.sa2tech47.domain.com!BBL.3745.1611062368.0: 10-19-2009: Tuxedo Version 10.3.0.0, 64-bit, Patch Level (none) 155116.sa2tech47.domain.com!BBL.3745.1611062368.0: LIBTUX_CAT:262: INFO: Standard main starting
155118.sa2tech47.domain.com!tmboot.3748.2436493632.-2: 10-19-2009: Tuxedo Version 10.3.0.0, 64-bit
155118.sa2tech47.domain.com!tmboot.3748.2436493632.-2: CMDTUX_CAT:1851: INFO: TM_BOOTTIMEOUT is set to 120 seconds 155118.sa2tech47.domain.com!tmboot.3748.2436493632.-2: CMDTUX_CAT:1855: INFO: TM_BOOTPRESUMEDFAIL option is selected 155118.sa2tech47.domain.com!PSWATCHSRV.3750.3590176352.-2: 10-19-2009: Tuxedo Version 10.3.0.0, 64-bit
155118.sa2tech47.domain.com!PSWATCHSRV.3750.3590176352.-2: LIBTUX_CAT:262: INFO: Standard main starting
155118.sa2tech47.domain.com!PSAPPSRV.3751.286221264.0: 10-19-2009: Tuxedo Version 10.3.0.0, 64-bit
155118.sa2tech47.domain.com!PSAPPSRV.3751.286221264.0: LIBTUX_CAT:262: INFO: Standard main starting
155119.sa2tech47.domain.com!PSAPPSRV.3751.286221264.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed
155119.sa2tech47.domain.com!tmboot.3748.2436493632.-2: tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler
155123.sa2tech47.domain.com!BBL.3745.1611062368.0: CMDTUX_CAT:26: INFO: The BBL is exiting system
155126.sa2tech47.domain.com!PSADMIN.3722: End boot attempt on domain HC

Issue is that when trying to connect and fire up the app server it fails on authentication with PS/PS. I have not changed any of the passwords. I also have searched and even run a fix located at:

http://tech.groups.yahoo.com/group/psftdba/message/577

I have also gone back and checked that:

1. The environment for weblogic is exported.
2. The weblogic daemon wlserver is running.
3. The environment for tuxedo is exported.
4. The tlisten daemon is running.
5. The tlisten listener is configured in /etc/services for port 3050.
6. Tested the sysadm, people accounts to ensure that I can log into the Oracle database. No passwords have been changed. Also checked that all of the tables exist and that they are populated with data.
7. Terminated the daemons and removed the ones that were hung using system resources using ipcrm.
8. Checked the UDDCONFIG file that was created by Peoplesoft to ensure that it was being read.
9. Went back and rechecked the installation and post-installation documentation for Tuxedo 10gR3, Weblogic, Peoplesoft PT 8.50, and Peoplesoft HRMS 9.1.
10. Went back and checked that all binaries and libraries were installed. (I did this prior to the install, but went back and checked again.)
11. Searched the error log files and looked up the codes presented. Checking on possible solutions (this is where I am now).

Anything that anyone can add would be most appreciated. I have log files from the server (of which I am still going through) that I can make available to anyone that is willing to help..

I will share any other findings as they become available and as I make progress.

Thanks in advance!
Walt
wvega_at_msn.com Received on Tue Oct 20 2009 - 00:09:09 CDT