Conn / as sysdba 出现ORA-01031: insufficient privileges

最新推荐文章于 2024-10-10 15:45:19 发布

转载最新推荐文章于 2024-10-10 15:45:19 发布 · 369 阅读

文章标签：

本文介绍了解决Oracle数据库登录时遇到的ORA-01031: insufficient privileges错误的方法。通过配置sqlnet.ora文件或调整init.ora/spfile参数remote_login_passwordfile为shared来创建密码文件。

sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 13 13:47:47 2013

ERROR:
ORA-01031: insufficient privileges

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@node1 admin]$

SQL> show parameter pass

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE

SQL> select * from V$PWFILE_USERS;

USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE

SQL> conn sys/oracle as sysdba;
Connected.

1 sqlnet.ora:注意：
ERROR:
ORA-01031: insufficient privileges
报错时要加sqlnet.ora文件的位置：

#SQLNET.ORA Network Configuration File
/u01/app/oracle/product/10.2.0/db_1/network/admin
SQLNET.AUTHENTICATION_SERVICES = (NTS) ---加nts这个是在win下面，如果linux下面误加时要加如上路径
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

2 要么就：NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

init.ora文件中添加或者spfile中将remote_login_passwordfile参数设置为shared，一旦库启动则密码文件将自动产生。

此外,SQLNET.AUTHENTICATION_SERVICES

   作用
Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. 
If authentication has been installed, 
it is recommended that this parameter be set to either none or to one of the authentication methods.
 
默认值
None
 
一般可选值
NONE for no authentication methods. A valid username and password can be used to access the database.
ALL for all authentication methods
NTS for Windows NT native authentication(An authentication method that enables 
a client single login access to a Windows NT server and a database running on the server)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-774281/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-774281/