一个测试库,sqlplus登录时无法使用os验证
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 29 16:51:32 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
查看sqlnet.ora 无配置,通过情况下默认是启用os验证的,也可以显示指定:
SQLNET.AUTHENTICATION_SERVICES = (ALL)
查看oracle用户
$ id oracle
uid=54321(oracle) gid=54321(oinstall) 组=54321(oinstall)
缺少dba组
usermod -G oinstall,dba oracle