June 10, 2015

ORA-28001: the password has expired

SYS>> select dbms_metadata.get_ddl('USER','DBSNMP') from dual;

DBMS_METADATA.GET_DDL('USER','DBSNMP')
--------------------------------------------------------------------------------
   CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C
558313D07013DE468963223CF2EC;E066D214D5421CCC'
      DEFAULT TABLESPACE "SYSAUX"
      TEMPORARY TABLESPACE "TEMP"
      PASSWORD EXPIRE

SYS>>alter user DBSNMP identified by values 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C558313D07013DE468963223CF2EC;E066D214D5421CCC';

User altered.

SYS>>select dbms_metadata.get_ddl('USER','DBSNMP') from dual;

DBMS_METADATA.GET_DDL('USER','DBSNMP')
--------------------------------------------------------------------------------
   CREATE USER "DBSNMP" IDENTIFIED BY VALUES 'S:DDFDBFCD2DE1B4C1BEF25EA7E30A2F7C
558313D07013DE468963223CF2EC;E066D214D5421CCC'
      DEFAULT TABLESPACE "SYSAUX"
      TEMPORARY TABLESPACE "TEMP"

1 comment:

  1. Online Slots - The M Resort at Borgata Hotel Casino & Spa
    Borgata Hotel Casino 남원 출장안마 & Spa · 제천 출장안마 Play. 전라남도 출장샵 Sign up 안동 출장안마 at the official website. Borgata Hotel Casino & Spa - Atlantic City. 서귀포 출장마사지

    ReplyDelete