ORA-28000: the account is locked

어떤 이유인지는 모르나 접속제한이 걸린 경우로 로그인이 실패한다.

해결책

alter user 계정명 identified by 계정암호 account unlock;

ex) alter user scott identified by tiger account unlock;

참고사이트 : http://www.dba-oracle.com/sf_ora_28000_the_account_is_locked.htm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s