@文心快码ora-01994: password file missing or disabled 文心快码 ORA-01994 错误解释 ORA-01994 错误代码表示在尝试修改系统用户(如 sys)或分配 SYSDBA 权限时,由于密码文件缺失或未启用而导致操作失败。这通常与数据库的参数设置或密码文件的状态有关。 解决password file missing 问题的步骤 检
ORA-01994: GRANT failed: password file missing or disabled 1、查看密码文件是否存在：ho ls $ORACLE...
例如:D:\oracle\ora92 \database>orapwd file=orcl.ora password=orclsys entries=2 其中参数entries的含义是表示口令文件中可以存放的最大用户数,对应于允许以SYSDBA/SYSOPER权限登录数据库的最大用户数,如果用户数 超过这个值只能重建口令文件,增大entries。 file后面可以指定口令文件的全路径和文件名,否则创建在当前...
从描述来看应该是密码文件丢失或REMOTE_LOGIN_PASSWORDFILE参数设置的问题。下面给出具体过程。1、错误提示情况 sys@CNMMBO> grant sysdba to scott; grant sysdba to scott * ERROR at line 1: ORA-01994: GRANT failed: password file missing or disabled /***/ /* Author: Robinson Cheng */ /* Blog: h...
ORA-01994: GRANT failed: password file missing or disabled SOLUTION: This error says, that the password file is not present for the database, which is used for authenticating SYSDBA users remotely. SQL> select * from v$pwfile_users;
Oracle Database - Enterprise Edition - Version 7.3.4.0 to 10.2.0.5.0 [Release 7.3.4 to 10.2]: ORA-01994: GRANT failed: password file missing or disabled
01994, 00000, "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...
简介:在给用户授予sysdba权限时,收到ORA-01994错误,查看描述信息即是password file missing or disabled。 在给用户授予sysdba权限时,收到ORA-01994错误,查看描述信息即是password file missing or disabled。也可以使用oerr ora <error_number> 来查看错误号具体的细节。从描述来看应该是密码文件丢失或REMOTE_LOGIN_PA...
1、错误提示情况 sys@CNMMBO>grant sysdba to scott;grant sysdba to scott*ERRORat line1:ORA-01994:GRANTfailed:password file missing or disabled/***//* Author: Robinson Cheng *//* Blog: http://blog.csdn.net/robinson_0612 *//* MSN: robinson_0612@hotmail.com *//* QQ: 645746311 *//*...
ORA-01994 今天想grant sysdba to sys.提示 sys@CNMMBO>grantsysdbatosys; grantsysdbatosys * ERRORatline 1: ORA-01994:GRANTfailed:passwordfile missingordisabled