当忘记sys口令的时候,可以使用orapwd命令重建口令文件。但是在Oracle 18c中却会报OPW-00029的错误。
https://www.cndba.cn/cndba/dave/article/2981
https://www.cndba.cn/cndba/dave/article/2981https://www.cndba.cn/cndba/dave/article/2981https://www.cndba.cn/cndba/dave/article/2981
https://www.cndba.cn/cndba/dave/article/2981
[oracle@www.cndba.cn dbs]$ sqlplus -version
SQL*Plus: Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
[oracle@www.cndba.cn dbs]$ orapwd file=/u01/app/oracle/product/18.3.0/db_1/dbs/orapwcndba password='oracle'
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
[oracle@www.cndba.cn dbs]$
https://www.cndba.cn/cndba/dave/article/2981https://www.cndba.cn/cndba/dave/article/2981https://www.cndba.cn/cndba/dave/article/2981https://www.cndba.cn/cndba/dave/article/2981https://www.cndba.cn/cndba/dave/article/2981
The ora12c_verify_function function fulfills the Department of Defense Database Security Technical Implementation Guiderequirements.
This function checks for the following requirements when users create or modify passwords:
The password contains no fewer than 8 characters and includes at least one numeric and one alphabetic character.
The password is not the same as the user name or the user name reversed.
The password is not the same as the database name.
The password does not contain the word oracle (such as oracle123).
The password differs from the previous password by at least 8 characters.
The password contains at least 1 special character.
所以解决方法有两种:
1. 在指定符合验证函数的密码
[oracle@www.cndba.cn dbs]$ orapwd file=/u01/app/oracle/product/18.3.0/db_1/dbs/orapwcndba password='$www.cndba.cn$666'
[oracle@www.cndba.cn dbs]$
2. 在orapwd命令中指定format到12.2 之前的版本。 该参数默认是12.2. 根据命令帮助,将format指定为12即可。
[oracle@www.cndba.cn dbs]$ orapwd -h
Usage 1: orapwd file= force={y|n} asm={y|n}
dbuniquename= format={12|12.2}
delete={y|n} input_file=
'sys={y | password | external()
| global()}'
'sysbackup={y | password | external()
| global()}'
'sysdg={y | password | external()
| global()}'
'syskm={y | password | external()
| global()}'
[oracle@www.cndba.cn dbs]$ orapwd file=/u01/app/oracle/product/18.3.0/db_1/dbs/orapwcndba password='oracle' format=12
[oracle@www.cndba.cn dbs]$
版权声明:本文为博主原创文章,未经博主允许不得转载。