Monday 9 July 2007

How to check if username sysadmin has been locked in Oracle Apps 11i

select end_date from fnd_user where user_name = 'SYSADMIN';

If it comes back with a date then the account is locked out and you need to run the following update statement to unlock it.

update fnd_user set end_date = '' where user_name = 'SYSADMIN';
commit;

No comments:

Profile - Oracle 11i AppsDBA
Over 7 years of experience as an Oracle Applications DBA managing Oracle Public Sector HRMS 11.5.10 and Oracle Financials 11i in Unix and Windows NT environments. Strong skills and experience with installing, patching, cloning and troubleshooting various Oracle E-Business Suite products in Oracle database 9i and 10g. Proactive in the different phases of architecture design, development, testing, maintenance, performance enhancement and postproduction support. Currently working as Oracle Application DBA at Warwickshire County Council.

------------------------------------------------------------------------------------------------------------------------------