ORA-47988: password should contain at least one numeric and one alphabetic character ORACLE 报错 故障修复 远程处理

文档解释

ORA-47988: password should contain at least one numeric and one alphabetic character

Cause: The password does not contain at least one numeric and one alphabetic character

Action: Please specify a password with at least one numeric and one alphabetic character and retry the operation

ORA-47988是将密码错误地设置为只包含数字或字母的Oracle错误。

官方解释

常见案例

一般处理方法及步骤

1. 确保新密码至少包含一个数字和一个字母字符。

2. 使用ALTER USER语句重新设置密码，如下所示：

ALTER USER [user_name] IDENTIFIED BY [new_password];

3. 确认新密码是否操作成功，并登录新用户。