ORA-01994 GRANT failed: cannot add users to shared password file Cause: A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to SHARED.Action: To add a user to the password file, shut down the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and restart the database. 改变一下参数了~ 呵呵,找个KXpertOracleAdminSetup.exe来用了~ 有什么错误都能查~
---------------------------------------------
www.oradb.net 右边的错误代码查询.
show 命令可以写在sqlplus中吗?
比如:show parameters remote
还有:$orapwd file=filename password=password
建立密码文件init.ora 数据库的初始化设置SQL>show all; 显示相关参数
============
你可以直接到ORACLE的官方网站查这个错误:http://otn.oracle.com/pls/db92/db92.error_search?search=
Cause: A grant failed because a user could not be added to the password file. This is because the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to SHARED.Action: To add a user to the password file, shut down the database, change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and restart the database.
改变一下参数了~
呵呵,找个KXpertOracleAdminSetup.exe来用了~
有什么错误都能查~
remote_login_passwordfile = exclusive
orapwd file=filename password=password
这个密码文件在那里找?
再详细一点,谢谢!
http://otn.oracle.com/pls/db92/db92.error_search?re=homepage&prefill=ORA-查看参数文件:
select name,value from v$parameter order by name;
*就是你的oracle sid的名字
比如我的数据库叫liq,那么initliq.ora,PWDliq.ora
一般都在*\oracle\ora81\database\你看看他里面写的什么东西,改改参数就可以了`
而且随便研究研究oracle目录下的东东,说不定也会有意外收获的~
如果是的话,为什么我的不能呢?
而自定义安装的数据库不可以用inrernal/oracle登陆
这是为什么?帮榜我,困惑中