开发测试人员,反馈,sqlplus / as sysdba 登陆需要输入密码?
本篇文档流程:
1.场景还原
2.问题处理
3.相关问题介绍
一、场景还原
1)配置SQLNET.ora配置文件,配置操作系统口令验证方式
[oracle@adg1 admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora SQLNET.AUTHENTICATION_SERVICES=(NONE) 2)登陆数据库
[oracle@adg1 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4. Production on Sat Feb :: Copyright (c) , , Oracle. All rights reserved. ERROR:
ORA-: invalid username/password; logon denied Enter user-name:
ERROR:
ORA-: invalid username/password; logon denied Enter user-name:
ERROR:
ORA-: invalid username/password; logon denied SP2-: unable to CONNECT to ORACLE after attempts, exiting SQL*Plus
二、问题处理
[oracle@adg1 admin]$ vi sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES(NTS)
or
SQLNET.AUTHENTICATION_SERVICES(ALL)
or
#SQLNET.AUTHENTICATION_SERVICES(NTS)
三、相关问题介绍
.操作系统口令验证相关文档链接 https://wenku.baidu.com/view/f2ea58c78bd63186bcebbc37.html 2.如果是sqlplus / as sysdba提示无法生成trace文件,则可以参考博客,操作系统存储空间不足,sysdba用户登录默认强制生成审计文件 3.如果是sqlplus / as sysdba,返回信息很慢,有一种可能性(操作系统审计文件,审计文件过多,造成系统层面文件写入慢)