Posts

Showing posts from 2017
Image
Oracle User's Password When It Has Expired , Also Make Profile Default and avoid future expire of passwords. 1. Export your database and login to the SQL Plus interface: export ORACLE_SID=YourDB sqlplus /nolog connect sys as sysdba 2. Modify the default user profile to set the password policies to ' UNLIMITED ': ALTER PROFILE DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED PASSWORD_VERIFY_FUNCTION NULL PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED; 3. Check the password expiration and status of the user account associated with the Mobility Suite's ' /usr/local/nukona/etc/settings.cfg ' file: SELECT EXPIRY_DATE from dba_users where username = 'YourUser' ; SELECT RESOURCE_NAME,LIMIT FROM DBA_PROFILES WHERE PROFILE= 'DEFAULT' AND RESOURCE_NAME IN ( 'FAILED_LOGIN_ATTEMPTS' ...