Problem – An error was encounter performing the requested operation. ORA-28001: The password has expired error.
We might get this error when you try to connect oracle after long time.
For now i got this error during deployment but you might encounter while connecting the oracle
java.sql.SQLException: ORA-28001: the password has expired
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801) ~[ojdbc14.jar:Oracle JDBC Driver version – “10.2.0.1.0XE”]
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:732) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:664) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:479) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118) ~[tomcat-jdbc-8.5.11.jar:na]
at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107) ~[tomcat-jdbc-8.5.11.jar:na]
Solution –
Step 1 – Open sql command line.
Step 2 – type connect. It will ask for username and password, after entering username and password it will allow you to set new password.
This worked for window 7 / Oracle 11g.