Feeds:
Posts
Comments

Archive for May, 2012

Well, you might get an expired login message if the user login is set to expire after a specific period of days. This could be fixed like this (I did a .bat-file for fixing this).

The .bat file’s content was a login command as well as invoking an sql file (sqlplus is run with the sys user which is not expired):

sqlplus sys/#passord# AS SYSDBA @”C:\temp\sqlfile.sql”

The sqlfile.sql’s content (this alter the password expire on user #username# to unlimited):

ALTER USER #username# IDENTIFIED BY #password#;
CREATE PROFILE my_profile LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER USER #username# PROFILE my_profile;

Read Full Post »