ORA-01994: GRANT failed: password file missing or disabled ORACLE 报错 故障修复 远程处理

文档解释

ORA-01994: GRANT failed: password file missing or disabled

Cause: The operation failed either because the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE was set to NONE or else because the password file was missing.

Action: Create the password file using the orapwd tool and set the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE.

ORA-01994错误指的是GRANT操作失败,原因是密码文件不存在或者未启用。

官方解释

ORA-01994: GRANT failed: password file missing or disabled

Cause: A GRANT or REVOKE command failed because the password file was either missing or disabled.

Action: Verify that a valid password file exists, and that the Remote Method Invocation (RMI) server is enabled.

常见案例

这一错误可能在用户以SYSDBA角色登陆数据库时被触发,这可能是由于不兼容的数据库版本或者移植终端引起的。

正常处理方法及步骤:

1. 确保服务器上的RMI服务器设置为正确的端口;

2. 确保密码文件存在,有效,并正确配置;

正常处理方法及步骤

(a)sqlplus ‘/as sysdba’

(b)根据需要,使用alter system set remote_login_passwordfile和create spfile from pfile定义新的密码文件;

(c)将新的密码文件复制到Oracle用户家目录;

4. 如果仍然存在问题,可尝试重新启动RMI服务器,删除脏数据,并再次尝试远程连接;


数据运维技术 » ORA-01994: GRANT failed: password file missing or disabled ORACLE 报错 故障修复 远程处理