文档解释 ORA-01994: GRANT failed: passWord file missing or disabled Cause: The operation failed either because the INIT.ORA
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服务器,删除脏数据,并再次尝试远程连接;
--结束END--
本文标题: ORA-01994: GRANT failed: password file missing or disabled ORACLE 报错 故障修复 远程处理
本文链接: https://www.lsjlt.com/news/540580.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0