Reset 11g password

alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED;

SET LINESIZE 300

SET PAGESIZE 999

SELECT 'ALTER USER '|| name ||' IDENTIFIED BY VALUES '''|| spare4 ||';'|| password ||''';' FROM sys.user$ WHERE name='DBSNMP';