linux 下orapwd 未找到命令,Oracle 18c orapwd 命令 OPW-00029 错误说明

当忘记sys口令的时候，可以使用orapwd命令重建口令文件。但是在Oracle 18c中却会报OPW-00029的错误。

https://www.cndba.cn/dave/article/2981

https://www.cndba.cn/dave/article/2981https://www.cndba.cn/dave/article/2981

https://www.cndba.cn/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/dave/article/2981

https://www.cndba.cn/dave/article/2981https://www.cndba.cn/dave/article/2981https://www.cndba.cn/dave/article/2981

https://www.cndba.cn/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]$

版权声明：本文为博主原创文章，未经博主允许不得转载。