Skip to main content

ORA-28001 Password expired 

To reset password need to log into system as sysdba user.
command line or terminal

#sqlplus sys as sysdba
password

SQL> SELECT * FROM DBA_PROFILES;
> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

This will keep you from expiring passwords hereafter

SQL>SELECT 'ALTER USER "'||D.USERNAME||'" IDENTIFIED BY VALUES            '''||U.PASSWORD||''';' C
    FROM DBA_USERS D, SYS.USER$ U
    WHERE D.USERNAME = UPPER('&&USERNAME')
    AND U.USER# = D.USER_ID;  


SQL> ALTER USER "SYSTEM" IDENTIFIED BY VALUES '563CF0CCDBBB0FE4';









































Comments











Post a Comment




















Popular posts from this blog



















Insert script with multiple cursors and condition check




























  DECLARE  CURSOR C1  IS    SELECT ID FROM TABLE_NAME_1 WHERE COLUMN IN ('');    CURSOR C2      IS        SELECT ID FROM TABLE_NAME_2 WHERE COLUMN IN ('');                CURSOR C3 (CP_TABLE_01_ID NUMBER,CP_TABLE_02_ID NUMBER)          IS            SELECT COUNT(*) AS COUNT_UP            FROM TABLE_NAME_3            WHERE COLUMN_CONDITION_01=CP_TABLE_02_ID            AND COLUMN_CONDITION_02=CP_TABLE_01_ID;  COUNT_UP NUMBER;  BEGIN  FOR R1 IN C1  LOOP      FOR R2 IN C2      LOOP            OPEN C3(R1.ID,R2.ID);         FETCH C3 INTO COUNT_UP;         CLOSE C3;                 IF (COUNT_UP=0) THEN            INSERT            INTO TABL...




















Post a Comment









Read more





























REF Cursor




























REF CURSOR WILL BE DYNAMICALLY OPENS OR OPEN BASED ON A LOGIC.   DECLARE  TYPE C1 IS  REF CURSOR ; CURSOR  C IS  SELECT  *  FROM  DUAL; REF_CURSOR RC; BEGIN  IF  (TO_CHAR(SYSDATE, 'DD' ) =  30  ) THEN  OPEN  REF_CURSOR FOR  'SELECT * FROM TABLE1' ; ELSIF ( TO_CHAR(SYSDATE, 'DD' ) =  29  ) THEN  OPEN  REF_CURSOR FOR  SELECT  *  FROM  TABLE2; ELSE  OPEN  REF_CURSOR FOR  SELECT  *  FROM  DUAL; END  IF ; OPEN  C; END ;  




















Post a Comment









Read more