Database Signon: Could not sign on to database HRMSPD with user PSAPPS orInvalid User ID or Password for SignOn; logon denied. Or Invalid Access ID or Password for Signon - see your security administrator.
Steps to check :
a) Check Connect ID and Connect Password Values are correct one.(default : people/peop1e)
Chech whether connect id was locked or not. We should be able to login with connectid/connectpass to database.
Connect ID login has SELECT privilege on SOPRDEFN,PSACCESSPRFL,PSSTATUS.
b) Make sure OPRID/password that is used to boot app server is correct. Make sure OPRID is not locked in PSOPRDEFN table.
Query: Select ACCTLOCK from PSOPRDEFN
The SymbolicID field in PSOPRDEFN & PSACCESSPRFL is same.
c) Make sure AccessID/Access password in PSACCESSPRFL are correct and the values are encrypted.
Make sure You are able to login to Database with Accessid/pass
Pls make sure sysadm(accessid for oracle) is not locked out or it's passwd is not expired
d) Analyse appsrv/tuxlog files.
Steps to check :
a) Check Connect ID and Connect Password Values are correct one.(default : people/peop1e)
Chech whether connect id was locked or not. We should be able to login with connectid/connectpass to database.
Connect ID login has SELECT privilege on SOPRDEFN,PSACCESSPRFL,PSSTATUS.
b) Make sure OPRID/password that is used to boot app server is correct. Make sure OPRID is not locked in PSOPRDEFN table.
Query: Select ACCTLOCK from PSOPRDEFN
The SymbolicID field in PSOPRDEFN & PSACCESSPRFL is same.
c) Make sure AccessID/Access password in PSACCESSPRFL are correct and the values are encrypted.
Make sure You are able to login to Database with Accessid/pass
Pls make sure sysadm(accessid for oracle) is not locked out or it's passwd is not expired
d) Analyse appsrv/tuxlog files.
No comments:
Post a Comment