问题:在使用管理员权限登录Oracle时提示ora-01031:insufficient privileges。
解决方法:
在路径:E:\app\aaa\product\11.2.0\dbhome_1\NETWORK\ADMIN的sqlnet.ora文件
添加 SQLNET.AUTHENTICATION_SERVICES=(NTS)
其中product\11.2.0\dbhome_1\NETWORK\ADMIN是通用目录,如果忘记在哪个盘下,可以直接搜索product文件夹
我的 sqlnet.ora文件如下 ,原本是NONE我改成了NTS就可以成功登录了
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
# SQLNET.AUTHENTICATION_SERVICES= (NONE)
SQLNET.AUTHENTICATION_SERVICES=(NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)