数据库版本：Oracle 12.2
报错现象：ORA-01017: invalid username/password; logon denied
[oracle@ray ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 26 18:13:06 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
0
PL/SQL Release 12.2.0.1.0 - Production
0
CORE 12.2.0.1.0 Production
0
BANNER
--------------------------------------------------------------------------------
CON_ID
----------
TNS for Linux: Version 12.2.0.1.0 - Production
0
NLSRTL Version 12.2.0.1.0 - Production
0
本机登录显示密码错误：
[oracle@ray ~]$ sqlplus system/oracle
SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 26 17:57:55 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
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
检查密码大小写参数：
SQL> show parameter sensi
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE
密码大小写敏感参数是关闭的，而且确定system的密码是oracle
此时解决办法是sqlnet.ora
[oracle@ray ~]$ cd $ORACLE_HOME/network/admin/
[oracle@ray admin]$ vi sqlnet.ora
添加：
SQLNET.ALLOWED_LOGON_VERSION=8
再测试连接
[oracle@ray admin]$ sqlplus system/oracle
SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 26 18:16:49 2022
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Tue Apr 26 2022 18:08:42 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
问题解决
