有时候在windows系统上想直接用系统认证以sysdba登陆数据库，会出现以下错误：
ORA-01031:insufficient privileges
原因如下：
SQLNET.AUTHENTICATION_SERVICES allows Windows users to be authenticated using Windows NT native security. What this means is that by setting SQLNET.AUTHENTICATION_SERVICES to NTS:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Creating a role called ORA_DBA, with your user in that group, you should be able to log in to oracle without supplying a password. (connect / as sysdba)
也就是说：
1. 保证在sqlnet.ora里有以下配置：
SQLNET.AUTHENTICATION_SERVICES= (NTS)
2. 保证你的Windows用户属于ORA_DBA组。
ORA-01031:insufficient privileges
原因如下：
SQLNET.AUTHENTICATION_SERVICES allows Windows users to be authenticated using Windows NT native security. What this means is that by setting SQLNET.AUTHENTICATION_SERVICES to NTS:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Creating a role called ORA_DBA, with your user in that group, you should be able to log in to oracle without supplying a password. (connect / as sysdba)
也就是说：
1. 保证在sqlnet.ora里有以下配置：
SQLNET.AUTHENTICATION_SERVICES= (NTS)
2. 保证你的Windows用户属于ORA_DBA组。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26277071/viewspace-709768/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
