- 论坛徽章:
- 0
|
我的安装了oracle 9206,选择的是Software Only, 然后用dbca创建数据库,然后用netca 创建了sqlnet.ora 文件,内容如下:
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# 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)
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)
但是我用如下方式连接数据库,出现了 ORA-01031: insufficient privileges 错误
c:\sqlplus /nolog
sql>connect /as sysdba
为什么不能用操作系统认证连接数据呢? 不知道哪为大哥遇到过这样的问题,如何解决?
还是,安装数据库的时候选择了只安装软件,后来就无法从操作系统认证了呢?
因为我在sqlnet.ora 里看到# 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.
这句很奇怪,请指教,谢谢。 |
|