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

最新推荐文章于 2024-05-02 18:59:05 发布

转载最新推荐文章于 2024-05-02 18:59:05 发布

· 350 阅读

文章标签：

#数据库 #操作系统

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)