远程客户端上
SQL> conn sys/password@oracle9i as sysdba
ERROR:
ORA-01031: insufficient privileges
2 查看sqlnet.ora和romote_
通过网络远程登录;需要设置的参数有两个,一个SQLNET.AUTHENTICATION_SERVICES,一个是REMOTE_LOGIN_PASSWORDFILE。
这两个参数都没有问题
3 是不是不允许直接sys登录,不应该啊。创建另外一个超级用户试试
create user tempsuper identified by oracle
grant sysdba to tempsuper
ORA-01994:授权失败:口令文件丢失或禁用。
GRANT failed: password file missing or disabled
4 问题貌似找到啦,怎么口令文件丢失了
1.5 hour later。。。
原来我手工建库时将 orapwSID 文件欢喜的加上了.ora后缀 ……
mv orapwSID.ora orapwSID
5 O了 太雷了 Oracle大人啊&&&&
附录:
来源王络
1)REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= none:
oracle安装用户本地sqlplus “/ as sysdba”无法登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录
非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”无法登录
(2)REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= none:
oracle安装用户本地sqlplus “/ as sysdba”无法登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录
非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”能登录
(3)REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= (NTS):
oracle安装用户本地sqlplus “/ as sysdba”能登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录
非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”无法登录
(4)REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= (NTS):
oracle安装用户本地sqlplus “/ as sysdba”能登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录
非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”能登录
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20399666/viewspace-716070/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20399666/viewspace-716070/