文档解释
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服务器,删除脏数据,并再次尝试远程连接;