技术分享 ORACLE 19C 实现不管大小写

1.修改参数
alter system set sec_case_sensitive_logon=false;
2.修改SQLNET.ORA

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
3.修改一下用户密码
alter user lijie identified by lijiE;
4.无关大小写
SQL> conn lijie/lijiE@192.168.133.121:1521/pdb1;
Connected.
SQL> conn lijie/lijie@192.168.133.121:1521/pdb1;
onnected.