[重庆思庄每日技术分享]-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.