Unable to log on to the background due to expiration of the oracle user name and password

I had a rest today, but my colleague reported that the customer's WEB cannot be accessed, the website can be opened, but the background cannot be logged on. I contacted the customer. The customer said that the password of the WEB user expires. The default value is 180 days. Next is my operation process: 1. First from the telnetOracle data port 1521 on the WEB server, it is found that it is accessible. 2. Login

I had a rest today, but my colleague reported that the customer's WEB cannot be accessed, the website can be opened, but the background cannot be logged on. I contacted the customer. The customer said that the password of the WEB user expires. The default value is 180 days. Next is my operation process: 1. First telnet port 1521 of Oracle data from the WEB server and find that it is accessible. 2. Login

I had a rest today, but my colleague reported that the customer's WEB cannot be accessed, the website can be opened, but the background cannot be logged on.

I contacted the customer. The customer said that the password of the WEB user expires. The default value is 180 days.

The next step is my operation process:

1. First telnet port 1521 of Oracle data from the WEB server and find that it is successful.

2. log on to the database server of the customer and Log On As sysdba. View the open and read/write status of the oracle database:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U14M9-0.jpg "title =" Data Warehouse logging query .jpg "alt =" wKiom1SMQkOywVO8AABF9PthLaA338.jpg "/>

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U1B23-1.jpg "title =" oracledata database write status query .jpg "alt =" wKiom1SMQw_SvgOHAABH1P6xwAw526.jpg "/>

3. view the customer's website directory:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U1Ob-2.jpg "title =" .jpg "alt =" wKioL1SMRQCQpTzBAAA67zhd6DA882.jpg "/>

4. view the JDBC file configuration of the client's website connecting to the oracle database:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U15V3-3.jpg "title =" jdbc .jpg "alt =" wKioL1SMRdXi2F3TAACTM9BFS0Y977.jpg "/>

5. view the WEB site username in the oracle database:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U1A16-4.jpg "title =" oraclew.website.png "alt =" wKioL1SMRoOhvrGZAAC2mulQn9k809.jpg "/>

6. The most important step in database settings is to change the oracle database username policy to "Never overdue ":

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U1G62-5.jpg "title =" oracle .jpg "alt =" wKioL1SMR6qCB0gQAADCn-brVLw955.jpg "/>

7. Reset the password of the System user in oracle:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U11a3-6.jpg "title =" oraclepreset system user password .png "alt =" wKioL1SMSFWBSKAZAAAyf58lLfs261.jpg "/>

8. query the oracle user name used for WEB site connection:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U13200-7.jpg "title =" querywebsite.jpg "alt =" wKiom1SMSFChwvHyAABmRkxTxNw311.jpg "/>

9. Update the password of the oracle user name used for WEB site connection:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U1E33-8.jpg "title =" Modify the oracleuser name and password of the website. PNG "alt =" wKioL1SMSaajZaCOAAA0m1fyJL8181.jpg "/>

10. log on to the website:

650) this. width = 650; "src =" http://www.68idc.cn/help/uploads/allimg/151111/121U1J13-9.jpg "title =" website.jpg "alt =" wKiom1SMSqDQbzflAAODwPo99N0363.jpg "/>

In this way, the problem is solved.

Conclusion: When the website that dynamically calls the oracle database cannot be opened, you can find the status of the database and the connected username in time. Generally, the login page cannot be opened because of the database or the connection between the page and the database.

The general location of the website database configuration file is/webapps/ROOT/WEB-INF/classes/jdbc. properties. Find the username and password in it and troubleshoot the problem.

After the database and user name problems are solved, the website background logon interface will automatically restore the status.