怎样解决“ORA-28001: the password has expired”

问题描述

Oracle 数据库用户密码长时间没有修改过期,导致Oracle驱动抛出如下错误:

Caused by: java.sql.SQLException: ORA-28001: the password has expired

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
	at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)
	at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)

问题解决

解决此问题的方法有很多种,我列出一种,共两个步骤。

1. 以管理员用户登录,解锁相应的用户

sqlplus / as sysdba
alter user demo_user account unlock;
exit

2. 以已解锁锁的用户登录,重置密码

~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 13 15:06:09 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: demo_user
Enter password: 
ERROR:
ORA-28001: the password has expired


Changing password for demo_user
New password: 
Retype new password: 
Password changed

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



怎样解决“ORA-28001: the password has expired”

上一篇:deep learning(深度学习)介绍


下一篇:《Apache MINA 2.0 用户指南》第十章:执行者过滤器