Errors :Database Signon: Could not sign on to database HCMDEV with user PSAPPS.
Return: 8097 - Oracle initialization error
PSAPPSRV Fails to Boot - Return: 8097 - Oracle initialization error
Solution:
Case #1- Same error message. Tnsping was able to connect to the DB OK.
The application server user on the Unix box needs read accesss to all files under $ORACLE_HOME.Please make sure that.
Case #2 - if Appserver is on 32bit Windows & Oracle client installed is 11.2.
This Oracle client version was never certified for 32bit Windows OS.
Installing Oracle client 11.1 or lower resolves the problem.
Oracle Client 11.2 is certified for Windows 64bit OS only.
Return: 8097 - Oracle initialization error
PSAPPSRV Fails to Boot - Return: 8097 - Oracle initialization error
Solution:
Case #1- Same error message. Tnsping was able to connect to the DB OK.
The application server user on the Unix box needs read accesss to all files under $ORACLE_HOME.Please make sure that.
Case #2 - if Appserver is on 32bit Windows & Oracle client installed is 11.2.
This Oracle client version was never certified for 32bit Windows OS.
Installing Oracle client 11.1 or lower resolves the problem.
Oracle Client 11.2 is certified for Windows 64bit OS only.
Hi Sravan,
ReplyDeleteI am trying to install Peoplesoft HCM 9.2 along with Peopletools 8.53 on Linux on my Laptop and I am having the following issue too.
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.
Any advise is highly appreciated.
Best Regards,
Manmohan
mbatra@appstek.ca
Hi All,
ReplyDeleteI have 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.