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.