Friday, 8 November 2013

Invalid Access ID or Password for Signon - see your security administrator.

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.

No comments:

Post a Comment