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