Unable to start application server in Peoplesoft.
===================================================================

While trying to install Peoplesoft HCM 9.2 along with Peopletools 8.53 on Linux on my Laptop and I faced the following issue.

PSAPPSRV.19596 (0) [2014-05-08T14:39:35.926](0) Cache Directory being used: /apps/oratest/pt853/appserv/PSDEMO/CACHE/PSAPPSRV_1/
PSAPPSRV.19596 (0) [2014-05-08T14:39:36.089](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database ORCL with user PS.
PSAPPSRV.19596 (0) [2014-05-08T14:39:36.089](0) Server failed to start
PSADMIN.19508 (0) [2014-05-08T14:39:43.787](0) End boot attempt on domain PSDEMO
PSADMIN.19651 (0) [2014-05-08T14:49:24.790](0) Begin boot attempt on domain PSDEMO
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.082](0) PeopleTools Release 8.53 (Linux) starting. Tuxedo server is APPSRV(99)/1
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.095](0) Cache Directory being used: /apps/oratest/pt853/appserv/PSDEMO/CACHE/PSAPPSRV_1/
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.252](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database ORCL with user PS.
PSAPPSRV.19682 (0) [2014-05-08T14:49:35.252](0) Server failed to start
PSADMIN.19651 (0) [2014-05-08T14:49:42.952](0) End boot attempt on domain PSDEMO

I have reset the password for PS user but still its complaining about logging in.

The following is my configuration.

Quick-configure menu -- domain: PSDEMO
----------------------------------------------
Features Settings
========== ==========
1) Pub/Sub Servers : No 16) DBNAME :[orcl]
2) Quick Server : No 17) DBTYPE :[ORACLE]
3) Query Servers : No 18) UserId :[PS]
4) Jolt : Yes 19) UserPswd :[PASSWORD]
5) Jolt Relay : No 20) DomainID :[TESTSERV]
6) WSL : No 21) AddToPATH :[/apps/oratest/product/11.2.0/dbhome_1/bin]
7) PC Debugger : No 22) ConnectID :[people]
8) Event Notification: No 23) ConnectPswd:[peop1e]
9) MCF Servers : No 24) ServerName :[starworld.appstek.ca]
10) Perf Collator : No 25) DomainConnectPswd:[]
11) Analytic Servers : No 26) WSL Port :[7000]
12) Domains Gateway : No 27) JSL Port :[9000]
28) JRAD Port :[9100]

Actions
=========

I am able to connect to the database as ps/people/sysadm user but cant seem to move forward from here.

Solution:
======================


I resolved this issue. It seems the PS user account was locked.
The solution is as follows.
SQL> select ACCTLOCK from psoprdefn where oprid='PS';

ACCTLOCK
----------
1
SQL> update psoprdefn set ACCTLOCK=0 where oprid='PS';

1 row updated.

SQL> commit;

Commit complete.

SQL> select ACCTLOCK from psoprdefn where oprid='PS';

ACCTLOCK
----------
0

Thanks to the solution posted by Rajeev Paramathmuni on it.toolbox.com.