在windows上以sysdba登陸oracle

Jujay發表於2011-10-27
WindowsOracle
有時候在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組。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26277071/viewspace-709768/，如需轉載，請註明出處，否則將追究法律責任。

相關文章