Oracle 12.2 ORA-01017问题处理

数据库版本：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

问题解决