From: Waldemar Vega on
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(a)msn.com


From: gazzag on
On 20 Oct, 06:09, "Waldemar Vega" <wv...(a)grandecom.net> wrote:
> 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
> wv...(a)msn.com

Wrong forum for PeopleSoft questions, however your error log contains
the following line:

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

Off the top of my head, Oracle 11g passwords are case-sensitive,
unlike in previous releases. Have you reconfigured the app server via
PSADMIN? Your password might be "correct" but the case might be
wrong.

HTH

-g