oracle 패스워드 유효기간 만료 복구

How to handle expired Oracle Express accounts

Database server administration issues increases with the use of Persuasion. Swift local default installations of database server express-releases often leaves you with an uncomfortable "What did i just do?"- feeling. This article describes what to do when your Oracle Express installation decides to expire your DB accounts. Your MGW platform log could shout something like this:

0919 095523 (0148) 1 ODBC: Failed executing: [1]: SQL State = "HY000", Error Message = "[STRS][ODBC Oracle Wire Protocol driver][Oracle]ORA-28001: the password has expired", (Native Error = 28001)

Oracle - Reactivate expired and locked accounts (Win)

1. Become database admin
First log into your host running oracle and become the oracle user by typing the following into the command window:

sqlplus /nolog
SQL> connect / as SYSDBA
Connected
SQL>

2. List the Expired accounts

select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';
3. Activate an expired account

Assign a password to reactivate the account:

경축! 아무것도 안하여 에스천사게임즈가 새로운 모습으로 재오픈 하였습니다.
어린이용이며, 설치가 필요없는 브라우저 게임입니다.
https://s1004games.com

ALTER USER ronnie IDENTIFIED BY password;  

4. unlock a locked account

ALTER USER ronnie ACCOUNT UNLOCK;

[출처] http://streamshare.streamserve.com/Articles/Article/?articleId=518