[ORACLE] PASSWORD 변경 방법

[invalid username/password 로 인한 login denied 에러 발생]

<<원인>>

[password가 LOCK이 걸렸었다. (expired 만료.)]

(LOCK_DATE에 저렇게 나오면 안됨. 비어져 있어야 됨)

 

select username, account_status, lock_date, expiry_date from dba_users;

<<해결책1>>

[11g DB에 대한 사전조치]

-비밀번호에 대한 제한이 없도록 설정한다.

alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;            alter profile default limit PASSWORD_GRACE_TIME unlimited;            alter profile default limit PASSWORD_LIFE_TIME unlimited;           alter profile default limit PASSWORD_LOCK_TIME unlimited;

<<해결책2 >>

[기존 비밀번호를 모를 시에는, 암호화 된 정보를 추출해서 변경한다]

 

[암호화 된 값을 DB내에서 추출하기 위해 아래 명령어를 사용]

select 'alter user '||b.NAME||' identified by values '''||b.PASSWORD||''' ; ' from dba_users a, SYS.USER$ b where a.username = b.name   and a.username like 'WCP%' order by a.username

 

추출 되서 나온 alter문들을 복사한다.

 

[복호화되어 있었던 Password를 모두 다른 비밀번호로 변경한다]

alter user WCP_ACTIVITIES identified by OOOOO ;

alter user WCP_CAPTURE identified by OOOOO ;

alter user WCP_DISCUSSIONS identified by OOOOO ;

alter user WCP_DISCUSSIONS_CRAWLER identified by OOOOO ;

alter user WCP_ESS identified by OOOOO ;

alter user WCP_IAU identified by OOOOO ;

alter user WCP_IAUOES identified by OOOOO ;

alter user WCP_IAUOES_APPEND identified by OOOOO ;

alter user WCP_IAUOES_VIEWER identified by OOOOO ;

alter user WCP_IAU_APPEND identified by OOOOO ;

alter user WCP_IAU_VIEWER identified by OOOOO ;

alter user WCP_IPM identified by OOOOO ;

alter user WCP_MDS identified by OOOOO ;

alter user WCP_OCS identified by OOOOO ;

alter user WCP_OCSSEARCH identified by OOOOO ;

alter user WCP_OPSS identified by OOOOO ;

alter user WCP_ORAIRM identified by OOOOO ;

alter user WCP_PORTLET identified by OOOOO ;

alter user WCP_URMSERVER identified by OOOOO ;

alter user WCP_WEBCENTER identified by OOOOO ;

[altered 명령어 실행]