Windows 下的sqlplus / as sysdba登陆报ORA-01031: insufficient privileges

msdnchina

于 2015-12-19 09:36:21 发布

阅读量2.5k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/msdnchina/article/details/50357293

Oracle DB 同时被 2 个专栏收录

772 篇文章

订阅专栏

Windows

116 篇文章

订阅专栏

本文解决了一个常见的Oracle数据库登录问题ORA-01031：权限不足。通过调整sqlnet.ora文件中特定行的格式，即去除行首的空白字符，可以成功使用SQL*Plus以sysdba身份登录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

现象：

F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Dec 19 09:15:03 2015

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges


Enter user-name:

原因：

# 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 = (NTS)


 TRACE_UNIQUE_CLIENT = ON------>>>>>>>>>>>>注意，此行的开头有空格,把空格去掉即可。
TRACE_LEVEL_CLIENT = 16------>>>>>>>>>>>>从此行开始，开头有无空格不影响sqlplus / as sysdba的登陆
TRACE_DIRECTORY_CLIENT = F:\oracle\product\10.2.0\db_1\NETWORK\trace
TRACE_FILE_CLIENT = SQLNetTrace
TRACE_TIMESTAMP_CLIENT = ON
DIAG_ADR_ENABLED = OFF
#TRACE_FILELEN_CLIENT = 2048
#TRACE_FILENO_CLIENT = 2