本文章来告诉你关于解决ORA-28002: 密码7天之后过期办法,有需要参考的同学可以看看哦,好了费话不说多了我们来看看吧。
本文章来告诉你关于解决ORA-28002: 密码7天之后过期办法,有需要参考的同学可以看看哦,好了费话不说多了我们来看看吧。现象描述:
登陆oracle 11g
提示ERROR:ORA-28002: the password will expire within 7 days
告警信息:
ERROR: ORA-28002: the password will expire within 7 days
原因分析:
代码如下 | 复制代码 |
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'; oracle11g |
中默认在default概要文件中设置了“PASSWORD_LIFE_TIME=180天”。 而10g?之前版本的Oracle仍默???NLIMITED
解决办法:
1、查看用户的proifle是那个,一般是default:
代码如下 | 复制代码 |
sql>SELECT username,PROFILE FROM dba_users where username='INFDB' ; |
2、查看指定概要文件(如default)的密码有效期设置:
代码如下 | 复制代码 |
sql>SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'; |
3、将密码有效期由默认的180天修改成“无限制”:
代码如下 | 复制代码 |
sql>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; |
4、修改后,还没有被提示ORA-28002警告的用户不会再碰到同样的提示;
已经被提示的用户必须再改一次密码,举例如下:
代码如下 | 复制代码 |
$sqlplus / as sysdba sql> alter user wapgw identified by |

The article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.

Article discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]

Article discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.

Article discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]

The article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.

Article discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.

The article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.

Article discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SublimeText3 Linux new version
SublimeText3 Linux latest version
