ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Conn / as sysdba 出现ORA-01031: insufficient privileges

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

原创 Linux操作系统 作者:yyp2009 时间:2013-10-13 13:53:21 0 删除 编辑
 sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Oct 13 13:47:47 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-01031: insufficient privileges

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

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-10-17

  • 博文量
    330
  • 访问量
    1024943