ITPub博客

首页 > 数据库 > Oracle > peoplesoft不能登录DB解决方法

peoplesoft不能登录DB解决方法

原创 Oracle 作者:yhj20041128001 时间:2013-12-24 14:56:16 1 删除 编辑

1 HRMS APP连接DB报错
Booting server processes ...

exec PSWATCHSRV -A -- -ID 73380 -C psappsrv.cfg -D HRMSUATO -S PSWATCHSRV :
        process id=9665 ... Started.
exec PSAPPSRV -s@../psappsrv.lst -- -C psappsrv.cfg -D HRMSUATO -S PSAPPSRV :
        CMDTUX_CAT:1685: ERROR: Application initialization failure

tmboot: CMDTUX_CAT:827: ERROR: Fatal error encountered; initiating user error handler

exec 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] :y

PSADMIN.9392 (0) [12/23/13 19:03:53](0) Begin boot attempt on domain HRMSUATO
PSWATCHSRV.9665 (0) [12/23/13 19:04:01] Checking process status every 120 seconds
PSWATCHSRV.9665 (0) [12/23/13 19:04:01] Server started
PSAPPSRV.9666 (0) [12/23/13 19:04:02](0) PeopleTools Release 8.49.25 (Linux) starting
PSAPPSRV.9666 (0) [12/23/13 19:04:02](0) Cache Directory being used: /app/hrmsuat/PT8.49/appserv/HRMSUATO/CACHE/PSAPPSRV_1/
PSAPPSRV.9666 (0) [12/23/13 19:04:02](3) File: /vob/peopletools/src/pssys/stmget.cppSQL error. Stmt #: 2441  Error Position: 70  Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
PSAPPSRV.9666 (0) [12/23/13 19:04:02](1) GenMessageBox(200, 0, M): /vob/peopletools/src/pssys/stmget.cpp: File: /vob/peopletools/src/pssys/stmget.cppSQL error. Stmt #: 2441  Error Position: 70  Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt:SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
PSAPPSRV.9666 (0) [12/23/13 19:04:02](1) GenMessageBox(0, 0, M): Database Signon: Could not sign on to database HRMSUATO with user PS.
PSAPPSRV.9666 (0) [12/23/13 19:04:02](0) Server failed to start
PSWATCHSRV.9665 (0) [12/23/13 19:04:03] Shutting down
PSADMIN.9392 (0) [12/23/13 19:04:10](0) End boot attempt on domain HRMSUATO


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

查看报错信息,权限问题。执行$PS_HOME/scripts/grant.sql,换成我的环境是

grant select on SYSADM.PSSTATUS to people;

grant select on SYSADM.PSOPRDEFN to people;

grant select on SYSADM.PSACCESSPRFL to people;

然后重启HRMS APP,发现可以正常登录。

2.登录HRMS页面之后,发现还有一个报错:
CHECK APPSERVER LOGS. THE SITE BOOTED WITH INTERNAL DEFAULT SETTINGS, BECAUSE OF: bea.jolt.ApplicationException: TPESVCFAIL - application level service failure
这是又是权限问题,立即修改PTWEBSERVER的密码,同时加密,把加密后的密码拷贝到配置文件
portal\web-inf\psftdocs\ps\configuration.properties
可参考链接:http://peoplesoft.wikidot.com/site-booted-with-internal-default-settings

具体的排查过程:
select * from  PSACCESSPRFL
HRMSUATO 445 kDzrUalvrag= kDzrUalvrag= 1

SELECT VERSION, OPERPSWD, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM PSOPRDEFN WHERE OPRID = 'PS';
11333 LdO1TaeKR0xmFeXpJseMSNYGuoA= 1 HRMSUATO 0

查看ps.psdbowner表看scheme
select * from ps.psdbowner
HRMSUATO SYSADM

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23757700/viewspace-1064142/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-09-17

  • 博文量
    163
  • 访问量
    356735